Junior Database Administrator

Overview

It is inspiring to work in an organization where individuals are deeply committed to the mission and values that drive our success. We are dedicated to delivering expert pension service to Illinois public educators as they earn their promised retirement security.

• Evaluate and handle failed SQL Server Agent jobs, including backups and maintenance jobs
• Perform defined tasks including implementing approved user access, running established audit processes, executing approved changes requests, restoring databases to other environments as required
• Perform database administration assignments as directed to 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 with direction, creation of DDL and data change scripts aligned with current database standards as part of iteration activities
• 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
• Support automated testing and provide feedback to team leadership during the development process
• Under the direction of senior staff, modify, test, and create DDL and data changes
• Document processes, data models, and other database artifacts with standardized tools
• Under direction of senior staff, partner with teams to document cataloging, lineage, and data stewardship, while ensuring data quality, security, and compliance
• Perform first-line troubleshooting and debugging of database issues, consulting with senior staff before performing non-standard changes
• Be available to troubleshoot SQL Server service outages and deployments after hours and on weekends
• Other duties as assigned

• Open to new ideas and encourage innovative practices amongst peers
• Practices positive interactions and displays ownership in tasks
• Able to multi-task in a fast-paced, fluid work environment
• Capable of presenting technical ideas and concepts in business-friendly language

• Bachelor's degree in a related field or a combination of education and relevant experience
• General understanding of database administration with SQL Server
• General understanding of SQL

• 1+ year related database administration experience with SQL Server
• 1+ year SQL experience
• C# Experience
• SSIS, SSRS, BI/reporting tools Experience
• Data Mart/Warehouse Experience
• Retirement systems Experience
• SQL Sentry Experience
• ETL/ELT Experience
• General understanding of OLTP vs OLAP, Object Oriented and Relational database design, and STAR, Snowflake, Galaxy Schemas structures
• Power Shell Experience
• Knowledge of LINQ

This position is posted at both the Standard DBA and Junior DBA levels. Candidates will be evaluated and may be selected for hire at either level depending on knowledge, skills, and abilities. Please note that only one hire will be made through this recruitment process.

$73,756.00 - $

Compensation will be determined based on the qualifications and experience of each candidate.

TRS is an agency of the State of Illinois. As such, full and part-time employees are eligible for the State of Illinois comprehensive benefits program which includes medical, dental and vision coverage. All employees participate in the TRS retirement pension plan and have the option to contribute to additional State of Illinois deferred compensation plans. The TRS pension plan is a reciprocal system to other state and local pension plans (SERS, SURS, IMRF, etc.).