Database Administrator

Job Requisition ID : 52586

Closing Date :

​Agency : Teachers' Retirement System of the State of Illinois

Salary : $76,051 - $111,925

Job Type : Salaried

Category : Full Time

County : Sangamon

Number of Vacancies : 1

Please follow the directions below when applying for this position.

• DO NOT CLICK THE APPLY BUTTON

TO APPLY FOR THIS POSITION PLEASE VISIT THE TRS WEBSITE :

Careers | Teachers' Retirement System of the State of Illinois

The Teachers’ Retirement System of the State of Illinois (TRS) is one of the largest public pension systems in the United States. We provide retirement, disability and survivor benefits to teachers, administrators and other public-school personnel employed outside the city of Chicago.

TRS serves over 456,000 members and manages a multi-billion-dollar investment portfolio for the exclusive benefit of the membership.

TRS is an agency of the State of Illinois governed by a Board of Trustees. Full-and part-time employees are eligible for the State of Illinois comprehensive benefits program which includes medical, dental and vision coverage. All employees hired after August 17, 2001 participate in the TRS retirement pension plan. Employees also have the option to contribute to additional State of Illinois deferred compensation plans. The TRS pension plan is a participating reciprocal system under the Illinois Pension Code Retirement Systems Reciprocal Act.

Learn more about careers at TRS : Careers | Teachers' Retirement System of the State of Illinois

Job Summary

As a Database Administrator, the successful candidate will perform database administration tasks with minimal guidance from senior staff, for the implementation and operation of a variety of database systems and applications running on Linux and Windows server platforms, containers and Azure. These tasks which are in direct support of TRS’ software development, data analytics, and application teams include creation of data fix scripts, database design, database analysis, database information assurance and security, database installation, database configuration, and database performance monitoring and tuning. The successful candidate will be responsible for mentoring junior staff.

Essential Functions

Perform database administration assignments essential to the implementation and operation of database systems and applications running on Linux and Windows server platforms

Support the complete software development life cycle from conception to deployment in an Agile environment. Including but not limited to creation of DDL and data change scripts as part of the iteration activities aligning with current Database standards

Support data replication processes and reporting environments

Improve indexing strategies

Support ETL / ELT processes

Review and ensure database integrity using standardized support tools

Essential Functions (Continued)

Ensure tasks are performed in accordance with database administration guidelines, standards and procedures for application development, implementation, testing, and migration

Modify and test changes to previously developed database artifacts

Support automated testing and provide feedback to team leadership

Support both DevOps and Database Feature development

Review and update documentation for processes, data models, and other database artifacts using standardized tools

As directed, partner with teams to document cataloging, lineage, and data stewardship, while ensuring data quality, security, and compliance.

Perform troubleshooting, debugging and upgraded of TRS database management systems as directed

Be available to troubleshoot SQL Server service outages even after- hours and weekends

Other duties as assigned

Knowledge, Skills, and Abilities

Open to new ideas and encourages innovative practices amongst peers

Practices positive interactions - leans on encouragement in place of judgment

Impresses responsibility on others by displaying ownership in tasks

Acts in the interest of the overall team

Able to multi-task in a fast paced, fluid work environment

Capable of presenting technical ideas and concepts in business-friendly language

Provide technical guidance to junior staff and suggestions to senior staff

Minimum Requirements

Bachelor's degree in a related field or a combination of education and relevant experience

3+ years of database administration experience with SQL Server

3+ years of complex SQL / DDL script creating and performance tuning experience

Experience with database design and implementation

Experience with data replication

Understanding the difference between OLTP vs OLAP, Object Oriented and Relational database design, and STAR, Snowflake, Galaxy Schemas structures.

ETL\ELT Experience

Preferred Qualifications

C# experience

SSIS, SSRS, BI / reporting tools experience

Data Mart / Warehouse experience

Retirement systems experience

SQL Sentry experience

PowerShell experience

Knowledge of LINQ

Work Hours : 8 : 30 - 4 : 30 M-F

Headquarter Location : 2815 W. Washington St., Springfield, IL 62702-3397

Work County : Sangamon

Agency Contact : Christina Lonbom

Email : clonbom@trsil.org

Phone # : 217-814-2226

Posting Group : Science, Technology, Engineering & Mathematics

TRS is a non-code state agency.

Candidates must submit applications through the TRS Careers Website :

Careers | Teachers' Retirement System of the State of Illinois

Please follow all instructions and include all required documents. You WILL NOT be considered for the position if you attach a CMS100, CMS100b or any other document in lieu of a Resume or CV.

TRS is an Equal Opportunity Employer. If you require reasonable accommodation in completing this application, interviewing, or completing any pre-employment testing, please direct your inquiries to Human Resources at (217) 814-2111, or HRServices@trsil.org. Hiring decisions are not based on or affected by political factors, including political sponsorship, affiliation, or support.