General:

Responsible for the physical design, definition, control, monitoring and performance of SQL Server databases. To provide technical services, consultancy guidance to support the goals and meet the requirements of contracted services.

Responsibilities:

• Establish and review complex processes and procedures for the effective use and exploitation of SQL Server database management systems.
• Provide consultancy, education and guidance in the use and exploitation of DBMS’s and database environments and infrastructure.
• Recommend technical solutions to clients.
• Assist in the logical design and implement the physical definition of databases in conjunction with application systems analysts.
• Enhance and maintain databases to accommodate new business functions and improve existing business functions.
• Assist application developers with problem analysis and resolution of development and production failures.
• Provide and maintain technically stable and performing production environments.
• Research and evaluates alternative solutions and recommends the most efficient and cost effective database solution for the application design.
• Monitors and analyzes ongoing database status, utilization and capacity.
• Implements and support database security regulations, policies, and guidelines.
• Work closely with technical and client management to plan and implement database tools in support of business applications development requirements and processes.
• Utilizes standard tools to record change and problem activities for tracking purposes.
• Support user and developer access, upgrade planning, implementation and resolution of database issues.

Competencies:

• Minimum of 3 years working experience as a SQL Server DBA, including and application development background.
• Sound working knowledge of SQL Server 2005 and SQL Server 2008
• Proficient with implementation and integration of SQL Technologies: Clustering, Logshipping, Mirroring, SSRS & SSIS
• Analytical and technically minded
• Organizational , interpersonal and verbal/written capabilities.
• Abilities to share knowledge effectively.

Outputs and deliverables:

• Utilization reports
• Capacity Plans
• Disaster recovery ( backup and restore ) Procedures and checks.
• Documented Database Architecture models and available.
• Documented and current Data dictionary and available.