Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Gayathri Shiam Sundar

Summary

Experienced Oracle and Snowflake DBA with recent exposure to Azure. Skilled in customer service, decision-making, and working under pressure. Excelled in production support and successfully handled multiple disaster recovery support activities.Previous experience with the cross-technology platform called Informix. Committed to continuing professional growth and seeking opportunities to contribute to the success of an organization.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Snowflake Database Administrator

Infosys Limited (Client - DTCC Financial Services)
Chennai, India
04.2023 - Current
  • Maintained a high standard of round-the-clock, on-call production database support, resulting in an exceptional 99.5% SLA rate.
  • Managed the deployment and configuration of Snowflake data warehouses to ensure optimal performance and stability. Created DB objects, stages, pipes, and tasks in accordance with project requirements. Conducted cloning of databases, schemas, tables, and views as needed for project implementations.
  • Experience in creating both CI/CD and local service accounts, along with key-pair authentication and OAuth connectivity setup, and troubleshooting deployment issues from the Jenkins pipeline.
  • Proficient in user creation and access management. Identify and resolve Snowflake database errors as part of daily DB administration duties.
  • Adjust Snowflake warehouse sizes, and adapt scaling policies based on current needs. Also, recovering data using time-travel functionality.
  • Develop and administer network policies, including managing IP whitelisting.
  • Worked with the application team to set up PrivateLink connectivity between AWS and Snowflake, which includes fetching S3 buckets and VPCE endpoint connections.
  • Setting up a database share and granting necessary privileges to users for accessing shared objects.
  • Renewing SAML certifications, and addressing expired SCIM token issues.
  • Experience in setting up replication between Snowflake accounts across different regions.
  • Collaborated with the Azure AD team to establish user accounts and implement group policies, guaranteeing database system security.
  • Ability to create and execute disaster recovery plans to ensure business continuity.

Oracle Database Administrator

Tata Consultancy Services (Client - The HomeDepot)
Chennai, India
06.2016 - 03.2023
  • Detected and diagnosed production system performance tuning of the database, including SQL tuning and the usage of tuning utilities such as AWR, ASH report, and ADDM. Measured system and database activity by querying Oracle's dynamic performance views.
  • Hands-on experience optimizing system performance through tuning activities, including addressing blocking, long-running, and deadlock sessions.
  • Led decommissioning efforts for multiple Oracle databases and servers, conducting comprehensive pre-checks. Activities included dropping databases, disabling audit archival, updating decommission details in inventory systems, deactivating ITO monitoring, removing targets from OEM (Oracle Enterprise Manager), updating CMDB with decommission details, deleting configuration files for production databases, shutting down OEM agents, removing jobs from Autosys, managing data archival and backup retention, removing configuration files from Goldengate, and deleting database entries from HAS (High Availability Services), tnsnames, and alert logs.
  • Managed efficient utilization of free space within tablespaces, reclaimed space, and reorganized tables and indexes within databases as necessary to optimize performance and storage efficiency, consistently maintaining thresholds below 70%.
  • Handled the bulk termination of Oracle users and managed inactive user accounts to ensure audit compliance.
  • Resolved conflicts between target and source databases in Oracle GoldenGate, such as stuck pumps and missing log files.
  • Efficiently handled RMAN backups, including troubleshooting for error resolution.
  • Ability to create and execute disaster recovery plans to ensure business continuity.
  • Collaborated with Oracle Support on service requests, and implemented their solutions to ensure successful task completion.

Informix Database Administrator

Tata Consultancy Services (Client - The HomeDepot)
Chennai
12.2018 - 11.2021
  • Proficient in utilizing both IBM Informix v11.7 and Informix v12.1 for live production systems.
  • Successfully worked with Informix high-availability data replication servers. Worked on overcoming instance recoveries and replication failure issues in HDR servers.
  • Performed space reclamation activities, including index rebuild, addition of DB space fragments, redistribution, shrink, and repack.
  • Performed level-0 backups and executed instant restorations.
  • Repaired database tables with no loss, fixing corruptions, and restoring functionality.

Education

B.Tech - Information Technology

SASTRA University
Tamilnadu, India
04-2012

Skills

  • Database Administration
  • Performance Tuning
  • OR/DR Planning and support
  • ITIL processes
  • Azure AD
  • Privatelink connectivity
  • Jenkins Pipeline
  • OAuth setup

Certification

  • ITIL Certifications
  • Oracle Database 11g: SQL Fundamentals I
  • Oracle Database SQL Certified Associate
  • AZ 900 Microsoft Azure Fundamentals
  • Oracle Cloud Infrastructure Certified Foundations Associate
  • Mongo DB SI Associate Certification

Timeline

Snowflake Database Administrator

Infosys Limited (Client - DTCC Financial Services)
04.2023 - Current

Informix Database Administrator

Tata Consultancy Services (Client - The HomeDepot)
12.2018 - 11.2021

Oracle Database Administrator

Tata Consultancy Services (Client - The HomeDepot)
06.2016 - 03.2023

B.Tech - Information Technology

SASTRA University

Similar Profiles

CREATE PROFILE
Gayathri Shiam Sundar