SQL Dba

PCV Career•Pomona, CA

22h

About The Position

The SQL DBA is responsible for the implementation, configuration, migration, maintenance, security and performance of the SQL Server RDBMS systems and is involved in the planning and development of the database; as well as in troubleshooting any database issues, along with managing the SQL server to successfully store, organize, and access data. The SQL DBA is a backup for the DBA/Reporting Analyst to create and modify reports when the DBA/Reporting Analyst is not available.

Requirements

3-5 years related work experience
Experience in fast paced environment
Prior Knowledge IT Protocol, Reporting Software
Detailed oriented with excellent analytical skills
Excellent verbal and written communication skills
Ability to resolve problems and remove barriers to problem resolution
Ability to work independently with little supervision
Proven ability to work in a complex, dynamic and ambiguous environment

Nice To Haves

Bachelor’s Degree in Computer Science, Information Systems, or other related field

Responsibilities

Designs logical and physical databases and coordinates database development as part of project team.
Reviews project request describing database user needs.
Estimates time and cost required to accomplish project.
Determines if project requires creating series of new programs or modifying existing programs that access data stored in databases.
Attends specification meeting with project team workers to determine scope and limitations.
Reviews workflow chart developed by Programmer Analyst to understand tasks computer will perform, such as updating records.
Reviews procedures in database management system manuals for making changes to database such as defining, creating, revising, and controlling database.
Revises company definition of data as defined in data dictionary (information about data, including name, description, source of data item, and key words for categorizing and searching for data item descriptions).
Determines and enters changes to data dictionary descriptions, including type, structure, and intended use of data within system.
Develops data model describing data elements and how they are used.
Creates description to enable Programmer Analyst to understand how programs should access data.
Writes description of how user accesses data, referred to as logical database.
Writes physical database description such as location, space requirements, and access method, to protect company data resources against unauthorized access and accidental destruction.