SQL Server DBA – Hybrid – Long Term Contract – Harrisburg, PA. – B3502B Position Available In Dauphin, Pennsylvania

Job Description:

Our direct client is looking for SQL Server DBA, for a Hybrid,Long Term Contract in Harrisburg, PA.

Job Description:

• TheGeneral Government Delivery Center (GGDC) is seeking a motivatedand skilled SQL Server and Database Administrator for all PDEApplications/SQL Servers.
• This individual will need to workindependently as assignments are given as well as in a team settingworking with Database Administrators, Developers of various skilllevels, and with Networking/Server teams.
• They will beresponsible for Database Support as well as SQL ServerAdministration.
• This individual will be primary supportingeGrants, the Consolidated Financial Reporting System (CFRS),Education Data and Calculations (EDC), the Teacher InformationManagement System (TIMS), the Professional Education RecordManagement System (PERMS), the Nonpublic Information ManagementSystem (NPIS) databases, as well as the CFRS data mart and the PIMSPS Schema used for

TIMS/PIMS

reporting.

• This includes designing,implementing, and updating the physical structures as required;migrating, loading, and correcting data as required; monitoring andtuning database performance; ensuring data security and integrity
• It also includes assisting with the administration of otherdatabases as assigned.
• They will also serve as a backup for thechief of the database administration section when required.

Responsibilities:

• Perform database management activities usingMicrosoft SQL Server 2016/2019
• Install database software.
• Analyze, design, and review logical and physical data models.
• Support the application system development life cycle.
• Performdata analysis and correction activities.
• Load data tables andperform data migrations from one database structure to another.
• Review and migrate stored procedures; recommend improvements toenhance performance.
• Write and Use SSIS (SQL Server IntegrationServices) and PowerShell Scripts
• Follow and help enforceestablished PDE database standards.
• Monitor database performanceand space requirements and give recommendations to improve.
• Analyze and resolve database performance issues.
• Assist withconversions from older SQL versions to current version
• Maintaindatabase access security and database integrity.
• Help ensuredatabases are backed up appropriately and can be restored ifnecessary.
• Assist with database server infrastructure andsoftware analysis and recommendations.
• Conduct work in a teamenvironment.
• Use strong communication skills; both written andspoken.
• Determine time estimates and schedule for own work.
• UseAzure DevOps for source control, manage work items, fordocumentation versioning, and to report time spent on all assignedwork item activities.
• Complete assigned work activities;Anticipate and resolve issues in a timely manner.
• Communicateaccurate and useful status updates to the Database AdministrationSection Chief, and to each Application Lead analysts/projectmanagers.
• Execute all assigned responsibilities with littledirect supervision from the Database Administration Section Chief
• Represent DBA staff at status meetings and other meetings asrequested.
• Keep current with the features of new databasereleases and related database products and make recommendations asto their use.
• Make recommendations on best practices andimprovements surrounding database administration practices.

SkillMatrix:

• Perform database management activities using MicrosoftSQL Server 2016/2019
• Required
• Write and Use SSIS (SQL ServerIntegration Services) and PowerShell Scripts
• Required
• Assistwith conversions from older SQL versions to current version.
• Required
• Assist with database server infrastructure and softwareanalysis and recommendations.
• Required
• Help ensure databasesare backed up appropriately and can be restored if necessary.
• Required
• Maintain database access security and database integrity
• Required Question 1: Do you understand, and will abide by, theprovision in your subcontract with OST that it is

PROHIBITED

forgovernment equipment to be taken or used outside of the UnitedStates by your contractors? The consequences of this occurring canand will result in repercussions to you, the prime vendor,regardless if the candidate works for a sub-vendor of yours. Itwill also result in immediate termination of the contractor andmake them ineligible for rehire in the program. Question 2: Pleaseprovide your candidates current physical location? (City, State)Question 3: Does your candidate have any previous workingexperience with the Pennsylvania State Department of Education?

Question 4: This is a regular Hybrid position, are you fine withit?

Location:

Hybrid, Harrisburg, PA Type:

Long Term Contract