You are viewing a preview of this job. Log in or register to view more details about this job.

Senior Technical Database Administrator

Illinois Department of Innovation and Technology
Email

Job Title: Senior Technical Database Administrator

Job Requisition ID: 45141

Closing Date: 3/12/2025

Salary: $7,966.00 a month

Work Hours: M-F 8:30AM - 5:00PM

Work Location: (Hybrid) 422 S 5th St, Springfield, Illinois, 62701

Union Position: Yes

Work authorization: US work authorization required at time of application. No sponsorship available. Not eligible for F1 OPT/CPT. Positions are W2 only and cannot be converted to a contract position. If you have questions about your work authorization eligibility, please email doit.recruitment@illinois.gov. 

Questions? Email doit.recruitment@illinois.gov

Transcripts are required for consideration.

 

Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment. 

This position serves as the Senior Technical Database Administrator supporting the Illinois Department of Public Health (IDPH). 

In this role, you will provide technical guidance and assistance to application development project teams and management in the highly technical area of database design, implementation, and maintenance.  

In addition, you will provide support to leading edge multi-tier applications and systems critical to the Agency.  

If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position to join the DoIT Team!

 

As a State of Illinois employee, you receive a comprehensive benefits package including:
•    Competitive Group Insurance benefits including health, life, dental and vision plans.
•    Flexible work schedules (when available and dependent upon position)
•    10 -25 days of paid vacation time annually (10 days for first year of state employment)
•    12 days of paid sick time annually which carryover year to year
•    3 paid personal business days per year
•    13-14 paid holidays per year dependent on election years
•    12 weeks of paid parental leave
•    Pension plan through the State Employees Retirement System
•    Deferred Compensation Program – voluntary supplemental retirement plan
•    Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP)
•    Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility

For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

 

Why Work for Illinois?

Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether you’re helping to improve schools, protect our natural resources, or support families in need, you’re part of something bigger—something that touches the lives of every person who calls Illinois home.

No matter what state career you’re looking for, we offer jobs that fit your life and your schedule—flexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois.
 

 

Essential Functions

  • Subject to management approval, serves as the Senior Technical Database Administrator for the Department of Innovation & Technology (DoIT), supporting the Illinois Department of Public Health (IDPH) creating and maintaining procedures for database design, backup, recovery, integrity, and security for the Office of Health Protection (OHP).
  • Provides support to application developers by participating in system design reviews and providing detailed recommendations on the database design and modifications pertaining to new system requirements.
  • Assists project managers in the development of system project plans, including the installation of OHP databases and system related tasks.
  • Monitors all Office of Health Protection production systems and databases to ensure systems are running optimally and efficiently by the utilization of database monitoring tools to interpret when databases and systems are in critical status.
  • Writes and maintains complex SQL scripts used to support infrastructure of business objects.
  • Reviews, conducts, and coordinates feasibility studies to determine user needs and requirements for computer applications.
  • Reviews, analyzes, and evaluates computer systems to determine adherence to department standards by verifying databases and systems to best utilize current technologies.
  • Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above.

 

Minimum Qualifications

  • Requires knowledge, skill, and mental development equivalent to four (4) years of college with coursework in management information systems, data processing, telecommunications, or directly related field.
  • Requires prior experience equivalent to three (3) years of progressively responsible administrative experience in management information systems, data processing or telecommunications in a public or business organization.

     

Preferred Qualifications (In Order of Significance)

  • Three (3) years of professional database administration experience including installation, configuration, and maintenance of SQL Server databases.
  • Three (3) years of professional experience utilizing SQL Server tools (e.g., SQL Server Management Studio, Profiler), SQL application development tools, software development methodology tools, and third-party monitoring tools to ensure database health, security, and scalability while aligning with business and IT objectives.
  • Three (3) years of professional IT experience demonstrating technical proficiency in analysis, design, and system development, with hands-on experience applying software development methodologies to enhance system efficiency and scalability.
  • Three (3) years of professional experience utilizing T-SQL and PowerShell to automate administrative tasks, streamline deployments, and enhance database management efficiency in enterprise environments.
  • Working knowledge of SQL application development, including writing scripts for database conversions, data migrations, and optimizing database performance to ensure seamless system integration and functionality.
  • Working knowledge of JAVA J2E_E programming including developing, maintaining, and integrating enterprise applications within a database-driven environment.
  • Working knowledge of conducting feasibility studies to assess user needs and requirements for computer applications, including analyzing business processes, evaluating technical solutions, and recommending system enhancements.
  • Ability to analyze administrative problems and adopt an effective course of action.
  • Ability to coordinate the activities of work associates to achieve desired results.
  • Demonstrated verbal and written communication skills to present technical information to others with clarity and precision.

 

Conditions of Employment

NOTE: Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position. 

  • Requires the ability to verify identity.
  • Requires employment authorization to accept permanent full-time position with the State of Illinois.
  • Requires the ability to pass a position specific, agency required background check.
  • Requires self-disclosure of criminal history.
  • Requires the ability to travel in performance of duties.
  • Requires the ability to work outside of normal hours to meet deadlines.
  • Requires the ability to serve in an on-call capacity.
  • Requires the ability to work overtime including scheduled, unscheduled, short notice, evenings, weekends, and holidays.
  • Requires the ability to attend seminars, conferences, and training to remain current on methods, tools, ideologies, or other industry related topics relevant to job duties.
  • Requires the ability to lift and carry objects or equipment weighing up to 20 pounds. This is considered light work as defined by the U.S. Department of Labor (20 CFR 404.1567(b)). Light work involves lifting no more than 20 pounds at a time with frequent lifting or carrying of objects weighing up to 10 pounds.

The conditions of employment listed are incorporated and/or related to any duties included in the position description.