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
29 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
    Branch Administrator

    Branch Administrator

    Western Construction Group • Springfield, IL, US
    Full-time
    Grow With Us at Western Specialty Contractors.At Western Specialty Contractors, we've been building more than projects-we've been building people, careers, and communities for over 110 years.Louis ...Show more
    Last updated: 1 day ago • Promoted
    Travel Cath Lab Tech - $2,692 to $2,892 per week in Springfield, IL

    Travel Cath Lab Tech - $2,692 to $2,892 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Springfield, IL, United States.ARRT(R) / BCLS / BLS - American Heart Association / RCIS.Titan Medical is looking for travelers to fill a Travel Cath Lab Tech position for a 13-week assignment in Springfi...Show more
    Last updated: 16 days ago • Promoted
    Travel Cath Lab Tech - $3,124 per week in Illinois

    Travel Cath Lab Tech - $3,124 per week in Illinois

    AlliedTravelCareers • All Cities, IL, US
    Full-time
    KPG Healthcare is currently seeking Cath Lab Techs to fill Travel and Local Contract opportunities throughout our network of hospitals. Certifications : ARRT(CV) or RCIS, State License (if applicable...Show more
    Last updated: 16 days ago • Promoted
    Travel Cath Lab Tech - $3,312 per week in Illinois

    Travel Cath Lab Tech - $3,312 per week in Illinois

    AlliedTravelCareers • All Cities, IL, US
    Full-time
    KPG Healthcare is currently seeking Cath Lab Techs to fill Travel and Local Contract opportunities throughout our network of hospitals. Certifications : ARRT(CV) or RCIS, State License (if applicable...Show more
    Last updated: 30+ days ago • Promoted
    Travel X-Ray Tech - $1,888 per week in Springfield, IL

    Travel X-Ray Tech - $1,888 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Atlas Medstaff is currently seeking candidates in the X-Ray Tech (X-Ray Tech) profession for a 13 week contract in the Springfield, Illinois area. Atlas Medstaff is a premier staffing firm dedicated...Show more
    Last updated: 5 days ago • Promoted
    Travel Cath Lab Tech - $2,985 to $3,178 per week in Springfield, IL

    Travel Cath Lab Tech - $2,985 to $3,178 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time +1
    AlliedTravelCareers is working with Aya Healthcare to find a qualified Cath Lab Tech in Springfield, Illinois, 62701!.Aya Healthcare has an immediate opening for the following position : .Cath Lab Te...Show more
    Last updated: 30+ days ago • Promoted
    Mainframe CICS Administrator (ISA I)

    Mainframe CICS Administrator (ISA I)

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Mainframe CICS Administrator (ISA I) Division : Data Center Services Union : &#...Show more
    Last updated: 30+ days ago
    Information Systems Advisor I - Senior Business Analysis

    Information Systems Advisor I - Senior Business Analysis

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Information Systems Advisor I – Senior Business Analysis Division : Governance & Business...Show more
    Last updated: 5 days ago
    Travel Cath Lab Tech - $2,462 to $2,729 per week in Springfield, IL

    Travel Cath Lab Tech - $2,462 to $2,729 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Ready to start your next travel adventure? LRS Healthcare offers a full benefits package, 24 / 7 support, and a responsive, traveler-first culture. What are you waiting for? Apply today!.Valid license...Show more
    Last updated: 30+ 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 - $2,460 to $2,828 per week in Springfield, IL

    Travel Cath Lab Tech - $2,460 to $2,828 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Facility in Springfield, Illinois.Fusion Medical Staffing is seeking a skilled Cath Lab Tech for a 13-week travel assignment in Springfield, Illinois. As a member of our team, you'll have the opport...Show more
    Last updated: 12 days ago • Promoted
    Travel Radiology Tech - $1,919 to $2,206 per week in Springfield, IL

    Travel Radiology Tech - $1,919 to $2,206 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Facility in Springfield, Illinois.Fusion Medical Staffing is seeking a skilled Rad Tech for a 13-week travel assignment in Springfield, Illinois. As a member of our team, you'll have the opportunity...Show more
    Last updated: 1 day ago • Promoted
    Travel Radiology Tech - $1,715 to $1,972 per week in Springfield, IL

    Travel Radiology Tech - $1,715 to $1,972 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Facility in Springfield, Illinois.Fusion Medical Staffing is seeking a skilled Rad Tech for a 13-week travel assignment in Springfield, Illinois. As a member of our team, you'll have the opportunity...Show more
    Last updated: 5 days ago • Promoted
    Travel Surgical Tech - $2,015 per week in Springfield, IL

    Travel Surgical Tech - $2,015 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Travel Nursing : OR Springfield.Shift Details : 8H Days (6 : 45 AM-3 : 15 PM).Length : 13 WEEKS 13 weeks.Apply for specific facility details.Show more
    Last updated: 8 days ago • Promoted
    Travel Cath Lab Tech - $2,836 per week in Springfield, IL

    Travel Cath Lab Tech - $2,836 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Travel Radiology : Cath Lab Tech Springfield.Shift Details : 12H Days (6 : 30 AM-7 : 00 PM).Length : 13 WEEKS 13 weeks.Apply for specific facility details.Show more
    Last updated: 30+ days ago • Promoted
    Travel X-Ray Tech - $1,870 per week in Springfield, IL

    Travel X-Ray Tech - $1,870 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    Travel Radiology : X-Ray Tech Springfield.Shift Details : 12H Nights (7 : 00 PM-7 : 30 AM).Length : 13 WEEKS 13 weeks.Apply for specific facility details.Show more
    Last updated: 5 days 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
    Job Description & Requirements.Cath Lab Technologist - (Cath Lab Tech) .StartDate : 2 / 23 / 2026 Available Shifts : 10 D Pay Rate : $3709. Current licensure as a Cardiovascular Technologist with EP ...Show more
    Last updated: 8 days ago • Promoted
    Travel Cath Lab Tech - $2,614 per week in Springfield, IL

    Travel Cath Lab Tech - $2,614 per week in Springfield, IL

    AlliedTravelCareers • Springfield, IL, US
    Full-time
    AlliedTravelCareers is working with Atlas MedStaff to find a qualified Cath Lab Tech in Springfield, Illinois, 62781!.Atlas Medstaff is currently seeking candidates in the Cath Lab Tech (Cath Lab T...Show more
    Last updated: 30+ days ago • Promoted