Gayathri Shiam Sundar

• Worked as team member to provide 24*7 on-call production database support.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs.
• Participate in DR activity and successfully completed with any lag.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers/accounts.
• Trained junior team members on best practices for database administration, promoting culture of continuous learning within organization.

Snowflake DBA roles & responsibilities:

• User creation and access management, have knowledge in AWS services.
• Diagnose and troubleshoot snowflake database errors in day-to-day DB administration .
• Increase/Decrease WH sizes and adapting scaling policies bases on requirement.
• Restoring data using time travel.
• Creation of stages, pipes and tasks as per project requirements.
• Create and manage network policies and perform IP whitelisting.
• Creation of objects like schema, views, tables and materialized view and provide necessary grants.
• Loading of data into snowflake tables using various COPY options.
• Performing failover and fallback of databases during DR activity.
• Performed Cloning of Databases/Schemas/tables/Views based on project needs.
• Creating Database share and providing required privilege to users to access shared objects.
• Loading and unloading data from Internal stage and external stage using PUT and GET command in snowsql.
• Creating file formats and use it in stages for data loading and unloading.

Oracle DBA roles & responsibilities:

• 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.
• Experience in performing tuning activities such as blocking,long running and deadlock sessions.
• Led decommissioning efforts for numerous databases and servers in Oracle platform by performing pre checks which includes DB decommission activities like dropping database,disabling audit archival, updating decommission details in Inventory, disabling ITO monitoring, removing targets from OEM, updating decommission details in CMDB, removing config files for production databases,shutting down OEM agents, removing jobs in Autosys, Data Archival, Backup retention, removing config files from Goldengate, remove DB entries from HAS, tnsnames,alert logs.,
• Managed appropriate use of free space within Tablespaces,reclaimed space and reorganized tables and indexes within databases when needed.
• Worked on bulk termination of oracle users and Inactive user managements for audit compliance.
• Resolved issues in conflicts like stuck pump, missing logfiles between target and source database in Goldengate.
• Interacted with Oracle support on Service Requests and implemented solutions for successful completion of tasks.

Informix DBA roles & responsibilities:

• Experience in Monitoring Informix engines health,connection managers and monitors.
• Worked in High Availability Data Replication servers(HDR).Worked on Instance recoveries and replication failure in HDR Pairs.
• Manual fail-over on HDR servers and fixing split-brain situations.
• Took level-0 and logical log backup on stores and HDR servers.
• Restore database from level-0 DB backup and secondary from primary backup.
• Performance tuning activities like checking table/user locks, long running sessions.
• Adding chunk to DB space,dropping and recreating index.
• Perform Shrink & repack and table truncation to reclaim DB spaces.
• Rebuiliding corrupted indexes in database.
• Worked with IBM support engineer to resolve database related issues.