Senior Technical Database Administrator (PUBLIC SERVICE ADMINISTRATOR, OPT. 3)

We continually strive for a workforce that reflects the growing diversity within the State of Illinois. A variety of employee backgrounds, perspectives, ideas and experiences are crucial to our ability to most effectively serve the public. Bilingual skills welcome

Reasonable Accommodation Statement

The State of Illinois is committed to working with and providing reasonable accommodations to people with disabilities. Further, federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job, interview for a job, or for any other activity related to the hiring process. Examples of reasonable accommodation include, but are not limited to, making a change to the application process (if possible), providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

To be provided a Reasonable Accommodation during the hiring process, you will need to provide a certification of disability from a physician, psychiatrist, school official or an Illinois Department of Human Services (DHS) Division of Rehabilitation Services (DRS) Vocational Rehabilitation (VR) Counselor. Supporting documentation should be uploaded underMy Documents Additional Documentssection for each application.

Any questions on Reasonable Accommodations can be directed to Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss an accommodation.

Sponsorship for Employment

The State of Illinois does not provide sponsorship for employment visa status (e.g. H-1B visa status). To be considered for permanent employment with the State of Illinois, applicants must be currently authorized to work in the United States on a full-time basis.

Disclosure of Salary Information

In compliance with the Illinois Equal Pay Act, 820 ILCS 112/1 et seq., the State does not seek, request, or require a job applicant's wage or salary history. Employment decisions are not made based on an applicant's wage or salary history. To that end, pleasedo not include wage or salary information in your resume or other profile or application materials.

Springfield, IL, US, 62701

Position Title:Public Service Administrator, Opt 3

Agency: Department of Innovation and Technology

Posting Date:08/27/2024
Closing Date/Time:09/10/2024
Salary:$7,966.00 - $11,759.00/month
Job Type:Salaried
County:Sangamon
Number of Vacancies:1
Plan/BU:RC063

This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position.

All applicants who want to be considered for this positionMUSTapply electronically through the illinois.jobs2web.com website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors employee career portal.

Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered.

Posting Identification Number40783

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 that are 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

Essential Functions

25% 1. 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):
• Serves as Senior Technical Database Administrator for the Office of Health Protection systems (OHP) - Division of Infectious Disease databases and applications.
• Creates and maintains procedures for database design, backup, recovery, integrity, and security.
• Makes detailed recommendations to project leaders and management on possible problems and on ways to solve these problems and improve the Office of Health Protection systems.
• Utilizes IBM AIX operating system, IBM WebSphere, DB2 UDB, SQL Server, JAVA J2E_E , Oracle, Azure DevOps and the use of database projects in performance of duties.

20% 2. Provides support to application developers by participating in system design reviews:
• Provides detailed recommendations on the database design and modifications pertaining to new system requirements.
• Performs database analysis and application analysis for area to enhance and improve performance.
• Coordinates activities with central agency staff or vendors to provide technical support of the databases and related software for maximum performance of the Office of Health Protection Systems.

15% 3. Assists project managers in the development of system project plans for tasks, including the installation of the Office of Health Protection databases and system related tasks:
• Assists in setting target dates, resource scheduling and objectives.
• Develops, recommends, and implements policies and procedures.
• Compiles data for cost-benefit analysis.
• Allocates resources.
• Derives and coordinates precise problem definition and procedures for the conduct of projects.
• Implements project management standards and techniques for accounting and control.

Essential Functions Continued

25% 1. 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):
• Serves as Senior Technical Database Administrator for the Office of Health Protection systems (OHP) - Division of Infectious Disease databases and applications.
• Creates and maintains procedures for database design, backup, recovery, integrity, and security.
• Makes detailed recommendations to project leaders and management on possible problems and on ways to solve these problems and improve the Office of Health Protection systems.
• Utilizes IBM AIX operating system, IBM WebSphere, DB2 UDB, SQL Server, JAVA J2E_E , Oracle, Azure DevOps and the use of database projects in performance of duties.

20% 2. Provides support to application developers by participating in system design reviews:
• Provides detailed recommendations on the database design and modifications pertaining to new system requirements.
• Performs database analysis and application analysis for area to enhance and improve performance.
• Coordinates activities with central agency staff or vendors to provide technical support of the databases and related software for maximum performance of the Office of Health Protection Systems.

15% 3. Assists project managers in the development of system project plans for tasks, including the installation of the Office of Health Protection databases and system related tasks:
• Assists in setting target dates, resource scheduling and objectives.
• Develops, recommends, and implements policies and procedures.
• Compiles data for cost-benefit analysis.
• Allocates resources.
• Derives and coordinates precise problem definition and procedures for the conduct of projects.
• Implements project management standards and techniques for accounting and control.

Minimum Qualifications

1. Requires knowledge, skill, and mental development equivalent to four (4) years of college with coursework in management information systems, data processing or telecommunications, or directly related field.
2. 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.

Specialized Skills

1. Requires three (3) years professional experience with maintenance of various database technologies such as DB2 UDB, SQL Server or Oracle.
2. Requires three (3) years professional experience with IBM AIX operating system and IBM WebSphere Application environment.
3. Requires three (3) years professional experience demonstrating technical ability in analysis, design, and system development.

Preferred Qualifications (In Order of Significance)

1. Three (3) years professional experience with maintenance of various database technologies such as DB2 UDB, SQL Server or Oracle.
2. Three (3) years professional experience with IBM AIX operating system and IBM WebSphere Application environment.
3. Three (3) years professional experience demonstrating technical ability in analysis, design, and system development.
4. Three (3) years of professional experience with application development tools and software development methodology tools.
5. Working knowledge of SQL application development experience including writing scripts to perform database conversions.
6. Demonstrated technical ability in Database Administration.
7. Working knowledge of JAVA J2E_E programming.
8. Ability to analyze administrative problems and adopt an effective course of action.
9. 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 meetALLof the following conditions of employment, with or without reasonable accommodation, to be considered for this position.

1. Requires the ability to verify identity.
2. Requires employment authorization to accept permanent full-time position with the State of Illinois.
3. Requires the ability to pass a position specific, agency required background check.
4. Requires self-disclosure of criminal history.
5. Requires the ability to travel in performance of duties.
6. Requires the ability to work outside of normal hours to meet deadlines.
7. Requires the ability to serve in an on-call capacity.
8. Requires the ability to work overtime including scheduled, unscheduled, short notice, evenings, weekends, and holidays.
9. 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.
10. 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.

Work Hours:8:30AM - 5:00PM Monday - Friday
Work Location:422 S 5th St, Springfield, Illinois, 62701
Agency Contact:

Jessica.Jordan2@illinois.gov

Posting Group:Leadership & Management

This position DOES contain “Specialized Skills” (as that term is used in CBAs).

The Department of Innovation & Technology (DolT) is the state's IT agency delivering an enterprise approach to statewide technology, innovation, and telecommunication services, as well as policy and standards development, lifecycle investment planning, and cybersecurity services. With over 1,500 employees, DolT delivers IT services and innovative solutions to customer agencies to improve services provided to Illinois residents, DolT offers employees the opportunity to advance their careers, develop new skills and reach their potential, both personally and professionally. DoIT is committed to promoting and preserving a workplace culture that embraces diversity and inclusion. We welcome and value employees with different backgrounds, life experiences and talents. It is the collective sum of our individual differences that provides a broad perspective, leading to greater innovation and achievement. In recruiting for our team, we recognize the unique contributions of each applicant regardless of culture, ethnicity, race, national origin, sex, gender identity and expression, age, religion, disability, and sexual orientation.