AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF21739
profile image
Madini A AXF21739 Active
Database administrator in Bangalore
As a seasoned Microsoft SQL Server Database Administrator (DBA), I specialize in managing, maintaining, and optimizing SQL Server databases to ensure maximum performance, reliability, and security. With a strong background in database administration, I excel in tasks such as database design, installation, configuration, backup and recovery, performance tuning, and troubleshooting. My expertise extends to implementing high availability and disaster recovery solutions, such as clustering, mirroring, and AlwaysOn Availability Groups. I am adept at writing and optimizing T-SQL queries, stored procedures, and triggers to streamline database operations and enhance application performance. Additionally, I possess excellent communication and problem-solving skills, enabling me to collaborate effectively with cross-functional teams and resolve complex database issues efficiently. Passionate about staying updated with the latest trends and technologies in the database realm, I am committed to delivering exceptional database solutions that meet the evolving needs of businesses.
Industries : Capital Markets, media
Share
Hire Madini A
Download PDF
Availability
Full-time
Total experience
8 years
Technical skills
SQL Server
8 Years & 6 Months
sql dba
8 Years & 6 Months
SQL Server DBA
8 Years & 6 Months
MS SQL DBA
8 Years & 6 Months
MS SQL Server
8 Years & 6 Months
Azure
4 Years
Azure SQL DB
2 Years
MSSQL DBA
Projects
TMF in-house project
November-2018 to June-2024
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
Freedom Communications
September-2015 to November-2017
Description
Freedom Communications, Inc., was an American media conglomerate that operated daily and weekly newspapers, websites and mobile applications, as well as Coast Magazine and other specialty publications.
Roles and Responsibilities
Involved in Installation & Configuration of SQL Servers with Latest Service Packs & Cumulative Updates. Maintained database level and object level security best practice by creation of users. Configuring permissions and assigning different roles to Users. Recovering the databases in case of database suspect issues. Performing backups and restoring them whenever user is requested for. Experience in scheduling jobs and alerts and troubleshooting. Implementing and troubleshooting database maintenance plans. Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, handling blocking. Reviewing SQL Server and SQL Server Agent Error Logs. Monitoring SQL server performance with the help of views, profiler and performance monitor. Handling blockings, deadlocks and also resolving any data conflicts. Checking fragmentation and performing the Database maintenance. Executing the scripts in production environment. Updating Service packs and Security patches for the Servers. Running Database consistency checks using DBCC. Explore knowledge on AlwaysOn High Availability.
Technologies: SQL DBA
Industry: media
Work history
Database administrator • November-2018 to June-2024
Description: Database Administrator
Soft skills
Team player
quick learner
Communication
Time management
Problem-solving
Critical thinking
Education
Bachelors degree in In technology
JNTU, Kakinada
2010 to 2014
Language
English - Advanced