Summary of Duties and Responsibilities The Database Administrator will be responsible to work with the Information Technology Project Manager to ensure that the computer programmers and programmer analysts utilize the system methodology in place to develop all software projects from the planning stage through the implementation stage. Additional responsibilities include: the ability to identify user needs to create and administer databases, ensure that the database operates efficiently and without error, make and test modifications to the database structure when needed, maintain the database and update permissions, oversee the merge of old databases into new ones, and backup and restore data to prevent data loss, work with the Information Technology Manager, Chief Technology Officer, and Management to understand the agency’s data needs and to plan the goals of the database.
Qualifications
This position requires a Bachelor’s degree in computer science with a concentration in database administration or computer programming, or 3-5 years of experience in a position comparable to overseeing information technology projects. Good communication skills are required to maintain and form working relationships with coworkers, staff, end-users, and management. Knowledge of the Microsoft products and certifications are a plus.
Additional requirements include knowledge and skills in:
Microsoft SQL Server 2005/2008, replication, relational databases, and communication protocols; experience with Business Objects XI and Crystal Reports 2008 as a reporting tool; working knowledge of T-SQL with respect to error checking, error handling, optimal methods, table/procedure/trigger creations, debugging and performance tuning of stored procedures and ad hoc queries; knowledge of development with MS Visual Studio Team System 2008/2010; ability to understand all aspects of relational databases, experience with XML, Developer Express 2010, and a general knowledge of MS Access; and Java helpful but not required. The ability to provide occasional unscheduled off-hours support, maintain satisfactory working relationships with other employees and the general public is required. Attendance is an essential function of this position.
Benefits
We offer a complete benefits package to full-time employees including health care, dental, vision, retirement, deferred compensation plans, flexible spending accounts, life insurance, long-term disability, holidays, vacation, and sick leave.
Part-time employees who work an average of 20 hours per week over the course of a year, receive benefits on a pro-rated basis.As an employee of the Illinois Attorney General's Office, you'll have access to many great benefits. Join the legal team responsible for protecting the public interest of the state and the people of Illinois!
- Health and Dental insurance along with free Vision insurance*
- Pension Benefits through the State Employees'; Retirement System
- Disability coverage
- Deferred Compensation: supplemental retirement savings program-457k
- Commuter Savings Program: pre-tax transportation program
- Flexible Spending: Medical and Dependent pre-tax savings program
- Health Savings Account
- Life insurance benefit: free with option to purchase additional (up to 8 x your annual salary) at low cost. Spouse and child life insurance available
- Employee Assistance Program through ComPsych
- Holidays: 13 1/2 paid
- Vacation days: minimum of 12 days, maximum of 27 days, prorated
- Personal days: 4 annually
- Floating Holiday: 1 annually
- Sick days: 1 per month
- For attorneys, office provided Continuing Legal Education
- Semi-monthly payroll
*Health and Dental cost ranges: for single: $120.00 - $322.00 monthly; for family: $292.00 - $665.00 monthly For more information on benefits: visit cms.illinois.gov/benefits/stateemployee.html