Postgresql Database Administrator

Hi,

We are hiring PostgreSQL / Greenplum Database Admin

Postgres/Greenplum DBA

• • 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.
• 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.
• Excellent experience in monitoring databases and identifying expensive and long running queries using query plans and analysis to tune queries and improve overall performance.
• 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.
• 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.
• In her previous role, worked with multiple DBAs across regions and contributed to development and coaching to junior members on assignment of work and ownership of deliverables.
• 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.
• Experience in database performance monitoring and review segment health to ensure overall DB performance is healthy with proper best practices.
• Deep experience in managing DR environments using backup and restore across different data centers/regions.
• Client evaluates on the following.
• Installation
• Replication
• Performance
• DB Objects
• PSG config params
• Architecture
• Statistics
• Ansible
• Shell
• Communication
• Attitude
• Basic SQL Development

For PostgresSQL these are additional requirements.

• Basic working hands on skill . Needs to understand and know regular day to day DBA job role questions .
• Know and explain different scenarios which DBA comes across on day-to-day basis .
• SQL writing .
• Prior scripting or automation experience .

Thanks & Regards,

Chetna Singh IT Recruiter

Axiom Software Solutions Limited

Direct: +44 (0) 2039501764

Email: chetna.singh@axiomsoftwaresolutions.com

Website :www.axiomsoftwaresolutions.com

Head Office : Head Office: 18th & 19th Floors 100 Bishopsgate, London,

Global Offices: UK| USA|Germany|Netherlands|Poland|India