What are the responsibilities and job description for the Database Administrator 19-E-02 position at Illinois Attorney General (IL)?
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.
Salary : $70,000 - $100,000