What are the responsibilities and job description for the SQL Database Administrator - JC #9577 position at Cook County Government?
Job Description - SQL Database Administrator, JC #9577 (Clerk of the Circuit Court) (00136006)
Increase your chances of an interview by reading the following overview of this role before making an application.
Requisition ID
00136006
Job Posting
Jan 7, 2025, 5 : 28 : 58 PM
Closing Date
Jan 22, 2025, 5 : 59 : 00 AM
Organization
Cook County Elected Officials
This position requires a physical presence at the work location.
SQL Database Administrator
Job Summary
A SQL Database Administrator (DBA) is responsible for managing, maintaining, and optimizing SQL Server databases, ensuring their performance, security, and availability by performing tasks like database configuration, monitoring system health, troubleshooting issues, implementing backup strategies, optimization, and schema design; often requiring 24 / 7 availability for critical production systems.
- Responsible for the day-to-day administration of the database infrastructure, including maintenance, upgrades, and patching.
- Manage high-volume MS SQL database instances, ensuring high availability and implementing Always On Availability Groups.
- Develop and maintain automation scripts for proactive system monitoring, debugging, code optimization, and automating routine tasks.
- Administer database storage engines and oversee master-slave replication processes to ensure efficient performance and data integrity.
- Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On.
- Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.
- Provides technical support and troubleshooting for database issues and responds to requests and incidents.
- Monitors system health and performance to ensure high availability and security. MS SQL production database level performance tuning.
- Ensures that data is protected from unauthorized access and complies with data privacy regulations.
- Refines and automates regular processes and tracks issues and changes.
- Assist in the technical analysis and design for current and future projects.
- Shares technical expertise and provides mentorship and cross-training to other team members and assist developers with query tuning.
- Participates in SQL code-reviews for the application teams to enforce SQL coding standards.
- Developing and implementing processes for data extraction, transformation, and loading.
- Strong problem-solving skills, with the ability to get to the root of an issue quickly.
- Documents on the company's database environment.
- Providing 24 / 7 support for critical production systems.
The duties listed are not set forth for purposes of limiting the assignment of work. They are not to be construed as a complete list of the many duties normally to be performed under a job title or those to be performed temporarily outside an employee’s normal line of work.
Minimum Qualifications
Preferred Qualifications
Education / Certifications Requirements
Candidates who are contacted for an interview will be required to produce original required documents (e.g., current driver’s license, diploma, school transcript, certifications, etc.) listed on the Notice of Job Opportunity within five (5) days of being notified, in writing, by the Bureau Chief of BHR (or designee) that they have been provisionally placed on the Interview List. Candidates will be notified of how to submit the required document.
Knowledge, Skills, Abilities and Other Characteristics
Physical Requirements
Veterans Preference
When applying for employment with the Clerk of the Circuit Court of Cook County, preference is given in the application process to honorably discharged Veterans who have served in the Armed Forces of the United States for more than 180 consecutive days, or during War Time. To take advantage of this preference a Veteran must :
The Cook County Department of Veterans Affairs can assist you with obtaining a certified DD214 and having it recorded for you at no charge. Please contact veterans.affairs@cookcountyil.gov for additional information.
Benefits Package
1. You must include all work experience in your application for it to be considered. Work experience included in your resume and not in your application will not be considered.
2. Proof of education, accreditation, certification, licenses, or other documents required under Minimum or Preferred Qualifications must be presented before the time of a scheduled interview. Failure to provide proof of education, accreditation, certification, licenses, or other documents required, will result in disqualification of your application and interview. Degrees awarded outside of the United States with the exception of those awarded in one of the United States territories and Canada, must be credentialed by a foreign credential evaluation agency qualified by the Illinois State Board of Education (currently approved agencies can be found here ). All documents will be reviewed for authenticity.
3. Must be legally authorized to work in the United States without sponsorship.
4. This position requires successful completion of post-offer tests, which may include a background check, drug screen and medical examination.
5. Falsification of any information in the application process or failure to comply with any of the requirements in the job notification will result in disqualification for the position, dismissal after hire, and / or placement on the Clerk’s Office’s Ineligible for Hire / Rehire List.
6. The Clerk of the Circuit Court does not hire for Non-Exempt positions based on Political Reasons or Factors.
7. For more information on how to apply, please visit https : / / www.cookcountyclerkofcourt.org / employment and follow the link to fill out an application.
The Clerk of the Circuit Court of Cook County is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, ethnicity, age, sexual orientation, gender identity, disability or veteran status. Auxiliary aids and services are available upon request to individuals with disabilities.
J-18808-Ljbffr
