Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Krithika Palani

Summary

Experienced Oracle DBA with 12 years of hands-on expertise in managing Oracle databases across versions 11g, 12c, and 19c. Skilled in installation, configuration, patching, upgrades, and performance tuning of large-scale databases on Linux and AIX platforms. Strong background in supporting high-availability systems, ensuring optimal performance, data security, and compliance in mission-critical environments.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Database Consultant

Optimum Solutions (S) Pte Ltd
06.2023 - Current
  • Provide end-to-end support for critical Oracle database environments, primarily supporting high-impact applications in the investment banking domain.
  • Act as a Subject Matter Expert (SME) in Oracle database technologies, with deep expertise across versions 11g R2, 12cR1, and 19c.
  • Responsible for the deployment, configuration, and administration of Oracle RAC, ASM, and Clusterware in high-availability environments.
  • Lead database build activities, version upgrades, and complex migration projects in compliance with enterprise standards and regulatory guidelines.
  • Perform advanced performance tuning across large-scale OLTP and data warehouse systems, ensuring optimal database performance and stability.
  • Manage Oracle Data Guard implementations, including setup, monitoring, and troubleshooting, with hands-on experience in Data Guard Broker and Fast-Start Failover.
  • Oversee backup and recovery strategies using Oracle RMAN, ensuring data protection and adherence to RTO/RPO targets.
  • Implement and manage Oracle security features such as Oracle Wallet and Secure External Password Store, ensuring compliance with internal and external security standards.
  • Collaborate effectively with application development, infrastructure, and service management teams to deliver robust, scalable, and resilient database solutions.
  • Serve as the primary point of contact for major incidents, providing leadership during critical issue resolution and maintaining effective communication with stakeholders.
  • Take ownership of change management activities including planning, coordination, communication, and securing required approvals for production deployments.
  • Offer technical consulting and mentorship to application teams, guiding best practices in database design, development, and optimization.
  • Ensure full compliance with change control processes, database security policies, and industry-standard database architecture patterns.
  • Maintain strong working knowledge of RHEL Linux, with hands-on skills in OS-level monitoring and basic administration.
  • Utilize key Oracle utilities such as DataPump, SQLLoader, SQLPlus, and DBCA for day-to-day administration and project work.
  • Configure and troubleshoot advanced Oracle SQL
  • Net networking, ensuring secure and efficient client-database communication.

Senior Executive (Senior Oracle DBA)

Comfort Transportation Pte Ltd
12.2018 - 06.2023
  • Company Overview: (Singapore)
  • Administrating 19c Autonomous database.
  • Monitoring performance and diagnose issues on the Performance Hub through OCI Console.
  • Performing Oracle 12c Database administration tasks that includes configuration management, backup/recovery, user and role administration, space management.
  • Monitoring & analyzing database performance and make changes to optimize performance.
  • Responsible for working with development/support teams to optimize SQL statements.
  • Patching / upgrading of Oracle software.
  • Enforcing data retention policies.
  • Performing disaster recovery exercises (Dataguard switchovers).
  • Configuring replication between databases (streams and golden gate).
  • Reviewing table design, PL/SQL procedures done by development team.
  • Creating common utility PL/SQL stored procedures that can be used by development team.
  • Supporting in deployment activities to perform database related changes.
  • (Singapore)

IT Analyst (Oracle Database Administrator)

Tata Consultancy Services India Pvt Ltd
07.2012 - 04.2018
  • Managed Oracle databases (11g&12c) and provided end to end support.
  • As part of DB operations, performed following tasks and challenges.
  • Database Installation/Configuration/Refresh & Cloning of Oracle 11g/12c in standalone environment.
  • Configured high availability (Dataguard) between Primary and Physical/Active standby databases.
  • Performance Tuning on Non Prod/Prod databases.
  • Capacity management, memory and user management.
  • Backup and Recovery of Prod databases using RMAN.
  • DB Migration (Oracle 11g to 12c) / DB Upgrade (Oracle 12cR1 to R2) in Prod/Non Prod standalone environment.
  • Administrated on snapshot and Hot cloning PDB.
  • Implementing PITR for Prod databases.
  • Configured user defined metrics for the full and archive backup failure.
  • Administration on exp/imp using datapump utilities.
  • Performed db complete/incomplete recovery, datafile recovery.
  • Automated daily health dashboard, backup reports for Prod/Non prod environments.
  • Shell scripting to automate day to day operations or tasks.
  • Automated RMAN backups for Prod/Non Prod in CRONTAB.
  • Performing critical patch for Non Prod in Windows environment.
  • Maintains and monitors the High Availability of the database.
  • Automated mail monitoring alerts for archive log gaps, observer failures, and capacity management.
  • Participate in on-call rotations.

IT Analyst (Oracle Database Administrator)

Tata Consultancy Services India Pvt Ltd
07.2012 - 07.2016
  • Worked with this project to manage and support Oracle databases from end to end on different platforms.
  • As part of the core activities, performed the following activities on day to day basis.
  • Administration of Oracle databases in Standalone/ RAC/ Dataguard on HP-UNIX, AIX, Sun Solaris and Linux platforms.
  • Capacity management, memory and user management.
  • Administrating on logical storage structures tablespace (creating/dropping/adding/resizing/truncating/online/offline of tablespace/data files).
  • Maintaining database objects (Table, Index, Views, Package etc...)
  • Maintaining database related physical files (LISTENER,TNS, Pfile, SPfile , Control Files, Redo log files, Data files,Trace files, Alert logs etc...)
  • Automated scripts for monitoring and maintaining database.
  • Implemented Oracle partition for large databases tables to speedup databases retrieval.
  • Administrating database using SRVCTL/CRSCTL/ASMCMD/DGMGRL/RMAN/ADRCI Utility.
  • Perform Dataguard sync issues/failover/switchover/standby rebuild.
  • Perform backup and Recovery operations using RMAN.
  • Maintaining archived data and backups in tape.
  • Scheduling Database level jobs using DBMS_JOBS.
  • Knowledge about Database Link & Materialized view concepts.
  • Performed db restore using export/import utility.
  • Involved in Performance Tuning (Identifying and resolving issues related to long running Queries, Create/Drop/Rebuild Index, Update stats of the table, SQL Query tuning, CPU/Swap utilization, Issues related to Memory component etc...)
  • Performed Oracle tuning in different applications using AWR reports, ADDM, STATSPACK &Explain plan.
  • Partnered with Life Cycle Management team on migration, upgradation and decommissioning of database.
  • Partnered with Life Cycle Management team on applying patches in standalone and RAC.
  • Worked with customers proactively on bridge calls to sort out their issues relevant to oracle databases.
  • Received mail appreciations from clients.

Education

Bachelor of Technology - Information Technology

SRM University
India
05.2012

Skills

  • Databases: Oracle 11g, 12c, 19c – installation, configuration, backup/recovery, performance tuning, and patching
  • Operating Systems: Linux (RHEL/OEL), Windows, Solaris, AIX
  • Tools & Utilities: RMAN, Data Pump (expdp/impdp), SQL*Loader, DBCA, OUI, OEM 13c
  • Development Tools: SQL Developer, PL/SQL Developer, TOAD
  • Replication & HA: Oracle GoldenGate – setup and monitoring
  • Automation & Version Control: Git, Chef
  • Project Tools: JIRA, Confluence, One Pager for reporting and documentation

Certification

  • ITIL Foundation Certificate in IT Service Management, 05/07/13
  • Oracle Database 11g Administrator certified Associate, 02/20/14
  • Oracle cloud Infrastructure 2022 Certified Foundations Associate, 01/21/23

Accomplishments

  • Designed a program for pax lucky draw contest 2019 for Comfort Delgro Taxi.
  • Received kudos for Best Team Player from TCS in the 3rd quarter of 2013.
  • Recognized as Star Performer from Target client for excellence in work (Year- 2014 & 2015).
  • Received Certificate of appreciation for RIO best practice sharing from TCS in 2017.

Timeline

Database Consultant

Optimum Solutions (S) Pte Ltd
06.2023 - Current

Senior Executive (Senior Oracle DBA)

Comfort Transportation Pte Ltd
12.2018 - 06.2023

IT Analyst (Oracle Database Administrator)

Tata Consultancy Services India Pvt Ltd
07.2012 - 04.2018

IT Analyst (Oracle Database Administrator)

Tata Consultancy Services India Pvt Ltd
07.2012 - 07.2016

Bachelor of Technology - Information Technology

SRM University

Similar Profiles

CREATE PROFILE
Krithika Palani