Senior SQL DBA & BI Developer (ETL/SSIS)

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