Database Support Specialist

Summary: Under general direction, this position maintains and modifies databases; analyzes system performance; designs and writes queries and programs; designs, documents and implements all system and server processes including security, access, test routings and back up; modifies existing programs to user requirements; troubleshoots and resolves malfunctions; writes systems documentation; and may provide work direction to programmers. Databases may include but are not limited to document imaging and telephony/unified messaging, confidential member data, system storage and public data.

Essential Functions: -- Essential functions, as defined under the Americans with Disabilities Act, may include any of the following representative duties, knowledge, and skills. This is not a comprehensive listing of all functions and duties performed by incumbents of this class; employees may be assigned duties which are not listed below; reasonable accommodations will be made as required. The job description does not constitute an employment agreement and is subject to change at any time by the employer. Essential duties and responsibilities may include, but are not limited to, the following:

• Writes complex SQL queries and stored procedures.
• Analyzes business processes and applies technology to improve accuracy and/or efficiency.
• Creates, monitors and maintains databases. May use IBM DB2, MS SQL Server, Oracle, MS Access and/or other applicable technologies.
• Performs database administration and maintenance.
• Archives/deletes expired data.
• Maintains the security of the system.
• Verifies and maintains the integrity of information in multiple databases.
• Evaluates new software to enhance existing system.
• Writes clear documentation.
• Performs system upgrades.
• Data warehouse analysis and design experience.
• Develops reports to solve business problems with experience in team facilitation and problem resolution;
• Writes and/or modifies software programs using database languages;
• Writes and tests scripts used to build, restore, dump and/or maintain databases;
• Uses system commands and protocols to maintain network systems and/or databases.
• Designs and implements testing routines to identify and resolve (de-bug) conflicts and potential operating malfunctions
• Analyzes database architecture and monitors disk-usage to maintain integrity of database (s) and/or servers, and reconfigures or relocates data for optimal performance.
• Design application programs to minimize run time and response times.
• Documents procedures and provides user information and training materials.
• Troubleshoots and resolves malfunctions with databases, servers, operating platform/database interfaces and networked systems.
• Estimates time and resources needed for projects, develops project schedules and may help end users prepare service request forms and other duties as needed or assigned.
• Supports the departmental operations with regular and timely attendance.
• Supports the relationship between the City of Odessa and the general public by demonstrating courteous and cooperative behavior when interacting with visitors and City staff; maintains confidentiality of work-related issues and City information; performs other duties as required or assigned.

 Minimum Qualifications:

 Education, Training and Experience Guidelines: High School Diploma or GED required. A.A. degree in Computer Science or MCSE: Data Management preferred. Comprehensive understanding of relational database theory and management systems. Extensive knowledge in SSRS reporting. Strong working knowledge of SQL Server Databases including SQL Server 2008 R2 and above.

    Skill in:

• Proficient knowledge of the various programming languages, applications, operating systems, hardware and networking.
• Ability to interact effectively with users and capable of working under stress to meet deadlines.
• Must have excellent customer service skills. Must be able to maintain strict confidentiality.
• Ability to read, write, understand and follow oral and written instructions.

 License and certification requirements: A Texas State Driver's License is required. Must have personal cell phone for communication with IT department 24x7. On-call.

 Physical demands and working environment: Work is performed in a standard office environment.

For more information, or to apply now, you must go to the website below. Please DO NOT email your resume to us as we only accept applications through our website.

https://www.applicantpro.com/j/1210882-111610