تخطي إلى المحتوى الرئيسي

Senior MS-SQL Admin

Technology
Mobily Infotech
القاهرة القاهرة الجديدة مصر, مصرمنذ أسبوع
دوام كامل

وصف الوظيفة

Must-Have

  • 5-7 years of experience
  • Responsible for Administration and Configuring of database.
  • Responsible for Maintaining and Monitoring of 24*7 Production and Non prod Database.
  • Enrolling Users and Maintaining System Security.
  • Monitoring and troubleshooting SQL server's issues using system monitor, SQL log, Event viewer & Log shipping.
  • Creating and sizing database storage structures and database objects
  • Restoration of database and troubleshooting.
  • Knowledge on Always-On Availability Groups (AAG) and HA/DR Setup and Configuration.
  • Build indexes at regular intervals for better performance.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • SQL Patching and service packs updates, client installations etc..
  • Manage backups and troubleshoot failed backups.
  • Create and managing Users, Roles and Groups and handling database security policies
  • Monitoring/Maintaining HA Log Shipping, Clustering and Mirroring.
  • Disk Space of servers & maintenance.
  • Scheduled and maintain routine Jobs, Alerts and Maintenance Plans
  • Knowledge on SQL Server Performance management
  • Managing security standards and MBSS – vendor recommendation.
  • replications between production, Snapshot and Transactional.
  • Upgrade of SQL db to optimize environment.
  • Should bring in expertise to automate and optimize the environment.

Good-to-Have

  • Project management skills.
  • Powershell/ Scripting
  • Reporting & presentation

Reporting To Which Role

Manager Infrastructure Operations

Keywords
ViEWERMicrosoft SQL ServerMysqlPowershellSqlEvent ViewerSystem monitor

هل أنت مهتم بهذه الوظيفة؟