Database Admin/Developer

Planned Systems International; United States; On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Paid leave

Group medical, dental, vision

Short-term and long-term disability

Life insurance

AD&D coverage

Legal services

Identity theft protection

Accident insurance

FSA/HSA options

401(k) with employer match

Tuition reimbursement

Job summary

Planned Systems International (PSI) has an immediate opportunity for an SQL Server Database Administrator (DBA) for a VA metrics data warehouse. The role sits on the TP QI Support team and covers data integration, QA, and BI reporting responsibilities.

Ideal candidates have 5+ years in SQL DB administration, strong ETL/SSIS experience, and expertise in data warehousing and BI reporting. This is a full-time position supporting a government contract with periodic after-hours work.

Qualifications

• 5+ years of experience in SQL database administration, database development, data engineering, or a similar technical role.
• Relational database technologies and data normalization.
• Microsoft SQL Server 2022 or higher.
• Database backup and recovery and disaster recovery planning.
• Transact-SQL programming and SSIS/SSDT.
• Data warehouse architecture, design, and implementation.

Responsibilities

• Provide support for the IETSS MM program.
• Analyze current and potential disparate data sources.
• Validate data quality and data governance.
• Build, test, schedule, and troubleshoot SSIS ETL projects.
• Monitor and improve database performance, availability, and security.
• Troubleshoot database issues in real time.
• Create and modify advanced SQL queries and objects.
• Support deployment activities and periodic maintenance.
• Assist in data visualizations and Power BI reporting.

Skills

SQL Server

T-SQL

SSDT

SSIS

Data Warehouse

Power BI

Backup & Recovery

Disaster Recovery

Performance Tuning

Documentation

Education

Bachelor's or Master's degree

Tools

TOAD for SQL Server

SSMS

SharePoint Online

Job description

Planned Systems International (PSI), a Government Contractor, has an immediate opportunity for an SQL Server Database Administrator (DBA) for a departmental metrics data warehouse on the Independent Enterprise Testing and Support Services (IETSS) contract with the Department of Veterans Affairs (VA), Office of Information and Technology (OIT). This position will be part of the Testing Process Quality Improvement (TP QI) Support team, which consists of Measurement and Metrics (MM), process development, management and process improvement, Lessons Learned, Change Management, Knowledge Management, internal Quality Audit Program, Root Cause Analysis (RCA) process, and Corrective and Preventive Action (CAPA) planning. The TPQI team supports and works closely with the Test and Evaluation (T & E) and Testing Intake Assessment teams, as well as the Test Center systems analysts, systems administrators, DBAs, the VA PM, VA COR and other divisions and stakeholders.

Essential Functions And Job Responsibilities

• Provide support for the I ET S S MM program
• Analyze current and potential disparate data sources
• Participate in the validation of data quality
• Build, test, schedule, and troubleshoot extract, transform, and load (ETL) SQL Server Integration Services (SSIS) projects, solutions, and tasks built in SQL Server Data Tools (SSDT) and executed from SQL Server
• Continually measure, analyze, and improve database system performance, availability, sustainability, and security
• Discover, troubleshoot, and correct any database system issues in real time
• Create, modify, and maintain advanced SQL queries
• Review and suggest refinements to proposed database modifications
• Support all phases of solution deployment activities
• Plan and perform regular database maintenance on a periodic basis
• Be available for after-hours activities on occasion as needed
• Aid in the build of data visualizations and reports in Power BI or other I ETS S accepted reporting/data visualization tools
• Assist with the extraction of requirements and assignments for proposed or impending initiatives
• Develop database objects, including but not limited to tables, functions, procedures, views, and database links in SQL Server using standard operating procedures (SOP). Review and pull information about I ETS S processes, policies, and procedures from I ETS S documentation
• Contribute to or write portions of TPQI Measures and Metrics documentation
• Support quality and process improvement methodologies to develop and continuously update the TPQI Plan
• Assist in the authoring, review, and revision of I ETS S program and process documentation and artifact templates

Minimum Requirements

• 5+ years of experience in SQL database administration, database development, data engineering, or a similar technical role
• Relational database technologies and data normalization
• Microsoft SQL Server 2022 or higher
• Database backup and recovery
• Disaster recovery planning and execution
• Producing, reviewing, and updating system and procedural documentation
• Creating, tuning, and maintaining complex SQL queries
• Data warehouse architecture, design, and implementation
• Transact‑SQL programming
• SQL Server Data Tools (SSDT)
• SQL Server Integration Services (SSIS)
• Designing and maintaining extract, transform, and load (ETL) packages, tasks, and processes
• Build and maintenance of Business Intelligence (BI) and management reports
• SharePoint Online
• Microsoft Word, Excel, PowerPoint, Outlook, and Visio 2013 or higher
• TOAD for SQL Server or SSMS
• Remote Desktop Connection
• United States government‑related work (e.g., Department of Defense, VA)

Education

• Bachelor’s or Master’s degree in business analytics, engineering, electronics engineering, information technology, computer science, data analytics or a related scientific or technical discipline is required
• Equivalent experience or industry certifications may substitute for formal education
• Degree in 8 years of additional relevant experience may be substituted for education

Desired Qualifications

• Ability to work simultaneously on multiple projects and handle changing priorities
• Capable of prioritizing tasks
• Excellent customer service skills (this position works closely with the customer)
• Detail‑oriented and can work independently
• Excellent verbal and written communication, organizational, presentation, and documentation skills
• Self‑driven and goal‑oriented with a focus on providing the best possible work product and improving efficiency
• Ability to work well with and communicate effectively with all levels of an organization
• Microsoft Power Automate
• Expert in Microsoft Excel and Access
• Experience with other business intelligence (BI) reporting solutions
• Knowledge of data dashboard design concepts
• Experience with other database technologies and concepts (e.g., Online Transaction Processing [OLTP], NoSQL, Data Lakes)
• Current Moderate Background Investigation (MBI) and VA network access a plus

Company Benefits

PSI offers full‑time, benefits‑eligible employees a competitive total compensation package that includes paid leave and options for employer‑sponsored group medical, dental, vision, short‑term and long‑term disability, life insurance, AD&D coverage, legal services, identity theft, and accident insurance. Flexible spending account and health savings account options provide pre‑tax savings for qualified medical, dental, and vision expenses. The company‑sponsored 401(k) retirement plan has an employer contribution match that is immediately vested. We invest in the professional growth of our employees through professional courses, certifications, and tuition reimbursement programs.

EEO Commitment

It is company policy to promote equal employment opportunities. All personnel decisions, including, but not limited to, recruiting, hiring, training, promotion, compensation, benefits, and termination, are made without regard to race, color, religion, age, sex, sexual orientation, pregnancy, gender identity, genetic information, national origin, citizenship status, veteran status, protected veteran status, disability, or any other characteristic protected by applicable federal, state, or local law. Reasonable accommodations for applicants and employees with disabilities will be provided. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Human Resources by emailing [e-mail], or by dialing 703‑575‑8400.