OFFICE OF ATTORNEY GENERAL
Position Classification: Database Administrator
Permanent Assignment: Deputy Chief of Staff, Administration
Bureau: Information Technology
Location: Chicago Office
Starting Salary: Commensurate With Experience
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.
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.
Hours of Work: 9:00 a.m. - 5:00 p.m. (Monday - Friday)
Send resume and cover letter to:
Office of the Illinois Attorney General
Attn: Human Resources
100 West Randolph, 11th Floor
Chicago, Illinois 60601
An Equal Opportunity Employer
The Illinois Attorney General's Office is an equal opportunity employer. The Office considers applicants 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.
Return to About Us main page