Talent.com
Database Administrator
Database AdministratorState of Illinois • Springfield, IL, US
No longer accepting applications
Database Administrator

Database Administrator

State of Illinois • Springfield, IL, US
6 days ago
Job type
  • Full-time
  • Part-time
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.

    Create a job alert for this search

    Database Administrator • Springfield, IL, US

    Similar jobs
    Database Administrator 3-IT

    Database Administrator 3-IT

    Oracle • Springfield, IL, United States
    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: 3 days ago • Promoted
    Travel Cath Lab Tech - $2633.76 / Week

    Travel Cath Lab Tech - $2633.76 / Week

    CrossMed Healthcare • Springfield, IL, US
    Full-time
    CrossMed 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 : $2633.At CrossMed Heal...Show more
    Last updated: 11 hours ago • Promoted • New!
    Associate Analyst Business Systems

    Associate Analyst Business Systems

    Medline Industries - Transportation & Operations • Springfield, IL, US
    Full-time
    Under direct oversight, provide support and basic consultation to users in the area of automated systems.Work cross-functionally to deliver system functionality in support of streamlined and effici...Show more
    Last updated: 1 day ago • Promoted
    ServiceNow Platform Administrator

    ServiceNow Platform Administrator

    ASM Research, An Accenture Federal Services Company • Springfield, IL, United States
    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: 3 days ago • Promoted
    Administrator

    Administrator

    TradeJobsWorkforce • 62563 Rochester, IL, US
    Full-time
    Administrator Job Duties : Answers the telephone and provides exceptional customer service to ...Show more
    Last updated: 30+ days ago • Promoted
    Travel Cath Lab Tech - $2790.7 / Week

    Travel Cath Lab Tech - $2790.7 / Week

    Host Healthcare • Springfield, IL, US
    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: 11 hours ago • Promoted • New!
    Travel Rad Tech - $2192 / Week

    Travel Rad Tech - $2192 / Week

    Fusion Medical Staffing • Springfield, IL, US
    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: 1 day ago • Promoted
    Travel Cath Lab Tech - $3,709 to $3,822 per week in Springfield, IL

    Travel Cath Lab Tech - $3,709 to $3,822 per week in Springfield, IL

    AlliedTravelCareers • SPRINGFIELD, IL, US
    Full-time
    AlliedTravelCareers is working with AMN Healthcare Allied to find a qualified Cath Lab Tech in SPRINGFIELD, Illinois, 62769!. Job Description & Requirements.Cath Lab Technologist - (Cath Lab Tec...Show more
    Last updated: 1 day ago • Promoted
    Mainframe CICS Administrator (ISA I)

    Mainframe CICS Administrator (ISA I)

    Illinois Secretary of State • Springfield, IL, United States
    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: 3 days ago • Promoted
    AIX Administrator

    AIX Administrator

    ASM Research, An Accenture Federal Services Company • Springfield, IL, United States
    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: 3 days ago • Promoted
    Travel Cath Lab Tech - $2529.6 / Week

    Travel Cath Lab Tech - $2529.6 / Week

    CrossMed Healthcare • Springfield, IL, US
    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: 30+ days ago • Promoted
    Travel Cath Lab Tech - $2613.64 / Week

    Travel Cath Lab Tech - $2613.64 / Week

    Atlas MedStaff • Springfield, IL, US
    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: 11 hours ago • Promoted • New!
    Travel Cath Lab Tech - $2761.2 / Week

    Travel Cath Lab Tech - $2761.2 / Week

    Ventura MedStaff • Springfield, IL, US
    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: 5 hours ago • 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
    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: 30+ days ago • Promoted
    Travel Cath Lab Tech - $3100 / Week

    Travel Cath Lab Tech - $3100 / Week

    CrossMed Healthcare • Springfield, IL, US
    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: 30+ days ago • Promoted
    Travel Cath Lab Tech - $2736.4 / Week

    Travel Cath Lab Tech - $2736.4 / Week

    FlexCare • Springfield, IL, US
    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: 11 hours ago • Promoted • New!
    Federal Senior Data Architect - Oracle Health

    Federal Senior Data Architect - Oracle Health

    Oracle • Springfield, IL, United States
    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: 3 days ago • 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
    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: 30+ days ago • Promoted