Browse Jobs
For Employers
Post JobLog inGet Started

Junior SQL Server DBA – Banha

Z2 Data
Banha, Qalubia
Posted 4 years ago
70Applicants for3 open positions
  • 41Viewed
  • 7In Consideration
  • 32Not Selected
Search other opportunities

Job Details

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

Skills And Tools:

Job Description

  • 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

  • Bachelor Degree: Computer Engineering or Computer Science or Equivalent
  • Proven experience as SQL server DBA from 1 to 3 years
  • 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
JobsInstallation/Maintenance/RepairJunior SQL Server DBA – Banha