Key Responsibilities
- Design, develop, and maintain SQL-based databases (MySQL, PostgreSQL, SQL Server, or Oracle).
- Write, optimize, and maintain complex SQL queries, stored procedures, functions, and views.
- Perform database performance tuning, indexing, query optimization, and capacity planning.
- Ensure data integrity, consistency, and security across all database systems.
- Implement and manage backup, recovery, and disaster recovery strategies.
- Monitor database health and proactively resolve performance and availability issues.
- Support application teams with database design and troubleshooting.
- Handle database migrations, upgrades, and version control.
- Implement role-based access control and manage user permissions.
- Work with DevOps teams on CI/CD pipelines, database automation, and deployments.
- Maintain documentation for database architecture, procedures, and standards.
- Ensure compliance with data protection and security policies.
Required Skills & Qualifications
- 4+ years of hands-on experience as a SQL Database Engineer or DBA.
- Strong expertise in SQL query writing and optimization.
- Experience with at least one major RDBMS:
- MySQL / PostgreSQL / SQL Server / Oracle
- Solid understanding of:
- Indexing strategies
- Normalization & denormalization
- ACID properties
- Transactions and locking mechanisms
- Experience with backup and recovery tools.
- Knowledge of database performance monitoring tools.
- Familiarity with Linux/Unix environments.
- Experience working with large datasets and high-availability systems.
Preferred / Nice-to-Have Skills
- Experience with cloud databases (AWS RDS, Azure SQL, Google Cloud SQL).
- Knowledge of replication, clustering, and failover setups.
- Exposure to NoSQL databases (MongoDB, Redis) is a plus.
- Experience with ETL processes and data migration projects.
- Scripting skills (Shell, Python, or PowerShell).
- Understanding of DevOps practices and CI/CD pipelines.
Job Type: Full-time