MSSQL Database Administrator

$70,000 - $90,000/Yr

Illinois State University

posted 3 months ago

Part-time - Entry Level
Remote
Educational Services

About the position

The MSSQL Database Administrator plays a crucial role within a collaborative team environment, focusing on the maintenance, optimization, and technical support of enterprise and business-level databases. This position is responsible for overseeing multiple servers and various versions of database software, ensuring the smooth operation of databases that support enterprise and business applications, as well as custom data warehouses. The primary database systems managed include Oracle, Microsoft SQL Server, MySQL, and PostgreSQL. The incumbent will also serve as a backup or secondary administrator for other database systems, performing specific duties as required for those databases. In this role, the Database Administrator will be tasked with ensuring the integrity, performance, and security of the databases. This includes responsibilities such as installation, configuration, patch management, and troubleshooting of database systems. The position requires a strong understanding of relational database concepts and the ability to write and optimize SQL queries. The incumbent will also need to be familiar with IT infrastructure hardware as it relates to database architecture, including servers, storage, networking, and backups. The MSSQL Database Administrator position offers flexibility, with the potential for 100% remote work or a hybrid arrangement within the State of Illinois, contingent upon employee performance and business needs. This role is open to candidates with varying levels of experience, and compensation will be commensurate with the applicant's qualifications and experience.

Responsibilities

  • Maintain and optimize enterprise and business-level databases.
  • Act as the primary administrator for multiple servers and versions of database software.
  • Support enterprise and business applications along with custom data warehouses.
  • Perform installation, configuration, and patch management for database systems.
  • Troubleshoot and resolve database-related issues.
  • Write and optimize SQL queries using common query/reporting tools.
  • Ensure the integrity, performance, and security of the databases.
  • Serve as a backup or secondary administrator for other database systems.

Requirements

  • High school diploma or equivalent.
  • Two years of college coursework in Information Technology (IT), IT Management, or a closely related discipline, or equivalent work experience.
  • At least three years of experience in Windows System Administration, MS SQL Database Administration, or PostgreSQL DB administration.
  • Understanding of relational database concepts and ability to use SQL and common query/reporting tools.
  • Knowledge of IT Infrastructure Hardware related to database architecture.

Nice-to-haves

  • Three years of experience supporting software applications that leverage databases, especially in higher education administrative systems.
  • Experience with PostgreSQL 13 and higher and MySQL 8.0 or higher, including installation and configuration.
  • Familiarity with Windows operating system script languages such as PowerShell.
  • Experience with Windows failover cluster and advanced firewall configuration.
  • Experience in Linux system administration and firewall configuration.
  • Familiarity with Source Control, Defect Management, and Incident Management Software Tools.
  • Experience with clustering, load balancing, mirroring, log shipping, and replication technologies.

Benefits

  • Health, dental, vision, and life insurance.
  • Tuition waiver benefits for staff and eligible dependents.
  • Paid holiday/administrative closures during Thanksgiving and Winter Breaks.
  • Paid vacation and sick time.
  • Retirement and supplemental retirement plans.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service