LA International Computer Consultants Ltd
Glasgow, Lanarkshire
PostgresSQL DBA Inside IR35 Hybrid in Glasgow (ideally 3 days per week) 12months+ contract o PostgreSQL/Greenplum would be 6+ years of Sr. Database Administration working with Enterprise Greenplum databases and well versed with Greenplum Installation, Upgrades, and Performance Tuning. o Worked cross-functionally across numerous DBA and Development teams located globally and exhibits effective communication, both written and verbal, for all the consulting/collaboration, engineering, and 24/7 support. o Excellent experience in monitoring databases and identifying expensive and long running queries using query plans and analysis to tune queries and improve overall performance. o Experience in monitoring the database logs for Greenplum parameter errors and fine-tuning database configuration settings like statement_mem, workfile limitations, etc. to improve overall database performance. o Well versed in Shell Scripting and scheduling jobs for running daily stats collection process, vacuum analysis on catalog tables, identifying skewed tables, cron jobs, and overall automation of effort, etc. o Worked with multiple DBAs across regions and contributed to development and coaching to junior members on assignment of work and ownership of deliverables. o Experience in Greenplum Command Center monitoring and reviewing gpperfmon data for the database analysis and understanding the database workload, daily no.# of queries and reviewing current DB settings and Capacity Expansion planning. o Experience in database performance monitoring and review segment health to ensure overall DB performance is healthy with proper best practices. o Deep experience in managing DR environments using backup and restore across different data centers/regions. * Client evaluates on the following. o Installation o Replication o Performance o DB Objects o PSG config params o Architecture o Statistics o Ansible o Shell o Communication o Attitude o Basic SQL Development * For PostgresSQL these are additional requirements. o Basic working hands on skill. Needs to understand and know regular day to day DBA job role questions. o Know and explain different scenarios which DBA comes across on day-to-day basis. o SQL writing o Prior Scripting or automation experience LA International is a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the largest single site in the UK as an IT Consultancy or as an Employment Business & Agency depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, LA International welcome applications from all sections of the community and from people with diverse experience and backgrounds. Award Winning LA International, winner of the Recruiter Awards for Excellence, Best IT Recruitment Company, Best Public Sector Recruitment Company and overall Gold Award winner, has now secured the most prestigious business award that any business can receive, The Queens Award for Enterprise: International Trade, for the second consecutive period.
18/09/2024
Contractor
PostgresSQL DBA Inside IR35 Hybrid in Glasgow (ideally 3 days per week) 12months+ contract o PostgreSQL/Greenplum would be 6+ years of Sr. Database Administration working with Enterprise Greenplum databases and well versed with Greenplum Installation, Upgrades, and Performance Tuning. o Worked cross-functionally across numerous DBA and Development teams located globally and exhibits effective communication, both written and verbal, for all the consulting/collaboration, engineering, and 24/7 support. o Excellent experience in monitoring databases and identifying expensive and long running queries using query plans and analysis to tune queries and improve overall performance. o Experience in monitoring the database logs for Greenplum parameter errors and fine-tuning database configuration settings like statement_mem, workfile limitations, etc. to improve overall database performance. o Well versed in Shell Scripting and scheduling jobs for running daily stats collection process, vacuum analysis on catalog tables, identifying skewed tables, cron jobs, and overall automation of effort, etc. o Worked with multiple DBAs across regions and contributed to development and coaching to junior members on assignment of work and ownership of deliverables. o Experience in Greenplum Command Center monitoring and reviewing gpperfmon data for the database analysis and understanding the database workload, daily no.# of queries and reviewing current DB settings and Capacity Expansion planning. o Experience in database performance monitoring and review segment health to ensure overall DB performance is healthy with proper best practices. o Deep experience in managing DR environments using backup and restore across different data centers/regions. * Client evaluates on the following. o Installation o Replication o Performance o DB Objects o PSG config params o Architecture o Statistics o Ansible o Shell o Communication o Attitude o Basic SQL Development * For PostgresSQL these are additional requirements. o Basic working hands on skill. Needs to understand and know regular day to day DBA job role questions. o Know and explain different scenarios which DBA comes across on day-to-day basis. o SQL writing o Prior Scripting or automation experience LA International is a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the largest single site in the UK as an IT Consultancy or as an Employment Business & Agency depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, LA International welcome applications from all sections of the community and from people with diverse experience and backgrounds. Award Winning LA International, winner of the Recruiter Awards for Excellence, Best IT Recruitment Company, Best Public Sector Recruitment Company and overall Gold Award winner, has now secured the most prestigious business award that any business can receive, The Queens Award for Enterprise: International Trade, for the second consecutive period.
NO SPONSORSHIP Associate Principal, Database Administration - DB2/LUW SALARY: $125K - $135K PLUS 15% BONUS LOCATION: CHICAGO, IL HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE Looking for a candidate with 7 years DB2 LUW on Red Hat linux and windows. 7 years postgre SQL SQL stored procedures to monitor and tune databases for application performance. backup and recovery DR drills provides primary on call support for production problems This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance. Primary Duties and Responsibilities: Assists with the design, implementation, and maintaining databases Manage database performance and disk usage Provides support in database access methods Provides consultation support in database analysis, modelling, coding, and production problem resolution. Develops maintenance, backup and recovery procedures and documentation Participates in Disaster Recovery drills Provides Primary On-Call Support for production problems Understands and supports corporate data standards Recommends and assists with new DBMS and operational standards. Participates in testing and in evaluations of new software and software release upgrades Supports business studies, proposal teams and costing/feasibility studies Prepares system documentation Maintains metadata repositories Qualifications: 3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA Well versed in all phases of Systems Analysis and Design Experienced in two or more programming/Scripting languages Practiced at Entity/Relationship or Object modelling and translation to physical database designs Proficient in DML, DDL, and database utilities for at least two DBMS technologies Proficient in all access methods of a DBMS as well as the underlying operating system access method Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment 7+ years' experience with PostgreSQL 7+ years' experience with DB2 LUW; preferably on Red Hat Linux Proficient with coding and review of SQL, stored procedures, and triggers bachelor's degree
16/09/2024
Full time
NO SPONSORSHIP Associate Principal, Database Administration - DB2/LUW SALARY: $125K - $135K PLUS 15% BONUS LOCATION: CHICAGO, IL HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE Looking for a candidate with 7 years DB2 LUW on Red Hat linux and windows. 7 years postgre SQL SQL stored procedures to monitor and tune databases for application performance. backup and recovery DR drills provides primary on call support for production problems This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance. Primary Duties and Responsibilities: Assists with the design, implementation, and maintaining databases Manage database performance and disk usage Provides support in database access methods Provides consultation support in database analysis, modelling, coding, and production problem resolution. Develops maintenance, backup and recovery procedures and documentation Participates in Disaster Recovery drills Provides Primary On-Call Support for production problems Understands and supports corporate data standards Recommends and assists with new DBMS and operational standards. Participates in testing and in evaluations of new software and software release upgrades Supports business studies, proposal teams and costing/feasibility studies Prepares system documentation Maintains metadata repositories Qualifications: 3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA Well versed in all phases of Systems Analysis and Design Experienced in two or more programming/Scripting languages Practiced at Entity/Relationship or Object modelling and translation to physical database designs Proficient in DML, DDL, and database utilities for at least two DBMS technologies Proficient in all access methods of a DBMS as well as the underlying operating system access method Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment 7+ years' experience with PostgreSQL 7+ years' experience with DB2 LUW; preferably on Red Hat Linux Proficient with coding and review of SQL, stored procedures, and triggers bachelor's degree
NO SPONSORSHIP Associate Principal, Database Administration - DB2, LUW, Postgre SALARY GOES TO $155K LOCATION: Dallas, TX HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE Looking for a DBA with 7 years of DB2 and LUW on Red Hat linux, windows 7. You will also need 7 years postgres. SQL stored procedures to monitor tune databases for application performance backup and recovery DR drills provides primary on call support for production problems. What You'll Do: This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance. Primary Duties and Responsibilities: Assists with the design, implementation, and maintaining databases Manage database performance and disk usage Provides support in database access methods Provides consultation support in database analysis, modelling, coding, and production problem resolution. Develops maintenance, backup and recovery procedures and documentation Participates in Disaster Recovery drills Provides Primary On-Call Support for production problems Understands and supports corporate data standards Recommends and assists with new DBMS and operational standards. Participates in testing and in evaluations of new software and software release upgrades Supports business studies, proposal teams and costing/feasibility studies Prepares system documentation Maintains metadata repositories Qualifications: 3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA Well versed in all phases of Systems Analysis and Design Experienced in two or more programming languages and two or more Scripting languages Technical Skills: 7+ years' experience with PostgreSQL 7+ years' experience with DB2 LUW; preferably on Red Hat Linux Proficient with coding and review of SQL, stored procedures, and triggers Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business [Preferred] Related financial industry experiences
12/09/2024
Full time
NO SPONSORSHIP Associate Principal, Database Administration - DB2, LUW, Postgre SALARY GOES TO $155K LOCATION: Dallas, TX HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE Looking for a DBA with 7 years of DB2 and LUW on Red Hat linux, windows 7. You will also need 7 years postgres. SQL stored procedures to monitor tune databases for application performance backup and recovery DR drills provides primary on call support for production problems. What You'll Do: This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance. Primary Duties and Responsibilities: Assists with the design, implementation, and maintaining databases Manage database performance and disk usage Provides support in database access methods Provides consultation support in database analysis, modelling, coding, and production problem resolution. Develops maintenance, backup and recovery procedures and documentation Participates in Disaster Recovery drills Provides Primary On-Call Support for production problems Understands and supports corporate data standards Recommends and assists with new DBMS and operational standards. Participates in testing and in evaluations of new software and software release upgrades Supports business studies, proposal teams and costing/feasibility studies Prepares system documentation Maintains metadata repositories Qualifications: 3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA Well versed in all phases of Systems Analysis and Design Experienced in two or more programming languages and two or more Scripting languages Technical Skills: 7+ years' experience with PostgreSQL 7+ years' experience with DB2 LUW; preferably on Red Hat Linux Proficient with coding and review of SQL, stored procedures, and triggers Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business [Preferred] Related financial industry experiences