Description

Detailed JD:


 

Roles and Responsibilities

  • Expert in SQL Server Database Administration, including SQL Server on VMWare (on premise), Azure SQL Database and Azure SQL Managed Instance, SQL Server Reporting Server (SSRS).
  • Install, configure, and maintain MSSQL databases on production, development, and UAT environments.
  • Monitor database performance to ensure high levels of performance, availability, and security.
  • Optimize and fine-tune databases for better query performance and scalability.
  • Implement and manage backup and recovery procedures, ensuring that databases are protected against data loss and can be quickly restored.
  • Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
  • Database and T-SQL optimization including performance tuning, query optimization, and supportability.
  • DevOps - be able to set up and integrate related DevOps process, managing CI/CD pipelines for Azure devops or Flyway tools.
  • Change management including maintenance of multiple development, UAT, and production environments. Responsible for deploying approved changes to production.
  • Create and maintain appropriate documentation about the database.
  • Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
  • Manage SQL server and Windows security audits and take corrective action to stay compliant.
  • Provide support after hours through the on-call rotation and weekend support coverage.
  • Perform scheduled maintenance and support release deployment activities after hours.

Experience and Qualifications

  • 10+ years of strong SQL Server Database administration experience preferably in the asset management Industry.
  • Knowledge of Azure cloud and 3+ years of experience in Azure SQL Server Managed Instances or Azure SQL Server.
  • 5+ years of experience with backups, restores and recovery models.
  • 5+ years of experience of High Availability (HA), Availability Groups (AG) and Disaster Recovery (DR) options for SQL Server.
  • Hands-on experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance.
  • Proficiency with T-SQL for querying, performance tuning, and troubleshooting.
  • Strong knowledge of backup, restore, and recovery models (SQL Server Native Backup or third-party tools such as Avamar or Commvault).
  • Experience with high-availability solutions (Always On Availability Groups, SQL Clustering, Replication, or Log Shipping).
  • Familiarity with database security protocols including encryption and data masking
  • Proficient in database monitoring tools (Foglight, or SQL Server Profiler).
  • Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSRS, and MS SharePoint.
  • Experience with SQL Server database replication and external replication platforms
  • Must be capable of working independently and collaboratively.
  • Great communication skills

Key Skills
Education

Any Graduate

Back To Jobs