· Experience with high availability and disaster recovery technologies including Always On Availability Groups, clustering, replication, and failover solutions.
· Knowledge of cloud computing and hybrid infrastructure environments including Microsoft Azure and related technologies.
· Experience with ETL processes, SSIS, API integrations, and enterprise data integration methodologies.
· Experience with database monitoring and performance analysis tools.
· Understanding of cybersecurity principles, database security, encryption, auditing, and compliance standards.
· Familiarity with DevOps methodologies, CI/CD pipelines, automation, and scripting technologies such as PowerShell.
· Experience supporting enterprise reporting and analytics platforms including SSRS and Power BI.
· Knowledge of virtualization technologies and virtual server environments.
· Ability to write and optimize complex SQL queries, stored procedures, views, and functions.
· Understanding of enterprise data architecture, data governance, and data lifecycle management principles.
· Strong troubleshooting and analytical skills with the ability to resolve complex technical issues.
· Ability to manage multiple priorities in a fast-paced operational environment.
· Strong verbal and written communication skills.
· Ability to work collaboratively across technical and business teams.
· Self-motivated with the ability to work independently and as part of a team.
· Experience with .NET technologies, C#, VB.NET, batch scripting, and related programming languages is preferred.
· Familiarity with AI-enabled monitoring, predictive analytics, and intelligent automation technologies is preferred.
Minimum Qualifications
· Three (3) or more years of experience functioning as a SQL Database Administrator in SQL Server 2019 or newer environments.
· Strong technical experience with installation, configuration, administration, troubleshooting, patching, maintenance, and performance tuning of enterprise database systems.
· Experience supporting high availability, disaster recovery, and enterprise backup/recovery solutions.
· Experience with cloud or hybrid database environments preferred.
· Bachelor’s degree in Information Technology, Computer Science, Information Systems, or a related field from an accredited college or university.
· Equivalent combination of professional experience, education, and technical certifications may be considered.
Typical Duties
· Assists with implementation and modification of logical and physical data models to support enterprise applications and reporting systems.
· Designs, develops, and maintains complex databases, tables, indexes, views, stored procedures, functions, triggers, and other database objects.
· Administers Microsoft SQL Server environments including SQL Server 2016, 2019, and newer platforms.
· Supports cloud and hybrid database technologies including Microsoft Azure SQL, Azure Managed Instances, and cloud-based backup/recovery solutions.
· Designs and maintains highly available and disaster recovery database architectures utilizing Always On Availability Groups, clustering, replication, log shipping, and failover technologies.
· Installs, configures, patches, upgrades, and secures database systems and related software tools.
· Monitors database health, availability, storage utilization, query performance, and system capacity using enterprise monitoring and analytics tools.
· Develops and maintains automated maintenance plans, scripts, jobs, alerts, and monitoring processes using SQL Agent, PowerShell, and automation technologies.
· Supports enterprise ETL and data integration processes utilizing SSIS, API integrations, data pipelines, and modern data movement technologies.
· Collaborates with application development teams to support DevOps, CI/CD deployment processes, and release management activities.
· Supports reporting and business intelligence solutions including SSRS, Power BI, and data warehouse environments.
· Assists with cybersecurity initiatives including database encryption, vulnerability remediation, auditing, access controls, privileged account management, and compliance monitoring.
· Implements backup, restoration, archival, retention, and disaster recovery procedures to ensure continuity of operations and data recovery readiness.
· Assists with data governance, data quality, and master data management initiatives.
· Supports virtualization and containerized environments including VMware and related infrastructure technologies.
· Participates in modernization initiatives involving enterprise payment systems, cashiering systems, revenue collection platforms, and public-facing applications.
· Works closely with technical and business teams to troubleshoot application performance issues and identify root causes.
· Performs database tuning and optimization for queries, indexes, memory allocation, CPU utilization, and disk I/O performance.
· Develops technical documentation, operational procedures, standards, and best practices for database administration and support.
· Assists with testing, validation, and implementation of new technologies and system enhancements.
· Provides Tier III database and production support as required.
· Participates in after-hours support and on-call rotation responsibilities.
Job Summary:
The System Database Administrator reports to and works under the guidance and supervision of the Chief Information Officer (CIO) and Director of Infrastructure. The individual is responsible for the installation, configuration, administration, monitoring, maintenance, optimization, security, and lifecycle management of enterprise database systems and related data technologies.
This role supports mission-critical applications, modern cloud-enabled infrastructure, enterprise reporting platforms, financial systems, payment processing environments, and high-availability data architectures. The Database Administrator works closely with software developers, cybersecurity personnel, infrastructure teams, business analysts, and technical operations staff to ensure optimal system performance, reliability, scalability, and data integrity.
The System Database Administrator will assist in implementing modern database technologies, automation tools, disaster recovery solutions, and enterprise monitoring systems while supporting ongoing digital transformation initiatives. The role also supports the deployment and maintenance of hybrid and cloud-based environments, data integration platforms, business intelligence systems, and secure data governance standards.
The individual will participate in system upgrades, production releases, quality assurance testing, change management procedures, and after-hours support as part of an on-call rotation to ensure continuity of operations.
·
Duties and Responsibilities of the Cook County Treasurer
In Cook County, the County Treasurer oversees the second-largest property tax collection and distribution system in the United States. Cook County Treasurer Maria Pappas is responsible for:
Treasurer Pappas also must maintain an investment policy and strategy to address:
Treasurer Pappas must receive and safely keep the revenues and other public funds of the County and all money and funds authorized by law to be paid to her and disburse the same pursuant to law. Under Illinois law, Treasurer Pappas appoints her deputies, assistants and personnel to assist her in the performance of her duties.
Treasurer Pappas must file regular reports with the President of the County Board to summarize the financial status of her office in the format deemed necessary by the County Board.
Under state law, Treasurer Pappas' office also maintains special funds, from which the County Board shall authorize payments by voucher between board meetings, to include:
In addition, Treasurer Pappas is required by law to:
Under Illinois law, Treasurer Pappas' office also oversees the process of refunding overpayments of taxes. There are varying statutes of limitation depending upon the type of refund. All refund applications must be submitted on or before the expiration of the specific statute of limitation, which begins on the date the right to the refund arose. These refunds are for overpayments that occur through: