Postgresql Database Administrator Axiom Software Solutions

6.0 - 11.0 years

10 - 20 Lacs

Bengaluru

Work from Office

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

Posted 2 weeks ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.