Illinoiscomptroller
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 Reasonable Accommodation Statement
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 at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss an accommodation. Sponsorship for Employment
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. Disclosure of Salary Information
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 . 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 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 SQL Sentry 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. 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.
#J-18808-Ljbffr
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 Reasonable Accommodation Statement
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 at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss an accommodation. Sponsorship for Employment
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. Disclosure of Salary Information
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 . 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 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 SQL Sentry 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. 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.
#J-18808-Ljbffr