Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ramesh Thangaraju

Atlanta,GA

Summary

Experienced data professional with over 15 years of progressive expertise in Microsoft SQL Server, spanning from SQL Server 2008 to SQL Server 2019. Proficient in working across diverse environments, including both public and private cloud setups in AWS and Azure. Committed to continuously expanding technical knowledge to meet evolving business demands.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Senior Database Administrator

Incomm Payments
05.2023 - Current
  • Working on On-Call rotations
  • During on-call, any server-related issue will work with Windows Server and the network teams etc.
  • Applying patching in multiple SQL servers by using Ansible
  • Automate getting the disk storage size by using PowerShell
  • Responsible for administering one or more databases in a production environment
  • Install, upgrade servers and application tools
  • Allocates system storage and plans for future allocations
  • Creates primary objects (tables, indexes, views etc.) during application design, create and allocate storage for the database
  • Enrolls the database users and ensure system is secure
  • Monitor user level access to database(s) and monitor database performance
  • Plan for backup and recovery of the database and clusters, replicates and normalizes data as required
  • Responsible for VLDB database design and modelling including performance tuning, input/output tuning and capacity planning
  • Interact with business partners (External Customers) on system and performance improvement techniques
  • Carrying out maintenance activities on database like Reorg, Integrity Check, Update Stats and backup management
  • Designed and Implemented Replication, Mirroring, Log Shipping and Always On (high availability) features to enhance availability of database
  • Setup thresholds monitoring and reporting for Storage and Disk Utilization, CPU and Memory utilization
  • Ensure backup availability of all database and performing backup validation for mission critical databases
  • Interacted with application team at the time database migration from SQL Server 2014/SQL Server 2016
  • Configure Golden gate replication for SQL Server
  • Configure Azure database for MYSQL on version 8.0
  • Optimized database performance by conducting regular maintenance and implementing best practices.
  • Set up and controlled user access levels across databases to protect important data.
  • Created and updated database designs and data models.

Senior Database Administrator

UPS Supply chain solutions
11.2018 - 01.2023
  • Allocates system storage and plans for future allocations
  • Creates primary objects (tables, indexes, views etc.) during application design, create and allocate storage for the database
  • Enrolls the database users and ensure system is secure
  • Interact with business partners (External Customers) on system and performance improvement techniques
  • Designed and Implemented Replication and Partitions
  • Designed and Implemented Replication, Mirroring, Log Shipping and Always On (high availability) features to enhance availability of data Foglight (tool) for all SQL Servers to monitor and capture performance metrics
  • Configure High Availability AlwaysOn on 2012, 2014, 2016 on Windows Server 2012R2 and Windows Server 2016
  • Configure DAG (Distributed Availability Group) on SQL server 2016/2019
  • Configured replication in conjunction with AlwaysOn
  • Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards
  • Developed and Designed Azure DevOps pipelines to manage the resources across multiple subscriptions in Azure
  • Experience with Azure Cloud Services (PaaS & IaaS), Azure Virtual Machines Azure Storage, SQL, Azure, Azure Active Directory
  • Give feedback to application team on best practices to be followed according to UPS standards on TSQL
  • Work seamlessly with Engineering, QA and Operations team to effectively manage application code
  • Providing Oncall support as needed by the business
  • Participate in Bi-annual DR exercise as needed by business requirements

Senior SQL Server DBA

FISERV
10.2018 - 04.2019
  • Supporting 24x7 production and Dev/QA environments
  • Strong experience in database administration in SQL Server (2005 and 2008) Migrate databases from SQL Server 2005 to SQL Server 2019
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc
  • Experience in performance tuning, query optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools

Database Administrator

Incomm Payments
03.2018 - 09.2018
  • Responsible for patching SQL server once every quarter
  • Participate in capacity planning for internal applications and work with systems engineering team to have resources available in Production and lower environments
  • Monitor user level access to database(s) and monitor database performance
  • Planned for backup and recovery strategies for applications based on RPO of the business
  • Interact with third party vendor system and performance improvement techniques
  • Handled Ola Hallengren maintenance solution
  • Designed and Implemented Replication, Mirroring, Log Shipping and Always On (high availability) features to enhance availability of database
  • Setup thresholds monitoring and reporting for Storage and Disk Utilization, CPU and Memory utilization
  • Ensure backup availability of all database and performing backup validation for mission critical databases
  • Interacted with application team at the time database migration from SQL Server 2014/SQL Server 2016
  • Upgraded SQL server 2012 to SQL Server 2014/SQL Server 2016 on standalone and clustered environments and applied service pack

SQL Server Database Administrator

The Home Depot
06.2014 - 03.2018
  • Upgraded SQL server 2005 to SQL Server 2008 R2/SQL Server 2012 on standalone and clustered environments and applied service pack
  • Co-ordinated cutover with application team at the time database migration from SQL Server 2005 to SQL Server 2008R2/SQL Server 2012
  • Interacted with Developers in troubleshooting application and database issues
  • Identified, tested and resolved database performance issues to ensure data optimization
  • Installing and Configuring SQL Server 2005/2008/2008 R2/2012 and 2016
  • Deployed and maintained SSIS packages and SQL objects in Dev, UAT and Prod environments
  • Designing, building, implementing, Troubleshoot and deploying Database Objects (Stored Procedures, functions, Tables, Views, Triggers, Indexes, synonyms, DB Links and Constraints), Database schema, T-SQL Code Security, integrity of the Databases and upgrading Database systems
  • Implemented Mirroring and Log Shipping for Disaster recovery, configured transactional, snapshot replication
  • Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks
  • Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2012
  • Involved in troubleshooting all the performance issues for different database applications
  • Deployed SSIS packages to SSIS database and file system using manifest file and the wizard utility in SQL Server 2012
  • Monitoring and scheduled jobs on production and staging environment
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Implemented for Database Objects such as stored procedures, views, triggers, functions, tables, indexes as per RFC
  • Created Linked Servers for data retrieval using OLE DB data sources and providers

SQL Server DBA

Tata Consultancy Services
09.2006 - 09.2013
  • Company Overview: Client : Ameriprise Financial Services
  • As a Production support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments
  • Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers
  • Worked in SQL Server DTS and SSIS (Integration Services) package deployment
  • Performance tuning for SSIS package mappings and trouble shoot SQL Procedures bottlenecks
  • Implemented Database Mirroring on SQL Server 2008 environments for DR/HA
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR
  • Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
  • Implemented Database Mirroring on SQL Server 2008 environments
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments
  • Installed, configured and maintained MS SQL Fail over clustering to provide server High Availability solution for different environments
  • Worked for tuning SQL Server using available tuning methods as index tuning wizards, profiler & execution plans
  • Created the standard documents for Disaster recovery testing and implemented the documents
  • Plan for database sizing and capacity planning of production servers
  • Worked on logical and physical database design for development projects
  • Utilized perfmon on windows level to monitor and improve server performance
  • Created the backup schedule for production, test and development servers based on RTO and RPO of applications
  • Worked with Developers to create database schema changes and database restore requests
  • Involved in restore operations to refresh the data from production to test servers
  • Experienced in troubleshooting production servers and fixed the application issues
  • Client : Ameriprise Financial Services

Trainee DBA

Madras Cements Limited
05.2005 - 08.2006
  • Handled activities pertaining to development and execution of TSQL Scripts
  • Worked also as SQL DBA for 1+ years, written complex queries, optimized long running queries etc
  • Migrated databases from SQL 2000 to SQL 2005
  • Created many packages in Integration services like import, export, DB mail etc
  • Developing and Implementing DBA maintenance plans for MS SQL Server (DB Backups, DBCC, updating index statistics, monitoring databases and disk space)
  • Running utilities like copy, load, import, export, reorg, update statistics etc
  • Managed VLDB in all version of SQL server

Education

Master of Computer Applications -

Bharathidasan University
India
05.2004

Bachelor of Science -

Bharathidasan University
India
05.2001

Skills

  • Database security
  • Performance tuning
  • Database maintenance
  • Olla Hallengren scripts
  • Azure
  • AWS
  • SQL Sentry
  • Foglight
  • Spotlight
  • SQL 2008
  • SQL 2008R2
  • SQL 2012
  • SQL 2014
  • SQL 2016
  • SQL 2017
  • SQL 2019
  • Windows Server 2003
  • Windows Server 2008
  • Windows Server 2008R2
  • Windows Server 2012
  • Windows Server 2016
  • Always On Availability Groups
  • Distributed availability Groups
  • On call support
  • Database Migrations
  • Store procedure tuning and reviews
  • Data Modelling
  • Mirroring
  • Log shipping
  • Transactional Replication
  • Golden Gate replication
  • Merge Replication
  • High availability
  • Disaster Recovery
  • Database Support
  • Security Standards
  • Database Optimization
  • Database Maintenance
  • Clustering
  • Readscale Availability Groups
  • Service now
  • Backup and recovery strategies

Certification

  • Microsoft Azure Database Administrator – DP 300
  • Microsoft Azure Fundamentals – AZ 900

Timeline

Senior Database Administrator

Incomm Payments
05.2023 - Current

Senior Database Administrator

UPS Supply chain solutions
11.2018 - 01.2023

Senior SQL Server DBA

FISERV
10.2018 - 04.2019

Database Administrator

Incomm Payments
03.2018 - 09.2018

SQL Server Database Administrator

The Home Depot
06.2014 - 03.2018

SQL Server DBA

Tata Consultancy Services
09.2006 - 09.2013

Trainee DBA

Madras Cements Limited
05.2005 - 08.2006
  • Microsoft Azure Database Administrator – DP 300
  • Microsoft Azure Fundamentals – AZ 900

Master of Computer Applications -

Bharathidasan University

Bachelor of Science -

Bharathidasan University

Similar Profiles

  • Ansar K. A.

    Ansar K. A.Ansar K. A.

    SDE-III at InComm Benefits, an InComm Payments divisionSDE-III at InComm Benefits, an InComm Payments division

    View Profile
  • Scott Campbell

    Scott CampbellScott Campbell

    Vice President/Director of Global Corporate Real Estate and Workplace Services at InComm PaymentsVice President/Director of Global Corporate Real Estate and Workplace Services at InComm Payments

    View Profile
  • Nancy Robinson

    Nancy RobinsonNancy Robinson

    Sr. Project Manager/Manager Software Engineering at Incomm PaymentsSr. Project Manager/Manager Software Engineering at Incomm Payments

    View Profile
Ramesh Thangaraju