Database Developer - MySQL

Key Responsibilities :

Database Administration & Management :

- Administer, maintain, and support enterprise database environments including MySQL, Elasticsearch, and Redis.

- Ensure high availability, reliability, scalability, and performance of database systems.

- Manage database installation, configuration, upgrades, migrations, and patching activities.

- Design and implement database standards, policies, and best practices.

- Monitor database health and proactively address performance bottlenecks.

Database Performance Optimization :

- Analyze and optimize SQL queries, indexes, schema designs, and database configurations.

- Implement advanced DBA optimization techniques to improve database performance and efficiency.

- Perform query tuning, execution plan analysis, indexing strategies, and resource optimization.

- Manage and optimize large datasets and high-volume transaction systems.

- Identify and resolve database performance issues affecting applications and business operations.

Monitoring & Troubleshooting :

- Establish proactive database monitoring and alerting mechanisms.

- Troubleshoot database-related incidents, performance degradation, and system failures.

- Conduct root cause analysis (RCA) and implement preventive measures.

- Monitor database utilization, capacity, and growth trends.

- Ensure minimal downtime and rapid incident resolution.

Cloud Database Administration :

- Manage and optimize cloud-native database services, including :

1. Amazon RDS

2. Google Cloud SQL

3. Azure Cosmos DB

- Support database migration initiatives from on-premises to cloud platforms.

- Implement cloud database security, backup, disaster recovery, and performance optimization strategies.

- Ensure cloud database environments align with organizational architecture and compliance standards.

Data Warehousing & ETL Support :

- Support the design, implementation, and maintenance of enterprise data warehousing solutions.

- Collaborate with data engineering teams to optimize ETL workflows and data pipelines.

- Ensure efficient data integration, transformation, and loading processes.

- Improve data quality, consistency, and availability across platforms.

- Support reporting, analytics, and business intelligence requirements.

Backup, Recovery & Disaster Management :

- Develop and maintain database backup and recovery strategies.

- Conduct regular backup validation and disaster recovery testing.

- Ensure business continuity through robust recovery procedures.

- Implement data retention and archival policies.

Security & Compliance :

- Implement database security controls, user access management, and encryption standards.

- Ensure compliance with organizational security policies and regulatory requirements.

- Conduct database audits and vulnerability assessments.

- Monitor and remediate database security risks.

DevOps & Database Automation :

- Collaborate with DevOps teams to automate database deployment, monitoring, and maintenance processes.

- Develop Infrastructure-as-Code (IaC) and automation solutions where applicable.

- Integrate database operations into CI/CD pipelines.

- Support automated testing, deployment, and release management activities.

- Promote database reliability through automation and operational excellence.

Cross-Functional Collaboration :

- Work closely with software developers, architects, DevOps engineers, and business stakeholders.

- Provide technical guidance on database design and optimization best practices.

- Support application teams during development, testing, and production deployments.

- Contribute to database architecture and modernization initiatives.

Required Qualifications :

- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.

- Relevant database certifications are preferred.

Required Experience :

- 5+ years of experience in Database Administration, Database Engineering, or related roles.

- Strong hands-on experience with :

1. MySQL

2. Elasticsearch

3. Redis

- Proven experience managing large-scale databases and high-volume transactional systems.

- Extensive experience in database performance tuning, monitoring, troubleshooting, and optimization.

- Experience with cloud database platforms :

1. Amazon RDS

2. Google Cloud SQL

3. Azure Cosmos DB

- Experience with data warehousing solutions and ETL processes.

- Familiarity with DevOps practices and database automation methodologies.

Technical Skills :

1. Database Technologies :

- MySQL Administration and Optimization

- Elasticsearch Administration

- Redis Administration

- SQL Performance Tuning

- Database Design and Architecture

- Query Optimization

- Indexing Strategies

- Replication and High Availability

2. Cloud Platforms :

- AWS (Amazon RDS)

- Google Cloud Platform (Cloud SQL)

- Microsoft Azure (Cosmos DB)

- Cloud Migration and Optimization

- Data Engineering

- Data Warehousing Concepts

- ETL Processes and Data Integration

- Data Modeling

- Data Pipeline Optimization

- DevOps & Automation

- CI/CD Pipelines

- Infrastructure Automation

- Database Deployment Automation

- Version Control Systems (Git)

3. Monitoring and Observability Tools :

- Monitoring & Performance Tools

- Database Monitoring Solutions

- Performance Analysis Tools

- Logging and Alerting Platforms

- Capacity Planning and Forecasting

Behavioral Competencies :

- Strong analytical and problem-solving skills

- Excellent troubleshooting and debugging abilities

- Attention to detail and operational excellence

- Ability to manage multiple priorities in a fast-paced environment

- Strong communication and collaboration skills

- Proactive and ownership-driven mindset

- Continuous learning and improvement orientation

- Ability to work independently and within cross-functional teams

Preferred Candidate Profile :

- Strong expertise in MySQL, Elasticsearch, and Redis administration.

- Proven experience handling large datasets and complex database environments.

- Hands-on experience with Amazon RDS, Google Cloud SQL, and Azure Cosmos DB.

- Strong SQL tuning and database optimization skills.

- Experience supporting data warehousing and ETL ecosystems.

- Familiarity with DevOps tools, CI/CD pipelines, and database automation practices.

- Ability to drive database performance, reliability, scalability, and operational excellence across enterprise environments.