Job Description
We are looking for a talented, energetic, and detail-oriented Mid-Level Database Administrator (DBA) with deep SQL optimization experience to join our growing team. Over the past two years, our organization successfully transitioned from an on-premises datacenter to 100% in the AWS cloud. In this role, you will be part of a geographically dispersed DBA team responsible for managing our fully cloud-native database environment. You will work closely with IT, Engineering, QA, and Data & Analytics teams to modernize, maintain, and improve our data architecture.
A deep understanding of SQL, robust cloud database management skills, and independent problem-solving abilities are essential for this role. While our ecosystem is heavily focused on PostgreSQL, experience maintaining or migrating legacy SQL Server environments is highly valued.
Role and Responsibilities
- Cloud Database Management: Create, configure, monitor, and maintain PostgreSQL database servers within AWS, ensuring high availability, health, and security across production, QA, and development environments.
- Security & Access Control: Manage IAM and database access control at various security levels, conducting periodic audits to maintain compliance.
- Backup & Disaster Recovery: Oversee automated backup and recovery systems using native tools and AWS automated processes; maintain and regularly test disaster recovery procedures.
- Maintenance & High Availability: Perform regular maintenance, patching, and major version upgrades with minimal downtime using cloud-native strategies.
- Replication & Scaling: Configure, support, and monitor database replication (including Aurora Read Replicas and logical replication) to ensure data durability and performance.
- Developer Support & Optimization: Collaborate with engineering teams to assist with schema design, deployment processes, and advanced query optimization.
- Code Review: Peer-review developer-written SQL code to ensure efficiency, security, and adherence to database standards.
- Performance Tuning: Analyze complex performance bottlenecks to determine the best solution, whether through index strategies, query rewriting, or server-side configuration changes.
- Cross-Platform Support: Maintain and support existing Microsoft SQL Server environments as required by the business.
- On-Call Support: Participate in a 24x7 on-call support rotation to ensure enterprise reliability.