Candidates About

                                                                                                                                                                                             

Animika Dwivedi

SUMMARY:

§  10+ years of experience in the IT Environment as an Oracle Database Administrator Providing 24/7         support.

§  Manage Oracle database administration assignments for diverse industry clients.

§  Experienced in upgrading and migrating oracle 9i,10g R2 databases to 11.2.0.1 and 11.2.0.2 on Linux5 and Solaris10.

§  Experienced in migrating oracle 11.2 databases to 12.1.0.2.0 on linux and AIX platforms

§  Excellent experience in installing and configuring oracle RDBMS and oracle client softwares using SILENT INSTALLATIONS and SOFTWARE CLONING.

§  Experience with Oracle 12c/11g/10gRAC in manufacture, insurance, financial,telecom and banking industries in both Business Intelligence/Data warehouse Systems and OLTP Systems.

§  Installation and configuration of 12c/11g/10g RAC on UNIX, solaris, HP and Windows environment.

§  Experience in GOLDENGATE replication and SHAREPLEX for migrating the databases.

§  Experienced in installing and configuring UNIDIRECTION and Bi directional replication usingoracle

     GOLDENGATE 11.2 and 12C R2

§  Involved in Installation and Configuration of MS SQL Server 2000/2005/2008 /2012/2014/2016 Versions.

§  Experience in installing and configuration of  Sybase databases

§  Experience working with data replication tools IBM CDC and informatica

§  Experience working on HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.

§  Involved in administrating multiple 24*7 Production Oracle 8i/9i/10g/11g/12c RAC Databases as well as              UAT/Dev/Test databases.

§  Experience in migrating Oracle databases from Solaris to Linux, Non-ASM to ASM and Non RAC to RAC.

§  Experience with Oracle Data Center infrastructures use commodity servers, network storage and full virtualization.

§  Excellent experience in database migrations from stand alone to 11gR2 & 12.1.0.2.0 RAC and also cross platform migrations.

§  Excellent experience in implementing data masking in oracle 11g,12c databases .

§  Experience in 11g and 12C OEM Oracle Grid Control, Quest central and Quest Fog light for databases.

§  Experience in AppWorx on Windows, LINUX, and AIX environments.

§  Experience in Writing Perl Scripting, Shell Scripting, bash scripting and Partitioning.

§  Experienced in Developing Oracle 9i/10g/11g PL/SQL Packages, Dynamic SQL, Triggers, Stored Procedures, Functions, DDL, and DML.

§  Experienced in administration setup, data migration and data dictionary reconciliation.

§  Worked on application servers Web logic, Web sphere in combination to oracle DB Oracle 10g.

§  Experience on installing and Administrating Oracle Enterprise Security Manager (ESM).

§  Experience working with Oracle E-Business Suite applications 11i & R12

§  Experience in Database Administration tools like OEM (Oracle Enterprise Manager) Grid Control and TOAD.

§  Experience in implementing ROLE based security as per SOX and OCC compliance and audit.

§  Oracle Database capacity planning, space management and storage allocation.

§  Strong Knowledge in Oracle Data ware house DBA skills relating to administration and management of VLDB environments, Oracle OLAP and Cognos.

§  Knowledge and done POC on NOSQL,MYSQL, & MONGODB databases

§  Working Experience with Hadoop & Bigdata

§  Knowledge and experience in AWS, Microsoft Azure cloud and cloud technologies

§  Strong Knowledge in People soft, SAP, Meta data & billing applications and also involved in reviewing performance reports with People soft & SAP Application developers.

§  Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN & HOT BACKUP methods.

 

TECHNICAL SKILLS:

 

Operating Systems	HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x,5,6,7,SOA servers and Windows 98/NT/2000/2003/2008/2012/2014/2016
RDBMS	Oracle 12C 12.1.0.2.0,11gRAC/10gRAC/10g/9i/8i, SQL Server 2000/2005/2008/2012, MYSQL 4.1, 5.X
Languages	SQL, PL/SQL, Dynamic SQL, C, C++, UNIX Shell Scripting, Perl Script, korn  scripting XML,GIT,JENKINS
DB Management	TOAD, OEM 9.2,11g,12c,13c, Cassandra-2.1, PostgreSQL 8.1/9.1
Tools/Utilities/Products	RMAN, OEM Grid Control 10g,11g & 12C, Ignite, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, TOAD, Patch Management, Oracle Warehouse Builder, Oracle Retek, SQLNET, ETL, Cognos, ODBC, Oracle Streams, Shareplex, Data pump, Data Guard, VERITAS Net Backup, VMware MS Office, Oracle EBS 11i/R12,Weblogic,Foglight,Precise,Informatica,TIBCO BC 5.2, TIBCO BE 3.2/5.x,TIBCO HAWK 4.9,TIBCO ADB6.x/SAP/File/MQ Adapters, Teradata V2R5, V2R6, V2R12
Tuning Tools	TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR
Database  Modeling	Erwin 4.0

 

EDUCATIONAL QUALIFICATION:

 

Bachelor of Engineering in Electronics&communications from Sri Indu College of Engineering &Technology.

 

 

PROFESSIONAL EXPERIENCE:

 

 

CLIENT      : Affinion Group,                                                                                             Jan 2016 – PRESENT DATE

LOCATION:  Wakefield, MA

POSITION :  ORACLE DBA

§  Installed and configured 2 Node RAC of Oracle 12c 12.1.0.2.0 on half rac Exadata machine x6-2.

§  Installed and configured GOLDENGATE 12.3.0.1.0 for the Bi-directional replication for high availability mission critical oracle databases.

§  Installed and configured Golden Gate 12C for cascading replication on Red hat Linux platforms

§  Expertise in debugging the oracle golden gate issues from ggserr.log and analyzing trial files using log dump utility

§  Expertise in Golden gate configuration in 12c and 11g for bidirectional, unidirectional and cascading replication

§  Maintained ASM disk groups using ASMCMD and command utility.

§  Installed and configured Oracle software using silent Installations on Exadata x6-2 server.

§  Installed and configured 2node RAC cluster databases on Exadata x2-2 & x6-2 server.

§  Performed Migration of 10TB data from windows server to Linux Exadata server using Golden Gate unidirectional method and data pump.

§  Configured Oracle Advanced Security Encryption Disk level & network level Encryption for the databases.

§  Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method

§  Installed and configured Oracle 12C Release 2 Container & pluggable databases on Linux.

§  Upgraded the Oracle 11gR2 databases to 12c databases on the AIX, Red hat Linux platform & Exadata.

§  Supported Amdocs billing Software applications on 12C databases on the AIX & HP Platform.

§  Knowledge and done POC on NOSQL,SQL, DymamoDb  & MONGODB databases.

§  Worked on Creating, Reading and Updating Data in MongoDB.

§  Configuring and monitoring replica sets in MongoDB

§  Experience in Optimizing, monitoring, and understanding of MongoDB

§  Worked on Installation and configuration of MongoDB

§  Experience Sharding setup, sharding monitoring, shard key selection, inserting large amounts of data in MongoDB

§  Performing Backup and recovery in MongoDB

§  Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.

§  Experience in managing MongoDB environment from availability, performance and scalability perspectives

§  Experience in performing Mongo DBA operational routines

§  Working Experience with Hadoop & Bigdata

§  Knowledge and experience in AWS Redshift and cloud technologies

§  Experience in a Linux environment with Apache Tomcat on Amazon AWS

§  Installed and configured MySQL on Linux and Windows environments

§  Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on  Linux (5.0, 5.1)

§  Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware

§  Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server

§  Used Netezz SQL to maintain ETL frameworks and methodologies

§  Sound knowledge with Netezza SQL

§  Participated in extraction and loading of data for Netezza data warehouses

§  Performed RMAN backup and restore for 12c R2 databases.

§  Installed and configured data guard for 11gR2 and 12c databases.

§  Installed and configured SQL Server 2008 R2/2012/2014/2016.

§  Experience working with shareplex replication

§  Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.

§  Upgraded production databases from 11g R2 databases to 12.1.0.2.0 on linux and solaris platforms.

§  Supported oracle databases for Amdocs billing applications

§  Worked and supported the Oracle ERP applications R12 & 11i on oracle 12C databases.

§  Proficient in installation and upgrading Oracle Applications11i e-business suite to R12

§  Applied patches to update and implement security fixes to Oracle E-Business Suite 11.5.5, 11.5.9, 11.5.10.2

§  Installed, upgraded and maintained Oracle ERP applications version 11.5.10.2

§  Administration of Oracle ERP applications version 11.5.10.2

§  Clones/Refreshes of 11i instances

§  Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator

§  Experience working closely with the application and developer teams and very good at communication with the teams

§  Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.

§  Extensively used Metadata & Data Dictionary Management, Data Profiling, Data Mapping.

§  Resolved issues, planned requests as point-of-contact to vendors, oversaw developers, business users, following change control procedure, reported result

§  Resolved performance issues by analyzing AWR & ADDM reports.

§  Performance monitoring using OEM grid 12c & 11g

§  Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

§  Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases

 

CLIENT      :  ALLIANZ                                                                                                                     Jan 2014 – Dec 2015

LOCATION:  RICHMOND, VIRGINIA

POSITION  :  ORACLE DBA

§  Installed and configured 2 Node RAC of Oracle 11gR2 on half rac Exadata machine x2-2.

§  Installed and configured GOLDENGATE 11.1 for the uni-directional replication for high availability mission critical oracle databases.

§  Maintained ASM disk groups using ASMCMD and command utility.

§  Installed and configured Oracle software using silent Installations on Exadata server.

§  Installed and configured 2node cluster databases on Exadata server.

§  Performed Migration of 2TB data from windows server to Linux Exadata server using Golden Gate unidirectional method and data pump.

§  Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method

§  Installed and configured Oracle 12C Release 1 on Linux.

§  Upgraded the Oracle 11gR2 databases to 12c databases on the AIX platform.

§  Supported People Soft applications on 12C databases on the AIX Platform.

§  Performed RMAN cloning using Active database feature in 11gR2 databases.

§  Installed and configured Physical standby databases for 11gR2 databases.

§  Installed and configured SQL Server 2008 R2.

§  Configured Transactional Replication and SQL server log shipping on SQL server 2008 R2.

§  Installed and configured Shareplex 8.0 on Linux server

§  Experience working with shareplex replication

§  Worked on Installation and configuration of MongoDB 2.4 versions

§  Performing Backup and recovery in MongoDB

§  Experience working with informatica data replication 9.6.2 version for the oracle 12c databases

§  Working Experience with SOA servers and file transfers using SFTP between the servers

§  Experience in setting up Oracle Advanced Security data encryption and integrity features 

§  Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.

§  Experienced in Automation using korn & Shell Scripting.

§  Upgraded more than 30 production 10g databases to 11.2.0.4.1 on linux and solaris platforms.

§  Supported oracle databases for people soft, Sap applications and Siebel CRM.

§  Created and enhanced the SAP roles, user Accounts in CUA (Central User Administration) environment, used SCAT for bulk changes in testing system

§  Monitored all production systems using SAP Solution Manager (Solman) and fixed issues, also scheduled the background jobs needed for the project and dealt with the job fails if any

§  Performed SAP EHP 5.4 Installation on windows server 2008 R2 with Oracle 10g

§  Configured SAP to enhance functionality and reporting

§  worked with SAP profile Generator

§  Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator

§  Experience working closely with the application and developer teams and very good at communication with the teams

§  Resolved issues, planned requests as point-of-contact to vendors, oversaw developers, business users, following change control procedure, reported result

§  Resolved performance issues by analyzing AWR & ADDM reports.

§  Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

§  Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases

 

 

    CLIENT:       LEXIS NEXIS                                                                                              MAY 2012 – Dec 2013

     LOCATION: MIAMISBURG, OHIO

     POSITION:  ORACLE DBA  

§  Installed and configured 2, 3 & 4 node oracle 10g and 11gR2 RAC on Red hat Linux 5 for databases upto 3TB on ASM. Provided 24/7 production support to over 300+ databases ranging from oracle 10g to 11gR3 in Linux, solaris and AIX.

§  Maintained ASM disk groups using ASMCMD and command utility.

§  Performed Database Refreshes from Production to Test and Development environments using Clone process by RMAN Duplicate.

§  Installed and configured OEM 12C Grid control for monitoring all Production and cert databases.

§  Installed and configured Oracle 12C databases on Solaris Platform.

§  Experience working on performance tuning on Oracle 12C databases.

§  Installed and configured GOLDENGATE 11.1 for the uni-directional replication for high availability mi