Cloud Database Administrator

We are seeking a mid-level Database Administrator to join our team. This position requires experience with Google Cloud Platform (GCP), and a foundational understanding of on-prem Microsoft SQL Server. The ideal candidate will possess a solid understanding of cloud infrastructure as code, demonstrated by proficiency in Terraform, including the development and management of custom Terraform providers/modules. Version control expertise using Git is essential, along with hands-on experience utilizing the Google Cloud CLI and SDK for automation and resource management. A background in Python programming is preferred, particularly for developing and deploying applications on Cloud Run and automating DBA tasks. Candidates should have experience with GCP's managed database services, including Cloud SQL for PostgreSQL, Spanner, and AlloyDB. This role offers an excellent opportunity for professional growth within an experienced team, contributing to the support and evolution of critical database systems that underpin both our provider and payer side operations. Candidates should be capable of working independently on routine database administration tasks, troubleshooting issues, and collaborating effectively with application teams and vendors on customer projects with limited guidance.

Responsibilities

Manage day-to-day operation, maintenance, and performance tuning of databases, including monitoring, capacity planning, and optimizing queries; Install, configure, and patch databases; Maintain backup and recovery strategies to ensure data integrity and availability; Monitor and maintain existing high availability and disaster recovery solutions (e.g., Always On Availability Groups) and assist with their implementation; Manage logins, users, roles, permissions, and ensure compliance with security policies; Diagnose and resolve database-related issues, provide support to application teams and vendors, and participate in incident resolution; Maintain clear and comprehensive documentation for database systems and processes; Provide after hours and weekend support as required for on-call responsibilities, database refreshes, testing, technology upgrades, and other off-hour assignments; Create, develop, and review physical models and ensure compliance with data modeling and database design standards; Establish automated monitoring for space and database availability; Conduct root cause analysis and contact vendor support when necessary; Participate in establishing technical standards, departmental procedures, and provide training to application developers

Requirements

CANDIDATE MUST BE US Citizen (due to contractual/access requirements); High school diploma GED; 1-3 years of experience in Information Technology; Experience with Google Cloud Platform (GCP); Foundational understanding of on-prem Microsoft SQL Server; Solid understanding of cloud infrastructure as code; Proficiency in Terraform, including development and management of custom Terraform providers/modules; Version control expertise using Git; Hands-on experience with Google Cloud CLI and SDK for automation and resource management; Experience with GCP's managed database services, including Cloud SQL for PostgreSQL, Spanner, and AlloyDB; Ability to work independently on routine database administration tasks, troubleshooting issues, and collaborating effectively with application teams and vendors on customer projects with limited guidance

Nice to have

Bachelor’s degree in information technology, Computer Science, or closely related field; Google Certifications; Vendor DBA Certifications for the relevant DBMS; Health insurance business knowledge; 3 to 5+ years of experience; Experience with GCP database services including Cloud SQL (PostgreSQL), Cloud Spanner, and AlloyDB; Experience with other cloud platform such as AWS; Proficiency in Terraform including custom Terraform providers, modules, and state management; Previous experience using Git for source code management, branching strategies, and collaborative development; Hands-on experience with Google Cloud CLI and SDK for automation, scripting, and resource interaction; Experience in Python programming, with focus on cloud-native application development and automation; Experience in developing and deploying applications on Cloud Run; Familiarity with prompt engineering and fine-tuning models like Claude for specific data-related tasks; Experience in automating routine database administration tasks using scripting and AI tools; AI tools such as Gemini, Claude, Duo, Copilot; Experience with SQL Server databases; SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS); Scripting proficiency in PowerShell; Knowledge of SolarWinds DPA for performance tuning, monitoring, and SQL; On-prem MySQL on Linux