Description

  • Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
  • Databases shrink operations, DBCC commands
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues
  • Implementation of Query store, table partitioning, always encryption
  • Performance tuning and optimization
  • Resolving SQL server Performance bottle necks (100% CPU, Memory, Disk I/O)
  • SQL Server Installation, Upgrades, Migrations and Configuration
  • Install database software service packs and cumulative updates as necessary
  • Maintain database documentation as required
  • Maintain and administer database security access
  • High Availability strategies for MS SQL environments (always on, clustering, log shipping, mirroring, replication)
  • Perform database Ad-hoc backups and restores
  • Troubleshoot and resolve database connectivity issues
  • Follow Change Management processes to implement database configuration changes
  • Follow Problem Management processes to troubleshoot and resolve recurring issues
  • Proactively monitor and respond to MSSQL database Alerts.
  • On-call requirements to ensure 24 x 7 support of database operations

What you’ll bring:

  • 6 years of experience as a database administrator in SQL Server environment
  • 6 years experience in Transact SQL, SSRS SSIS package development
  • 4 years of SQL Server database development / programming
  • Experience of administering SQL Server 2008, 2008R2,2012,2014,2016,2017 and 2019 databases
  • Experience with Monitoring & Diagnostic tools
  • Experience working with Windows server, including Active Directory and disk configurations
  • Bachelor's\Master’s Degree or equivalent combination of education and experience

Key Skills
Education

Bachelor's or Master's degrees

Back To Jobs