FLSA STATUS: Full Time/Exempt
Under direction; performs work of considerable difficulty in performing all activities related to establishing and maintaining a successful database environment and to ensure its performance, availability and reliability and activities administering and supporting the County’s enterprise applications; performs related work as required.
DISTINGUISHING FEATURES OF THE CLASS
An employee in this class spends a substantial amount of time administering and maintaining Enterprise Applications; e.g. ERP, CAD/RMS etc. This position ensures smooth operation of the system and servers to provide optimum performance and ensure the integrity and security of the environment. Work is performed and technical decisions are made with some latitude for independent judgment. Direction is received from a department Manager or Director.
ESSENTIAL DUTIES AND RESPONSIBILITIES
The list of duties and responsibilities is illustrative only, and is not a comprehensive listing of all the duties and responsibilities performed by positions in this class.
• Works with the software vendor and internal development, system and support teams to ensure a high performing software and database environment.
• Maintains and enhances application functionality within and adjacent to a database environment, including external systems.
• Works with application development staff to ensure the database changes adhere to best practices and are properly prioritized and scheduled. Ensures proper change management is followed.
• Provides technical support and direction in business application requirements and alternatives analysis.
• Develops database utilities and automated reporting.
• Designs and documents server architecture.
• Performs database tuning and performance monitoring, and addresses errors and refines changes to databases as needed.
• Manages test, pilot and live systems.
• Implements and manages software and system upgrades, updates and patches.
• Monitors project plans and participates in implementations.
• Works with staff to define requirements and features for new applications.
• Monitors hardware use by Enterprise Applications and makes recommendations regarding growth or capacity.
• Implements roles and permissions to ensure the integrity and security of all databases.
• Develops sound database backup and recovery plans.
• Monitors servers to ensure it does not go over the capacity allowed.
• Advises leadership of emergency technology and new design approaches.
• Establishes and implements policies and procedures pertaining to the management, security, maintenance, and use of the software and database management system.
• Develops and maintains documentation and standards.
• Develops and conducts training on new or updated database software and systems.
• Provides 24X7 support as required.
• Maintains regular attendance and punctuality.
NON-ESSENTIAL DUTIES AND RESPONSIBILITIES
• Adjusts work assignments and schedules in the event of an emergency to participate in emergency preparedness, response, and recovery activities as assigned.
• Depending on assignment may maintain required emergency management training, licensure and/or certifications.
• Performs related duties as required or assigned within job classification.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and /or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
• Principles methods, techniques and practices of programming and project management.
• Standard project management methodologies and tools.
• IBM mainframe environment or Microsoft Client/Server environment.
• Enterprise Application Systems e.g. ERP, CAD/RMS, etc.
• Relational and distributed database design and implementation.
• Report writing software.
• Database files and reporting requirements.
• SQL knowledge base.
• Delivering high levels of agreed upon service to end users.
• Process re-engineering and requirements analysis.
• Analytical review of project work.
• Making and presenting sound recommendations based on technical requirements.
• Identifying, addressing and resolving technical problems within a system.
• Proactively identify and define business needs and apply applicable technology solutions.
• Apply proven principles of theory and design to build and manage a database.
• Estimating, specifying, designing, implementing and deploying database application solutions using project driven methodology.
• Managing software development projects, utilizing external vendors.
• Implement best practices in information technology management.
• Develop innovative methods to achieve desired results.
• Carry out instructions furnished in writing, oral or diagram form, and to produce desired outcomes timely and completely.
• Communicate and use interpersonal skills to interact with coworkers, supervisor, the general public, etc. to sufficiently exchange or convey information and to receive work direction.
EDUCATION and/or EXPERIENCE
Completion of a Bachelor's Degree in Information Technology-related field and four (4) years of Database Administration experience in an Enterprise Resource Planning environment, or an equivalent combination of training and experience.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Position is typically office or administrative work and is not substantially exposed to adverse environmental conditions.
CERTIFICATES, LICENSES, REGISTRATIONS