Lumeris Database Administrator - 3rd shift in St. Louis, Missouri
In order to apply for a position at Lumeris, you must create an account using your email address and a password of your choosing. This account will allow you to receive notifications each step of the way through the job application process. With these updates, you’ll never have to wonder where you are in the process. Additionally, we can easily send pertinent documents to you for your review. Once you create the account, you may apply to any position you feel is a good fit without having to re-enter information. Thank you for your interest in Lumeris.
Database Administrator - 3rd shift
The right candidate will possess expert understanding of the SQL Server architecture, administration and security arenas and will demonstrate a solid grasp of advanced SQL query techniques in addition to experience with large OLTP and OLAP environments. Primary job duties will include support for business intelligence developers as well as maintenance and administration of the live production SQL Server instances including data warehouse and other off-site instances related to live production.
Ensures accurate, appropriate and effective use of data; including data definition, structure, documentation, long-range requirements, and operational guidelines
Augments application development support including updates to data models, creation and maintenance of data access code (typically stored procedures), optimization of existing SQL
Performs quality control audits to ensure accuracy completeness and proper usage of data in tables and support tools, such as database dictionaries
Reviews database design and integration of systems and makes recommendations for enhancements or improvements.
Monitors transaction activity and utilization, with particular strengths in performance tuning highly transactional databases in both the development and production environments including remotely located servers
Ensures data replication is scheduled and optimized
Provide 24x7 on-call support for production systems
Experience, Qualifications, and Education
6+ years DBA experience with Microsoft SQL Server in a production environment
3+ year experience with SSIS / SSRS / SSAS
3+ year experience in database and ETL development
Experience working in agile environment including creating of automated build, integration and data refresh processes
Expertise with configuring, implementing and supporting large high availability SQL Server environments, including experience with replication, log shipping, and database mirroring
Deep understanding of database design principals
Excellent understanding of query execution plans
Expert in Stored Procedures and SQL coding
Expert in query, index and DB I/O performance tuning
Ability to proactively identify, troubleshoot and resolve live database systems issues
Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
Thorough knowledge of current hardware systems, RAID and disk subsystems commonly used in fault tolerant production environments
Ability to manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc.
Experience running and supporting very large databases under high transaction rates (OLTP, VLDB)
Experience running and supporting very large data warehouse databases (OLAP, Big Data)
Lumeris is an EEO/AA employer M/F/V/D.
St. Louis, MO
2 - CO
Join Our Growing Team!
Lumeris serves as a long-term operating partner for organizations that are committed to the transition from volume- to value-based care and delivering extraordinary clinical and financial outcomes. Lumeris enables clients to profitably achieve greater results through proven playbooks based on collaboration, transparent data and innovative engagement methodologies. Lumeris offers comprehensive services for managing all types of populations, including launching new Medicare Advantage Health Plans, Commercial and Government Health Plan Optimization, and Multi-Payer, Multi-Population Health Services Organizations (PHSOs). Currently, Lumeris is engaged with health systems, provider alliances and payers representing tens of millions of lives moving to value-based care.
Over the past seven years, we have tripled in size to more than 800 employees and built the only solution on the market with our proven outcomes. For the past six years, Essence Healthcare, a long-standing Lumeris client, has received 4.5 Stars or higher from the Centers for Medicare and Medicaid Services (CMS). Essence Healthcare was Lumeris’ pioneer client and has been leveraging Lumeris for more than a decade to operate its Medicare Advantage plans, which serve more than 60,000 Medicare beneficiaries in various counties throughout Missouri and southern Illinois.
In 2018, Lumeris was named Best in KLAS for Value-Based Care Managed Services in the area of client-reported impact on the Triple Aim by KLAS Research. This was the third year in a row Lumeris received the award, and it has only been given for three years. As the industry’s most reliable and effective partner for developing population health management solutions, our success is driving tremendous growth in our company. Join us today in making a real difference in how healthcare is delivered!
Why Join Lumeris?
At Lumeris, you will be part of team that is focused on solving the nation’s healthcare problem, and you will be able to contribute to our purpose. Our environment is fast-paced, change-oriented and focused on growth and employee engagement. At Lumeris, we know that talent is best utilized when given the opportunity to succeed. That is why we have removed the boundaries that inhibit success and focus on fostering an environment that allows employees to utilize their talents.