GEETA KHANNA ( Green Card holder)

Email:adnew0@r.postjobfree.com #404-***-****

SUMMARY:

(Oracle 10g Certified Professiona0 senior Database administrator (DBA) with more than 19 years of extensive experience in Capacity Planning, designing, testing and supporting database solutions in Multi database environments such as Oracle RAC on VMware and 9i, 10g, 11g, 12c, 18c and 19c with Sql Server and MSSQL Excellent communication skills, Experience in managing and mentor DBA team. Expert in Enhancing database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups and ensure technical and functional designs meet business requirements. Learning about Oracle Database Cloud Services and AWS.

TECHNICAL SKILLS:

Systems & Databases

Sun Solaris 8,9,10, HP UNIX, and Linux Red Hat 5 & Windows XP VMWare, worked for few months on AIX. ASM, Oracle 8i/9i/10g/11g/ 12c,18c and 19c SQL SERVER, MYSQL

Environment

Oracle Data Warehouse RAC 18c/12c/11g, Active Data Guard 18c/12c

Applications

PeopleSoft Financials, Oracle Portal Application, Banner systems. Oracle CRM Application 11i, DSS, E-Business-Suite Oracle Data Warehouse Oracle RAC 18c & 12c., OBIEE & EBS, Financials 12.1.3 and Oracle PeopleSoft HCM/CRM 9.2 and People tools 8.53/8.54. BANNER 8 & 9.

Tools

OEM Cloud control 13c, OEM 12c, 11g, Quest Stat 5.5, People tool 8.4, Sql Developer, TOAD, Delphix, vPlex. ETL and Hadoop.

Utilities

SQL Loader, TKPROF, Data pump, exp/imp, Sql analyzer, RMAN 8i/9i/10g/11g/12c and 18c

Replication

Streams10, 11g and Golden gate 18c, 12c and 11g

EDUCATION:

Bachelors of Science in Computer & Masters of Science – Computer

EMPLOYMENT:

HISCOX (Role: Sr. Oracle DBA)

19c upgrade for non data guard and data guard environment on Linux for SE and EE 12c .

Databases on Linux platform. Set up of OEM 13c cloud control for monitoring all DBs

Administration of Primary and secondary databases in Data guard environment.

RMAN backup and restore from production to give copy to developers for testing.

Performance and tuning of application related queries by working closely with developers.

Day to day DBA activities, service tickets and objects creation and validations. Partitioning of large tables. Data Migration and Replication using golden gate.

PNC Bank (Role: Senior DBA Lead)

18c Upgrade from version 12.2 on Linux Platform., Administrating Oracle RAC database 12c, 18c and Active Data Guard, Configuration management, performance tuning and administration of mission critical production databases.

RMAN backup and recovery, performance tuning, migration, data configuration and security administration using 13c Cloud Control, Golden Gate Active-Active and One way replication implementation. Day to day DBA activities including Tickets, on call rotation, working closely with Developers to work on performance and tuning of Application code.

State of Georgia (SOA) (March 2019-October 2019)

Administration of two Nodes RAC Database for Peoplesoft Application 9 version, Administration of Golden gate for replication using 13c CLOUD CONTROL.RMAN backup & recovery testing for using only control file not catalog, Cloning, restoring of Databases from production for testing/report purposes.

Active data guard for reporting databases, Administration of ASM. Database Monitoring. Patching, Partitioning, tune queries which performing slow. Exadata implementation in Development environment, proposed by ORACLE. Constant efforts for performance and tuning for custom code and provided by Peoplesoft.

STLCC, St. Louis, MO (July 2018-March 2019)

Banner 8 Administration & Banner 9 Administration, Upgrade from banner 8 to banner 9. Patches and banner security administration. Banner Enterprise Identity Services (BEIS). Single Sign-on Configuration/Support (SSO) and Operational Data Storage (ODS) . Installation Oracle 18c Enterprise cloud control-using ASM to use for monitoring purpose. Active Data guard for reporting and golden gate for Replication.

Migration of Oracle databases from HP-UX to Red hat Linux. Administration of Data warehouse Databases and ETL procresses. OBIEE & EBS, E-Business Suite.

ORPINE INC, Atlanta, GA (April 2012-July 2018)

Clients:

FLEETCOR, Atlanta GA (08/2017-07/2018):

Supported Production 12c and 11g databases. GoldenGate Administration. Daily operational tickets & closely working with Developers on tuning of SQL queries, Objects creation in Dev/QA & Production. ASM Administration, Active Data Guard, Performance tuning & monitoring OEM 12c. Capacity Planning and sizing for future growth of objects in databases, tickets to implement changes of code along with modification and creation of objects in development as well as production environment, Oracle Advanced Security, data encryption.

ERICCSON, Atlanta GA (04/2016-07/2017) :

Consolidation and build next generation database platform on Oracle Exadata 12c, Active Data Guard Administration. RAC administration of multiple nodes. Performance enhancement. Database design, Partitioning, Replication using GoldenGate /Shareplex.

COTIVITI, Atlanta, GA (04/2014-04/2016) :

GOLDNEN GATE administration Cloning & Refreshing of databases using RMAN, HUR and export/import, Audit reporting for all production databases, Worked on VLDBs, Usage of Oracle Identity & Access Management. Taking snapshots of database using DELPHIX, SQL SERVER database administration.

TVA, Knoxville, TN (01/2013-03/2013) :

Day to day activities of Change requests, testing and closely working with developers. Table partitioning for archiving the old data based on years in data warehouse system. Refresh/clone of databases for testing and training, validating backup using RMAN.

MCKESSON, Atlanta, GA (04/2012-12/2012):

Refresh/restore of DBs for testing and training, validating backup using RMAN. Monitoring of databases in OEM Grid control, Troubleshooting required for testing. Managing RAC environments & ASM.

GEORGIA STATE UNIVERSITY, GA (June 2008- April 2012)

Administration of BANNER Databases on 11g, Administration of PeopleSoft using performance monitor and OEM grid control. Administration of Portal and Applications on operating,, Table partitioning for archiving the old data based on years. Implemented Oracle 10g, 11g Streams. Active Data Guard for replication and high availability. Implementation of OWB, APEX in Data warehousing. Worked on Quest stat software for change management version control, RMAN backup encryption using Oracle Advanced security features.

Worked on DSS project bases on data ware housing using OWB and Oracle Application Portal. Partitioning of big tables for archiving purpose.

OBIEE and EBS and E-Business Suite Application.

HORIZON COMPUTER SRVICES, EDISON NJ (Feb 2007-June 2008)

Clients:

DHL, Scottsdale, AZ (09/2007-06/2008)

Installation of 10g RAC on Linux, On call rotation to provide 24/7 support, Implementation of data guard setup for standby databases., Consolidation of Dev/Test Environment, Performance. Optimisation of SQL scripts. Using Oracle Enterprise Manager, Explain Plan, TKPROF. Setting up OEM alerts and e-mail notifications.

Disney World, Orlando, FL (06/2007-09/2007)

Planning of Disaster Recovery for production databases-9i and 10g databases with day to day activities. Tools like TKPROF, 10g Tuning Advisor, segment advisor, ADDM like features of 10g for performance issues.

Jewellery Television, Knoxville, TN (01/2007-06/2007)

Physical Database Design, RMAN backups, Export/Import to migrate data. Configured and scheduled RMAN jobs, Installed and scheduled STATSPACK for collecting database performance statistics, Responsible for Performance Tuning at system level, database level and application level, Performance. Optimisation of SQL scripts. Using Oracle Enterprise Manager, Explain Plan, TKPROF. Setting up OEM alerts and e-mail notifications.

COMVERSE, Gurgaon, India (Jan 2005- Jan 2007 ) .

AIRTEL, Gurgaon, India (June 2002-June 2005)

NIIT, Singapore (May2001-May 2002)

Contact this candidate