Database Administrator

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 ResponsibilitiesCloud 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.