Database Administrator

Job Requisition : 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

The State of Illinois is committed to working with and providing reasonable accommodations to people with disabilities. Further, federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job, interview for a job, or for any other activity related to the hiring process. Examples of reasonable accommodation include, but are not limited to, making a change to the application process (if possible), providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

To be provided a Reasonable Accommodation during the hiring process, you will need to provide a certification of disability from a physician, psychiatrist, school official or an Illinois Department of Human Services (DHS) Division of Rehabilitation Services (DRS) Vocational Rehabilitation (VR) Counselor. Supporting documentation should be uploaded under My Documents → Additional Documents section for each application.

Any questions on Reasonable Accommodations can be directed to Central Management Services Disability Resource Center ability

ResCen or call  for further information and to request or discuss an accommodation.

The State of Illinois does not provide sponsorship for employment visa status (e.g. H-1B visa status), nor is the State able to provide extensions of optional practical training (OPT) under the STEM-designated degree program for F-1 students. To be considered for permanent employment with the State of Illinois, applicants must be currently authorized to work in the United States on a full-time basis.

In compliance with the Illinois Equal Pay Act, 820 ILCS 112/1 et seq., the State does not seek, request, or require a job applicant’s wage or salary history. Employment decisions are not made based on an applicant’s wage or salary history. To that end, please do not include wage or salary information in your resume or other profile or application materials
.

• 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

• 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 Dev Ops 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

• 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…