Job Description
JOB DESCRIPTION:
- The Senior Engineer - Database is a critical role in ensuring the performance, scalability, security, and resilience of our databases. You will work closely with Software Engineers, Infrastructure Engineers, CI/CD Engineers, Data Warehouse Team, Customer Success Teams, and Analytics Team to design, deploy, and manage robust database systems.
- This role requires deep technical expertise in database administration, performance tuning, automation, and cloud-based database solutions. You will be responsible for driving best practices, optimizing database performance, ensuring security compliance, and contributing to the architecture of mission-critical systems.
KEY RELATIONSHIPS:
- Software Engineers.
- Infrastructure Engineers.
- CI/CD Engineers.
- Data Warehouse Team.
- Customer Success Teams.
- Analytics Team.
CORE RESPONSIBILITIES:
- Database Administration: Manage and maintain SQL and NoSQL databases to ensure availability, security, and performance.
- Performance Tuning & Optimization: Analyze database queries, indexes, and performance bottlenecks, and implement solutions for efficiency.
- Scalability & High Availability: Architect and maintain scalable and fault-tolerant database solutions using replication, clustering, and partitioning techniques.
- Automation & Scripting: Automate database maintenance tasks using Python, Bash, Terraform, or Ansible to improve efficiency and reduce manual effort.
- Backup & Disaster Recovery: Develop and manage reliable backup and restore strategies, ensuring business continuity and minimizing data loss risks.
- Security & Compliance: Implement and enforce database security best practices, including role-based access control (RBAC), encryption, and compliance with data protection laws.
- Observability & Monitoring: Set up proactive monitoring and alerting for database health, performance, and capacity planning using tools like Prometheus, Datadog, Grafana, or New Relic.
- Cloud & On-Premise Database Management: Support both cloud-native (AWS RDS, Aurora, DynamoDB, Google Cloud Spanner, etc.) and self-hosted database solutions.
- Incident Response & Troubleshooting: Act as a subject matter expert in diagnosing and resolving complex database issues in production environments.
- Documentation & Knowledge Sharing: Maintain up-to-date documentation and contribute to internal knowledge bases to ensure smooth onboarding and operational excellence.
QUALIFICATIONS & EXPERIENCE:
- 5+ years of hands-on experience in database administration, engineering, or architecture.
- Expertise in relational database management systems (RDBMS) such as MySQL, PostgreSQL, SQL Server, or Oracle.
- Experience managing NoSQL/NewSQL databases such as MongoDB, Cassandra, CockroachDB, or Google Spanner.
- Strong knowledge of query optimization, indexing, caching strategies, and database schema design.
- Experience with database replication, clustering, sharding, and failover strategies.
- Proficiency in Linux-based environments and shell scripting for database operations.
- Understanding of networking concepts (TCP/IP, DNS, HTTP/HTTPS, security best practices).
- Experience implementing database security measures, auditing, and compliance (e.g., GDPR, SOC2, PCI DSS).
- Hands-on experience with Cloud Database Services (AWS RDS, Aurora, Google Cloud SQL, Azure SQL, etc.).
SKILLS:
- Database Administration for SQL and NOSQL environments
- Linux Administration.
- Proficiency in SQL language.Proficiency in open source database engines and tools.
- Proficiency in cloud database computing.