Database Administrator

Hiring range is negotiable between $76,316 and $99,195 depending on a candidate's qualifications and experience.

Performs professional and technical work developing, implementing and supporting an automated information system for the City.The essential functions listed below are those that represent the majority of the time spent working in this class. Management may assign additional functions related to the type of work of the class as necessary.

• Ensures proper installation and configuration of MSSQL and Oracle servers and databases. Work involves writing scripts and creating SQL queries for MSSQL and Oracle. Install and maintain the performance of database servers.
• Serves as enterprise application administrator.
• Backup the disaster recovery administrator.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Troubleshoots and resolves hardware and software problems for the servers, network printers, PCs varying in make, model, operating systems, servers and software packages, including various types of equipment at other sites.  
• Maintains daily activity logs in ticketing system; provides detailed documentation of all tickets.

• Considerable knowledge with database management best practices 

• Considerable knowledge with database management best practices 
• Thorough knowledge of SQL server and how it integrates with ODBC connections on the client machine. 
• Considerable knowledge of current information technology in hardware, software and various applications and configurations. 
• Considerable knowledge of how computer technology can be integrated into the environment for a variety of applications and purposes. 
• Considerable knowledge of mid-range, personal computer, network and client/server environments. 
• Ability to analyze, diagnose, and solve computer hardware, network and application problems 
• Ability to understand technical language, programming and applications 
• Ability to communicate effectively orally and in writing 
• Ability to establish and maintain effective working relationships with other employees, City officials and vendors 
• Thorough knowledge of a variety of manufacturer’s software capabilities 
• Ability to plan and implement systems with the IT Director and Network Administrator. 
• Ability to troubleshoot operational problems and to recommend software and hardware solutions as well as applications to resolve problems.  Ability to implement the proposed solutions within a set time frame and prepare detailed documentation. 
• Ability to provide demonstrations and training sessions which increases the participants’ knowledge and ability to use PC software, hardware and in-house developed systems. 
• Ability to follow complex oral and written instructions and to prepare clear and concise instructions and summaries of materials.

MINIMUM EDUCATION AND EXPERIENCE REQUIREMENTS:

• Bachelor’s Degree in Computer Science, Information Technology, Physical Science or related discipline.
• Five (5) years of experience in server/systems support and/or computer programming; or an equivalent combination of education, training, and experience. 

SPECIAL CERTIFICATIONS AND LICENSES:

• Possession of an MCSA Certification preferred.
• Experience in the following is preferred: 
  • Programing in SQL server  
  • SQL Server Administration 

PHYSICAL DEMANDS:
Physical demands refer to the requirements for physical exertion and coordination of limb and body movement.

• Performs medium work that involves walking, standing, stooping, jumping, lifting, digging, pushing and raising objects and also involves exerting between 20 and 50 pounds of force on a regular and recurring basis and 50 to 100 pounds of force on an occasional basis.
• Must possess the visual acuity to prepare and analyze data, operate a computer, and do extensive reading.  
• Must be able to perform the basic life operational support functions of stooping, reaching, standing, walking, pushing, pulling, lifting, fingering, grasping, talking, hearing, and repetitive motions.    

UNAVOIDABLE HAZARDS (WORK ENVIRONMENT):
Unavoidable hazards refer to the job conditions that may lead to injury or health hazards even though precautions have been taken.

The work is generally performed in an office environment and involves everyday risks or discomforts which require normal safety precautions typical of such places as offices, meeting and training rooms, libraries, residences or commercial vehicles.  Use of safe work practices with office equipment, avoidance of trips and falls, observance of fire regulations and traffic signals are minimally required. 

AMERICANS WITH DISABILITIES ACT COMPLIANCE
The City of Goldsboro is an Equal Opportunity Employer.  ADA requires the City to provide reasonable accommodation to qualified persons with disabilities. Prospective and current employees are encouraged to discuss ADA accommodations with management.

STANDARD CLAUSES
May be required to work nights, weekends, holidays and emergencies (man-made or natural) to meet the business needs of the City.
This job description is not designed to cover or contain a comprehensive listing of essential functions and responsibilities that are required of an employee for this job. Other duties, responsibilities, and activities may change or be assigned at any time with or without notice. 

ESSENTIAL SAFETY FUNCTIONS
It is the responsibility of each employee to comply with established policies, procedures, and safe work practices. Each employee must follow safety training and instructions provided by their supervisor. Each employee must also properly wear and maintain all personal protective equipment required for their job. Finally, each employee must immediately report any unsafe work practices or unsafe conditions as well as any on-the-job injury or illnesses. 
Every manager/supervisor is responsible for enforcing all safety rules and regulations. In addition, they are responsible for ensuring that a safe work environment is maintained, safe work practices are followed, and employees are properly trained.