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

Jobot

Director of SEO Job at Jobot

 ...Benefits.Job Details Our company, a leading player in the tech services industry, is seeking a dynamic, experienced, and passionate Director of SEO. This is a permanent position that offers an incredible opportunity to lead and shape our SEO strategy. The successful... 

Upgrow

PPC Manager Job at Upgrow

 ...rise! You will be working with a fun and smart team to help manage PPC (SEM, Display, Paid Social) work for our clients. ABOUT...  ...are ideally looking for someone in San Francisco, but is open to remote work in the US for the right candidate. CORE RESPONSIBILITIES... 

Pella Windows and Doors by Gunton Corporation

Entry Level B2B Sales Rep Job at Pella Windows and Doors by Gunton Corporation

 ...Corporation, the largest independent distributor of Pella Windows & Doors in the country, is an innovative leader in our industry. Our Sales Representatives provide solutions for our customers' window and door needs and are key to our success since 1932. Due to our... 

Crown Cork & Seal USA, Inc.

Production Worker - General Laborer Job at Crown Cork & Seal USA, Inc.

 ...company of Crown Holdings, Inc. is a global leader in the design, manufacture, and sale of packaging products for consumer goods. At Crown,...  ...well as new energy drinks. Crown Beverage leads the packaging industry with innovative technologies that redefine how the world looks... 

Staff Financial Group

Customer Service Representative Job at Staff Financial Group

 ...Entry-Level Customer Service Representative | Orlando, FL | In-Office One of our valued clients, a well-established industrial equipment...  ...months! Key Requirements: ~1-5 years of experience in call center, customer service, or retail/service industry roles. ~ A...