PSP seeks a DBA with 7 years' relevant experience.
Work hours: 8 AM 4:30 PM
Work Location: Remote
Interview: Preferably in-person but manager may do virtual via Teams.
Manager will work details for equipment pick up in interviews & after selection.
***Client would prefer candidates local to the Harrisburg, PA Area.***
***This requisition's current PO is funded through 6/30/27, so use that date in the RTR. Contract end date is dependent on the final schedule and projected needs. Historically additional funding should then last a year and occur from 7/1/27-6/30/28.***
This position is responsible for advanced technical work in all phases of database administration support; development activities (support the application development lifecycle, planning, design, development, implementation, data migration, quality assurance, data cleanup, and data administration) as well as database operations activities (database administration, database security, assuring availability, server and database monitoring, performance monitoring, SQL software installation and configuration, and Service Pack installations).
- Provides Operations support for SQL Database and Database Server administration support for critical production systems.
- Ensures overall health and availability and quality of services
- Perform Health Checks to review the performance of databases to identify and provide recommendations to enhance performance of databases.
- Performs migration and upgrade of SQL Databases from legacy server\\SQL Version to new server\\SQL Version.
- Performs data migration by designing programs to optimally extract, cleanse, transform and load data between data sources as part of data migration and data validation support.
- Deploying SQL database solutions within Azure
- Securing Azure SQL resources and data
- Provides Database Design support.
- Defines, develops, and creates databases by assessing requirements.
- Meet with developers and vendors to ascertain requirements and to provide consulting assistance to determine the appropriate database configurations.
Deploy and maintain database schema changes across test and production environments.
Provide technical support for the PSP Data Warehouse, Data Marts, and Power BI environments in collaboration with the Lead Power BI Administrator.
Deploy, configure, secure, backup, and maintain Azure SQL database solutions.
Integrate Azure SQL resources with other Azure services to support enterprise applications and data solutions.
Monitor, troubleshoot, and optimize Azure SQL and SQL Server Database performance and availability.
Support the migration of on-premises SQL Server databases to Azure SQL.
Design, develop, and maintain logical and physical database models based on business and technical requirements. Review and validate data models and data dictionaries to ensure compliance with organizational standards.
Develop and maintain database structures, including tables, relationships, and normalization, to ensure data integrity, efficiency, and minimize redundancy.
Collaborate with developers, business stakeholders, and vendors to gather requirements and recommend appropriate database architectures and configurations.
Coordinate database backup and restore requests with the backup administration team.
Role Description:
Engages in ongoing process improvement.
Knowledgeable in data analysis and database management techniques.
Execution of all responsibilities with little direct supervision of Team Lead.
Determine time estimates and schedule for own work and resolve issues in a timely manner.
Identify and track issues, risks, and action items.
Coordinates with vendors and service providers to resolve technical support issues
Assists in coordinating software releases.
Manages and provides status update on all work activities.
Follow database standards.
Able to work in a team environment.
Complete assigned tasks.
Required/Desired Skills: (Please add any additional required/desired skills)
SQL Server Database Administration experience Required 7 years
Data Analytics experience Required 3 years
Azure Database Administration experience Required 1 year
Data Warehouse experience Required 1 year
Business systems analysis and design experience Desired
Worked in Database Administration on Production Servers Required 4 years
Excellent Communication Skills Required
Provides high quality and professional customer service Required
Microsoft SQL (HA / Always On) Desired
Power BI Administration Highly Desired
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
|---|
| SQL Server Database Administration experience | Required | 7 | Years |
| Worked in Database Administration on Production Servers | Required | 4 | Years |
| Data Analytics experience | Required | 3 | Years |
| Azure Database Administration experience | Required | 1 | Years |
| Data Warehouse experience | Required | 1 | Years |
| Excellent Communication Skills | Required | 0 | |
| Provides high quality and professional customer service | Required | 0 | |
| Power BI Administration | Highly desired | 0 | |
| Business systems analysis and design experience | Desired | 0 | |
| Microsoft SQL (HA / Always On) | Desired | 0 | |
Questions
| No. | Question |
|---|
| Question1 | Background Check: This position requires an in-depth background check, including fingerprinting and requires successful results. Do you accept this requirement? |
| Question2 | The vendor rate for this position is $$$. Do you accept this rate? |
| Question3 | Position will primarily be remote; however, candidate may have to report on-site for fingerprinting and picking up equipment. Does your candidate agree to this requirement? |
| Question4 | Where does your candidate currently reside (e.g. city, state)? |
| Question5 | This requisition will preferably feature in-person first round interviews. The manager may; however, consider doing first round interviews virtual via Teams. If so and in order to deter a fake candidate scam the candidate must present a valid photo ID to the camera at the beginning of the interview. They also must pan the camera 360 degrees in the fixed room for the panel to see to make sure they are the only person in the room during the interview. Do you accept these conditions? |
| Question6 | Resume wise, please do not include filler material (e.g. describing a company's core capabilities/description). Please only include relevant info (e.g. what was done at the job/project). Is this reflected in the resume? |
| Question7 | Inaccurate responses to the skills above will result in your company being omitted from future PSP requisitions. The skills (and applicable experience) must also be explicitly referenced in the candidate resume. Have you confirmed that the responses to the skills above are accurate and reflect the actual experience the candidate possesses? |
| Question8 | Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor, and make them ineligible for rehire in the program. |