Job
Description
Key Responsibilities:Install, configure, and maintain PostgreSQL, MongoDB, MySQL, and MariaDB databases.Ensure database performance, availability, scalability, and security.Design and implement backup/recovery strategies, high-availability setups, and disaster recovery solutions.Monitor database performance and perform tuning and optimization (indexes, queries, configs).Automate routine database tasks using scripting (Shell, Python, or equivalent).Manage data replication, sharding (MongoDB), clustering, and connection pooling.Collaborate with developers and DevOps teams to support database integration and CI/CD pipelines.Apply patches and perform version upgrades with minimal downtime.Conduct capacity planning and performance forecasting.Ensure data integrity and enforce compliance with security standards and policies.Required Skills and Experience:Bachelor’s degree in Computer Science, Engineering, or a related field.5–8 years of experience as a DBA with production support responsibilities.Hands-on experience with:PostgreSQL: configuration, tuning, replication, extensions (e.g., PostGIS).MongoDB: replica sets, sharding, indexes, BSON queries.MySQL / MariaDB: performance tuning, replication (GTID, semi-sync), backup strategies.Experience with monitoring tools such as pgAdmin, Percona Toolkit, Prometheus + Grafana, or OpsManager.Proficient in SQL, NoSQL, PL/pgSQL, and scripting languages (Bash, Python).Strong knowledge of Linux-based environments (RHEL, CentOS, Ubuntu).
