Junior SQL Server DBA – Banha
Z2 Data -
Banha, QalubiaPosted 3 years ago57Applicants for1 open position
- 46Viewed
- 22In Consideration
- 24Not Selected
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
- Microsoft SQL Server Database ...The Micro, Small & Medium Enterprise Development Agency - Dokki, Giza2 days ago