Database Specialist DB2/SQL (ISS I)

Job Title: Database Specialist DB2/SQL
Division: Data Center Services (ISS I)
Union: IFT
Location: 501 S Second St, Springfield, IL Sangamon County

Salary: Starting at $5,483.00 monthly, commensurate with experience

Overview:

Under general direction, the successor in this role will manage, maintain, and secure the Office's database systems; oversee database design, implementation, and troubleshooting, ensuring optimal performance and data integrity; enhance the efficiency and security of the database infrastructure.

Duties and Responsibilities:

• Design, implement, and maintain database systems for optimal performance and reliability.
• Monitor database performance, implement changes, and apply new patches and versions when required.
• Ensure database security (working closely with the data security team), backup, and recovery plans are in place and effective.
• Collaborate with IT teams to integrate databases with other software applications. Provide technical expertise and support in database design, development, and management.
• Analyze and report on database performance and suggest improvements.
• Completes necessary education, training, and certifications to stay abreast of latest technologies effecting Illinois Secretary of State information security.
• Travels as necessary for education and meetings.
• Performs other duties as required or assigned.

Required Specific Skills:

• Proficient in database administration, management, or a related field.
• Working scholarship of database languages like SQL, and experience with database management software.
• Functioning knowledge of scripting languages such as Python or PowerShell.
• Know-how with cloud-based database services.
• Experience with data backup, recovery, security, integrity, and SQL.
• Requires experience in a government or public sector IT environment.
• Excellent problem-solving and analytical skills.
• Advanced database certifications (e.g., Oracle, Microsoft SQL Server, MySQL).
• Strong communication skills with the ability to collaborate effectively with various IT teams.
• Willingness to travel and possession of a valid Illinois driver s license as required by individual positions within the class.
• Ability to lift/carry, push/pull 0 50 lbs.

Required Education and Work Experience:

• Knowledge, skill and mental development equivalent to completion of two (2) years of college, with coursework in the computer science field.
• Two and a-half (2.5) years of technical systems and programming experience as would be gained as an Information Systems Technician or any equivalent combination of education and experience.

Application Process:

• Please visit https://ilsos.applytojob.gov/apply to apply by completing the online application; you may also upload a resume or other attachments as needed.
• Preference will be given to Illinois residents in the hiring and selection process, in accordance with the Illinois Secretary of State Merit Employment Code.
• Questions regarding this posting or Illinois Secretary of State employment practices may be directed to Job Counselors at our Personnel offices in Chicago (312-793-5515) or Springfield (217-782-4783).

Equal Employment Opportunity Employer. Applicants must be lawfully authorized to work in the United States.
Applicants are considered for all positions without regard to race, color, religion, sex, national origin, sexual orientation, age, marital or veteran status, or the presence of a non-job-related medical condition or disability.

Powered by JazzHR

xUGwHgDagH