Key Responsibilities :
Database Maintenance & Administration :
- Perform routine maintenance tasks including backup, recovery, patching, and performance tuning.
- Conduct standard database maintenance and administration tasks with attention to detail.
- Monitor database activity, health, and performance, using database management system software and tools to collect performance statistics.
- Optimize database performance, plan for forecast resource needs, and recommend corrective actions.
- Ensure database high availability, replication, failover, and clustering.
- Develop and configure tools to automate database administration tasks, enhancing efficiency and minimizing downtime.
- Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects.
- Implement disaster recovery strategies and maintain data integrity across environments.
Incident Management & Troubleshooting :
- Handle critical escalations and complex troubleshooting for database issues.
- Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues.
- Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis).
Backup, Recovery & Disaster Recovery :
- Design and implement backup strategies and disaster recovery plans.
- Ensure data integrity, redundancy, and compliance with RPO/RTO requirements.
Containerization & Orchestration :
- Manage databases using Docker and Kubernetes to ensure scalability and resilience.
- Optimize containerized database solutions for performance optimization.
- Implement CI/CD pipelines for automated deployment and maintenance of databases within containerized environments.
Collaboration & Communication :
- Work closely with application teams to ensure seamless integration and optimal performance by understanding business logic, data models, and query patterns.
- Optimize database schema and queries for application performance improvement.
- Interact with customers, suppliers, and partners to deliver effective database maintenance.
Documentation & Reporting :
- Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides.
- Prepare reports detailing system health, performance metrics, and improvement plans.
Required Skills and Qualifications :
- Database Technologies : Deep knowledge of PostgreSQL, Redis and MongoDB.
- Containerization & Orchestration : Hands-on experience with Docker and Kubernetes for deploying and managing databases.
- Infrastructure and Application Integration : Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows.
- Performance Tuning & Optimization : Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms.
