Candidates About

 

Swati Madhuri

Summary:

•       Having 8 years of experience in Administering Oracle Databases, experience on Oracle E-Business Suite R12, 11i and development.

•       Have a good working knowledge of Oracle database and Application installation on Linux Platform.

•       Establish and maintain sound backup and recovery policies and procedures using RMAN.

•       Worked extensively on backups (Exp/Imp, Data pump (Expdp/impdp), Cold Backup and recovery.

•       Performed health checks and proactive monitoring using Oracle Enterprise Manager/Grid Control and UNIX shell scripts.

•       Worked on Patching, Application cloning, patch analysis, backups, RMAN, restorations (tape, disk).

•       Worked with utilities like SQL Plus, Oracle Database Assistance, Oracle Enterprise Manager for monitoring database performance.

•       Strong knowledge and experience in disaster recovery failover/switchover procedure. Oracle data guard hands-on support.

•       Worked on Rebuilding the Disaster Recovery systems with and without Data Guard Broker.

•       Configured and maintained multiple standby servers.

•       Monitoring and troubleshooting Database and EBS application performance issues.

•       Experience in working for large Oracle databases.

•       Worked on performance tools like AWR, ADDM, ASH.

•       Developed, implement and maintained automation using scripting languages (Shell script) in a UNIX environment.

•       Participated in the planning, analysis, design, implementation, maintenance, and control of the organization's databases.

•       Strong experience with Database performance tuning.

•       Worked on Data migration, Schema Creation, Ongoing Schema Maintenance (Reorg) and Tablespace management (ASM).

•       GoldenGate configuration review, implementation, test and performance analysis and tuning.

•       Installed and configured Golden Gate software, patching, created manager, extract, replicate parameter files and tested the data flow from source to target database

•       Experience in basic and advance replication using Oracle Golden gate.

•       Continuous review of Business-Critical Database to proactively identify space issues, performance tuning issues.

•       Worked on R12 upgrades (11.5.10.2 to 12.1.3) on all DEV, Stage and Production Instances.

•       Patching, Cloning and Oracle 11i applications Maintenance activities using ad utilities.

•       Setup, support and manage Oracle E-business Suite applications and databases in production, test and development environments.

•       Thorough understanding of Oracle EBS Services management and start-up or shut-down trouble shooting.

•       Created and Managed Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions, views, indexes, user accounts, roles, grants and performing day-to-day operations.

•       Involved in timely java upgrades.

•       Worked on Parallel Concurrent Processing, custom top creation and database links creation.

•       Linux installation, creating mount points, configuration of server.

 

Technical Skills

 

Databases                               :           Oracle 10g, 11g, 12c, MySQL, SQL Server 2005, 2008R2

Oracle Applications               :           Oracle Applications R12 and 11i

Tools                                       :           SQL Loader, SQL *Plus, EXP/IMP, EXPDP/IMPDP, RMAN

Operating Systems                :           Linux, UNIX, OEL, AIX, Solaris and Windows

Web Technologies                 :           HTML, CSS, PHP and JavaScript

 

Professional Experience­

 

Client: Broadridge Financial Solutions, El Dorado Hills, California

Designation: Oracle DBA

Duration: June 2017 – Present

 

Responsibilities:

·         Worked on server validations such as validating File system, Operating System, network and firewall.

·         Worked on OEM 12c for Database Performance Monitoring and Tuning.

·         Worked on Oracle Enterprise Manager 12c.

·         Rebuild indexes and add/rename, resize data files in table spaces.

·         Created schemas, users, profiles, roles.

·         Managing database security and users, Creating and assigning appropriate roles and privileges to user.

·         Monitoring Alert logs to overcome the errors and warnings recorded.

·         Developed SQL scripts for database cold and hot backups.

·         Tuned SQL statements for the efficient uses of Indexes.

·         Created and maintained indexes, used SQL trace, Analyze, Explain Plan utilities.

·         Created Crontab in Linux to run the shell scripting.

·         Provided technical support to development team for database issues.

·         Memory Management across all the environments.

·         Performed regular maintenance activities like backup and recovery operations.

·         CPU Patching applied on all the application and DB instances on quarterly basis.

·         Applying latest patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.

·         Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.

·         Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.

·         Scheduled the Rman Backup scripts in a cron job.

·         Created checkpoint table, did Data load using Expdp/Impdp for replication in Golden gate.

·         Implemented Bidirectional Replication using Oracle Golden Gate.

·         Added new tables for OGG replication in the current running extract and replicat

·         Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Applications

·         Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.

·         Installed the Oracle 10g, Oracle 11g databases and Created Tablespaces on ASM environment.

·         Installed, configured and written scripts for RMAN backups

·         Daily DBA activities as Performance Monitoring, Instance Health Check etc.

·         Provided 24*7 Production support in Oracle Production Databases as well as Oracle Applications environments.

·         Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

 

Environment: Oracle 12c, 11g, Oracle E-business Suite R12 (12.2.5, 12.1.3, 11.5.10.2), OEL, Red Hat Linux ES6, AIX 5, SQL *Plus, SQL Loader.

 

Client: Global Payments, Atlanta, Georgia

Designation: Oracle Consultant

Duration: Aug 2014 – Jan 2016

 

Responsibilities:

·         Installed and Created Oracle Databases in LINUX and Windows servers.

·         Managing Oracle Database users. Activities includes creation, alter and dropping users, controlling resource use with profiles. Granting and revoking privileges, creation and assigning roles, Auditing user activities and session management.

·         Configuring Flashback Database in a standby database to open it in read write mode and reverting it back to standby mode by using restore points.

·         Space management by resizing or adding datafiles to tablespaces in both Production and standby.

·         Created a new database and its standby for a new project that went live.

·         Reorganization of tables and Indexes.

·         Creating and Resolving Database links, TNS entry issues and listener related issues.

·         Performance monitoring of Production databases using ADDM report, AWR and ASH Reports

·         Monitoring and providing support during End of Day batch processing activity.

·         Plan stability for SQL statements using stored outlines and SQL plan management.

·         Schema refreshes by exp/imp and Datapump utilities.

·         Conducted DR-DRILL for databases.

·         Portioning of tables and maintaining of partitioned tables/indexes, merging and splitting partitions.

·         Managing redo logs, archive logs and Monitoring archival mount points and taking archival backups to tape

·         Restoring and recovering hot backups on a different server for reports.

·         Responsible for support and maintenance of the Oracle Applications R12 and 11i.

·         Worked on AD utilities, patching techniques and cloning of Oracle Applications environments.

·         Worked on R12 upgrades (11.5.10.2 to 12.1.3) on all development and Staging environments.

·         Cloning database and applications.

·         Upgraded RAC Databases from 11.2.0.3 to 11.2.0.4.

·         Maintain 11gR2 Grid Infrastructure for RAC databases.

·         Created custom top, worked on Migration tasks and java upgrades.

·         Implemented PCP.

·         Perform regular maintenance activities like backup and recovery operations of database servers on Sun Solaris environment.

 

Environment: Oracle 11gR2 RAC, Oracle E-business Suite R12 (12.2.4, 12.1.3, 11.5.10), Sun Solaris, SQL *Plus, SQL Loader.

 

Client: Kaycan (EBS Support), Alpharetta, Georgia

Designation: Oracle Consultant

Duration: Jan 2014 – July 2014

 

Responsibilities:

·         Involved in upgrading oracle production 12c database from 11.2.0.4 to 12.1.0.2.

·         Maintain all the databases and applications to the latest quarterly security patches (till previous quarter)

·         Includes 24*7 production support for various 11g (11.1.0.7) and 12c databases with RAC and single instances.

·         Worked on shell scripting to automate various development environments refresh from production environments.

·         Created shell scripts to automate backups for various production and development databases using RMAN.

·         Maintenance of Test and Production environments.

·         Installed and configured Golden Gate software, patching, created manager, extract, replicate parameter files and tested the data flow from source to target database.

·         Converting classic Extract to Integrated Extract.

·         Migration and upgradation using Oracle Golden Gate.

·         Experience with AD utilities, patching techniques and cloning of Oracle Applications environments.

·         Cloning oracle database and applications.

·         Perform regular maintenance activities like backup and recovery operations of database servers on Sun Solaris environment.

·         Concurrent Manager monitoring and administration.

·         Patch Impact Analysis and patch management.

·         Regular health checkup of database including space management.

·         Backup’s including cold, hot and RMAN backup.

·         Monitoring ETL status of all the environments.

·         Migrating RPD and catalog from test to production.

·         Migrated user from test to production environment.

·         Upgrading RPD and catalog

·         Configured ODBC connections for RPD

·         BIAPPS migration from production to test environment.

 

Environment: Oracle 11g, 12c, Oracle E-business Suite R12 (12.1.3), AIX Linux, SQL *Plus, SQL Loader, Oracle Business Intelligence Applications Version 7.9.6.4, Windows Server.

 

Client: Biogen, Alpharetta, Georgia

Designation: Oracle Consultant

Duration: Oct 2013 – Dec 2013

 

Responsibilities:

·         Upgrade of Oracle database from 11g to 12c.

·         Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, deadlocks, CPU, I/O, memory.

·         Manage and maintain high volume transactional tables and indexes, database reorg.

·         Administration of Oracle Enterprise Manager like monitoring the databases, invalid objects, blocking sessions, server load, locks, long running sessions, scheduling jobs and alerting based on the metrics.

·         Performance tuning of Database like SQL tuning using AWR, ADDM, ASH reports and TKPROF utility.

·         Troubleshoot Concurrent programs, JVM OutOfMemory issues, forms issues and Workflow related issues.

·         Provided Application and Concurrent Manager load-balancing, failover, User creation, Roles and Managing Security & Concurrent Managers administration.

·         Configured DR setup for R12.2.3

·         Maintenance of the disaster recovery environment.

 

Environment: Oracle 11g, 12c, Oracle E-business Suite R12 (12.1.3), OEL.

 

Client: Care Hospitals, Hyderabad, Telangana

Designation: Oracle DBA

Duration: Aug 2010 – Oct 2013

 

Responsibilities:

• Responsible for the support and maintenance of 14 Oracle databases along with 2 physical standbys for each database in high availability (24*7) heterogeneous environment across all over India.
• ­Installation and Configuration of Oracle 11g, created databases manually and using Database Configuration Assistant (DBCA).
• Installed and configured the Oracle server on the client side.  
• Worked on Oracle Enterprise Manager 12c
• Performed sysaux rebuild on all DEV, QA and UAT instances.
• Performing Pre Patch Analysis for all the patches that needs to be applied.
• Granted privileges to Oracle Users depending upon the requirements and worked on Oracle Space (adding, Dropping, resizing datafiles and tablespaces) and Instance Management. (Increasing parameter sizes, creating SP file, creating Pfile from Spfile and Spfile from Pfile).
• Worked on data migrations.
• Developed RMAN shell Script to Perform Backup of the whole database once in a week and daily incremental backup.
• Configured the SPFILE parameter per the new requirements.
• Use of Data pump to import and export the data in Oracle database.
• Developed Shell Script to gather the Statistics of the Database to update the Data dictionary tables to improve the performance of the queries.
• Upgradation of the Database form 10g to 11g.
• Responsible for end user Support, Troubleshooting and Bug fixing of existing applications
• Responsible for data conversion and data loading using SQL*Loader
• Used TOAD to check the performance of SQL statements.
• Participated in DBA activities like performance tuning, creation of Data files, table spaces, tables, views, synonyms, DB link etc.
• Implemented Active DATA GUARD.
• Migrated oracle database from windows server to Linux servers.
• Installed, configured and administered Oracle Applications ERP R12, 11i in a Multi-tier architecture.
• Cloned Oracle Applications using Rapid Clone and RMAN.
• Good experience in applying patches, Created and Managed Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions, views, Indexes, user accounts, roles, grants and performing day-to-day operations and involved in timely Upgrades of Oracle Applications to the latest versions.
• Experience with AD utilities, patching techniques and cloning of Oracle Applications environments.
• Upgrade database from 10g to 11g.
• Cloning database and application.
• Perform regular maintenance activities like backup and recovery operations of database servers on Sun Solaris environment.
• Rebuild indexes and add or rename, resize data files in table spaces.
• Created schemas, users, profiles, roles
• Managing database security and users, Creating and assigning appropriate roles and privileges to user.
• Monitoring Alert logs to overcome the errors and warnings recorded.
• Developed SQL scripts for database cold and hot backups
• Job scheduling for snapshots.
• Tuned application's SQL statements for the efficient uses of Indexes. Created and maintained Indexes. Used SQL trace, Analyze, Explain Plan utilities
• Created Crontab in Linux to run the shell scripting
• Worked with utilities like SQL *Plus, Oracle Database Assistance and Oracle Enterprise Manager for monitoring database performance.
• Provided support for Mongo databases and worked on time maintenance activities.

 

Environment: Oracle 10g and 11g, Windows, OEL 5.4, Oracle E-business Suite R12 (12.1.1, 12,1.3), SQL *Plus, SQL Loader.

 

Client: JNT University Kakinada, Kakinada, Andhra Pradesh

Designation: Web Developer Intern

Duration: Apr 2009 – Mar 2010

 

Responsibilities:

• ­­Developed web pages in PHP for University website.
• Worked on Results processing section.
• ­Worked on internal software’s.

 

Environment: PHP, HTML, CSS and MySQL

 

Academic Projects­

 

Client: Habits Technologies, Hyderabad, Telangana

Designation: Intern

Duration: Feb 2008 – Jan 2009

 

Responsibilities:

• ­­Worked on developing websites using PHP, HTML and Java.
• Developed Java scripts and CSS files.

 

Environment: PHP, HTML, CSS and MySQL

 

Education­

 

Master of Science in Management Information Systems                                                                      

University of Illinois, Springfield, IL                                                                                                      May 2017

 

Master of Computer Applications                                                                                                              

AIET, Vishakhapatnam, India                                                                                                                 May 2008  

 

Bachelor of Science in Mathematics, Statistics, Computer Science

Gayatri Vidya Parishad Degree College, Andhra Pradesh, India                                                          April 2005