Demo

SQL Server and Database Administrator

Omm IT Solutions
Harrisburg, PA Full Time
POSTED ON 4/2/2025
AVAILABLE BEFORE 4/30/2025

Job Description

Please Note :

This is a Remote Position

Complete Description :

  • Client 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 team setting 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 :

  • Perform database management activities using Microsoft SQL Server 2016 / 2019
  • 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 from 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
  • Requirements

  • 2 Years experience with Perform database management activities using Microsoft SQL Server 2016 / 2019
  • 2 Years experience with  Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts
  • 2 Years experience with  Assisting with conversions from older SQL versions to current version
  • 2 Years experience with  Assisting with database server infrastructure and software analysis and recommendations
  • 2 Years experience with  Help ensure databases are backed up appropriately and can be restored if necessary
  • 2 Years experience with  Maintain database access security and database integrity
  • Requirements

    2 Years experience with Perform database management activities using Microsoft SQL Server 2016 / 2019 2 Years experience with Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts 2 Years experience with Assisting with conversions from older SQL versions to current version 2 Years experience with Assisting with database server infrastructure and software analysis and recommendations 2 Years experience with Help ensure databases are backed up appropriately and can be restored if necessary 2 Years experience with Maintain database access security and database integrity

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a SQL Server and Database Administrator?

    Sign up to receive alerts about other jobs on the SQL Server and Database Administrator career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $150,731 - $188,044
    Income Estimation: 
    $176,131 - $238,730
    Income Estimation: 
    $172,979 - $241,697
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $66,897 - $84,160
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Omm IT Solutions

    Omm IT Solutions
    Hired Organization Address Schenectady, NY Full Time
    Job Description Please Note : It is a Full-Time Hybrid position with up to 50% REMOTE. Skill Level : Expert Engagement L...
    Omm IT Solutions
    Hired Organization Address Milford, MD Full Time
    Job Description Description of Work : The client is seeking a SharePoint Developer / Administrator Subject Matter Expert...
    Omm IT Solutions
    Hired Organization Address Olympia, WA Full Time
    Job Description Software Test Analyst Resources are responsible for validating the full functionality of systems, intero...
    Omm IT Solutions
    Hired Organization Address Olympia, WA Full Time
    Job Description Software Test Analyst Resources are responsible for validating the full functionality of systems, intero...

    Not the job you're looking for? Here are some other SQL Server and Database Administrator jobs in the Harrisburg, PA area that may be a better fit.

    SQL Server and Database Administrator

    Apollo ITS, Harrisburg, PA

    SQL Server Database Administrator at PA

    Elite WorkForce Inc, Dauphin, PA

    AI Assistant is available now!

    Feel free to start your new journey!