Job Description
Job Description
Data Server and Database Administration for Microsoft SQL Server, db2, MarkLogic, DataStage and Tableau.
1. Servers - Install, configure and maintain Database System software to support the needs of the business in providing excellent service to Meritains customers and partners.
a. Appropriate sizing, resourcing and configuration of database servers to support customer requirements.
b. Maintenance of data server software to meet compliance requirements and sustain current licensing needs. Maintain servers at most recent release level where possible.
c. Assist in the design of servers to meet the requirements of the task or project.
d. Acquire and maintain software to monitor the performance and physical resources of data servers.
e. Provide 24/7 services to address issues uncovered through monitoring processes or as a result of stakeholder discovery.
f. Provide reports that can be used by stakeholders to review server usage and configurations.
2. Database instances - assist in the design, creation and assume responsibility for maintaining and monitoring databases in the environment.
a. Advise and assist in data modeling and database design when requested. Offer assistance in technical database implementation issues.
b. Provide and maintain tools to monitor database activities and create alerting systems for events.
c. Provide 24/7 response capabilities for alert events.
d. Provide guidance and assistance with performance issues related to database usage.
e. Encourage standardization of usage and best practices and share best practices standards.
f. Oversee the processing of valid backups and understand Disaster Recovery processes.
g. Identify areas of potential concern and proactively address these with the process stakeholders, including suggested alternatives in process, and the creation of repeatable maintenance tasks.
h. Provide reports that users may review to analyze database activities and usage.
3. Data - facilitate the access to the data for approved users.
a. Provide access for users to data that is necessary or advantageous to their job with approved authority, using role-based authentication wherever possible.
b. Create access at the lowest level of permissions to fill the requirements of the user.
c. Provide reporting for user privileges by database instance to support any auditing or inquiry.
d. Limit access to sensitive, protected data using company policy to define the access authenticity.
Required Qualifications
-SQL Server Versions 2012+ (2014, 2016, 2017, 2019); SSIS, SSRS, Always On, Replication
-5+ years DBA experience within SQL Server
-Windows
-Citrix
-Backup and Recovery experience
-Performance tuning experience
-Working within VM environment
-On-call support
-Off-hour deployments
Preferred Qualifications
-Redgate SQL Monitor
-MarkLogic
-db2
-Tableau
-DataStage
-Splunk
-Jazz: RTC
-github
-DevSecOps:Octopus/Team City
-Cloud:Azure/AWS
-Linux
-Putty
-Commvault
Education
H.S Diploma with 2 years of experience for every year of college not completed - Required
Bachelors degree preferred
Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.
Data Server and Database Administration for Microsoft SQL Server, db2, MarkLogic, DataStage and Tableau.
1. Servers - Install, configure and maintain Database System software to support the needs of the business in providing excellent service to Meritains customers and partners.
a. Appropriate sizing, resourcing and configuration of database servers to support customer requirements.
b. Maintenance of data server software to meet compliance requirements and sustain current licensing needs. Maintain servers at most recent release level where possible.
c. Assist in the design of servers to meet the requirements of the task or project.
d. Acquire and maintain software to monitor the performance and physical resources of data servers.
e. Provide 24/7 services to address issues uncovered through monitoring processes or as a result of stakeholder discovery.
f. Provide reports that can be used by stakeholders to review server usage and configurations.
2. Database instances - assist in the design, creation and assume responsibility for maintaining and monitoring databases in the environment.
a. Advise and assist in data modeling and database design when requested. Offer assistance in technical database implementation issues.
b. Provide and maintain tools to monitor database activities and create alerting systems for events.
c. Provide 24/7 response capabilities for alert events.
d. Provide guidance and assistance with performance issues related to database usage.
e. Encourage standardization of usage and best practices and share best practices standards.
f. Oversee the processing of valid backups and understand Disaster Recovery processes.
g. Identify areas of potential concern and proactively address these with the process stakeholders, including suggested alternatives in process, and the creation of repeatable maintenance tasks.
h. Provide reports that users may review to analyze database activities and usage.
3. Data - facilitate the access to the data for approved users.
a. Provide access for users to data that is necessary or advantageous to their job with approved authority, using role-based authentication wherever possible.
b. Create access at the lowest level of permissions to fill the requirements of the user.
c. Provide reporting for user privileges by database instance to support any auditing or inquiry.
d. Limit access to sensitive, protected data using company policy to define the access authenticity.
Required Qualifications
-SQL Server Versions 2012+ (2014, 2016, 2017, 2019); SSIS, SSRS, Always On, Replication
-5+ years DBA experience within SQL Server
-Windows
-Citrix
-Backup and Recovery experience
-Performance tuning experience
-Working within VM environment
-On-call support
-Off-hour deployments
Preferred Qualifications
-Redgate SQL Monitor
-MarkLogic
-db2
-Tableau
-DataStage
-Splunk
-Jazz: RTC
-github
-DevSecOps:Octopus/Team City
-Cloud:Azure/AWS
-Linux
-Putty
-Commvault
Education
H.S Diploma with 2 years of experience for every year of college not completed - Required
Bachelors degree preferred
Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.
We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities.
69662382