Database Administrator

Teachers Retirement System of Illinois • Springfield, IL

2d • Onsite

About The Position

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. 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.

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

Nice To Haves

• C# experience
• SSIS, SSRS, BI/reporting tools experience
• Data Mart/Warehouse experience
• Retirement systems experience
• SQL Sentry experience
• PowerShell experience
• Knowledge of LINQ

Responsibilities

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

Benefits

• medical coverage
• dental coverage
• vision coverage
• TRS retirement pension plan
• option to contribute to additional State of Illinois deferred compensation plans

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree