Satish G

Client: Redington (July 2024 – June 2025)

Role: Database Administrator

• Developed and maintained SSIS packages to automate ETL processes and data transformations.
• Designed and tuned complex stored procedures, functions, and SQL scripts for large-volume datasets.
• Analyzed slow-performing queries and optimized execution plans, indexes, and query structure.
• Conducted root cause analysis of performance bottlenecks and provided long-term fixes.
• Collaborated with developers, DBAs, and application teams for SQL performance improvement.
• Monitored SQL Server Agent Jobs, backups, disk space, and integrity using custom dashboards and reports.
• Created and managed Azure SQL Databases, firewall rules, and automated backups.
• Configured Always On Availability Groups, Log Shipping, and Database Mirroring for HA/DR.
• Participated in regular database refreshes from production to test environments.

Client: O9 Solutions (Jan 2023 – Feb 2024)

Role: SQL DBA and SSIS Ops

• Developed and maintained SSIS packages to automate ETL processes and data transformations.
• Designed and tuned complex stored procedures, functions, and SQL scripts for large-volume datasets.
• Analyzed slow-performing queries and optimized execution plans, indexes, and query structure.
• Conducted root cause analysis of performance bottlenecks and provided long-term fixes.
• Collaborated with developers, DBAs, and application teams for SQL performance improvement.
• Monitored SQL Server Agent Jobs, backups, disk space, and integrity using custom dashboards and reports.
• Created and managed Azure SQL Databases, firewall rules, and automated backups.
• Configured Always On Availability Groups, Log Shipping, and Database Mirroring for HA/DR.
• Participated in regular database refreshes from production to test environments.

• Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions.

• Involved in Installing SQL Server and its service packs, and also client installations as required.

• Monitoring free space of database and server free space.

• Checking the status of backup, troubleshooting the failed backups and restoration of databases.

• Implementation of SQL Logins, Roles and Authentication modes as a part of Security Policies for various categories of User Support

• Fixing orphaned users through stored procedures.

• On-Call responsibilities for Production database systems.

• Verifying all instances are up and running as per the checklist.

• Creating Indexes to improve the performance as per Dev/App team request.

• Reorganizing or rebuilding the indexes based on Fragmentation percentages.

• Recovering and Restoring databases from backup in disaster situations.

• Performing SQL server daily health check and preparing a report based on it.

• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

• Involved and completed multiple DR tests including third party DR test and native DR technologies like Always ON, Log shipping and mirroring.

• Have good knowledge and experience in Replication.

• Volunteered team many times in high impact changes for additional support.

Client: Baker Hughes (Jan 2022 – Dec 2022)

Role: SQL Developer and DBA

• Developed custom reports and complex queries using T-SQL.
• Managed database migrations, backups/restores, and index maintenance.
• Implemented high availability using Log Shipping, Replication, and Mirroring.
• Performed daily database health checks, monitored locks, waits, and top-consuming queries.
• Implemented security measures, login management, and access auditing.
• Designed performance monitoring tools and assisted in long-term capacity planning.

• Installation and configuration of MS SQL Server 2005 and 2008R2 and 2012.Involved in Installing SQL Server and its service packs, and also client installations as required.

• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking

• Implementation of SQL Logins, Roles and Authentication modes as a part of Security Policies for various categories of User Support

• Standardize SQL Server environment by designing guidelines for SQL Server installation, configuration, storage specifications, CPU, Memory, account and security to follow best practices and standards

• Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

• Fixing orphaned users through stored procedures.

• On-Call responsibilities for Production database systems.

• Verifying all instances are up and running as per the checklist.

• Creating Indexes to improve the performance as per Dev/App team request.

• Reorganizing or rebuilding the indexes based on Fragmentation percentages.

• Recovering and Restoring databases from backup in disaster situations.

• Performing SQL server daily health check and preparing a report based on it.

• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

• Involved and completed multiple DR tests including third party DR test and native DR technologies like Always ON, Log shipping and mirroring.

• Have good knowledge and experience in Replication.

• Volunteered team many times in high impact changes for additional support.

• Good experience on migration and up gradation of databases.