Database Administrator/SQL Developer

Essette, a medical management software division within HMS, is seeking a talented Database Administrator/SQL Developer, responsible for managing database performance and security within the Essette software offering. This role also assists with designing and building high-performing and scalable ETL and data migration solutions. This role will work closely with both Essette's product development and implementation teams. The position is based in Essette's Longmont, Colorado office, with the expectation that the individual work from the office most days to offer high visibility and consistency. The Database Administrator/SQL Developer position reports to the Director of Operations.
Essette, a medical management software division within HMS, is seeking a talented Database Administrator/SQL Developer, responsible for managing database performance and security within the Essette software offering. This role also assists with designing and building high-performing and scalable ETL and data migration solutions. This role will work closely with both Essette's product development and implementation teams. The position is based in Essette's Longmont, Colorado office, with the expectation that the individual work from the office most days to offer high visibility and consistency. The Database Administrator/SQL Developer position reports to the Director of Operations.
Essential Responsibilities: - Performs database/application performance monitoring and tuning in both a development and production-support capacity.- Establishes and maintains sound backup and recovery policies and procedures in conjunction with the system administrators. - Develops database interfaces required to move critical data between disparate systems.- Implements and maintains database security.- Creates and implements plans for database growth and changes.- Creates and documents database development and testing standards.- Builds and maintains scripts to create and populate databases with pre-defined health care industry content.- Performs database patch management and version control.
Essential Responsibilities: - Performs database/application performance monitoring and tuning in both a development and production-support capacity.- Establishes and maintains sound backup and recovery policies and procedures in conjunction with the system administrators. - Develops database interfaces required to move critical data between disparate systems.- Implements and maintains database security.- Creates and implements plans for database growth and changes.- Creates and documents database development and testing standards.- Builds and maintains scripts to create and populate databases with pre-defined health care industry content.- Performs database patch management and version control.
Non-Essential Responsibilities: - Performs other functions as assigned
Non-Essential Responsibilities: - Performs other functions as assigned
Knowledge, Skills and Abilities:- Advanced understanding of Microsoft SQL Server 2014 to the current version.- Database storage, security, warehousing, encryption, and recovery best practices.- Ability to write complex and high-performing SQL statements.- Understanding of industry-standard database management tools.- Experience with transferring large quantities of data (millions of records or more) between systems while applying complex business logic during transformation, using MS SSIS, SQL scripts, or other data transfer tools.- Ability to work independently and with a team.- Ability to manage multiple assignments simultaneously.- Exceptional analytical and deduction skills.
Knowledge, Skills and Abilities:- Advanced understanding of Microsoft SQL Server 2014 to the current version.- Database storage, security, warehousing, encryption, and recovery best practices.- Ability to write complex and high-performing SQL statements.- Understanding of industry-standard database management tools.- Experience with transferring large quantities of data (millions of records or more) between systems while applying complex business logic during transformation, using MS SSIS, SQL scripts, or other data transfer tools.- Ability to work independently and with a team.- Ability to manage multiple assignments simultaneously.- Exceptional analytical and deduction skills.
Work Conditions and Physical Demands:- Primarily sedentary work in a general office environment- Ability to communicate and exchange information- Ability to comprehend and interpret documents and data- Requires occasional standing, walking, lifting, and moving objects (up to 10 lbs.)- Requires manual dexterity to use computer, telephone and peripherals- May be required to work extended hours for special business needs- May be required to travel at least 5% of time based on business needs
Work Conditions and Physical Demands:- Primarily sedentary work in a general office environment- Ability to communicate and exchange information- Ability to comprehend and interpret documents and data- Requires occasional standing, walking, lifting, and moving objects (up to 10 lbs.)- Requires manual dexterity to use computer, telephone and peripherals- May be required to work extended hours for special business needs- May be required to travel at least 5% of time based on business needs
Minimum Education:- Bachelor's Degree preferredMinimum Related Work Experience:- 5 years of experience in database management in Microsoft SQL Server environments- 5 years of experience in complex ETL and data manipulation
Minimum Education:- Bachelor's Degree preferredMinimum Related Work Experience:- 5 years of experience in database management in Microsoft SQL Server environments- 5 years of experience in complex ETL and data manipulation