Database Admin/Developer

Planned Systems International, Inc.•, Remote

6d•Onsite

About The Position

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 (TPQI) 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.

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)

Nice To Haves

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

Responsibilities

Provide support for the IETSS 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 IETSS 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 IETSS processes, policies, and procedures from IETSS 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 IETSS program and process documentation and artifact templates.