Oracle & PostgreSQL Database Administrator (L3 Support) Pune & HYD Hybrid
Share
Job Location:
Monthly Salary:
Posted on:
15 hours ago
Vacancies:
1 Vacancy
Job Summary
Role Overview
We are looking for an experienced Oracle & PostgreSQL Database Administrator (L3 Support) with strong expertise in database administration performance optimization high availability and disaster recovery. The candidate will be responsible for designing implementing maintaining and optimizing database systems while ensuring high availability security and performance.
Key Responsibilities Database Administration- Provide L3 support for Oracle and PostgreSQL databases in production environments.
- Design implement and maintain PostgreSQL database systems including schema design and indexing strategies.
- Manage database installations configurations upgrades and patching.
- Analyze and optimize SQL queries and database performance.
- Implement indexing strategies and query tuning using tools such as:
- EXPLAIN ANALYZE
- pgstatstatements
- pgtop
- Monitor database performance storage growth and resource utilization using Prometheus/Grafana dashboards.
- Develop and manage backup and recovery strategies using:
- pgdump
- pgbasebackup
- WAL archiving
- Point-in-Time Recovery (PITR)
- Ensure disaster recovery readiness and conduct periodic DR testing.
- Implement and manage High Availability (HA) and Disaster Recovery (DR) solutions.
- Configure and maintain:
- Streaming replication
- Logical and physical replication
- Synchronous / Asynchronous replication
- Hot standby failover
- Load balancing
- Use Patroni for failover orchestration and cluster management.
- Implement Role-Based Access Control (RBAC).
- Configure audit logging using pgaudit.
- Ensure compliance with organizational and regulatory security standards.
- Develop automation scripts for database maintenance and monitoring.
- Support database operations using Linux-based scripting.
- Oracle Administration
- PostgreSQL Administration
- Strong SQL and PL/pgSQL expertise.
- Experience in database optimization and indexing.
- Proficiency in Linux scripting for database automation.
- Experience working in Linux/Debian environments.
- 7 years of hands-on experience in Oracle and PostgreSQL database administration.
- Strong analytical troubleshooting and problem-solving skills.
