Job Closed
This listing is no longer active.
Bringing our heart to every moment of your health.
Senior Application Production Support Engineer
Location
Arizona + 4 moreAll locations: Arizona | Connecticut | Florida | North Carolina | Texas
Posted
138 days ago
Salary
$47.0K - $112.2K / year
Seniority
Senior
Job Description
Senior Application Production Support Engineer
CVS Health
• Provide on-call support • Monitor batch jobs • Troubleshoot problems • Perform Root Cause Analysis • Troubleshoot and optimize database queries • Maintain SOPs and run books • Complete technical requirements and testing • Act as a liaison with DBA and server teams • Manage code promotion releases • Provide application support • Provide data modeling and design guidelines and best practices • Responsible for database structures/designs to support Reporting Development • Provide direction in data integration standards, frameworks and best practices related to ETL and storage/management technologies
Job Requirements
- Demonstrated proficiency in using the MS Office Suite, particularly Excel
- 5 years working with SQL Server (T-SQL, SSIS, SSRS, Visual Studio) and Business Intelligence Tools (Tableau, etc.)
- Proficiency with writing SQL/T-SQL queries, stored procedures, functions, and views for adhoc, recurring standard reports or file builds
- 5 years of exposure to multiple RDBMS, as well as complex SQL Report Development skills across a variety of DB platforms
- 3 years developing in modern BI tools like Tableau, PowerBI, MicroStrategy and other development tools like Gitlab or Github
- 3 years supporting .NET applications including but not limited to technologies like VB, HTML, CSS and Javascript
- Strong ability to debug SSIS Packages in SQL Server and Visual Studio, identifying problem, isolating the source of the problem, and determining a work around solution
- Strong technical understanding of data integration standards, frameworks and best practices; especially as they relate to ETL development
- Strong technical understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data; strong technical expertise in data storage/management technologies
- Experience crafting and optimizing table structures, queries, and views to support data processing and reporting requirements
- Demonstrated ability innovate automated solutions using tools like Python, Batch, or PowerShell scripts
- Regular communication with technical, vendor, application and PBM operations staff to ensure reporting database integrity with multiple systems-of-record data extracts
Benefits
- Affordable medical plan options
- 401(k) plan (including matching company contributions)
- Employee stock purchase plan
- No-cost wellness screenings
- Tobacco cessation and weight management programs
- Confidential counseling and financial coaching
- Paid time off
- Flexible work schedules
- Family leave
- Dependent care resources
- Colleague assistance programs
- Tuition assistance
- Retiree medical access
Related Guides
Related Categories
Related Job Pages
More Production Engineer Jobs
• Scale hybrid cloud + bare-metal infrastructure for Sui validators and Walrus storage nodes • Supercharge observability with our Grafana stack • Evolve deployment pipelines beyond GitHub Actions • Drive reliability wins—measure/optimize performance • Support Engineering partners collaborating cross-functionally
• Handle complex support tickets requiring deep technical expertise • Configure and manage SQL Server databases (SSMS, SQL Administration) • Perform database maintenance, including log file management, index rebuilding, and health monitoring • Implement best practices for database backup, recovery, and disaster recovery planning • Analyse, prepare, and execute application patches and upgrades • Troubleshoot issues related to third-party software upgrades • Plan and execute data refreshes between different environments • Lead customer communication and provide regular updates on issue resolution • Diagnose and troubleshoot SQL Server, Windows, and database performance issues
