SQL Database Administrator

  • Ascension
  • Sterling, MI 48659, USA
  • Oct 23, 2018

Job Description

Title: SQL Database Administrator
City, State:  Sterling, MI
Location:  MI Sterling - Offsite
Department:   Solutions Admin
Additional Job Details:  FT Days, 40 hours. 8am-5pm.
Why Join Ascension?
Ascension Technologies is one of the nation's largest healthcare information technology services organizations.
We provide Ascension and its subsidiaries low-cost, high-value IT infrastructure and software application services that:
• Support rapid and effective clinical decision making
• Improve efficiency and care transitions
• Foster information sharing across the continuum of care
• Make knowledge and data actionable, leading to improved   patient outcomes

What You Will Do
Summary:
Overall responsibility for administration and technical support of multiple database environments, utilized within Ascension Care Management Holdings to support claims administration. Administration and technical support functions include though not limited to; ensuring operational readiness (security, health and performance), executing data loads, overseeing installation, upgrades, administration, tuning, development, high reliability, performing data modeling in support of multiple development teams and performance through architecture and application integration development to achieve a state of the art environment meeting current and future business needs. Must be capable of working independently and collaboratively within a team.
 
Responsibilities:
  • Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)
  • Test backups to ensure business' Recovery Time Objectives (RTO) can be met
  • Deploy database change scripts provided by third party vendors
  • Build required database schemas, tables, procedures, indexes and permissions
  • Establish disk sharing and disk partitioning
  • Develop database utilities and automated reporting
  • Work with Solution Architect during the Facets upgrade process to determine if Database or business changes will impact product configuration
  • When database performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Design and document database architecture and data modeling
  • Create shell scripts for task automation
  • On-call troubleshooting experience for service outages
  • Tuning SQL queries to improve performance
  • Ensure new database code meets company standards for readability, reliability, and performance
  • Weekly, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
  • Design indexes for existing applications, choosing when to add or remove indexes
  • When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
  • Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)
  • Designing tables and picking datatypes
  • Using Profiler traces and other tools to find the most frequently run queries
  • Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem

Qualifications
Education:
  • Bachelor's degree preferred or equivalent experience.
Work Experience:
  • Two years of experience required.
  • DBA Administration inside Trizetto preferred
  • Healthcare Payor Systems (Trizetto / Cognizant, Facets ) preferred
  • Trizeto Facets experience preferred
Preferred Skills:
  • Strong proficiency with SQL and its variation among popular databases
  • Technical Literacy - Possesses a high level of technical literacy, with the ability to determine how a data solution fits into an organization's current structure and assists in the development of specifications and requirements
  • Analytical Assessment -  A high level of analytical skills to examine existing current data structures and determine overall data need and project scope required to implement
  • Skilled at optimizing large complicated SQL statements
  • Schedule Management - Need extensive time management skills to determine development schedules and milestones and ensure that deliverables are completed on time
  • Team Leadership - Oversee data requirement throughout the project development lifecycle.
  • Knowledge of best practices when dealing with relational databases
  • Capable of configuring popular database engines and orchestrating clusters as necessary
  • Experience with team leadership and motivation is essential
  • Ability to plan resource requirements from high level specifications
  • Capable of troubleshooting common database issues
  • Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Responsible for communicating with management, team members, stake holders, clients and external vendors, exhibiting excellent written and verbal communication skills
  • Need to be excellent problem-solvers, demonstrating the ability to quickly change direction based on updated client specifications or system limitations.
  • Working experience/knowledge of Facets software and data structures
Equal Employment Opportunity
Ascension Technologies is an EEO/AA Employer M/F/Disability/Vet. Please click the link below for more information.
 
http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf
 
EEO is the Law Poster Supplement
http://www.dol.gov/ofccp/regs/compliance/posters/pdf/ofccp_eeo_supplement_final_jrf_qa_508c.pdf
E-Verify Statement
Ascension Technologies participates in the Electronic Employment Verification Program. Please click the E-Verify link below for more information.
E-Verify (link to E-verify site)