Database Admin/Developer

Overview 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.   Essential Functions and Job Responsibilities Candidate must be able to: 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.   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 saving account options offer 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,