hero

Join the Edison family of high-growth, market-leading companies in financial services, healthcare, enterprise software sectors.

51
companies
353
Jobs

Senior SQL Server Performance Tuning Database Administrator

Zelis

Zelis

IT
Boston, MA, USA · Atlanta, GA, USA
Posted on Aug 31, 2023

The Senior SQL Server Performance Tuning Database Administrator is responsible for the performance, reliability, and scalability of the organization’s current MS SQL Server database environments as well as the design, construction, and population of our new technology database schemas/environments.

From a day-to-day perspective, this position will be responsible to drive efforts to implement and/or refine operational and business continuity processes such as performance tuning, availability groups, clustering, mirroring, backups and high availability. Additionally, tasks include supporting our production and development MS SQL Server databases and ensuring their performance, availability, recovery, maintain security and utilization.

Key Responsibilities

The Senior SQL Server Performance Tunning Database Administrator will be responsible for working closely with a team of SQL Server DBA professionals, providing leadership in performance tuning, design, architecting, maintaining, securing and providing on-call support for HA database systems (On-Prem and Cloud)

  • Subject matter expert in MS SQL Server performance tuning

  • Provide leadership in creating roadmaps and future state architecture of SQL Server platform collaborating with stake holders and business partners.

  • Participate proactively in daily stand-up meetings, story grooming sessions, team retrospectives, suggesting and implementing improvements.

  • Ensure performance, security, scalability and availability of enterprise MS SQL databases.

  • Perform technical troubleshooting to diagnose, isolate and correct data and database issues.

  • Research emerging trends and new technologies to identify potential improvements.

  • Anticipates issues and develops preventive measures.

  • Collaborate with clients, service providers and peers to successfully deliver on business commitments.

  • Negotiate solutions for issues that may be complex or controversial.

  • Design, implement and monitor disaster recovery plans as it pertains to the production database environment.

  • Strong TSQL and PowerShell knowledge; able to write and read as well as diagnose, develop and troubleshoot scripts.

  • Work with Atlassian products such as Jira and Confluence.

Technical Responsibilities

  • Identify high-load SQL statements.

  • Gather performance-related data

  • Determine Inefficiently designed SQL statements.

  • Identify Suboptimal execution plans.

  • Identify and resolve missing, unused, and indexes that need enhancements.

  • Identify stale statistics.

  • Identify suboptimal hardware performance related to memory pressure, I/O, and CPU.

Functional Competencies

  • Superior troubleshooting skills, inquisitiveness, and the ability to preemptively resolve problems.

  • Strong communication (oral and written) & presentation skills combined with the ability to influence others at different levels of leadership.

  • Ability to ‘own’ and drive projects and initiatives.

  • Strong people and thought leadership; ability to develop, mentor and coach others.

  • Demonstrated and foster a sense of urgency, strong commitment, and ownership.

  • High level of personal accountability for the continuity and improvement of the organization’s database environments, data, and processes.

Required Experience:

  • 10+ years of experience in MSSQL Server (version 2019) in an enterprise level environment.

  • Strong performance tuning experience

  • Experience with managing large-scale, complex database environments supporting complex/critical applications.

  • Lead level expertise in MSSQL database platform

  • Major ticketing system

  • Architect level experience

  • Work on-call once every 6 weeks

Preferred Experience:

  • Bachelor’s degree or equivalent experience

  • Familiarity with Atlassian products such as Jira and Confluence

  • Knowledge of PowerShell

As a leading payments company in healthcare, we guide, price, explain, and pay for care on behalf of insurers and their members. We’re Zelis in our pursuit to align the interests of payers, providers, and consumers to deliver a better financial experience and more affordable, transparent care for all. We partner with more than 700 payers, including the top-5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, over 4 million providers, and 100 million members, enabling the healthcare industry to pay for care, with care. Zelis brings adaptive technology, a deeply ingrained service culture, and a comprehensive navigation through adjudication and payment platform to manage the complete payment process.

Commitment to Diversity, Equity, Inclusion, and Belonging
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations. We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work. We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.

Equal Employment Opportunity
Zelis is proud to be an equal opportunity employer. All applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

We encourage members of traditionally underrepresented communities to apply, even if you do not believe you 100% fit the qualifications of the position, including women, LGBTQIA people, people of color, and people with disabilities.

Accessibility Support

We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email TalentAcquisition@zelis.com

SCAM ALERT: There is an active nationwide employment scam which is now using Zelis to garner personal information or financial scams. This site is secure, and any applications made here are with our legitimate partner. If you’re contacted by a Zelis Recruiter, please ensure whomever is contacting you truly represents Zelis Healthcare. We will never asked for the exchange of any money or credit card details during the recruitment process. Please be aware of any suspicious email activity from people who could be pretending to be recruiters or senior professionals at Zelis.