SQL Database Administrator Job at IPS Consulting, Harrisburg, PA

T1lwUUt3UkxlakdsS2lhMENIQk5NS05BM3c9PQ==
  • IPS Consulting
  • Harrisburg, PA

Job Description

Position Overview:

Our client is seeking a skilled and motivated SQL Server Database Administrator to support and maintain all applications and SQL Server environments. The ideal candidate will collaborate with database administrators, developers, and infrastructure teams to ensure the reliability, security, and performance of critical database systems.

Key Responsibilities:

  • Administer and maintain Microsoft SQL Server 2016/2019 databases
  • Install, configure, and upgrade database software and infrastructure
  • Design, review, and optimize logical and physical data models
  • Support all phases of the application development lifecycle
  • Perform data analysis, corrections, and migrations across systems
  • Optimize and migrate stored procedures to improve performance
  • Develop and maintain SSIS packages and automate tasks using PowerShell scripts
  • Monitor database performance, tune queries, and manage storage utilization
  • Ensure data security, integrity, and appropriate user access controls
  • Manage database backup and recovery procedures
  • Use Azure DevOps for source control, documentation, and project tracking
  • Communicate effectively with team members, application leads, and project managers
  • Provide status updates and proactively identify potential issues
  • Represent the DBA team in meetings as needed
  • Stay current with new SQL Server technologies and recommend improvements
  • Serve as backup to the Chief of Database Administration when required

Supported Systems Include:

  • eGrants
  • Consolidated Financial Reporting System (CFRS)
  • Education Data and Calculations (EDC)
  • Teacher Information Management System (TIMS)
  • Professional Education Record Management System (PERMS)
  • Nonpublic Information Management System (NPIS)
  • CFRS Data Mart
  • PIMS PS Schema (supporting TIMS/PIMS reporting)

Qualifications:

  • Proven experience in SQL Server administration and support
  • Strong understanding of database structures, security, and performance tuning
  • Proficient in SSIS, PowerShell scripting, and data migration methods
  • Experience with Azure DevOps or equivalent tools for version control and project management
  • Ability to work independently and collaboratively within a team
  • Excellent communication, analytical, and problem-solving skills
  • Experience managing large, complex database environments is highly preferred

Job Tags

Permanent employment,

Similar Jobs

Allied Universal

Armed Security Guard - Government Site Job at Allied Universal

 ...Overview Allied Universal, North America's leading security and facility services company, provides rewarding careers that give...  ...for most full-time positions! Job Description As a Armed Security Guard - Government Site in New Port Richey, FL , you will serve... 

Ford Motor Company

Global Security Specialist Job at Ford Motor Company

As a global leader in advanced mobility solutions, our outstanding team of legal professionals helps us navigate the continually changing...  ...of General Counsel, youll be part of an organization that collabo Security Specialist, Security, Specialist, Global Ford Motor Company

Energy Vault

1.4. Director of Government Relations Job at Energy Vault

 ...Be Resourceful Listen HustleWho We Are Looking For:The Government Relations Director will manage Phoenix Tailings ongoing relationships...  ...responsible for implementing our advocacy efforts with the federal government and, if needed, supporting advocacy efforts with... 

Lilt, Inc.

Director Financial Planning & Analysis (San Francisco) Job at Lilt, Inc.

 ...translation strategy, focusing on business outcomes instead of outputs. With LILT, innovative, category-defining organizations like Intel, ASICS, WalkMe, and Canva are using AI technology to deliver multilingual, digital customer experiences at scale. While our core... 

C2 Education

English Tutor Job at C2 Education

About C2 Education At C2 Education, we believe in our students and their potential for greatness. We work hard every day to help students achieve their academic goals so they may attend the college of their dreams. We assist with multiple educational needs such as College...