C
Senior Operational Database Administrator
Not specifiedFull-timeDatabase AdministrationRetail Technology
Take hands-on ownership of production databases and data environments, ensuring reliability, performance, security, and scalability. Partner with infrastructure, security, and development teams to support a growing retail technology platform.
Responsibilities
- Own the availability, reliability, performance, and security of production databases.
- Monitor database health, capacity, replication, and resource utilization, and resolve emerging issues.
- Design and test backup, restore, disaster recovery, and high-availability strategies aligned with RPO and RTO targets.
- Investigate production incidents, perform root-cause analysis, and implement preventive improvements.
- Diagnose and resolve query, indexing, locking, connection, and resource-contention issues.
- Plan and execute database upgrades, patches, migrations, and configuration changes with minimal downtime.
- Manage database users, roles, permissions, authentication, and auditing using least-privilege principles.
- Establish database monitoring, alerting, dashboards, and operational runbooks.
- Build, maintain, and monitor ETL/ELT pipelines across operational SQL and NoSQL databases, including batch, CDC, replication, and event-driven flows.
- Work with infrastructure, security, and development teams to improve database resilience and operational readiness.
Requirements
- At least 6 years of database engineering or application/production DBA experience.
- Hands-on experience operating relational databases, including schema design, indexing, query optimization, migrations, and performance troubleshooting.
- Hands-on experience operating NoSQL databases, preferably document databases, including data modeling, indexing, scaling, and performance optimization.
- Experience collaborating with software development and R&D teams on database architecture, implementation, troubleshooting, and optimization.
- Experience building ETL/ELT pipelines for operational systems, including reliability, data consistency, failure recovery, and production workload considerations.
Nice to have
- Strong PostgreSQL experience.
- Experience with MongoDB and MongoDB Atlas.
- Experience with Airflow or similar workflow orchestration tools.
- Experience designing systems for high-volume telemetry, IoT, or event data.
- Experience with multi-tenant and distributed data architectures.