IT Database Engineer
Job Description
Design, develop, install, and support all databases (70% Microsoft SQL and 30% Oracle) to support Business Unit and Application Development, both in clustered and stand-alone environments leveraging virtual infrastructure
Build and support AWS RDS using Terraform in compliance to AWS Well-Architected Framework.
Execute recurring and timely SQL server maintenance to ensure consistent and reliable database environment
Monitor and fine tune databases and performance issues as required, this includes proactive monitoring of application SQL to recommend improvements and query optimization
Implement and manage high availability solutions such as Always On Availability Groups, log shipping, mirroring, or other technologies
Responsible for identifying and implementing improvements to databases to optimize performance
Maintain backup/recovery processes and maintenance to ensure recovery timelines are met and assist development in lower environmental restores
Monitor and troubleshoot issues with all SQL Server stack products (i.e. SQL Server, SSRS, SSIS, SSAS, etc.)
Fluent understanding of database instance maintenance tasks (i.e. DB Integrity Checks, Index Maintenance, etc.) and how to resolve
Advise developers on the most efficient database design (tables, data types, stored procedures, etc.)
Using profiler trace and other tools to find most frequently ran queries and help resolve issues with those queries
Automate and support deployments to different environments
Qualification
Bachelor's degree in related field, equivalent work experienceMinimum 8+ years of experience required with Microsoft SQL Server 2012/2016/2019 Enterprise and Standard EditionsMinimum of 2+ years of experience administering Oracle, including RMAN backupsIndustry certifications such as AWS, Microsoft MCSA: SQL certified preferredExperience working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)Experience in database migration to cloud, AWS RDS, or similar cloud servicesStrong Database Administration and SQL Coding/Debugging SkillsExperience in monitoring database performance and fine tune both server and database parameters using native and third-party tools.Experience in working and installing Microsoft Clustering Services (MSCS) MS SQL Server Active/Active and Active/PassiveAbility to provide on call responsibilities for 24x7 production supportAbility to work a flexible schedule, perform after hour maintenance and support
About The Hospitals and Health Care
Hospitals and Healthcare is a leading provider of performance management analytics, consulting, extended business office, and revenue recovery services to the healthcare industry.
Jobs
