SQL Server and Database Administrator

Diversified Systems.com; Harrisburg (Dauphin County); Hybrid; USD 80,000 - 120,000; Full time

Job summary

A leading technology services corporation in Harrisburg seeks a motivated SQL Server and Database Administrator. This full-time role encompasses database support, administration of various MS SQL Servers, and ensuring data security. Ideal candidates should possess strong technical skills, be able to perform under minimal supervision, and work collaboratively in a team environment.

Benefits

Flexible compensation packages

Qualifications

• Experience with SQL Server Administration and Database Management.
• Proficient in performance tuning and data security management.
• Ability to work independently and as part of a team.

Responsibilities

• Support various databases and ensure data integrity.
• Analyze, design, and review data models.
• Perform data analysis, migrations, and database software installations.

Skills

Database Support

SQL Server Administration

Data Security

Performance Tuning

Data Migration

Tools

Microsoft SQL Server 2016/2019

SSIS

PowerShell

Azure DevOps

Job description

Join to apply for the SQL Server and Database Administrator role at Diversified Systems.com

Join to apply for the SQL Server and Database Administrator role at Diversified Systems.com

Hybrid (Onsite up to 2 days/wk)

Description:

DSI is searching for 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.

Responsibilities:

• 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.
• Serve as a backup for the chief of the database administration section when required.
• 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 migrations 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.
  
  

About Diversified Systems

Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion

DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Other

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Diversified Systems.com by 2x

Get notified about new SQL Database Administrator jobs in Harrisburg, PA.

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.00-$160,000.00 2 days 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.