SQL DBAPosition OverviewThe 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.
Essential Job Duties and Responsibilities- Designs logical and physical databases and coordinates database development as part of project team by performing the following duties.
- 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.
Qualifications and SkillsRequiredPreferredQualificationBachelor's Degree in Computer Science, Information Systems, or other related field
Experience3-5 years related work experience
Experience in fast paced environment
Prior KnowledgeIT 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
