Database Administrator

The Database Administrator is responsible for providing database development and support of enterprise information systems. Helps ensure control, integrity and accessibility of data. Responsible for assisting in the establishment of database system flows, database design, and supporting enterprise database standards. Performs integration testing, schedules and upgrades to databases and monitors utilization for capacity planning. Establishes requirements, methods and procedures for database backup and recovery and builds scripts automating the daily operations of database management. Responsible for tracking and reporting database performance while performing database tuning activities that ensure optimization. Responsible for determining and recommending solutions and the procurement of equipment consistent with the system’s needs. Assists in project management as assigned, provide excellent service and support on technology needs to user base and management, and work closely with technology team and departments under the general supervision. This position may work after normal business hours including on-call.

• Service Level Agreements: Is aware of service level agreement levels. Takes steps to meet or exceed requirements.
• Database Availability: Provides high availability so that authorized users can access and change data as needed to support the business. Access is 24 x 7 or 7 days a week.
• Information Flows: Assists in the establishment of database system flows.
• Database Design: Analyzes, tests and implements physical database design for the storage aspects of the database objects (tables, views, procedures, etc.)
• Testing: Creates test files and performs system tests. Performs integration testing.
• Database Standards: Supports enterprise database standards such as file system layout and database installation and creation, etc. Also responsible for the support of database security standards.
• Metadata Models: Develops and maintains enterprise data documentation and metadata models. - Information Access: Provides, evaluates and develops data access tools and techniques to enable information access by business users.
• Upgrades: Schedules and performs upgrades of databases, adding new structures and elements.
• Capacity Planning: Monitors utilization for capacity planning. Forecasts utilization patterns and recommends modifications or upgrades.
• Security: Analyzes audit trails to detect systematic security violations.
• Backup and Disaster Recovery: Performs database backup and disaster recovery procedures and contingency plans. Establishes requirements, methods and procedures.
• Database Metrics: Develops, tracks and reports database performance metrics.
• Database Tuning: Monitors, analyzes database performance and calibrates DBMS parameters so that the database is tuned for optimal performance.
• Operating System: Implements batch shell scripts in a basic language. Facilitates the design of DB related Storage Area Networks (SANs) with Storage Administration.
• DBMS Software: Schedules and implements enterprise DBMS software installs. Assists in establishing the methods and procedures of database installations.
• Scripting Automation: Builds scripts automating the daily operations of database management.
• Software and Hardware Upgrades: Evaluates future technologies and makes recommendations for software and hardware upgrades.
• Performs related duties and fulfills responsibilities as required.

QUALIFICATION REQUIREMENTS: 

• Bachelor’s Degree in Computer Science or closely related field with

• Three (3) years of progressively responsible work experience in various database management systems in database design, testing, implementation, maintenance and administration.

• Associate’s Degree in computer science or related field plus 5 years of experience may be substituted for the required education and minimum experience.

• Obtain ITIL Foundation Certification within 1 year of employment. 

Able to pass FBI criminal background fingerprint check, and have the ability to comply with state and federal requirements for criminal justice information security standards. 

KNOWLEDGE, SKILLS, AND ABILITIES: 

• Ability to maintain a valid Texas Driver's License with safe driving record.
• Knowledge of multiple software applications and operating systems.
• Knowledge of business operations, systems requirements process, and analysis tools.
• Knowledge of internet and client/server architectures.
• Knowledge of database schema development.
• Knowledge of backup and recovery concepts.
• Knowledge of client-server application architecture.
• Knowledge of SAN-based storage.
• Skill in problem solving/troubleshooting.
• Ability to establish and maintain effective working relationships with County staff and the general public.
• Ability to communicate clearly and effectively.
• Ability to perform all the physical requirements of the position, with or without accommodations.

PHYSICAL AND ENVIRONMENTAL REQUIREMENTS: Work generally performed in a climate controlled building with minimal exposure to outdoor weather conditions. Work generally performed in a climate controlled building with minimal exposure to outdoor weather conditions. The physical requirements of the job include the ability to sit, talk, kneel, bend at both the waist and knee, reach with the arms over the head, and hear, both on the telephone and in person, using regular conversational tones; vision requires the ability to focus and read printouts, computer, screens, and other written material. Duties may require lifting up to 35 pounds and have the use of hands and fingers to perform essential functions of the job, i.e., typing, data entry, using the calculator, and operating other office equipment. Working conditions involve occasional exposure to variable and/or extreme weather conditions when responding to emergencies, working at heights, and working in confined spaces.

DISCLAIMER: The above description reflects the details considered necessary to describe the standard functions of this position and should not be constructed as a thorough description of all work requirements. The characteristics of the work environment described are representative of those that 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. 

Equal Employment and Affirmative Action Employer: Lubbock County will not discriminate in our employment practices based on an applicant’s race, ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, genetic information or status as a protected veteran.

Salary : $68,000 - $82,000