Database Specialist – CMOP Staffing Support
Leidos Health Group has an opportunity for an MS SQL Database Specialist supporting the Department of Veterans Affairs’ Consolidated Mail Outpatient Pharmacy (CMOP) Staffing Support task order at the Great Lakes CMOP in Hines, IL. Veterans Affairs (VA) CMOP is a network of seven (7) highly automated production facilities which employ a mixture of robotic devices, conveyor systems, and human factors to accurately fill and ship nearly 120,000,000 prescriptions per year for healthcare beneficiaries primarily our nation’s Veterans. The CMOP National Information Technology (IT) Office has a requirement to augment its staffing with contractor support for on-site database operations analysis and optimization in support of its key systems nationwide. This position is located on-site at VA’s Great Lakes CMOP, Hines, IL.
JOB DESCRIPTION/SCOPE: The candidate will provide database administration subject matter expertise for highly specialized CMOP medical systems, on-site at the VA CMOP facility in Hines, IL. This includes analysis of database inconsistencies; assessment and development of SQL queries and scripts to support the mining of business data; recommendations for the optimization of database functionality and performance, and recommendations with respect to data management with interconnected databases and their supported applications at the VA CMOP facility.
Analyze SQL functions, procedures, processes, and jobs operations and recommend solutions to problems and inefficiencies
Analyze Visual Studio .NET processes and procedures that interact with database functions and processes for extracting, transforming, and moving data between databases and environments including but not limited to interdependent report servers (via SSRS) and websites; recommend solutions to problems and inefficiencies
Assist local developers to resolve inconsistencies, conflicts, anomalies with data and assist VA Database Administration SQL Tier 3 team with problem resolution
Work with other Contractors and VA IT staff as part of the team and share knowledge for the benefit of the team.
The MS SQL Database Specialist may be required to provide on-site support on nights, holidays, and weekends (on average 2 – 3 times per month).
Support the provision of SQL database design and operations services in support of maintenance, enhancement, and modernization of CMOP facilities. The CMOP software baseline, inclusive of the underlying databases, is responsible order management, inventory control, fulfillment activities and the interfaces with the equipment on the automation floor.
Interact with senior management, engineers, and pharmacists within the VA CMOP organization. Interaction normally involves matters between business, functional, and technical areas. Interaction includes collaboration with and SME support to the Facility Chief Information Officer (FCIO), the pharmacist Quality Assurance (QA) team, and pharmacists and pharmacy technicians on the production floor at the Hines CMOP; the VA Database Administration SQL Tier 3 team, peer Database Specialists / DBAs at other CMOPs, and the National CMOP IT Office.
Work closely with other teams, support organizations, and program and product management within the VA CMOP and VA Office of Information and Technology (OIT) Infrastructure Operations (IO) environment.
Learn to understand / internalize the dataflows for approximately 50 – 60 database applications to ensure effective processing of the site workload. Learn to understand / internalize CMOP applications and their interfaces with the database; learn how to resolve issues caused by the applications and their interaction with CMOP data.
Work closely with business stakeholders and end users to develop an understanding of how CMOP applications are used
Diagnose data discrepancies for associated database tasks, jobs, and processes in support of operational reports, movement of data from one SQL database to another, and to populate pharmaceutical web-based applications used in pharmacy operations. Support the resolution of data discrepancies. Learn to understand the CMOP databases and their tables and how CMOP applications interact with the database.
Diagnose data discrepancies for approximately 20 – 30 database reports, visualizations, and dashboard web applications. Support the resolution of data discrepancies.
Utilize SQL database and SQL server tools (i.e., Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS)), available monitors, and dashboards to diagnose database issues and recommend solutions.
Apply expert knowledge of advanced technical principles, theories, and concepts to sustain and enhance the CMOP databases / software baseline.
Be involved in analyses and the investigation of database performance and any blocking issues.
Support the VA Database Administration SQL Tier 3 team in their diagnosis and troubleshooting of database errors; assist with problem resolution.
Design and recommend solutions that integrate with existing VA architecture.
Monitor SQL Agent jobs and processes; monitor SSIS package executions and report on any errors.
Create SSRS reports to monitor health as well as key performance indicators.
Develop, maintain, and enhance PowerBI dashboards for Southwest CMOP production operations
Assist with the identification and implementation of emerging database technologies to enhance operational capabilities at the CMOP
Thoroughly complete and timely deliver the Daily Database Server Report for Great Lakes CMOP, Hines.
Bachelor's degree in computer science, electronics engineering or other engineering or technical discipline. 8 years of additional relevant experience may be substituted for the degree.
5 or more years’ experience of performing database administration of MS SQL Server databases or back-end SQL Server Database Development (or a combination of SQL database administration and SQL Server database development for 5 years or more).
High level knowledge of SQL: indexes, normalization, schemas, stored procedures, and triggers
Expert T-SQL programming and analysis skills
Strong database development skills MS SQL 2016/2019
Strong SSIS and ETL skills
Experience with Relational database design, data modeling, and entity-relationship diagrams.
Experience with Visual Studio database projects and deployment (dacpac)
Experience with AlwaysOn availability groups
Experience developing systems in the Microsoft environment using Microsoft’s development tools in real-time is required i.e., SSMS (SQL Server Management Studio) Visual Studio, etc.
Experience in supporting large development initiatives that are similar in scope and complexity to VA’s CMOP
Experience in high transaction OLTP relational databases
Collaborative, self-starting, expert resource that can learn CMOP database systems and applications thoroughly to provide subject matter expertise for all CMOP production operations and enhancement.
Experience with Department of Veterans Affairs within the last two years, to include previous possession of VA PIV card and VA network access
Experience working as a contractor for the Federal government
Ideally 2+ year of experience working in the field of industrial process automation similar to CMOP or health care industry
Ability to adequately document designs, coded solutions and systems.
Experience with MS PowerBI
Experience with Mid-Tier Application Servers (IIS)
Experience with .NET and C#, Model View Controller (MVC)
Experience with Microsoft Teams
Experience with Visual Studio 2019
Pay Range:Pay Range $78,000.00 - $120,000.00 - $162,000.00
The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.