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 / AXF13711
profile image
Soodappan S AXF13711 Active
SQL Server DBA in Bangalore
I have 10 years of experience in SQL server DBA end to end support, where I have worked with MNCs like Cognizant, IBM, LTIMindtree, etc. Completed my Masters in Computer Applications in 2013.
Industries : Information Technology
Share
Hire Soodappan S
Download PDF
Availability
Full-time
Total experience
10 years
Technical skills
SQL Server
10 Years & 5 Months
Windows
8 Years
SSIS
5 Years
SSAS
5 Years
SSRS
5 Years
Azure SQL
Projects
Air cargo
November-2022 to December-2023
Description
Velocity is an advanced comprehensive forecasting, revenue management, planning and business intelligence solution that enables airlines to maximize their profitability by significantly increasing incremental revenue.In addition to a financial benefit, airlines typically realize productivity benefits, improved response times and better decision making.
Roles and Responsibilities
Providing 24/7 SQL Server DBA production support with On-call support. • Installing, configuring & monitoring SQL 2005, 2008R2, 2012, 2014, 2016, 2017 & 2019. • Involved installing service pack, cumulative updates and hot fixes. • Experience on Installing SQL Server using unattended and slipstream method. • Experience in upgrading SQL Server 2005-2008/R2 and 2008R2-2012. 2012-2017. • Migrate logins through sp_help_rev_login stored procedure and fixing orphan users. • Instance & DB security, creating logins-users and granting permissions to logins/users • Checking the status of backups and troubleshooting the failed backups. • Checking the backup reports and ensuring that all the backups are proper. • Schedule and maintain routine jobs, alerts and maintenance plans. • Restoring the backups (users and system DB’s) as needed. • Technical troubleshooting gives consultation to development teams. • Tracking the locking issues, including deadlocks, blocking and lock timeouts. • Monitoring disk space of all the servers and freeing up the space as per the requirement. • Experience on monitoring SQL Server Performance using Perfmon and Profiler Tools. • Reviewing SQL Server Error log and Event viewer • Performing disaster recovery (DR) test on a Quarterly basis. • Ensuring process documentation is updated on regular basis. • Experienced on piecemeal restore and restorations to STOP AT MARK. • Experience on configuring database mail, jobs, maintenance plans and alerts. • Implementing and troubleshooting log shipping, DB mirroring and clustering. • Experience on configuring and troubleshooting Always On AG in SQL Server. • Configuring and troubleshooting snapshot, transactional, merge & peer-to-peer. • Creating, rebuilding and reorganizing different types of indexes. • Using stored procedures, views, functions, T-SQL codes, queries, DMV’s and DBCC. • Follow SLAs & ITIL process for changes and all tickets, Service Requests from clients. • Experience on Installing and configuring SSAS, SSIS and SSRS, • Experience on collection data using PSSDIAG tool. • Experience on automation using PowerShell. • Experience on taking backup and restore using Litespeed and Commvault tool. • Experience on monitoring SQL performance using SQLDM.
Technologies: SQL Server
Industry: Information Technology
Paramount
June-2022 to November-2022
Description
Paramount delivers premium content to audiences across platforms worldwide. We connect with billions of people—through our studios, networks, streaming services, live events, merchandise, and more. Our studios create content for all audiences, across every genre and format, while our networks and brands forge deep connections with the world’s most diverse audiences. In streaming, our differentiated strategy is scaling rapidly across free, broad pay, and premium.
Roles and Responsibilities
Installation and configuration of SQL Server 2019. • Configured Publisher, Distributor, Subscriber in AlwaysOn Availability Groups. • Upgraded the SQL server 2019 developer to enterprise edition. • Worked on Implementation and troubleshooting log shipping and DB mirroring. • Worked on configuring and troubleshooting AlwaysOn AG in SQL Server. • Migrated older version of SQL Server to latest version. • Technical troubleshooting gives consultation to development teams. • Migrated On-prem SQL Server to Azure cloud VM, SQL databases and SQL MI. • Effectively managed and reduced cost by effectively monitoring databases elastic pool. • Configured Azure site recovery for DR and Azure backup on-premises/Azure Environment. • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed Instances, Configured High Availability Solutions; AlwaysOn, Log Shipping, patching, troubleshooting, optimization, maintenance. • Configured Transparent Data Encryption (TDE) using AE256 Algorithm to make sure that all databases are fully encrypted. • Configured Geo replication with availability group in Azure SQL DB • Involved on Installing and configuring SSAS, SSIS and SSRS.
Technologies: SQL Server, Azure SQL
Industry: Information Technology
Hertz
October-2016 to June-2022
Description
Hertz, is an American car rental company based in Estero, Florida. The company operates its namesake Hertz brand, along with the brands Dollar Rent A Car, Firefly Car Rental and Thrifty Car Rental.
Roles and Responsibilities
Installation and configuration of SQL Server 2019. • Configured Publisher, Distributor, Subscriber in AlwaysOn Availability Groups. • Upgraded the SQL server 2019 developer to enterprise edition. • Worked on Implementation and troubleshooting log shipping and DB mirroring. • Worked on configuring and troubleshooting AlwaysOn AG in SQL Server. • Migrated older version of SQL Server to latest version. • Technical troubleshooting gives consultation to development teams. • Migrated On-prem SQL Server to Azure cloud VM, SQL databases and SQL MI. • Effectively managed and reduced cost by effectively monitoring databases elastic pool. • Configured Azure site recovery for DR and Azure backup on-premises/Azure Environment. • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed Instances, Configured High Availability Solutions; AlwaysOn, Log Shipping, patching, troubleshooting, optimization, maintenance. • Configured Transparent Data Encryption (TDE) using AE256 Algorithm to make sure that all databases are fully encrypted. • Configured Geo replication with availability group in Azure SQL DB • Involved on Installing and configuring SSAS, SSIS and SSRS.
Technologies: SQL Server
Industry: Information Technology
Evicore
May-2015 to September-2016
Description
viCore by Evernorth leverages our clinical expertise, evidence-based guidelines, and innovative technologies to deliver best-in-class medical benefit management solutions that inform more effective, affordable treatment and site of care decisions for each patient’s needs. The result: Better outcomes and lower costs for patients, providers, and plans.
Roles and Responsibilities
Involved in installing SQL Server 2008, 2008R2, 2012, 2014 and 2016. • Involved installing service pack, cumulative updates and hot fixes. • Creating logins and mapping logins to DB and granting permissions at server and object level. • Checking the status of backups and troubleshooting the failed backups. • Checking the backup reports and ensuring that all the backups are proper. • Schedule and maintain routine jobs, alerts and maintenance plans. • Restoring the backups (users and system DB’s) as needed. • Implemented HADR options such as log shipping, clustering, mirroring and AlwaysOn AG. • Configuring and troubleshooting snapshot, transactional and merge replication. • Creating indexes on tables to improve the performance as per the Dev/App team request. • Migrated SQL Server 2012 to SQL Server 2016. • Performing disaster recovery (DR) test on a Quarterly basis.
Technologies: SQL Server
Industry: Information Technology
Syndicate bank
August-2013 to May-2015
Description
Syndicate Bank was one of the oldest and major commercial banks of India
Roles and Responsibilities
Involved in installing SQL Server 2008, 2008R2, 2012, 2014 and 2016. • Involved installing service pack, cumulative updates and hot fixes. • Creating logins and mapping logins to DB and granting permissions at server and object level. • Checking the status of backups and troubleshooting the failed backups. • Checking the backup reports and ensuring that all the backups are proper. • Schedule and maintain routine jobs, alerts and maintenance plans. • Restoring the backups (users and system DB’s) as needed. • Implemented HADR options such as log shipping, clustering, mirroring and AlwaysOn AG. • Configuring and troubleshooting snapshot, transactional and merge replication. • Creating indexes on tables to improve the performance as per the Dev/App team request. • Migrated SQL Server 2012 to SQL Server 2016. • Performing disaster recovery (DR) test on a Quarterly basis.
Technologies: SQL Server
Industry: Information Technology
Work history
SQL Server DBA • November-2022 to December-2023
Description: Providing 24/7 SQL Server DBA production support with On-call support. • Installing, configuring & monitoring SQL 2005, 2008R2, 2012, 2014, 2016, 2017 & 2019. • Involved installing service pack, cumulative updates and hot fixes. • Experience on Installing SQL Server using unattended and slipstream method. • Experience in upgrading SQL Server 2005-2008/R2 and 2008R2-2012. 2012-2017. • Migrate logins through sp_help_rev_login stored procedure and fixing orphan users. • Instance & DB security, creating logins-users and granting permissions to logins/users • Checking the status of backups and troubleshooting the failed backups. • Checking the backup reports and ensuring that all the backups are proper. • Schedule and maintain routine jobs, alerts and maintenance plans. • Restoring the backups (users and system DB’s) as needed. • Technical troubleshooting gives consultation to development teams. • Tracking the locking issues, including deadlocks, blocking and lock timeouts. • Monitoring disk space of all the servers and freeing up the space as per the requirement. • Experience on monitoring SQL Server Performance using Perfmon and Profiler Tools. • Reviewing SQL Server Error log and Event viewer • Performing disaster recovery (DR) test on a Quarterly basis. • Ensuring process documentation is updated on regular basis. • Experienced on piecemeal restore and restorations to STOP AT MARK. • Experience on configuring database mail, jobs, maintenance plans and alerts. • Implementing and troubleshooting log shipping, DB mirroring and clustering. • Experience on configuring and troubleshooting Always On AG in SQL Server. • Configuring and troubleshooting snapshot, transactional, merge & peer-to-peer. • Creating, rebuilding and reorganizing different types of indexes. • Using stored procedures, views, functions, T-SQL codes, queries, DMV’s and DBCC. • Follow SLAs & ITIL process for changes and all tickets, Service Requests from clients. • Experience on Installing and configuring SSAS, SSIS and SSRS, • Experience on collection data using PSSDIAG tool. • Experience on automation using PowerShell. • Experience on taking backup and restore using Litespeed and Commvault tool. • Experience on monitoring SQL performance using SQLDM.
SQL Server DBA • June-2022 to November-2022
LTIMindtree
Description: Installation and configuration of SQL Server 2019. • Configured Publisher, Distributor, Subscriber in AlwaysOn Availability Groups. • Upgraded the SQL server 2019 developer to enterprise edition. • Worked on Implementation and troubleshooting log shipping and DB mirroring. • Worked on configuring and troubleshooting AlwaysOn AG in SQL Server. • Migrated older version of SQL Server to latest version. • Technical troubleshooting gives consultation to development teams. • Migrated On-prem SQL Server to Azure cloud VM, SQL databases and SQL MI. • Effectively managed and reduced cost by effectively monitoring databases elastic pool. • Configured Azure site recovery for DR and Azure backup on-premises/Azure Environment. • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed Instances, Configured High Availability Solutions; AlwaysOn, Log Shipping, patching, troubleshooting, optimization, maintenance. • Configured Transparent Data Encryption (TDE) using AE256 Algorithm to make sure that all databases are fully encrypted. • Configured Geo replication with availability group in Azure SQL DB • Involved on Installing and configuring SSAS, SSIS and SSRS.
SQL Server DBA • October-2016 to June-2022
Kyndrl india
Description: Installation and configuration of SQL Server 2019. • Configured Publisher, Distributor, Subscriber in AlwaysOn Availability Groups. • Upgraded the SQL server 2019 developer to enterprise edition. • Worked on Implementation and troubleshooting log shipping and DB mirroring. • Worked on configuring and troubleshooting AlwaysOn AG in SQL Server. • Migrated older version of SQL Server to latest version. • Technical troubleshooting gives consultation to development teams. • Migrated On-prem SQL Server to Azure cloud VM, SQL databases and SQL MI. • Effectively managed and reduced cost by effectively monitoring databases elastic pool. • Configured Azure site recovery for DR and Azure backup on-premises/Azure Environment. • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed Instances, Configured High Availability Solutions; AlwaysOn, Log Shipping, patching, troubleshooting, optimization, maintenance. • Configured Transparent Data Encryption (TDE) using AE256 Algorithm to make sure that all databases are fully encrypted. • Configured Geo replication with availability group in Azure SQL DB • Involved on Installing and configuring SSAS, SSIS and SSRS.
SQL Server DBA • May-2015 to September-2016
Congnizant
Description: Involved in installing SQL Server 2008, 2008R2, 2012, 2014 and 2016. • Involved installing service pack, cumulative updates and hot fixes. • Creating logins and mapping logins to DB and granting permissions at server and object level. • Checking the status of backups and troubleshooting the failed backups. • Checking the backup reports and ensuring that all the backups are proper. • Schedule and maintain routine jobs, alerts and maintenance plans. • Restoring the backups (users and system DB’s) as needed. • Implemented HADR options such as log shipping, clustering, mirroring and AlwaysOn AG. • Configuring and troubleshooting snapshot, transactional and merge replication. • Creating indexes on tables to improve the performance as per the Dev/App team request. • Migrated SQL Server 2012 to SQL Server 2016. • Performing disaster recovery (DR) test on a Quarterly basis.
Education
Masters degree in Computer Science
VTU
2010 to 2013
Language
English - Advanced