Database Administrator

Company:

enGen

We are seeking a skilled and proactive Mid-Level Database Administrator to join our strong, dedicated, and experienced team. The ideal candidate will primarily focus on the reliable operation, maintenance, and performance of our on-prem SQL Server environments.

A foundational understanding of cloud database concepts, particularly Google Cloud SQL, is important, coupled with a strong willingness to learn and grow across diverse database platforms, including Postgres and MySQL on Linux.

They should possess strong communication skills and a keen understanding of automating database tasks and managing infrastructure as code to enhance efficiency. 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.

• Database Operations & Performance:
  Manage the day-to-day operation, maintenance, and performance tuning of on-prem SQL Server instances and databases. This includes monitoring, capacity planning, and optimizing queries.
• Installation & Configuration:
  Install, configure, and patch SQL Server environments, including managing SQL Server Agent jobs.
• 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:
  Administer SQL Server security, managing 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.

• Create, develop, and review the physical model from the logical model, ensuring detailed physical design complies with standards, guidelines, and procedures for data modeling, database design, and maintenance. Provide support for application staff and business areas regarding database implementations, including customized in-house database and/or third-party application package. Establish automated monitor mechanism for space and database availability conditions. Establish best practices for database and application high availability through third-party technologies and database features.
• Provide application support for staff and 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 compliance with required corporate standards, procedures, guidelines, and processes, including audits.
• Assist in identifying, developing, and providing technology training to the application developers of the organization (formal and informal). Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources.
• Participate as assigned to intra‑ and inter‑departmental project initiatives. Participate as assigned in the testing and recommendation of tools and utilities to improve the effectiveness…