Summary
Overview
Work History
Education
Skills
Software
Certification
Interests
Timeline
Generic

Gayathri Shiam Sundar

Database Administrator
Chennai

Summary

Experienced Oracle DBA with recent exposure to Snowflake database platform. 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. Currently expanding expertise in Snowflake and actively involved in support platforms. Committed to continuing professional growth and seeking opportunities to contribute to the success of an organization.

Overview

8
8
years of professional experience
4
4
years of post-secondary education
6
6
Certifications

Work History

Snowflake Database Administrator

Infosys Limited (Client - DTCC Financial Services)
Chennai
04.2023 - Current
  • Collaborated within team to provide round-the-clock on-call production database support, consistently maintaining SLA rate of 99.5%.
  • Managed deployment and configuration of Snowflake data warehouses to ensure optimal performance and stability. Created stages, pipes, and tasks in accordance with project requirements. Conducted cloning of databases, schemas, tables, and views as needed for project implementations.
  • Engaged in disaster recovery as part of standard management activity.
  • Proficient in user creation, access management, and experienced with AWS services. 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.
  • Setting up Database share and granting necessary privileges to users for accessing shared objects.
  • Renewing SAML certifications and addressing expired token issues.
  • Experience in setting up replication between Snowflake accounts across different regions.
  • Collaborated with Azure AD team to create user accounts, implement group policies, ensuring security of database systems.

Oracle Database Administrator

Tata Consultancy Services (Client - The HomeDepot)
Chennai
06.2016 - 03.2023
  • Detecting and diagnosing production system performance tuning of database - SQL tuning, used tuning utilities like AWR,ASH report,ADDM, measuring system and database activity, querying Oracle dynamic performance views.
  • Hands-on experience in tuning activities including addressing blocking, long-running, and deadlock sessions to optimize system performance.
  • 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 bulk termination of Oracle users and managed inactive user accounts to ensure audit compliance.
  • Resolved conflicts such as stuck pumps and missing log files between target and source databases in Oracle GoldenGate.
  • Collaborated with Oracle Support on Service Requests and implemented their solutions to ensure successful task completion.

Education

B.Tech - Information Technology

SASTRA University
Tamilnadu, India
07.2012 - 05.2016

Skills

Oracle Database Administration

Performance Tuning

Disaster Recovery Planning

ITIL Processes

Database Troubleshooting

Replication Management

Cloud Database Services

Software

Service Now

Oracle Enterprise Manager (OEM)

Grafana

Azure Portal

Snowsight

Autosys

Oracle & Snowflake Support

SecureCRT

JIRA

POWER BI

Certification

ITIL Certification

Interests

Keen interest in acquiring proficiency in regional languages and recently started a hobby of learning Dutch

Timeline

Snowflake Database Administrator

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

Oracle Database Administrator

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

B.Tech - Information Technology

SASTRA University
07.2012 - 05.2016

Similar Profiles

CREATE PROFILE
Gayathri Shiam SundarDatabase Administrator