Database Engineer
Posted
Description
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.
- 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.
- MariaDB MaxScale
- Galera Cluster
- ProxySQL
- Redis
- RabbitMQ
- Docker
- Kubernetes
- AWS / Azure / GCP
- Grafana Prometheus
- Liquibase or Flyway
- OpenSearch or Elasticsearch
- Spring Boot database optimization
- Database architecture
- Multi-tenant applications
- Microservices data design
- Event-driven systems
- High concurrency systems
- Read/write database separation
- Performance tuning
- Database scaling strategies
- Data migration
- Audit logging
- Reporting databases
- Workplace Type: In-Office
- Employment Type: Full-time
- Experience Level: mid-senior-level
- Work Experience (years): 4 - 8 years
- Skills: database engineer, sql, mysql