Database Administrator-Advanced - 02062024-54625

Job Information

LOCATION OF (1) POSITION TO BE FILLED: DEPARTMENT OF FINANCE & ADMINISTRATION, BUSINESS SOLUTIONS DELIVERY DIVISION, DAVIDSON COUNTY
This position requires CJIS & FTI fingerprints. This position requires a criminal background check. Therefore, you may be required to provide information about your criminal history in order to be considered for this position.
This position is designed as hybrid.

Qualifications

Education and Experience: Graduation from an accredited college or university with a bachelor's degree and two years of professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., IMS/DB, SQL Server, DB2, Oracle).
Substitution of Graduate Coursework for the Required Experience: Any additional graduate coursework in data modeling, database design, or performance monitoring and tuning of database management systems may substitute for the required experience on a year for year basis to a maximum substitution of two years.
Substitution of Experience for Education: Professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., IMS/DB, SQL Server, DB2, Oracle) may be substituted for the required bachelor's degree on a year-for-year basis to a maximum of four years.
OR

Education and Experience: Graduation from an accredited college or university with an associate's degree in business data processing, management information systems, computer and information systems, computer science, or other directly related field and two years of professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (i.e., IMS/DB, SQL Server, DB2, Oracle).
Substitution of Experience for the Specialized Associate's Degree: Experience in data modeling, database design, or performance monitoring and tuning of database management systems may substitute for the specialized associate's degree on a year-for-year basis to a maximum of two years.
Necessary Special Qualifications: None.

Examination Method: Education and Experience,100%, for Preferred Service positions.

Summary

Summary: Under general supervision, is responsible for implementing and revising database structures of considerable difficulty and is responsible for ensuring accuracy of data and that processes are followed.
Distinguishing Features: An employee in this class designs, implements or revises data structures and database systems following defined standards and procedures. This class differs from Database Administrator-Intermediate in that an incumbent of the latter learns to implement or revise databases. This class differs from Database Administrator-Lead in that an incumbent of the latter is responsible for leading or supervising other database administrators in implementing methods, techniques, and standards for data, and performs complex database management work.

Responsibilities

Provide Consultation and Advice to Others:

• Provide technical assistance to database consumers, development and support teams including troubleshooting and diagnostics.
• Assist other database administrators in development and enforcement of standards, procedures and guidelines.

Interacting With Computers:

• Execute Disaster Recovery (DR) solutions including testing established/developed disaster recovery procedures, documenting DR tests and cataloging results.
• Executes database migrations, upgrades or conversions including installations and patching.
• Uses database documentation and knowledge of the system to assist in the recovery from problems or failures.
• Create, schedules and tests database specific jobs and backup/recovery jobs and designed strategies.
• Perform daily maintenance processes and procedures.
• Provide administration of database to ensure stated uptime goals as provided by management.
• Monitors and administers RDBMS security, i.e. adding and removing users, changing passwords, administering quotas, auditing, and checking for security problems.

Monitoring and Controlling Resources:

• Monitors database system for availability, track and report database performance and usage metrics and confirm all databases are operational.
• Implements database monitoring solutions and assist senior DBA in design of monitoring solutions.

Analyzing Data or Information:

• Preforms database tuning including infrastructure and SQL tuning.
• Assist other database administrators in monitoring database system performance.
• Reviews, requests and provides reports for capacity planning which includes database hardware and associated storage.
• Assist in troubleshooting database issues by using all available resources.
• Evaluates database software to enhance database system usage, facilitate problem resolution, and maximize customer service.

Processing Information:

• Develops and creates SQL, PL/SQL, TSQL, or equivalent advanced SQL Packages/languages.
• Creates change scripts, backout procedures for DML, DDL and other RDBMS changes and analysis of change.
• Implements physical database changes on appropriate system platforms.
• Creates and implements designs and revises data structure under supervision.

Communicating with Supervisors, Peers, or Subordinates:

• Reviews logs for RDBMS systems and report all system issues to supervisor.
• Assist other database administrators in implementing and reviewing database systems to ensure accuracy and efficiency.

Evaluating Information to Determine Compliance with Standards:

• Evaluates information gathered from users, other staff and historical data to ensure optimal performance and productivity of database systems.
• Assist other database administrators in identification, selection and use of database software.

Documenting/Recording Information:

• Reviews and ensures complete and appropriate handover of documentation prior to operational acceptance of new or changed applications.
• Provide support/assistance to development/application teams to ensure that applications and related services are documented and kept current.
• Documents anomalies from daily maintenance procedures.
• Documents processes and procedures for database operations and maintenance.
• Documents area of poor response and turnaround times by reviewing historical data and information from users.

Competencies

Competencies:

• Dealing with Ambiguity
• Functional/Technical Competency
• Problem Solving
• Technical Learning
• Time Management
• Perseverance
• Presentation Skills
• Written Communications
• Customer Focus
• Approachability
• Listening
• Composure

Knowledge:

• Knowledge of advanced backup/recovery methodology including Hot backups, transition logs, archive logs, point-in-time recovery, advanced import/export routines
• Knowledge of RDBMS administration such as developing security roles and groups, memory optimizations (pinning SQL to memory), space management, Data Dictionary Views, task and job automation, upgrades, patches, migrations, installations, etc.
• Knowledge of hardware and infrastructure tuning such as disk I/O, CPU memory, kernel or O/S parameters, Data Dictionary Views
• Knowledge of basic Disaster Recovery concepts
• Computers and Electronics
• Knowledge of Database Architecture - database design and logical data models for OLTP
• Knowledge of Database Architecture memory optimization
• Knowledge of basic firewalls, network routing, load balancers, etc.
• Knowledge of SQL such as multiple joins PL/SQL, TSQL, or equivalent packages, etc.
• Knowledge of RDBMS database systems such as data modifications and normalization, transformations into ERD, Data Dictionary Views, and relation tables
• Knowledge of OS architecture, interoperability between groups, users and security, Kernel parameters, disk management, etc.
• Knowledge of monitoring software including ability to script out monitoring alerts, thresholds and notifications. May include 3rd party utilities such as SNMP traps
• Customer and Personal Service
• Knowledge of Basic Mathematics
• Knowledge O/S scripting such as korn shell, bash shell, windows, etc. including variables, strings, and automation
• Knowledge of Database Development Lifecycle
• Knowledge in documentation or technical writing using word processing and diagraming tools

Skills:

• Stress Tolerance
• Persistence
• Active Learning
• Active Listening
• Skills in database design, including physical and logical data models for OLTP
• Skills in advanced database backup and recovery and deployment including Cold Backups, Hot backups, and database dumps, clones, refreshes, compression, scripting, implementing, and scheduling and troubleshooting
• Skills in storage and capacity planning including RDBMS hardware
• Skills in basic high availability database implementations, setup, configuration and deployments
• Skill in executing advanced Disaster Recovery (DR) solutions including testing established/developed disaster recovery procedures, documenting DR tests and cataloging results
• Skills in database migrations/upgrades or conversions from O/S platforms, versions, servers, storage, installations and patching
• Attention to Detail
• Dependability
• Adaptability/Flexibility
• Initiative
• Achievement/Effort
• Judgment and Decision Making
• Operations Analysis
• Systems Analysis
• Skills in understanding/reading SQL, PL/SQL, TSQL, or equivalent advanced SQL Packages/languages
• Skills in database architecture including memory optimization, and database parameters, etc.
• Skills in database security including auditing and database firewalls
• Skills in database tuning including database infrastructure tuning, hardware infrastructure tuning
• Skills in implementing and ensuring compliance with defined database standards
• Skills in deploying or writing monitoring scripts or monitoring software, establishing alerts, notifications and escalations
• Skills in implementing business resumption strategies
• Skills in documentation or technical writing
• Integrity
• Analytical Thinking
• Speaking
• Skills and exposure to multiple operating systems, networking and storage
• Skill in O/S Scripting

Abilities:

• Ability to work under direct supervision
• Ability to read and understand ideas and information presented in writing
• Attention to Detail
• Integrity

Tools & Equipment

• Computer
• Telephone
• Fax Machine
• Printer