Browse Jobs
For Employers
Post JobLog inGet Started

SQL Server Administrator

Union Coop
Dokki, Giza
Posted 2 years ago
27Applicants for1 open position
  • 26Viewed
  • 12In Consideration
  • 8Not Selected
Search other opportunities

Job Details

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

Skills And Tools:

Job Description

  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
  • Manage ETL and reporting environment on SQL server and will develop ETL and reports.
  • Refine and automate regular processes, track issues, and document changes.
  • Assist developers with complex query tuning and schema refinement.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Monitor capacity to prevent unplanned outages grants permission to servers and databases in conjunction with standards as per the security team.
  • Research, assess, and implement new features in SQL SERVER where appropriate and beneficial to the solution.
  • Work with the Security team to manage access and compliance regularly review database and SQL instance permissions to make sure appropriate access is in place.
  • Implement encryption and data masking options where required.
  • Grant permission to servers and databases in conjunction with standards as per the Security team.
  • Review SQL SERVER licenses for compliance as well opportunities to reduce costs.
  • Cloud experience helpful.
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
  • Apply service packs/ DB Archive/ Capacity planning.
  • Perform scheduled maintenance and support release deployment activities after working hours.
  • Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention, and resolve them.
  • Support software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures.
  • Learn relevant business processes and understand the data flow, criticality, and dependencies.

Job Requirements

Education

  • Bachelor's Degree in Computer Sciences / Information Technology or equivalent.
  • Microsoft SQL Server Certification.
  • MCTS, MCITP, and/or MVP certifications preferred.

Skills:

  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
  • Technical documentation skills.
  • Ability to conduct research into database issues, standards, and products as required.
  • Skilled in working with large volumes of data and loading data from multiple sources.
  • Knowledge of reporting and query tools and practices.
  • Knowledge of indexes, index management, and statistics.
  • Skilled in deploying database change scripts.
  • Skilled in performance optimization.
  • Proven experiences with large data sets.
  • Experience in BIG Data environments and Big Data tools advantageous.
  • Strong understanding of SQL database structures, principles, and practices.
  • Working technical experience with designing, building, installing, configuring, and supporting database servers, including Microsoft Clustered SQL Servers.
  • Experience with replication (transactional or log shipping) required.
  • On-call troubleshooting for SQL Server service outages.
  • In-depth SQL Server Database Administration experience.
  • Strong self-sufficiency and initiative working on Database projects.
  • Experience Practical experience in monitoring and tuning a database to provide a high availability service.
  • Experience in Transactional SQL, and DTS stored procedures.
  • Practical experience in managing the internal and external MS SQL database security.
  • 5 years of experience as a SQL Server DBA or similar role.
  • 5 years of experience with MY SQL Server Administration experience are required.
  • 5 years of experience with Performance Tuning and Optimization (PTO).
  • 5 years of experience with backups, restores, and recovery models.
  • 5 years of experience with Windows servers, including Active Directory
  • Continuous improvement of processes and practices, automating processes where possible.
  • Sense of ownership and pride in your performance and its impact on the company’s success.
  • Critical thinker and problem-solving skills.
  • Great interpersonal and communication skills.
  • Prefer a candidate for Retail Experience.

Featured Jobs

Similar Jobs

Search other opportunities
JobsIT/Software DevelopmentSQL Server Administrator