Poornima Shanmugam

Email:ad4ic2@r.postjobfree.com

Phone: +1-309-***-****

Highly motivated and results-driven DBA with a successful 11 years of experience in Oracle database administration, AWS, PostgreSQL and Oracle Exadata databases. Proficient in various core DBA activities involving Oracle RAC, ASM, Golden gate, Capacity planning, Database upgrades, Patching, Performance tuning, disaster recovery, Golden gate and AWS Technology. PROFESSIONAL SUMMARY

• Hands on experience in Installation, Administration, Troubleshooting and migration of Oracle database versions 19c in both RAC and standalone databases.

• Responsible for setting up new RAC /Standalone Databases including DB creation, Data Load, Backup setup and monitoring along with applying the latest patches.

• Experienced in Golden gate installation, configuration, troubleshooting, upgrades and used golden gate for performing database migrations.

• Assisted in management, patching and database administration of Oracle database applications on Exadata platforms.

• Expertise in performing rolling upgrade to 18c/19c multitenant databases for Oracle databases.

• Skilled in database refresh, patching, maintenance, and backup/recovery using RMAN .

• Experienced in troubleshooting and resolving database-related issues, performance tuning, and user support for Oracle databases.

• Experienced in designing schema and have good knowledge in access patterns, locking strategy and SQL development.

• Implemented Oracle high availability by setting up standby databases using active Data guard.

• Configured Data guard broker and used for switchover and starting and stopping of Media recovery processes.

• Extensive Knowledge and experience in AWS Technologies like Aurora, DynamoDB, EC2, RDS, Route53, S3, Redshift, ELB, CloudWatch, VPC, subnets and IAM.

• Worked on data migration using AWS data migration services from oracle to RDS.

• Extensive experience in performance tuning and analysis using AWR, ASH.

• Expert in Performance Tuning of application code at the database level using various SQL tuning methodologies.

• Strong knowledge in database tuning, performance tuning, database reorganization, data replication and database backup and recovery.

• Experience with Oracle 12c CDB/PDB architecture and setup experience in High Availability environments using RAC with ASM.

• Performed Maintenance Activities in Oracle RAC and Data guard database setup like rolling upgrades and Patching.

• Performing instance recovery, block recovery and data file recovery using RMAN.

• Having experience in Shell scripting, and have automated various database related Activities.

• Extensive Experience in database security and auditing.

• Proficient in handling client calls and knowledge transfer to the new team.

• Supported Oracle developers for deployment in pre-production and Production Environment.

• Monitoring database and performing troubleshooting. Reorganizing table spaces, tables, and indexes

• Implementation and maintaining Database Security (create and maintain users and roles, assign privileges and Profiles)

• Supported Application team for their successful completion of data loading to DB’s by

• resolving performance/other issues

• Enabled Auditing at session level and database level. TECHNICAL SKILLS

Primary Skills Oracle DBA,PostgreSQL DBA, Exadata, AWS, Goldengate Operating System Red Hat Linux, Solaris, HP, AIX

Tools & Utilities Data Pump, RMAN, DBCA, Data Guard, Putty, SQL developer Languages SQL, plsql, Shell Scripting

Databases Oracle 19c/18c/12c/11.2/10.2/9i/8i, Oracle RAC, PostgreSQL 7.4.x/8.x Oracle Database Appliance (Exadata hardware) ODA X4- 2/X5-2/X7-2-HA, PostgreSQL.

File systems Oracle Automatic Storage Management (ASM), ASM Cluster File System (ACFS), Network File Systems (NFS)

CERTIFICATIONS:

Oracle Certified Associate, Oracle Certified SQL Expert, AWS Certified Cloud Practitioner. EDUCATIONAL DETAILS:

B.E Electronics and Communication Engineering (Full Time) at Sri Ramakrishna Institute of Technology, Coimbatore, India-2009

PROFESSIONAL EXPERIENCE

Innovative Information Technologies

McAfee Software Inc, Bloomington- IL Oct 2023 –Till now Senior Database Administrator.

Responsibilities:

• Extensive experience in oracle database installations, patching, upgrading.

• Installation, Maintenance, Administration of RAC, and Standalone databases and applying patches.

• Responsible for up gradation and applying latest PSU patches according to the application requirement.

• Responsible for fixing Physical and logical data corruption using RMAN for oracle databases.

• Performed Zero down time migration of databases from on premises to AWS RDS, S3 and EC2 databases,.

• Experience with AWS Cloud services EC2, Auto scaling, IAM, RDS, CloudWatch, Redshift, Aurora, DynamoDB etc.

• Implemented database refresh using export/import for table level and full database.

• Performed RMAN backup, restore and recovery for databases.

• Experience on database Upgrade from Oracle 12c to Oracle 19c in production environment.

• Having experience in Cloning a database using RMAN.

• Having Experience in schema refresh and Database refresh using Logical backups.

• Performing regular activities like gathering statistics of Database, Rebuilding the Fragmented Indexes.

• Having Experience on Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, SQL TRACE, AWR and ADDM &ASH reports.

• Experience in configuring the Real Application Clusters (RAC).

• Experience of scripting and automation.

HCL Technology Solutions

McAfee Software Inc Bangalore, India Feb2019-Nov2021 Senior Technical Consultant

Responsibilities:

• Experience in Oracle database administration, patching, upgrading and performance tuning.

• Implemented Data guard for High availability and disaster recovery.

• Responsible for fixing archive gap issues using Data guard, along with implementing data guard broker configuration.

• Installed, configured, and upgraded Goldengate software.

• Configured Golden gate replication with zero downtime migration.

• Using data pump utilities for data migration.

• Managing undo segments redo logs, Checking alert log and trace files for errors PostgreSQL databases.

• Resolved user-reported application errors related to both Oracle and PostgreSQL databases.

• Creating and scheduling shell scripts for monitoring backups, databases, listeners and storage alerts.

• Troubleshooting and resolving the user reported application errors by validating the necessary backend database related objects.

• OEM grid installation and monitoring of databases using OEM agent. NTT Data Global Technology Solutions

Harvard pilgrim Healthcare Inc Bangalore, India Aug 2018 – Jan2019 Oracle DBA Lead

Responsibilities:

• Database performance monitoring, tuning to optimizing overall performance of the database using AWR, ASH, SQL tuning using Explain plan, TKPROF and OEM.

• Using RMAN to backup, clone, and duplicate databases and to fix block corruption.

• Implemented Shell scripts to automate mount point alerts, monitoring backup, adding space to the table space, Table space growth tracking, data guard sync status, Automating SRDC reports required to be submitted to Oracle support and few others.

• Capacity planning and maintenance of Storage using ASM.

• Implementing Golden gate replication for databases in different environments.

• Performed User management tasks and creation of DB logins/troubleshooting the login issues as reported by users.

• Performed automation of routine DBA core/Process related tasks using shell scripting as required by customer.

• Patching, Performance monitoring for Oracle RAC servers.

• Performed RMAN backups and expdp/Impdp the data using Data pump on production databases.

• Monitoring the sessions and blocking sessions/table locks and resolving the issues using SQL tuning advisor, AWR, ASH.

• Going through the day-to-day user requests and troubleshooting the database related problems. Cognizant Technology Solutions

Hartford Bangalore, India May 2014– May 2018

Technical Lead

Responsibilities:

• Installing & configuring Oracle cluster ware & Database versions 11g and 12c using RAC and ASM.

• Table space management and monitoring space related issues as reported.

• Performed User management tasks and creation of DB logins/troubleshooting the login issues as reported by users.

• Performed automation of routine DBA core/Process related tasks using shell scripting as required by customer.

• Provide support for Oracle RAC, including applying patches, cluster, and system management.

• Performed RMAN backup, restore, recovery and Data pump on production databases.

• Worked on performance tuning for long running queries using AWR and ASH.

• Performed applying patches/upgrading the databases as required.

• Monitoring the sessions and blocking sessions/table locks and resolving issues. TATA CONSULTANCY SERVICES

Lexmark Chennai, India Jan 2011 – April 2014

System Engineer - Oracle DBA

Responsibilities:

• Proactively monitoring of multi-instances servers in aspect of space, Alerts, backup/recovery.

• Creating the users and assigning the Table spaces/quotas of required size.

• Installed and managed PostgreSQL databases.

• Automated routine DBA tasks using Shell scripting for both Oracle and PostgreSQL.

• Scheduling for backup of database information and maintaining Hot Backups, Logical Backups using Exports/Imports and RMAN backups as required.

• Performed database cloning and backup/recovery using RMAN for Oracle and pg_dump for PostgreSQL.

• Implemented database refresh using export/import for table level and full database.

• Monitoring standby/data guard for redo log gaps.

• Provided support to users on database login issues/roles/privileges as reported.

• Monitoring various logs and alert files of database for any critical ORA errors.

Contact this candidate