Sr. SQL Server DBA

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 include 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.
• Build and maintain conceptual data model to identify key business entities and visualize their relationships.
• Perform reverse engineering of physical data models from disparate databases and SQL scripts.
• Provide support after hours through the on-call rotation and weekend support coverage.
• Perform scheduled maintenance and support release deployment activities after hours.

Basic Qualifications:

• 10 years of strong SQL Server Database administration experience preferably in the asset management Industry.
• 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.
• 3 years of experience in Azure SQL Server Managed Instances or Azure SQL Server. Hands-on experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance
• 2 years of experience working with Data modeling tools with ERWIN or similar tool

Preferred Qualifications:

• Microsoft Certified Database Administrator (MCDBA) or higher certificates on SQL Server.
• 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).
• Familiarity with database security protocols including encryption and data masking
• Proficiency 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.
• Understanding or experience supporting .NET applications connectivity to SQL Servers.
• Understanding of or experience with virtual environments.
• Great communication skills.