Database Administrator

Company: Health Management Associates
Location: Saint Paul
Posted on: March 16, 2023

Job Description:

Cirdan Health Consulting, an HMA company, is recruiting for a Database Administrator. We offer a flexible (in-office, Hybrid, or WFH) set up, but do prefer someone be commutable to our main office location in St. Paul. On a case-by-case basis, we will consider a fully remote WFH setup. Job SummaryA Database Administrator will work on a development team in a dynamic healthcare actuarial and data warehousing environment. They will support our many and varied ETL operations with an emphasis on improved standardization, accuracy, efficiency, automation, and documentation in our data warehouse operation. The Database Administrator will be provided projects that will offer opportunities to gain broad knowledge of the ever-changing health care environment.Work Performed and Job RequirementsSpecific database administrator responsibilities may include:Proactively monitoring and resolving database and server performance issues by identifying bottlenecks, capacity issues, and areas for improvementDesigning a backup and retention policy to achieve variable recovery point objectives (RPO) and recovery time objectives (RTO) based on server needs while minimizing data bloatMonitoring and managing backups, recovery testing and retention processes and procedures to ensure viable recovery points conform to RPOAssisting in disaster recovery processes and proceduresImplementing and validating user access levels for databases and serversImproving database operational efficiency through configuration, targeted query updates and index creationPlanning, scheduling, and implementing database and server patching and upgradesMonitoring and remediating after-hours failed processes and critical server issuesProviding SQL training for internal users and assist with ad-hoc query design to improve performanceSupporting database server functions by designing and coding utilities, scripts, jobs, packages, etc.Specific developer responsibilities may include:Developing, testing, debugging, and deploying SSIS solutions to efficiently automate recurring ETL tasksMaintaining, updating, and upgrading existing SSIS solutionsAssisting in determination of root cause and future prevention strategies for complex issues related to ETL tasks failureCollaborating with internal staff to determine and apply best practices to both new and existing solutionsDocumentation of code, user instructions, data, and process flowIndependent creation of complex SQL queries to perform data analysis and validationRoutine and ad-hoc data downloading, uploading, and validation as neededAll other duties as assigned.Education/TrainingBachelor's degree in computer science/database management or similarExperienceAt least three years of experience in data processing and ETL development.Minimum of five years of experience with database management in the following:Server performance monitoring and tuningData backup and recoveryData warehousingMS SQL (2014 or later)MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS); 2012 or laterMicrosoft Word and ExcelKnowledge, Skills and AbilitiesExcellent written and verbal communication skillsAbility to collaborate effectively and work as part of a teamExcellent time management and organizational skillsSelf-motivation and curiosity to learn, understand and growStrong attention to detail and analytical abilitiesExperience with healthcare data helpful, but not requiredWork Aids and Equipment UsedComputer, printer, copier, scanner, fax, telephone, web conferencing.Working ConditionsThis position is expected to be primarily remote. To work remotely, reliable and fast internet access must be available. If this is not available, attendance at the office is expected.Occasional short-term travel may be required.Physical/Mental DemandsWork requires hand dexterity for office machine operation; stooping, climbing, and bending to files and supplies; mobility to complete errands; stand/sit for up to eight hours each day; ability to communicate clearly when using the telephone; requires sitting; standing, walking, reaching, bending, lifting, and twisting at times; moderate levels of stress. Prolonged periods sitting at a desk and working on a computerMust be able to lift up to 15 pounds at timesEqual Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)Vaccine RequirementThe Executive Order on Ensuring Adequate COVID Safety Protocols for Federal Contractors (EO 14042) is not currently being enforced by the Federal Government. However, please be advised that Health Management Associates (HMA) does work on or in connection with federal contracts and/or subcontracts and may be required to abide by this Executive Order if enforcement is reinstated by Federal Government.In accordance with the Executive Order on Ensuring Adequate COVID Safety Protocols for Federal Contractors, Health Management Associates (HMA), has adopted the Federal Contractor COVID-19 Vaccination Policy to comply with the requirements for entities that are assigned to federal contracts/subcontracts, and to safeguard the health of our colleagues and their families; our clients and visitors; and the community at large from COVID-19.This policy applies to current and future HMA colleagues working on or in connection with any federal contract and/or subcontract for which HMA and/or its subsidiaries are a party, including colleagues working from home/remotely. These colleagues may include, but may not be limited to, administrative colleagues and worksite colleagues. In addition, colleagues may be required to show proof of vaccination to work on specific client engagements if the client requires the same.Colleagues who will be working on federal contracts will need to provide proof of vaccine prior to their start date. Employment will be contingent upon the employer receiving proof of being fully vaccinated. Fully vaccinated means receiving two doses of Moderna or Pfizer COVID-19 vaccine, or one dose of the Johnson & Johnson COVID-19 vaccine.

Keywords: Health Management Associates, St. Paul , Database Administrator, Other , Saint Paul, Minnesota