IT Database Administrator Sr

About This Position

Job Description:

IT Database Administrator Senior

Purpose:

This position designs, administers, maintains, secures, and improves performance of complex databases.

Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.

Designs, analyzes, troubleshoots, and resolves advanced operational and performance-related database issues; coordinates changes; maintains database structures; and assists in developing policies and procedures designed to ensure the integrity of the database environment.

Designs, coordinates, implements, and determines procedures necessary to save and recover production databases and databases from hardware and software failure.

Performs database performance monitoring and auditing, implements efficiency improvements, and modifies existing databases and database management systems.

Designs, configures, and implements database network connectivity working with required technical teams.

Monitors capacity versus utilization and recommends appropriate action on a timely basis to avoid performance degradation.

Creates databases and database objects, such as tables, indexes, views, triggers, and stored procedures.

Tracks database assets and critical information about those assets.

Assists in development of data security standards to ensure data integrity data security.

Maintains data standards and prepares and develops database documentation, procedures, and definitions for data dictionaries.

Creates test database environment for applications section, including the creation of necessary libraries and procedures.

Installs new software releases and/or upgrades including researching, testing, and implementing new technology.

May provide leadership, work assignments, evaluation, training, and guidance to others.

Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

Knowledge of industry and department best practices, requirements and policies and procedures.

Knowledge of the advanced principles, practices and techniques of secure computer programming, system design, computer operations, systems and procedures.

Knowledge of advanced database structures and theories.

Knowledge of current database technologies.

Knowledge of Oracle and SQL Server database tools, environments and query languages (SQL, TSQL).

Knowledge of statistical analysis processes.

Skill in developing reports and cross references from the data dictionary.

Skill in performing data modeling and prototyping to implement efficiency improvements.

Skill database debugging, testing and troubleshooting techniques.

Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts

Ability to write Extraction, Transform and Load (ETL) or SSIS tasks for the Extraction, Transformation or Loading (ETL) process.

Ability to gather, assemble, correlate, and analyze facts.

Ability to perform a root cause analysis.

Ability to assess future information needs so that the databases can evolve in an appropriate manner.

Ability to accurately identify/determine customer needs and take appropriate actions and/or steps to address identified needs.

Ability to recognize, value, and include different perspectives, experiences, approaches, and cultures in achieving organizational goals.

Ability to gain and maintain the trust and confidence of others and the organization through consistency and reliability.

Ability to give, receive, or share thoughts, ideas, perspective, and data to create shared understanding.

Ability to define, analyze, and find solutions for difficult or complex problems.

Ability to view the big picture.

Ability to quickly become familiar with emerging technologies.

Ability to identify trends as well as isolated events.

Graduation with a Bachelor's degree from an accredited college or…