Cloud Database Administrator

## **Company :** enGen ## **Job Description :** **JOB SUMMARY** **\*\*\*CANDIDATE MUST BE US Citizen (due to contractual/access requirements)\*\*\*** 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. **Duties include** - **Database Operations & Performance:** Manage the day-to-day operation, maintenance, and performance tuning. This includes monitoring, capacity planning, and optimizing queries. - **Installation & Configuration:** Install, configure, and patch. - **Backup & Recovery:** Maintain backup and recovery strategies to ensure data integrity and availability. - **High Availability & Disaster Recovery (HA/DR):** Monitor and maintain existing HA/DR solutions (e.g., Always On Availability Groups) and assist with their implementation. - **Security Management:** Manage logins, users, roles, permissions, and ensuring compliance with security policies. - **Troubleshooting & Support:** Diagnose and resolve database-related issues, providing support to application teams, vendors, and participating in incident resolution. - **Documentation:** Maintain clear and comprehensive documentation for database systems and processes. **ESSENTIAL RESPONSIBILITIES** - Create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of data modeling, database design, and maintenance. Provide support for application staff and business areas regarding database implementations, which could include a customized in-house database and/or a third party application package. Establish automated monitor mechanism for space and database availability conditions. Establish best practices for database and application high availability through the use of third party technologies and through the exploitation of various database features. - Provide applications support for staff, as well as, outside division to answer questions and resolve problems related to the DBMS technology and computing platform such as Z/OS, UNIX, Linux, and Windows. Conduct root cause analysis to identify and resolve problems impacting application and/or database availability and service levels. Contact vendor support when necessary to facilitate application development and client problem resolution with optimum speed and efficiency. - Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments. - Participate in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. Assure compli…