SQL Database Administrator Job at IPS Consulting, Harrisburg, PA

bk5WcFRHWCtjSGlVY3N1aWZyZVp1aTdJVFE9PQ==
  • IPS Consulting
  • Harrisburg, PA

Job Description

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

Pacific Aviation

Airline Customer Service Agent - Korean/English Speakers Job at Pacific Aviation

 ...connect with our Korean-speaking travelers? If so, Pacific Aviation is looking for enthusiastic individuals to join our team at LAX as Airline Customer Service Agentsand were especially seeking bilingual Korean/English speakers who can turn travel challenges into positive... 

Zenex Staffing Solutions Pvt Ltd.

Registered Nurse - Outpatient Clinic Job at Zenex Staffing Solutions Pvt Ltd.

 ...Years of Experience REQ: 2 First-Timers Accepted: Yes Weekend REQ: No Is on-call REQ? No Certs REQ: BLS Skills REQ: Adult Outpatient Clinic Experience Preferred but not Required. Will clinician float within scope to meet facility needs? As Needed Within Skillset Pending... 

Compunnel Inc.

Service Desk Quality Analyst Job at Compunnel Inc.

 ...Job Summary: We are seeking a meticulous and dedicated Service Desk Quality Analyst to join our team. The ideal candidate will be...  ...strategies to enhance the overall efficiency and effectiveness of our support services. Key Responsibilities: Monitor and Evaluate:... 

Piedmont Medical Center

RN Supervisor CV Tele FT Days Job at Piedmont Medical Center

 ...visitors. The Clinical Supervisor maintains clinical and professional competency as appropriate to the ages, developmental stages, and special needs of the population. Service Sevice Excellence behavior is promoted at all times. THE RN SUPERVISOR CVI TELE FULL TIME DAYS... 

Access Healthcare

Travel Endoscopy Registered Nurse - $2,682 per week Job at Access Healthcare

 ...Access Healthcare is seeking a travel nurse RN Endoscopy for a travel nursing job in Tracy, California. Job Description & Requirements ~ Specialty: Endoscopy ~ Discipline: RN ~ Start Date: 06/23/2025~ Duration: 13 weeks ~40 hours per week ~ Shift: 8 hours...