Database Engineer

What You'll Do
● 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.

Required Skills
● 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.

Good to Have
● MariaDB MaxScale
● Galera Cluster
● ProxySQL
● Redis
● RabbitMQ
● Docker
● Kubernetes
● AWS / Azure / GCP
● Grafana & Prometheus
● Liquibase or Flyway
● OpenSearch or Elasticsearch
● Spring Boot database optimization

We'd Love Someone Who Understands
● 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