Senior SQL Server Database Administrator (DBA) - EviCore - Hybrid
Evernorth Health Services, Morris Plains, NJ, United States
Overview
Senior SQL Server Database Administrator (DBA) - EviCore - Hybrid role at Evernorth Health Services. The Senior SQL Server DBA is responsible for providing technical support for the database environments SQL 2012-2022 in a 24/7 environment. Day to day responsibilities include production support, access provisioning, DBA related tasks, monitoring system alerts, and technical reviews. Participate in on-call rotation. Provide assessment of database performance and identify problem areas. Document the company’s database environment. Building drift management, alerting, deployment, and patching automation solutions using T-SQL and PowerShell. Essential Functions
Production performance troubleshooting / tuning: ensuring high levels of performance, availability, sustainability and security Analyzing, solving and correcting issues in real time SQL Server hardware / software issues troubleshooting Monitor the database performance and prepare database and progress reports. Provide reporting to management. Developing and automating drift management using T-SQL/PowerShell Supporting databases on Azure Manage metrics using Idera/DPA/Dynatrace Backup/Recovery strategies Patching / Certification / Encryption keys management Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database Internal audits Works on internal projects as assigned On-call support Design, implement and manage high availability methods like AlwaysOn Availability Groups, Replication, Log Shipping and Database Mirroring Monitoring system's health and performance using IDERA Diagnostic Manager/SolarWinds Database Performance Analyzer /Dynatrace Qualifications
Bachelor's degree in Information Systems or related field, or equivalent work experience 10+ years in database administration and programming 10+ years IT operation with understanding of SQL Server database structures, theories, principles, and practices Extensive knowledge of database maintenance tasks Knowledge of programming languages (PowerShell, PHP, Python, T-SQL, JavaScript, and other languages) Idera/DPA/Dynatrace Demonstrated ability to design, develop, and maintain databases and automate solutions Project Management Understanding of, and experience with relational database environments Knowledge of reporting and query tools and practices Good interpersonal, written, and oral communication skills Technical documentation skills Ability to present ideas in user-friendly language Self-motivated and directed, with keen attention to detail Able to prioritize and execute tasks in a high-pressure environment Experience working in a team-oriented, collaborative environment Willingness to work a flexible schedule and be on call to accommodate project deadlines Additional Information
If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload. Salary: This position offers an annual salary range of 114,800 - 191,400 USD, depending on experience and geographic location. This role may be eligible to participate in an annual bonus plan. Benefits include medical, vision, dental, well-being and behavioral health programs, 401(k) with company match, company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year and paid holidays. For more details on employee benefits programs, visit Life at Cigna Group. About The Cigna Group: Doing something meaningful starts with a simple decision, a commitment to changing lives. At The Cigna Group, we’re dedicated to improving health and vitality. Qualified applicants will be considered without regard to race, color, age, disability, sex, pregnancy or related medical conditions, veteran or military status, religion, national origin, or any other characteristic protected by equal employment opportunity laws. Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances.
#J-18808-Ljbffr
Senior SQL Server Database Administrator (DBA) - EviCore - Hybrid role at Evernorth Health Services. The Senior SQL Server DBA is responsible for providing technical support for the database environments SQL 2012-2022 in a 24/7 environment. Day to day responsibilities include production support, access provisioning, DBA related tasks, monitoring system alerts, and technical reviews. Participate in on-call rotation. Provide assessment of database performance and identify problem areas. Document the company’s database environment. Building drift management, alerting, deployment, and patching automation solutions using T-SQL and PowerShell. Essential Functions
Production performance troubleshooting / tuning: ensuring high levels of performance, availability, sustainability and security Analyzing, solving and correcting issues in real time SQL Server hardware / software issues troubleshooting Monitor the database performance and prepare database and progress reports. Provide reporting to management. Developing and automating drift management using T-SQL/PowerShell Supporting databases on Azure Manage metrics using Idera/DPA/Dynatrace Backup/Recovery strategies Patching / Certification / Encryption keys management Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database Internal audits Works on internal projects as assigned On-call support Design, implement and manage high availability methods like AlwaysOn Availability Groups, Replication, Log Shipping and Database Mirroring Monitoring system's health and performance using IDERA Diagnostic Manager/SolarWinds Database Performance Analyzer /Dynatrace Qualifications
Bachelor's degree in Information Systems or related field, or equivalent work experience 10+ years in database administration and programming 10+ years IT operation with understanding of SQL Server database structures, theories, principles, and practices Extensive knowledge of database maintenance tasks Knowledge of programming languages (PowerShell, PHP, Python, T-SQL, JavaScript, and other languages) Idera/DPA/Dynatrace Demonstrated ability to design, develop, and maintain databases and automate solutions Project Management Understanding of, and experience with relational database environments Knowledge of reporting and query tools and practices Good interpersonal, written, and oral communication skills Technical documentation skills Ability to present ideas in user-friendly language Self-motivated and directed, with keen attention to detail Able to prioritize and execute tasks in a high-pressure environment Experience working in a team-oriented, collaborative environment Willingness to work a flexible schedule and be on call to accommodate project deadlines Additional Information
If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload. Salary: This position offers an annual salary range of 114,800 - 191,400 USD, depending on experience and geographic location. This role may be eligible to participate in an annual bonus plan. Benefits include medical, vision, dental, well-being and behavioral health programs, 401(k) with company match, company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year and paid holidays. For more details on employee benefits programs, visit Life at Cigna Group. About The Cigna Group: Doing something meaningful starts with a simple decision, a commitment to changing lives. At The Cigna Group, we’re dedicated to improving health and vitality. Qualified applicants will be considered without regard to race, color, age, disability, sex, pregnancy or related medical conditions, veteran or military status, religion, national origin, or any other characteristic protected by equal employment opportunity laws. Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances.
#J-18808-Ljbffr