MS SQL Database Specialist

Description

Job Description:

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 Southwest CMOP in Tucson, AZ.  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 Southwest CMOP, Tucson, AZ. 
 

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 Tucson, AZ.  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).

WHAT YOU WILL BE DOING:

• 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 Tucson 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 Southwest CMOP, Tucson.

FACTORS FOR SUCCESS:

• Bachelor's degree in computer science, electronics engineering or other engineering or technical discipline.  8 years of additional relevant experience may be substituted in lieu of 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.

HOW TO STAND OUT FROM THE CROWD:

• 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 JavaScript plus jQuery

• Experience with Microsoft Teams

• Experience with Visual Studio 2019

"External Referral Eligible"

Pay Range:

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.

About Leidos

Leidos is a Fortune 500® technology, engineering, and science solutions and services leader working to solve the world’s toughest challenges in the defense, intelligence, civil, and health markets. The company’s 46,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $14.4 billion for the fiscal year ended December 30, 2022.  For more information, visit www.Leidos.com.

Pay and Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here.

Securing Your Data

Beware of fake employment opportunities using Leidos’ name. Leidos will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Leidos ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Leidos will only communicate with you through emails that are generated by the Leidos.com automated system – never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Leidos that asks for payment-related information or any other personal information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at [email protected].

If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

Commitment to Diversity

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.