Senior PostgreSQL DBA

We are #Hiring: #Senior PostgreSQL DBA

Job Title : #Senior PostgreSQL DBA

Location : PAN India - ( Hybrid )

Total Yrs. of Experience : 7+ Years

️ Duration: Contract to Hire (C2H)

Notice Period: Immediate Joiners

Job description*:

#Key Responsibilities:

• Administer, maintain, and optimize PostgreSQL databases across Dev/UAT/Prod environments.

• Perform routine maintenance: VACUUM, ANALYZE, REINDEX, bloat management, autovacuum tuning, and partition maintenance.

• Implement and support high availability solutions (Streaming Replication, Logical Replication, PgBouncer, etc.).

• Troubleshoot performance issues: slow queries, locks, deadlocks, replication lag, and resource bottlenecks.

• Design and implement backup/restore strategies including PITR, WAL archiving, and DR planning.

• Support database upgrades, migrations.

• Collaborate with developers to optimize SQL queries, indexing strategies, and schema design.

• Monitor database health using pg_stat_statements, pg_stat_activity, Prometheus/Grafana, and Azure monitoring tools.

• Automate operational tasks using Shell/Python scripting and CI/CD pipelines.

• Ensure database security, auditing, access control, and compliance.

• Document database standards and best practices.

?• 5+ years of hands on experience as a PostgreSQL DBA.

• Strong understanding of PostgreSQL internals, query planner, indexing, and performance tuning.

• Experience with logical & physical replication, failover, and HA architectures.

• Expertise in backup/restore, PITR, WAL management, and DR planning.

• Strong SQL skills and experience optimizing complex queries.

• Hands on experience with Azure Database for PostgreSQL – Flexible Server.

• Experience with monitoring tools (pgBadger, Prometheus, Grafana, Azure Monitor).

• Scripting experience (Bash, Python) for automation.?

?• Hands on experience with Azure Database for PostgreSQL – Flexible Server provisioning, scaling, storage tuning, and maintenance windows.

• Strong understanding of Azure PaaS architecture, including compute tiers, IOPS, storage auto grow, and zone redundant HA.

• Experience with Azure Monitor, Log Analytics, Query Performance Insight, and alerting for PostgreSQL performance troubleshooting.

• Expertise in tuning Azure PostgreSQL parameters: autovacuum settings, work_mem, shared_buffers, WAL settings, and connection pooling.

--

Thanks & Regards

Rajkiran.G

Technical Recruiter

Burgeon IT Services

Email Id:

Ph no: +91 9160720004

Website: www.burgeonits.com

Shirisha. Ch Sona P Thota Harika Ramya Sarige k Nitusha Kalyani R Sudha Yadav Veeraboina Syed Nazima Vara lakshmi kota Sushma Gowrishatti Golagani Saikumar Shiva Kumar Rajkiran G Srikanth Vicky Khaja Mansoor Ahmed Kiran Gomasa Nagarjuna Duggineni vinay goud Masthanvali SHAIK Nanda Kishore Kumar Lakkakula Laxmi Narayana (Raja) Arraganti palley Mahathi Navya Tumuluri BURGEON IT SERVICES