Database Administrator

About the position

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.

Responsibilities

• Is aware of service level agreement levels. Takes steps to meet or exceed requirements.
• 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.
• Assists in the establishment of database system flows.
• Analyzes, tests and implements physical database design for the storage aspects of the database objects (tables, views, procedures, etc.)
• Creates test files and performs system tests. Performs integration testing.
• Supports enterprise database standards such as file system layout and database installation and creation, etc. Also responsible for the support of database security standards.
• Develops and maintains enterprise data documentation and metadata models.
• Provides, evaluates and develops data access tools and techniques to enable information access by business users.
• Schedules and performs upgrades of databases, adding new structures and elements.
• Monitors utilization for capacity planning. Forecasts utilization patterns and recommends modifications or upgrades.
• Analyzes audit trails to detect systematic security violations.
• Performs database backup and disaster recovery procedures and contingency plans. Establishes requirements, methods and procedures.
• Develops, tracks and reports database performance metrics.
• Monitors, analyzes database performance and calibrates DBMS parameters so that the database is tuned for optimal performance.
• Implements batch shell scripts in a basic language. Facilitates the design of DB related Storage Area Networks (SANs) with Storage Administration.
• Schedules and implements enterprise DBMS software installs. Assists in establishing the methods and procedures of database installations.
• Builds scripts automating the daily operations of database management.
• Evaluates future technologies and makes recommendations for software and hardware upgrades.
• Performs related duties and fulfills responsibilities as required.

Requirements

• Bachelor's Degree in Computer Science or closely related field.
• 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.

Nice-to-haves

• 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.