Browse Jobs
For Employers
Post JobLog inGet Started

Senior SQL Server DBA

Z2 Data
Nasr City, Cairo
Posted 4 years ago
38Applicants for1 open position
  • 23Viewed
  • 0In Consideration
  • 0Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

Job brief:

  • We’re looking for a Senior SQL server DBA who is able to provide physical database support for large scale SQL Server databases and multiple Database servers ensuring database integrity and availability.

Main Job Tasks and Responsibilities

  • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
  • Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
  • Configure SQL Server monitoring utilities to minimize false alarms
  • As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
  • Install and configure new SQL Servers
  • Deploy database change scripts provided by third party vendors
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Document the company’s database environment
  • Ensure that new database code meets company standards for readability, reliability, and performance
  • Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
  • Design indexes for existing applications, choosing when to add or remove indexes
  • When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
  • Conduct SQL Server lunch-and-learn sessions for application developers
  • Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)
  • Database migration over multi servers.
  • Database Replications
  • Database Clustering and High Availability solution
  • Database reporting services
  • Dealing with large scale DB’s and many DB servers

Job Requirements

Education and Experience

  • Bachelor Degree: Computer Engineering or Computer Science or Equivalent
  • Proven experience as SQL server DBA with 4+ years
  • No SQL DB experience is a plus
  • Excellent understanding of data administration and management functions
  • Familiarity with modern database and information system technologies
  • Good in MS Office (Excel, Access, Word, PowerPoint etc.)

Key Competencies

  • Communication skills
  • Customer service focus
  • Supervisory skills
  • Problem analysis and problem-solving
  • Decision-making
  • Planning and organizing
  • Initiative
  • Flexibility
  • Presentation skills
  • Stress tolerance

Featured Jobs

Similar Jobs

Search other opportunities
JobsIT/Software DevelopmentSenior SQL Server DBA