Database Administrator 19-E-02

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. Business Objects XI and Crystal Reports 2008 as a reporting tool. T‑SQL: error checking, error handling, optimal methods, table/procedure/trigger creation, debugging, performance tuning of stored procedures and ad hoc queries. MS Visual Studio Team System 2008/2010 development. Relational database concepts, XML, Developer Express 2010. General knowledge of MS Access. Java (helpful but not required). Ability to provide occasional unscheduled off‑hours support and maintain satisfactory working relationships with other employees and the general public is required. Attendance is an essential function of this position. #J-18808-Ljbffr