Talent.com
Database Administrator
Database AdministratorState of Illinois • Springfield, IL, US
[error_messages.no_longer_accepting]
Database Administrator

Database Administrator

State of Illinois • Springfield, IL, US
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
  • [job_card.part_time]
[job_card.job_description]

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.

  • APPLICATION INSTRUCTIONS
  • 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.

    [job_alerts.create_a_job]

    Database Administrator • Springfield, IL, US

    [internal_linking.similar_jobs]
    Database Administrator 3-IT

    Database Administrator 3-IT

    Oracle • Springfield, IL, United States
    [job_card.full_time]
    Work with a world class team to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Cath Lab Tech

    Travel Cath Lab Tech

    LanceSoft • Springfield, IL, US
    [job_card.permanent]
    LanceSoft is seeking a travel Cath Lab Technologist for a travel job in Springfield, Illinois.Job Description & Requirements. ACLS, BLS, ARRT, RCIS required.First time travellers accepted.Establ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Travel Cath Lab Tech - $2729 / Week

    Travel Cath Lab Tech - $2729 / Week

    LRS Healthcare - Allied • Springfield, IL, US
    [job_card.full_time]
    LRS Healthcare - Allied is seeking an experienced Cath Lab Tech for an exciting Travel Allied job in Springfield, IL.Shift : Inquire Start Date : 01 / 26 / 2026 Duration : 13 weeks Pay : $2729 / Week.Ready...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    ServiceNow Platform Administrator

    ServiceNow Platform Administrator

    ASM Research, An Accenture Federal Services Company • Springfield, IL, United States
    [job_card.full_time]
    The role of a ServiceNow Platform Administrator involves managing and maintaining the ServiceNow platform to ensure its optimal performance and alignment with organizational needs.This includes tas...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Administrator

    Administrator

    TradeJobsWorkforce • 62563 Rochester, IL, US
    [job_card.full_time]
    Administrator Job Duties : Answers the telephone and provides exceptional customer service to ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Cath Lab Tech - $2790.7 / Week

    Travel Cath Lab Tech - $2790.7 / Week

    Host Healthcare • Springfield, IL, US
    [job_card.full_time]
    Host Healthcare is seeking an experienced Cath Lab Tech for an exciting Travel Allied job in Springfield, IL.Shift : Inquire Start Date : 01 / 26 / 2026 Duration : 13 weeks Pay : $2790.At Host Healthcare, ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Travel Rad Tech - $2192 / Week

    Travel Rad Tech - $2192 / Week

    Fusion Medical Staffing • Springfield, IL, US
    [job_card.full_time]
    Fusion Medical Staffing is seeking an experienced Rad Tech for an exciting Travel Allied job in Springfield, IL.Shift : Inquire Start Date : 02 / 09 / 2026 Duration : 13 weeks Pay : $2192 / Week.Facility i...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Mainframe CICS Administrator (ISA I)

    Mainframe CICS Administrator (ISA I)

    Illinois Secretary of State • Springfield, IL, United States
    [job_card.full_time]
    Office of the Illinois Secretary of State.Mainframe CICS Administrator (ISA I).Springfield, IL - Sangamon County (On-Site). Applicants must be authorized to work in the United States; the Office of ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    AIX Administrator

    AIX Administrator

    ASM Research, An Accenture Federal Services Company • Springfield, IL, United States
    [job_card.full_time]
    Responsible for unique or complex information systems and / or information technology projects across more than one discipline, such as application support, database administration, software quality ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Cath Lab Tech - $2529.6 / Week

    Travel Cath Lab Tech - $2529.6 / Week

    CrossMed Healthcare • Springfield, IL, US
    [job_card.full_time]
    CrossMed Healthcare is seeking an experienced Cath Lab Tech for an exciting Travel Allied job in Springfield, IL.Shift : 10 hr days Start Date : ASAP Duration : 13 weeks Pay : $2529.At CrossMed Healthc...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Cath Lab Tech - $2613.64 / Week

    Travel Cath Lab Tech - $2613.64 / Week

    Atlas MedStaff • Springfield, IL, US
    [job_card.full_time]
    Atlas MedStaff is seeking an experienced Cath Lab Tech for an exciting Travel Allied job in Springfield, IL.Shift : 3x12 hr days Start Date : 01 / 26 / 2026 Duration : 13 weeks Pay : $2613.Atlas Medstaff i...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Travel Cath Lab Tech - $2761.2 / Week

    Travel Cath Lab Tech - $2761.2 / Week

    Ventura MedStaff • Springfield, IL, US
    [job_card.full_time]
    Ventura MedStaff is seeking an experienced Cath Lab Tech for an exciting Travel Allied job in Springfield, IL.Shift : 3x12 hr days Start Date : 01 / 26 / 2026 Duration : 13 weeks Pay : $2761.Founded in 201...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Travel Board Certified Behavioral Analyst - School (BCBA) in Springfield, IL

    Travel Board Certified Behavioral Analyst - School (BCBA) in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    [job_card.full_time]
    Board Certified Behavioral Analyst - School.Competitive weekly pay (inquire for details) .AlliedTravelCareers is working with Aequor to find a qualified BCBA - School in Springfield, Illinois, 6270...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Cath Lab Tech - $3100 / Week

    Travel Cath Lab Tech - $3100 / Week

    CrossMed Healthcare • Springfield, IL, US
    [job_card.full_time]
    CrossMed Healthcare is seeking an experienced Cath Lab Tech for an exciting Travel Allied job in Springfield, IL.Shift : 10 hr days Start Date : ASAP Duration : 13 weeks Pay : $3100 / Week.At CrossMed ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Cath Lab Tech - $2736.4 / Week

    Travel Cath Lab Tech - $2736.4 / Week

    FlexCare • Springfield, IL, US
    [job_card.full_time]
    FlexCare is seeking an experienced Cath Lab Tech for an exciting Travel Allied job in Springfield, IL.Shift : 3x12 hr days Start Date : 01 / 26 / 2026 Duration : 13 weeks Pay : $2736.Why Clinicians Choose ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Database Team Lead

    Database Team Lead

    GovCIO • Springfield, IL, United States
    [job_card.full_time]
    GovCIO is currently hiring for Database Team Lead todeploy and manage databases supporting customer applications.This position will be located in Radford, VA and will be a remote position.Senior da...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Federal Senior Data Architect - Oracle Health

    Federal Senior Data Architect - Oracle Health

    Oracle • Springfield, IL, United States
    [job_card.full_time]
    Come and join us! We're looking for a skilled Senior Data Architect to help our team get the most out of their data.This person will be a key contributor, ensuring our team has continuous, reliable...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel CT Tech - $2,531 per week in Springfield, IL

    Travel CT Tech - $2,531 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    [job_card.full_time]
    AlliedTravelCareers is working with Atlas MedStaff to find a qualified CT Tech in Springfield, Illinois, 62781!.Atlas Medstaff is currently seeking candidates in the CT Tech (CT Tech) profession fo...[show_more]
    [last_updated.last_updated_30] • [promoted]