{"schemaVersion":"jobsearcher.job.v1","id":"7d1bc3d4ca1400d78c099edf","url":"https://jobsearcher.com/jobs/7d1bc3d4ca1400d78c099edf","canonicalUrl":"https://jobsearcher.com/jobs/7d1bc3d4ca1400d78c099edf","title":"SQL Developer","description":"SQL Developer\nRequisition ID: 00138492\nOrganization: Sheriff's Department\nJob Posting: Feb 9, 2026, 2:20:23 PM Closing Date: Feb 23, 2026, 11:59:00 PM\nFull-time A.M. P.M.\nPosting Salary: $102,032 annually\n\nCook County\nSheriff\nJob Code: 7173\nJob Title: SQL Developer\nSalary Grade: 23\nDepartment: Sheriff’s TechOps Bureau – Data Operations\nBargaining Unit: Not Applicable\nPosition Details: Civilian (non-sworn) / non-merit ranked / internal & external candidates\nFLSA Status: Exempt\nProbation Period: 12 Months\nDesignation – SEAM EE: Technical\n\nCharacteristics of the Position\nGeneral Overview\nUnder the direction of the Executive Director of Data Operations / Designee, the SQL Developer plays a pivotal role in spearheading the development of SQL databases and crafting applications that seamlessly interface with them. This position involves not only writing and testing robust code but also designing and implementing tables, stored procedures, views and functions, along with executing complex calculations and optimizing existing procedures through strategic use of indexing and temp tables.\nThe SQL developer collaborates closely with team members across Business Intelligence and Applications to create innovative database protypes that effectively validate system requirements. Additionally, the SQL Developer is responsible for producing comprehensive code documentation, providing detailed progress reports, and conducting thorough code reviews while delivering constructive feedback. This dynamic role is essential for driving the success of our data initiatives for the Cook County Sheriff’s Office.\n\nKey Responsibilities and Duties\nWorks with design, creating, and maintaining efficient SQL databases to enable departments and employees to accomplish the goals set by the Sheriff’s Office on a timely basis.\nWrites efficient SQL queries to retrieve, manipulate, and analyze data which includes optimizing queries to improve performance and minimize response time.\nDesign, develop and maintain extract, transform, load (ETL) processes to integrate data from various sources for applications, dashboard, and reporting purposes.\nCollaborates with architecture team, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.\nDevelop and create scripts, triggers, stored procedures, and functions using Transact-SQL.\nCreate documentation for SQL code, database schema, procedures, and processes for future reference, troubleshooting, and team collaboration.\nDiagnose and resolve issues related to database performance, query errors, and system failures which involves debugging SQL code and working closely with the team to ensure system stability.\nPerforms other related assignments and duties as directed.\n\nKnowledge, Skills and Abilities\nStrong knowledge of SQL syntax, relational database management systems, and database architecture.\nStrong understanding of database normalization (reduce redundancy) and denormalization (optimize performance)\nKnowledge of indexing, query execution plans, and optimization techniques for improving query performance.\nKnowledge of ETL tools and techniques for data extraction, transformation, and loading.\nAbility to design data models, including creating entity relationship diagrams (ERD).\nUnderstanding software development life cycles to ensure smooth development and deployment of web-based applications.\nExpertise in writing complex SQL queries, store procedures, triggers, and functions.\nStrong ability to analyze and interpret data, including working with large datasets.\nSkilled in designing normalized relational database schema, creating tables, relationships, and constraints.\nSkilled in performance tuning, indexing, query optimization, and database maintenance.\nSkilled in identifying and resolving query issues, including debugging complex queries and resolving errors in database transactions.\nStrong understanding of Microsoft SQL 2016, 2022, and SQL PaaS as well as various SQL Server features including SSIS, SSRS, XML, etc.\nExperience with modern API technologies (REST, SOAP, JSON, XML).\nStrong leadership, project management skills, time management, and problem-solving skills.\nAbility to accept responsibility, be self-governing, be proactive, and responsible for accomplishment.\nExcellent customer service skills with the ability to react diplomatically and patiently to internal and external customers.\nGood follow-up skills paired with the ability to multi-task and determine root causes.\nExcellent written and verbal communication skills with the ability to read, analyze and interpret technical procedures.\nAbility to work independently under minimal supervision in stressful situations and meet deadlines.\nAbility to manage multiple projects utilizing best practices based on departmental priorities.\n\nMinimum Qualifications\nPossession of a bachelor’s or higher degree in Computer Science, Information Technology, Engineering, or a related field AND at least two (2) years of work experience in SQL Development, OR (5) years of full time, professional work experience in SQL Development, database design, and query optimization\nStrong proficiency in writing SQL queries including complex joins, subqueries, and stored procedures.\nAbility to diagnose and resolve issues related to database performance, integrity, and security, with attention to detail in data analysis and debugging.\nUnderstanding of database normalization, schema design, and relational data modeling.\nKnowledge of data extraction, transformation, and loading.\nRequired to be capable of working any shift assigned, including days, afternoons or midnights; must be capable of working Holidays and weekends; must be capable of working mandatory overtime, as required.\n\nPreferred Qualifications\nExperience with Microsoft Azure SQL Database and Amazon RDS\nStrong ability to identify bottlenecks in SQL queries and optimize database performance using indexing, query optimization, and caching.\nKnowledge of JSON and XML\nKnowledge of scripting languages such as Python, PowerShell, and/or C#\nStrong knowledge of migrating data across different platforms or from on-prem to cloud platforms.\nPossession of ITIL Foundation Certification.\nMicrosoft Certified Solutions Master (MCSM): Data Platform or Business Intelligence.\n\nThe 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.\n\n**Article EE, Civilian Selection Process, of the Sheriff’s Employment Action Manual (SEAM), applies to this employment process and can be found at the following link:\nhttps://cookcountysheriffil.gov/wp-content/uploads/2025/11/SEAM-Article-EE-Civilian-Selection-Process-updated-11-15-25.pdf\n\nPlease note that there are no remote job opportunities, all positions are located onsite.\n\nAll Cook County Sheriff’s Office employees must apply on the internal employment page to be considered; the application may be accessed via the SheriffNet site on the Human Resource page.\n\nNote: All Internal Applicants are subject to Cook County Promotional salary rules if selected.\n\nI Certify that no Political Reasons or Factors were considered in any decision I made or action I took related to this Employment Action. Further, I do not know of or have any reason to believe that anyone else considered or took action based on Political Reasons or Factors with respect to this Employment Action.\n\nEEO Statement\nThe Cook County Sheriff’s Office is an equal opportunity employer and prohibits all unlawful discrimination in its hiring and promotional process. The Cook County Sheriff’s Office employment decisions will not be based on race, color, ancestry, religion, national origin, age, gender identity, sexual orientation, family or parental status, disability, genetic information, or any other basis prohibited by applicable law.\n\nBenefits\nHealth Insurance Program – Health insurance coverage includes medical, dental and vision care and is available for an employee and his/her eligible dependents.\n\nHolidays – Thirteen (13) Holidays are granted in each Fiscal Year. Employees who are active at the beginning of the fiscal year (December 1st) also qualify for a floating holiday.\n\nSick Leave – Granted sick leave is earned and accrued at the rate of one (1) day for each month of service and may be accumulated up to one hundred and seventy-five (175) working days.\n\nVacation Leave – Granted Vacation leave is earned and accrued, with employees having the opportunity to accrue fifteen (15) days within the Fiscal Year; Vacation leave accruals increase based on an employee’s anniversary date of employment.\n\nLife Insurance – Basic term life insurance, equal to one (1) time the employee’s annual salary, is offered to every employee at no cost and the employee may elect to purchase supplemental coverage.\n\nPension Plan – Employees contribute into the Cook County Pension Fund and earn a prescribed percentage for each year of service; employees may be eligible for an annual annuity after ten (10) years of service and upon reaching a certain age based on when the employee started employment.\n\nDeferred Compensation Program – Employees may elect to enroll in a deferred compensation plan, a tax deferred plan which may be used as a supplemental retirement option.\n\nThe 2025 Cook County Employee Benefits Overview can be viewed at:\nhttps://www.cookcountyil.gov/sites/g/files/ywwepo161/files/documents/2025-09/OE26.Employee Benefits Overview (EBO)_County.pdf\n\nDrug and Alcohol-Free Workplace\nIt is the policy of the Cook County Sheriff’s Office to provide a drug- and alcohol-free workplace for all members.\n\nIt is imperative that all Sheriff’s Office members are capable of devoting constant and uninterrupted attention to the performance of all assigned duties without risk to safety and security for themselves, other members, or the public. To ensure the goals of this policy are met, all Sheriff’s Office members shall be subject to drug and alcohol testing, whether mandatory, random, or based on reasonable suspicion.\n\n*Must be legally authorized to work in the United States. *\n\nThis position requires successful completion of post-offer tests, which may include a background check, drug screen and/or medical examination. Falsification of any information in the application process will result in disqualification and ineligible for appointment to, or employment in, a position in the County service for a period of five years. For current Cook County Sheriff’s employees, such falsification may result in discipline, up to and including termination, and ineligible for appointment to or employment in a position in the County service for a period of five years. See Cook County Code of Ordinances, Article II, Sections 44-54 Unlawful Practices Relating to Employees and Employment - Penalty, 44-56 Political Discrimination; Cook County Employment Plan, Section V.N. Pre-Interview License and Certification Verification; Supplemental Policy No. 2014-2.13 Ineligible for Rehire List; and Cook County Personnel Rules 3.3(b) (7) (8) (18).\n\nSheriff’s Employment Action Manual (SEAM)\nThe Cook County Sheriff’s Office hiring process is governed by the Sheriff’s Employment Action Manual (SEAM) which prohibits employment actions from being influenced by any Political Reasons or Factors for Non-Exempt Positions. Cook County Sheriff’s officials and employees who become aware of or receive a complaint that involves an allegation of Political Reasons or Factors being considered in the hiring process of Non-Exempt positions are obligated to refer the complaint to the Cook County Sheriff’s Director of Compliance. If the Cook County Sheriff’s Director of Compliance sustains allegations of Political Reasons or Factors being considered, the Cook County Sheriff’s Office will disqualify the Applicant or Candidate from consideration for employment and disciplinary action will be imposed on any involved Cook County employees, if applicable.”\n\nThe advertisement of this position by any individual does not constitute an offer or promise of employment, promotion, or any other employment action and shall not influence the Cook County Sheriff’s Office hiring decision.","company":"Cook County Sheriffs Office","rawCompany":"cook county sheriffs office","city":"Chicago","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-04-14T11:09:05.855Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"922190","title":"Other Justice, Public Order, and Safety Activities","slug":"other-justice-public-order-and-safety-activities"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"SQL Developer","description":"SQL Developer\nRequisition ID: 00138492\nOrganization: Sheriff's Department\nJob Posting: Feb 9, 2026, 2:20:23 PM Closing Date: Feb 23, 2026, 11:59:00 PM\nFull-time A.M. P.M.\nPosting Salary: $102,032 annually\n\nCook County\nSheriff\nJob Code: 7173\nJob Title: SQL Developer\nSalary Grade: 23\nDepartment: Sheriff’s TechOps Bureau – Data Operations\nBargaining Unit: Not Applicable\nPosition Details: Civilian (non-sworn) / non-merit ranked / internal & external candidates\nFLSA Status: Exempt\nProbation Period: 12 Months\nDesignation – SEAM EE: Technical\n\nCharacteristics of the Position\nGeneral Overview\nUnder the direction of the Executive Director of Data Operations / Designee, the SQL Developer plays a pivotal role in spearheading the development of SQL databases and crafting applications that seamlessly interface with them. This position involves not only writing and testing robust code but also designing and implementing tables, stored procedures, views and functions, along with executing complex calculations and optimizing existing procedures through strategic use of indexing and temp tables.\nThe SQL developer collaborates closely with team members across Business Intelligence and Applications to create innovative database protypes that effectively validate system requirements. Additionally, the SQL Developer is responsible for producing comprehensive code documentation, providing detailed progress reports, and conducting thorough code reviews while delivering constructive feedback. This dynamic role is essential for driving the success of our data initiatives for the Cook County Sheriff’s Office.\n\nKey Responsibilities and Duties\nWorks with design, creating, and maintaining efficient SQL databases to enable departments and employees to accomplish the goals set by the Sheriff’s Office on a timely basis.\nWrites efficient SQL queries to retrieve, manipulate, and analyze data which includes optimizing queries to improve performance and minimize response time.\nDesign, develop and maintain extract, transform, load (ETL) processes to integrate data from various sources for applications, dashboard, and reporting purposes.\nCollaborates with architecture team, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.\nDevelop and create scripts, triggers, stored procedures, and functions using Transact-SQL.\nCreate documentation for SQL code, database schema, procedures, and processes for future reference, troubleshooting, and team collaboration.\nDiagnose and resolve issues related to database performance, query errors, and system failures which involves debugging SQL code and working closely with the team to ensure system stability.\nPerforms other related assignments and duties as directed.\n\nKnowledge, Skills and Abilities\nStrong knowledge of SQL syntax, relational database management systems, and database architecture.\nStrong understanding of database normalization (reduce redundancy) and denormalization (optimize performance)\nKnowledge of indexing, query execution plans, and optimization techniques for improving query performance.\nKnowledge of ETL tools and techniques for data extraction, transformation, and loading.\nAbility to design data models, including creating entity relationship diagrams (ERD).\nUnderstanding software development life cycles to ensure smooth development and deployment of web-based applications.\nExpertise in writing complex SQL queries, store procedures, triggers, and functions.\nStrong ability to analyze and interpret data, including working with large datasets.\nSkilled in designing normalized relational database schema, creating tables, relationships, and constraints.\nSkilled in performance tuning, indexing, query optimization, and database maintenance.\nSkilled in identifying and resolving query issues, including debugging complex queries and resolving errors in database transactions.\nStrong understanding of Microsoft SQL 2016, 2022, and SQL PaaS as well as various SQL Server features including SSIS, SSRS, XML, etc.\nExperience with modern API technologies (REST, SOAP, JSON, XML).\nStrong leadership, project management skills, time management, and problem-solving skills.\nAbility to accept responsibility, be self-governing, be proactive, and responsible for accomplishment.\nExcellent customer service skills with the ability to react diplomatically and patiently to internal and external customers.\nGood follow-up skills paired with the ability to multi-task and determine root causes.\nExcellent written and verbal communication skills with the ability to read, analyze and interpret technical procedures.\nAbility to work independently under minimal supervision in stressful situations and meet deadlines.\nAbility to manage multiple projects utilizing best practices based on departmental priorities.\n\nMinimum Qualifications\nPossession of a bachelor’s or higher degree in Computer Science, Information Technology, Engineering, or a related field AND at least two (2) years of work experience in SQL Development, OR (5) years of full time, professional work experience in SQL Development, database design, and query optimization\nStrong proficiency in writing SQL queries including complex joins, subqueries, and stored procedures.\nAbility to diagnose and resolve issues related to database performance, integrity, and security, with attention to detail in data analysis and debugging.\nUnderstanding of database normalization, schema design, and relational data modeling.\nKnowledge of data extraction, transformation, and loading.\nRequired to be capable of working any shift assigned, including days, afternoons or midnights; must be capable of working Holidays and weekends; must be capable of working mandatory overtime, as required.\n\nPreferred Qualifications\nExperience with Microsoft Azure SQL Database and Amazon RDS\nStrong ability to identify bottlenecks in SQL queries and optimize database performance using indexing, query optimization, and caching.\nKnowledge of JSON and XML\nKnowledge of scripting languages such as Python, PowerShell, and/or C#\nStrong knowledge of migrating data across different platforms or from on-prem to cloud platforms.\nPossession of ITIL Foundation Certification.\nMicrosoft Certified Solutions Master (MCSM): Data Platform or Business Intelligence.\n\nThe 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.\n\n**Article EE, Civilian Selection Process, of the Sheriff’s Employment Action Manual (SEAM), applies to this employment process and can be found at the following link:\nhttps://cookcountysheriffil.gov/wp-content/uploads/2025/11/SEAM-Article-EE-Civilian-Selection-Process-updated-11-15-25.pdf\n\nPlease note that there are no remote job opportunities, all positions are located onsite.\n\nAll Cook County Sheriff’s Office employees must apply on the internal employment page to be considered; the application may be accessed via the SheriffNet site on the Human Resource page.\n\nNote: All Internal Applicants are subject to Cook County Promotional salary rules if selected.\n\nI Certify that no Political Reasons or Factors were considered in any decision I made or action I took related to this Employment Action. Further, I do not know of or have any reason to believe that anyone else considered or took action based on Political Reasons or Factors with respect to this Employment Action.\n\nEEO Statement\nThe Cook County Sheriff’s Office is an equal opportunity employer and prohibits all unlawful discrimination in its hiring and promotional process. The Cook County Sheriff’s Office employment decisions will not be based on race, color, ancestry, religion, national origin, age, gender identity, sexual orientation, family or parental status, disability, genetic information, or any other basis prohibited by applicable law.\n\nBenefits\nHealth Insurance Program – Health insurance coverage includes medical, dental and vision care and is available for an employee and his/her eligible dependents.\n\nHolidays – Thirteen (13) Holidays are granted in each Fiscal Year. Employees who are active at the beginning of the fiscal year (December 1st) also qualify for a floating holiday.\n\nSick Leave – Granted sick leave is earned and accrued at the rate of one (1) day for each month of service and may be accumulated up to one hundred and seventy-five (175) working days.\n\nVacation Leave – Granted Vacation leave is earned and accrued, with employees having the opportunity to accrue fifteen (15) days within the Fiscal Year; Vacation leave accruals increase based on an employee’s anniversary date of employment.\n\nLife Insurance – Basic term life insurance, equal to one (1) time the employee’s annual salary, is offered to every employee at no cost and the employee may elect to purchase supplemental coverage.\n\nPension Plan – Employees contribute into the Cook County Pension Fund and earn a prescribed percentage for each year of service; employees may be eligible for an annual annuity after ten (10) years of service and upon reaching a certain age based on when the employee started employment.\n\nDeferred Compensation Program – Employees may elect to enroll in a deferred compensation plan, a tax deferred plan which may be used as a supplemental retirement option.\n\nThe 2025 Cook County Employee Benefits Overview can be viewed at:\nhttps://www.cookcountyil.gov/sites/g/files/ywwepo161/files/documents/2025-09/OE26.Employee Benefits Overview (EBO)_County.pdf\n\nDrug and Alcohol-Free Workplace\nIt is the policy of the Cook County Sheriff’s Office to provide a drug- and alcohol-free workplace for all members.\n\nIt is imperative that all Sheriff’s Office members are capable of devoting constant and uninterrupted attention to the performance of all assigned duties without risk to safety and security for themselves, other members, or the public. To ensure the goals of this policy are met, all Sheriff’s Office members shall be subject to drug and alcohol testing, whether mandatory, random, or based on reasonable suspicion.\n\n*Must be legally authorized to work in the United States. *\n\nThis position requires successful completion of post-offer tests, which may include a background check, drug screen and/or medical examination. Falsification of any information in the application process will result in disqualification and ineligible for appointment to, or employment in, a position in the County service for a period of five years. For current Cook County Sheriff’s employees, such falsification may result in discipline, up to and including termination, and ineligible for appointment to or employment in a position in the County service for a period of five years. See Cook County Code of Ordinances, Article II, Sections 44-54 Unlawful Practices Relating to Employees and Employment - Penalty, 44-56 Political Discrimination; Cook County Employment Plan, Section V.N. Pre-Interview License and Certification Verification; Supplemental Policy No. 2014-2.13 Ineligible for Rehire List; and Cook County Personnel Rules 3.3(b) (7) (8) (18).\n\nSheriff’s Employment Action Manual (SEAM)\nThe Cook County Sheriff’s Office hiring process is governed by the Sheriff’s Employment Action Manual (SEAM) which prohibits employment actions from being influenced by any Political Reasons or Factors for Non-Exempt Positions. Cook County Sheriff’s officials and employees who become aware of or receive a complaint that involves an allegation of Political Reasons or Factors being considered in the hiring process of Non-Exempt positions are obligated to refer the complaint to the Cook County Sheriff’s Director of Compliance. If the Cook County Sheriff’s Director of Compliance sustains allegations of Political Reasons or Factors being considered, the Cook County Sheriff’s Office will disqualify the Applicant or Candidate from consideration for employment and disciplinary action will be imposed on any involved Cook County employees, if applicable.”\n\nThe advertisement of this position by any individual does not constitute an offer or promise of employment, promotion, or any other employment action and shall not influence the Cook County Sheriff’s Office hiring decision.","datePosted":"2026-04-14T11:09:05.855Z","dateModified":"2026-04-14T11:09:05.855Z","hiringOrganization":{"@type":"Organization","name":"Cook County Sheriffs Office","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Chicago","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"7d1bc3d4ca1400d78c099edf"},"url":"https://jobsearcher.com/jobs/7d1bc3d4ca1400d78c099edf"}}