About This Role
This Database Engineer role focuses on designing, maintaining, and optimizing highly scalable relational databases for enterprise applications. The position involves working closely with software engineers and DevOps teams to ensure high performance, security, and availability of production databases.
Responsibilities
- Design and maintain highly scalable relational databases
- Build efficient database schemas for enterprise applications
- Optimize complex SQL queries and stored procedures
- Design indexing strategies for high-performance applications
- Monitor database performance and eliminate bottlenecks
- Implement replication, backups, disaster recovery, and high availability
- Tune databases handling millions of records
- Work closely with software engineers to improve application performance
- Design partitioning and archival strategies for large datasets
- Manage database security, permissions, and auditing
- Review application database designs before production deployment
- Troubleshoot production database issues with minimal downtime
- Support DevOps teams with database deployments and migrations
Requirements
- 4+ years of experience as a Database Engineer or DBA
- Strong expertise in MariaDB, MySQL, or PostgreSQL
- Excellent SQL query writing and optimization skills
- Deep understanding of:
- Indexing
- Query execution plans
- Transactions
- Locking
- Deadlock analysis
- Isolation levels
- Experience with database replication and failover
- Knowledge of backup and recovery strategies
- Experience designing normalized and denormalized schemas
- Strong understanding of data integrity and constraints
- Experience working with high-volume production databases
- Knowledge and experience in database architecture
- Knowledge and experience in multi-tenant applications
- Knowledge and experience in microservices data design
- Knowledge and experience in event-driven systems
- Knowledge and experience in high concurrency systems
- Knowledge and experience in read/write database separation
- Knowledge and experience in performance tuning
- Knowledge and experience in database scaling strategies
- Knowledge and experience in data migration
- Knowledge and experience in audit logging
- Knowledge and experience in reporting databases
