Back to searchPostgreSQL DBA
LA International Computer Consultants Ltd
Posted 3 days ago, valid for 4 days
Glasgow, City of Glasgow G2 5LA, Scotland
£400 - £500 per day
Full Time
In order to submit this application, a TotalJobs account will be created for you. As such, in addition to applying for this job, you will be signed up to all TotalJobs’ services as part of the process. By submitting this application, you agree to TotalJobs’ Terms and Conditions and acknowledge that your personal data will be transferred to TotalJobs and processed by them in accordance with their Privacy Policy.
Sonic Summary
- The job is for a PostgreSQL DBA inside IR35 with a hybrid work model based in Glasgow, ideally requiring three days per week in the office.
- Candidates should have at least 6 years of senior database administration experience, specifically with Enterprise Greenplum databases.
- The role involves monitoring databases, tuning queries for performance, and fine-tuning database configuration settings.
- The position offers a competitive salary of £500 per day and requires effective communication skills for collaboration across global teams.
- Additionally, experience in shell scripting, automation, and disaster recovery management is essential for this 12-month contract role.
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.
