SQL Developer

Cook County • Chicago, IL

5h • Onsite

About The Position

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

Requirements

• Strong knowledge of SQL syntax, relational database management systems, and database architecture.
• Strong understanding of database normalization (reduce redundancy) and denormalization (optimize performance)
• Knowledge of indexing, query execution plans, and optimization techniques for improving query performance.
• Knowledge of ETL tools and techniques for data extraction, transformation, and loading.
• Ability to design data models, including creating entity relationship diagrams (ERD).
• Understanding software development life cycles to ensure smooth development and deployment of web-based applications.
• Expertise in writing complex SQL queries, store procedures, triggers, and functions.
• Strong ability to analyze and interpret data, including working with large datasets.
• Skilled in designing normalized relational database schema, creating tables, relationships, and constraints.
• Skilled in performance tuning, indexing, query optimization, and database maintenance.
• Skilled in identifying and resolving query issues, including debugging complex queries and resolving errors in database transactions.
• Strong understanding of Microsoft SQL 2016, 2022, and SQL PaaS as well as various SQL Server features including SSIS, SSRS, XML, etc.
• Experience with modern API technologies (REST, SOAP, JSON, XML).
• Strong leadership, project management skills, time management, and problem-solving skills.
• Ability to accept responsibility, be self-governing, be proactive, and responsible for accomplishment.
• Excellent customer service skills with the ability to react diplomatically and patiently to internal and external customers.
• Good follow-up skills paired with the ability to multi-task and determine root causes.
• Excellent written and verbal communication skills with the ability to read, analyze and interpret technical procedures.
• Ability to work independently under minimal supervision in stressful situations and meet deadlines.
• Ability to manage multiple projects utilizing best practices based on departmental priorities.
• Possession 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
• Strong proficiency in writing SQL queries including complex joins, subqueries, and stored procedures.
• Ability to diagnose and resolve issues related to database performance, integrity, and security, with attention to detail in data analysis and debugging.
• Understanding of database normalization, schema design, and relational data modeling.
• Knowledge of data extraction, transformation, and loading.
• Required 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.

Nice To Haves

• Experience with Microsoft Azure SQL Database and Amazon RDS
• Strong ability to identify bottlenecks in SQL queries and optimize database performance using indexing, query optimization, and caching.
• Knowledge of JSON and XML
• Knowledge of scripting languages such as Python, PowerShell, and/or C#
• Strong knowledge of migrating data across different platforms or from on-prem to cloud platforms.
• Possession of ITIL Foundation Certification.
• Microsoft Certified Solutions Master (MCSM): Data Platform or Business Intelligence.

Responsibilities

• Works 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.
• Writes efficient SQL queries to retrieve, manipulate, and analyze data which includes optimizing queries to improve performance and minimize response time.
• Design, develop and maintain extract, transform, load (ETL) processes to integrate data from various sources for applications, dashboard, and reporting purposes.
• Collaborates with architecture team, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
• Develop and create scripts, triggers, stored procedures, and functions using Transact-SQL.
• Create documentation for SQL code, database schema, procedures, and processes for future reference, troubleshooting, and team collaboration.
• Diagnose 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.
• Performs other related assignments and duties as directed.

Benefits

• Health Insurance Program – Health insurance coverage includes medical, dental and vision care and is available for an employee and his/her eligible dependents.
• Holidays – 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.
• Sick 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.
• Vacation 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.
• Life 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.
• Pension 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.
• Deferred 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level