Position: Postgre DBA
Work Location: Hyderabad
Duration: 6 – 12 Months Contract to Hire
Experience: 5-15 Years
Job Description:
Experience as a Postgres database Administrator with strong working knowledge of
Operational/Systems DBA to setup and support Postgres.
• Must have experience in PostgreSQL database architecture, logical and physical design,
automation, documentation, installs, shell scripting, PSQL programming, catalog navigation,
query tuning, system tuning, resource contention analysis, backup and recovery, replication, etc.
• In depth knowledge of the PostgreSQL architecture with Version 9.6, 10, 11 and 12.
• Experienced in installing, configuring and upgrading Postgres databases and clusters.
• Experience in configuring and supporting PMM tool.
• Experience in working with percona support.
• Experience in deploying Postgresql on Linux on Power environment and good understanding of
operating system concepts of Linux (RHEL).
• Good knowledge of capacity planning and architecture design for database server deployment.
• Proven experience in working in a mission critical environment in a multi-terabyte database
platforms.
• Working knowledge of architecting, configuring, setting up Patroni or similar set-up for HA
solution.
• Experience in setting up streaming, logical Replication and any additional Replication methods
• Working Knowledge of connection poolers (pgPool and pgBouncer)
• Perform routine maintenance on several database environments including application of
updates, patches, and hotfixes
• Installation/configuration and implementation of PMM Dashboard.
• Creating databases, migrating database objects from non-production to production
environment.
• Designing and building data models, schemas, views, and tables to support application
requirements
• Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing
using tools such as Guardium.
• Extensive experience designing and executing backup and recovery concepts and procedures
• Measure database performance and troubleshoot complex database issues, I/O bottlenecks,
SQL Tuning/
• Experience in using Splunk, Nimsoft for Availability and performance.
• Good understanding of licensing options and optimization.
• Experience in scripting languages (shell or python or Perl) for automating DBA administrative
tasks.
• In-depth knowledge of IT industry database technologies and processes and business
applications integrated with database technologies.
• Experience in working closely with the application development teams to resolve any
performance related issues and provide application support.
• Provide 24 x 7 Support to Critical production systems.
• Knowledge of Project Management Methodologies
Thanks & Regards
Sindhuja
sindhuja@burgeonits.com
+91- 8125400040