York University Oracle

Location:

Trenton, NJ

Posted:

October 27, 2021

Contact this candidate

Resume:

Abhinav Tiwari

https://www.linkedin.com/in/abhinav-tiwari-7b781329

ado6ka@r.postjobfree.com • 848-***-****

SENIOR-LEVEL ORACLE DATABASE ADMINISTRATOR

A distinguished leader with specific emphasis in Oracle database technologies. Expertise includes over 13+ years working with the Oracle database in database administration, project management, resource management, database design and architecting. Solid background managing projects, demand and resource capabilities and managing budgets for global database technology needs. Demonstrated success leading and mentoring senior to junior level database administrators having skill sets in Oracle RAC, GoldenGate Microservices, Middleware, Exadata, Amazon AWS, GoldenGate, R12, DB2, SQL Server and Progress database technologies.

SKILLS

Operating Systems: HP-UX 10.x, 11.x, SLES (11,12), Red Hat Linux RHEL (7,8) and Windows 10

RDBMS: Oracle 19c,12c/11g/10g/9i/8i. Oracle 11i OBIE and R12.1

Languages: Shell, PLSQL, PYTHON, Ansible

Replication Software/ Tools /Utilities: RMAN, OEM, DATA PUMP, Dataguard, GoldenGate, GoldenGate MicroServices

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Profile (Base Line)

Database Modeling: Rational rose, Toad Data Modeler, Datanamic and start UML, ER/Studio

Other: Clear Quest

EXPERIENCE

ADP, Roseland NJ January 2016 – Till Date

Senior Oracle Database Admin with Oracle Cloud, RAC, Middleware, AWS Cloud, GodenGate & Exadata

Provided afterhours 24x7 database support. Managed product development / implementation. Primary on Oracle RAC 19C. Implemented 13c Monitoring and Maintenance. Designed highly available, scalable, Secure and resilient solutions to meet business requirements.

Designed databases and automated processes to keep the business module running efficiently in cost effective way.

Installed and Configured GoldenGate MicroServices.

Worked on 19c migration and maintenance.

Installed and configured 19c database on Linux and configured OEM 13c Monitoring.

Applied Cell level patches and updated firmware on Oracle Exadata.

Oracle Infrastructure and Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers Configuration of multiple ERP Cloud prototypes (Financials and Procurement Cloud).

Created

Implemented Security policy enhancement through roles, profile, privileges and password policies as per business requirements.

Implemented transparent database security (TDE). Used TDE with both Encrypted columns and Tablespaces.

Installed and configured Oracle GoldenGate Homogeneous and Heterogeneous replication.

Configured GodenGate Micro Services for easy manageability.

Configured Bi-Directional GoldenGate replication resulting in zero down time on Database Migration.

Troubleshooting of Oracle Advance replication which involves GoldenGate, Dataguard etc.

Provided Oracle RAC consulting and engineering to internal organizations for planned implementations and migrations.

Migrated database using RMAN, GoldenGate and Data Pump.

Supported end to end cloud Migration of Oracle Databases, resulting in reduction of physical hosts and cost.

Performed SQL tuning during the performance issues by utilizing SQL profile, AWR, Explain Plan etc.

Installed and administered PostgreSQL Databases.

Migrated Test, UAT, IAT and Production databases on Oracle Cloud.

Planned and migrated High Volume and High transactional database on Amazon AWS Cloud with minimum down time.

Designed the CPU including IOPS allocation per database.

Worked on taking Volume Level Snapshot of environments running on AWS Cloud.

Scale and load distribution on AWS Cloud.

Oracle Corp, New York, NY April 2015 - December 2015

Senior Oracle DBA with Oracle RAC, Middleware, GodenGate & Exadata

Provided afterhours 24x7 database support. Configured Unidirectional and bidirectional Oracle GoldenGate replication. Installed and supported Homogeneous and Heterogeneous replication on Oracle GoldenGate.

Applied Patch and upgraded Oracle RAC Databases.

Applied Cell level patches and updated firmware on Oracle Exadata.

Configured one to many GoldenGate replication processes.

Installation and configuration of Oracle Multi node RAC (max 6 nodes) architecture.

Planned and patched Exadata X4 full Rack Design.

Migrated Oracle RAC databases with minimal down time.

Proactively perform capacity planning including scaling.

NYU (New York University), New York, NY Feb 2013 - March 2015

Senior Oracle DBA with Oracle RAC, Middleware, GodenGate

Applied Patch and upgraded current Oracle RAC Databases.

Build, configure, debug and support SOA 10.X 11g and fusion middleware applications such as OSB, in a multi-instance hosting environment.

Manage the functionality and efficiency of all Middleware/SOA servers and SOA based application

Applied Cell level patches and updated firmware on Oracle Exadata.

Configured one to many GoldenGate replication processes.

Installation and configuration of Oracle Multi node RAC (max 6 nodes) architecture.

Planned and patched Exadata X4 full Rack Design.

JP Morgan Chase NJ Feb 2012 - Jan 2013

Senior Oracle DBA with Oracle RAC, GodenGate & Exadata

Performed installation and configuration of oracle 11g R1/10g on HP-UX, UNIX RHEL 5.x series. Configured Unidirectional and bidirectional Oracle GoldenGate replication. Configuration and Implementation of Oracle Golden Gate.

Designed backup solutions, disaster recovery plans, and performance tuning advice for RAC implementations.

Provided Oracle RAC consulting and engineering for planned implementations and migrations.

Administered Oracle Exadata X2-8 (Quarter, Half &Full architecture) configuration, maintenance, support.

Configured various Oracle Exadata Database Machine.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands.

Implemented Data Guard with performance configurations and participated in Data Guard Fail over tests.

SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.

Citco Hedge Fund, Jersey City, NJ Nov 2010- Jan 2012

Senior Oracle DBA

Installed and configured oracle 11g R1/10g on HP-UX, UNIX RHEL 5.x series. Configured Unidirectional and bidirectional Oracle GoldenGate replication. Configuration and Implementation of Oracle Golden Gate.

Installation, configuration and monitoring of a 3 node RAC environment.

Administered Oracle Exadata X2-8 (Quarter, Half &Full architecture) configuration, maintenance, support.

Configured various Oracle Exadata Database Machine.

Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.

E-Biz Technocrats, Gwalior (India, M.P) June 2008 - Oct 2010

Senior Oracle DBA

Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures. Implemented and administered multi–Node Oracle RAC architecture. Applied Patch and upgraded current Oracle RAC Databases.

Resolved Block re-mastering issues.

Troubleshot Database Replication issues.

Performance tuning of Oracle Database Objects by fixing row chaining.

Identified performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Rebuilt Indexes for better performance, maintenance of Oracle Database.

EDUCATION

Bachelor of Science - SVITS INDORE INDIA (Year-2008)

Trainings

Oracle Grid Infrastructure Manage ASM

Oracle Certified Professional (OCP)

Oracle OEM Grid control 12c

Oracle 11g R2 Data guard

RAC Administration Release 2

Mongo DB

AWS RDS & EC2

Oracle GoldenGate 12c

Trained on Oracle Exadata

Oracle Exadata.

Trained on PostgreSQL

Oracle Fusion Middleware 12c

Oracle Database Security

Oracle Database 11GR2 - Clustering Installation and Configuration

Accomplishments (2021)

Designed a consolidated Database group to improve efficiency by 85%.

Tested databases to identify and resolve related to performance.

Migrated 1700 Production databases on Cloud with Minimal down time.

Designed process to Migrate 12000 Oracle Enterprise Manager 12c targets to latest 13c Version.

Contact this candidate