– SQL Database Administrator

Title SQL Database Administrator

Description

The SQL Database Administrator’s role is to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities

Strategy & Planning

• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.

Acquisition & Deployment

• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Operational Management

• Manage and/or provide guidance to junior members of the team.
• Respond to and resolve database access and performance issues.
• Establish appropriate end-user database access control levels.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Install and configure relevant network components to ensure database access as well as database consistency and integrity.
• Create, or support creation of, required reports in response to business user needs.
• Monitor, optimize and allocate physical data storage for database systems.
• Create models for new database development and/or changes to existing ones.
• Develop routines for end users to facilitate best practices database use.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Perform database transaction and security audits.
• Plan and coordinate data migrations between systems.

Position Requirements

Formal Education & Certification

• Certifications in a SQL
• College diploma or university degree in the field of computer science and/or 5 years equivalent work experience.

Knowledge & Experience

• Hands-on database tuning and troubleshooting experience.
• Working technical experience with designing, building, installing, configuring and supporting database servers, including
• Experience with data processing flowcharting techniques.
• Strong understanding of database structures, theories, principles, and practices.
• Knowledge of applicable data privacy practices and laws.
• Project management experience.
• Good understanding of the organization’s goals and objectives.

Personal Attributes

• Good interpersonal skills.
• Good written and oral communication skills.
• Ability to conduct research into database issues, standards, and products as required.
• Strong customer service orientation.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Strong technical documentation skills.
• Proven analytical and problem-solving abilities.
• Keen attention to detail.
• Ability to present ideas in user-friendly language.
• Experience working in a team-oriented, collaborative environment.
• Highly self motivated and directed.

Work Conditions

• On-call availability for 1 days per month.
• Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and to handle other computer components.
• Lifting and transporting of moderately heavy objects, such as computers and peripherals.
• Sitting for extended periods of time.