Description
TMF group Staffing : TMF Group is a leading service provider for Corporate Secretarial and Payroll services across 180 countries. As part of DBA team, my team is responsible for taking care of SQL server environment (having 500+ database servers) across TMF group, supporting more than 50 applications, used by business users.
Roles and Responsibilities
Installation and configuration of MS SQL Server Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions. Dealt with the space issues such as Log file full, Data file full, TempDB full. Analyze reports for long running queries, locks, deadlocks, backup history check and retention. Handling blockings, deadlocks and also resolving any data conflicts. Involved in database Backups, Restore and scheduling them accordingly and troubleshooting the failed backups. Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking. Running database refresh jobs from production to development environments. Expertise implementing high availability with Always on Availability Groups and failover clustering. Mentoring new recruits in the Project on Virtualization and Server Administration, Documenting Processes, Tips for Trouble shooting issues. Handling issues with Databases out of sync in Availability Groups. Troubleshoot issues with Availability Groups,Replicas,Databases,Listener. Managing added responsibility of Shift Lead as per project scope. Installing SQL server on Azure Environment. Maintaining SQL Server in Azure Environment. Work closely with Change management team and application teams to make sure proper ITIL process is followed. Outlining process for security hardening and process for granting access privileges to database server.
Technologies: MSSQL DBA, Azure SQL DB, Azure
Industry: Capital Markets