Senior Database Administrator

Company : enGen Job Description

JOB SUMMARY

*** CANDIDATE MUST BE US Citizen (due to contractual/access requirements)***

We are seeking a Database Administrator with experience in Postgre

SQL databases within Google Cloud Platform (GCP), as well knowledge in Microsoft SQL Server on-prem environment. This role involves comprehensive support for database projects, encompassing design, implementation, and optimization, as well as critical production support to ensure high availability and performance. The ideal candidate will also be responsible for collaborating effectively with third-party vendors and other internal teams to integrate and support database solutions.

• Cloud SQL for Postgre
  
  SQL Expertise:
• Proficient in managing and optimizing Postgre
  
  SQL databases within the Google Cloud Platform (GCP) Cloud SQL environment.
• Experience with Cloud SQL administration tasks, including provisioning, configuration, scaling, backup and recovery, and monitoring.
• Familiarity with Postgre
  
  SQL specific features, performance tuning, and troubleshooting in a cloud context.
• SQL Server Administration:
• Knowledge in SQL Server administration, including installation, configuration, patching, and upgrades.
• SQL Server performance tuning, indexing strategies, and query optimization.
• Experience with high availability and disaster recovery solutions for SQL Server (e.g., Always On Availability Groups, log shipping, replication).
• Database Design and Development Support:
• Ability to collaborate with development teams on database schema design, data modeling, and query development best practices.
• Experience in reviewing and optimizing SQL code for performance and efficiency across both Postgre
  
  SQL and SQL Server.
• Monitoring and Alerting:
• Proficiency in setting up and maintaining database monitoring tools and alerts to ensure optimal performance and availability.
• Experience with tools relevant to both Cloud SQL (e.g., Cloud Monitoring, Cloud Logging) and SQL Server.
• Knowledge of Solar Winds is a plus
• Security and Compliance:
• Understanding of database security best practices, including user and role management, encryption, and data masking.
• Knowledge of compliance requirements relevant to healthcare data (e.g., HIPAA) is a significant plus.
• Automation and Scripting:
• Experience with scripting languages (e.g., Python, Power Shell) for automating routine DBA tasks and deployments.
• Familiarity with Infrastructure as Code (IaC) principles, Terraform and tools is beneficial.

ESSENTIAL RESPONSIBILITIES

• Take a lead role to 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 more complex data modeling, database design, and maintenance.
• Take a lead role to provide support for application staff and business areas regarding more complex 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.
• Take a lead role in providing 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
• Take a lead role in conducting root cause analysis to identify and resolve problems impacting more complex 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.
• Take a lead role and participates in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. Assure compliance to required…