SQL Server and Database Administrator

My3Tech; Harrisburg (Dauphin County); On-site; USD 55,000 - 241,000; Full time

Job summary

A leading technology company is seeking a motivated SQL Server and Database Administrator for its General Government Delivery Center. The successful candidate will manage essential databases, ensure performance efficiency, and maintain data integrity while working independently and as part of a team in Harrisburg.

Qualifications

• Minimum of 2 years experience working with SQL Server.
• Experience with SSIS and PowerShell required.
• Familiarity with database backup and recovery processes.

Responsibilities

• Install database software and support application life cycle.
• Monitor database performance and provide recommendations.
• Assist with database security and integrity.

Skills

SQL Server Integration Services (SSIS)

PowerShell

Database Analysis

Data Migration

Database Performance Monitoring

Team Collaboration

Communication

Job description

Get AI-powered advice on this job and more exclusive features.

Sign in to access AI-powered advices

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Continue with Google Continue with Google

Direct message the job poster from My3Tech

The General Government Delivery Center (GGDC) is seeking a motivated and skilled SQL Server and Database Administrator for all PDE Applications/SQL Servers. This individual will need to work independently as assignments are given as well as in a teamsetting working with Database Administrators, Developers of various skill levels, and with Networking/Server teams.They will be responsible for Database Support as well as SQL Server Administration.

This individual will be primary supporting eGrants, the Consolidated Financial Reporting System (CFRS), Education Data and Calculations (EDC), the Teacher Information Management System (TIMS), the Professional Education Record Management System (PERMS), the Nonpublic Information Management System (NPIS) databases, as well as the CFRS data mart and the PIMS PS 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 and tuning database performance;ensuring data security and integrity. It also includes assisting with the administration of other databases as assigned.

They will also serve as a backup for the chief of the database administration section when required.

Responsibilities:

·Install database software

·Analyze, design, and review logical and physical data models

·Support the application system development life cycle.

·Perform data analysis and correction activities

·Load data tables and perform data migration sfrom one database structure to another

·Review and migrate stored procedures;recommend improvements to enhance performance

·Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts

·Follow and help enforce established PDE database standards.

·Monitor database performance and space requirements and give recommendations to improve

·Analyze and resolve database performance issues

·Assist with conversions from older SQL versions to current version

·Maintain database access security and database integrity

·Help ensure databases are backed up appropriately and can be restored if necessary

·Assist with database server infrastructure and software analysis and recommendations

·Conduct work in a team environment

·Use strong communication skills; both written and spoken

·Determine time estimates and schedule for own work

·Use Azure DevOps for source control, manage work items, for documentation versioning, and to report time spent on all assigned work item activities

·Complete assigned work activities; Anticipate and resolve issues in a timely manner

·Communicate accurate and useful status updates to the Database Administration Section Chief, and to each Application Lead analysts/project managers

·Execute all assigned responsibilities with little direct supervision from the Database Administration Section Chief

·Represent DBA staff at status meetings and other meetings as requested

·Keep current with the features of new database releases and related database products and make recommendations as to their use

·Make recommendations on best practices and improvements surrounding database administration practices

Required

2

Years

Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts

Required

2

Years

Assist with conversions from older SQL versions to current version

Required

2

Years

Assist with database server infrastructure and software analysis and recommendations

Required

2

Years

Help ensure databases are backed up appropriately and can be restored if necessary

Required

2

Years

Maintain database access security and database integrity

Required

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at My3Tech by 2x

Sign in to set job alerts for “SQL Database Administrator” roles.

Continue with Google Continue with Google

Continue with Google Continue with Google

SQL Server DBA::Need local Pennsylvania candidates

Lead Data Engineer With SQL QUERIES- Hybrid

Harrisburg, PA
$130,800.00
-
$241,000.00
1 day ago

Harrisburg, PA
$92,720.00
-
$143,952.00
3 weeks ago

Harrisburg, PA
$80,000.00
-
$120,000.00
6 days ago

Harrisburg, PA
$55,000.00
-
$60,000.00
1 day ago

Harrisburg, PA $150,000 - $160,000 2 days ago

Harrisburg, PA $53.25 - $58.25 6 hours ago

Microsoft Power Apps and SharePoint Developer

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.