Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Job Description – PostgreSQL DBA / MongoDB DBAExperience - 1 YearsLocation - Hyderabad Role SummaryWe are seeking a highly skilled and proactive Database Administrator with strong expertise in PostgreSQL and/or MongoDB database administration. The ideal candidate will be responsible for database administration, high availability, backup and recovery, security, and operational support of mission-critical database environments. Experience with distributed databases such as YugabyteDB will be an added advantage.Key ResponsibilitiesDatabase Administration
Install, configure, upgrade, patch, and maintain PostgreSQL and/or MongoDB environments.
Manage database health, availability, performance, and capacity planning.
Perform database migrations, refreshes, and environment provisioning.
Administer database users, roles, permissions, and security policies.
Ensure compliance with organizational security and audit requirements.
High Availability & Disaster Recovery
Configure and manage replication technologies.
Manage clustering, failover, and disaster recovery solutions.
Perform backup and recovery operations and conduct recovery drills.
Ensure database resiliency and business continuity.
Performance & Optimization
Monitor and optimize database performance.
Analyze query execution plans and recommend tuning strategies.
Optimize indexes, database objects, and configurations.
Troubleshoot database bottlenecks and production incidents.
Monitoring & Automation
Implement and maintain monitoring, alerting, and reporting solutions.
Automate routine DBA tasks using scripts and tools.
Develop operational runbooks and standard procedures.
Production Support
Provide L2 support for production environments.
Participate in on-call support and incident management.
Ensure SLA adherence and timely issue resolution.
Mandatory SkillsPostgreSQL Administration
Strong experience in PostgreSQL administration.
Expertise in:
Replication (Streaming, Logical Replication)
Backup and Recovery (pgBackRest, WAL management)
Performance Tuning
Partitioning
HA solutions such as EDB EFM, Patroni, Pgpool-II, etc.
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
