Database Administrator.

Abhijit Kothari

*********@*****.***

703-***-**** (Cell)

Page 1 of 4

SUMMARY:

** ***** ******* ** ********** out of which 14+ years with expertise in Oracle Database Administration.

CompTIA Security+ CE Certified

AWS Certified Solutions Architect - Associate

Oracle Certified DBA for Oracle 11g database

Extensive knowledge on database administration for Oracle 10g, 11g and 12c on a wide range of operating systems (Windows, UNIX, Sun Solaris, AIX, Linux).

Experience with very large scale database environment and mission critical large systems.

Experience in full life cycle development of enterprise level applications.

Experienced in database design, development, and maintenance.

Experience in maintaining data warehouses and creating data mining routines.

Providing 24x7 DBA support for Production and Development environments.

Upgraded and migrated databases from Oracle 11g to 12c

Expertise in Oracle Backup and Recovery techniques using export/import and RMAN.

Extensive Performance tuning of oracle queries.

Experience in advance technologies Oracle ASM/ Data Guard/ RAC / Streams.

Expertise in installing, upgrading and maintaining OEM/Grid Control 11g, 12c & 13c

Expertise in Oracle PL/SQL (Procedure/functions/Packages/Triggers) Programming

Expertise in installing, configuring and maintaining Informatica 9.0.1/9.5/9.6.1/10.1, OBIEE 11g/12c /DAC/OBIA 11g environments

Expertise in installing, configuring and maintaining Oracle EBS R12 environment

Experience in Shell script/Perl Script.

Experience Managing Hadoop Cluster, HDFS, Spark.

Experience installing PostgreSQL, migrating data from Oracle to PostgreSQL

Dedicated and Motivated Individual who delivers quality products on time

Takes ownership of product from beginning to end and does everything to meet or exceed SLA’s

Good Communication and Interpersonal Skills.

EDUCATION : B.E. Electronics – 1996 – Visvesvaraya National Institute of Technology (VNIT),

(formerly known as VRCE), Nagpur, India.

VISA STATUS : US Citizen, DHS Public Trust Security Clearance TRAINING

SQL Server MCSA Boot Camp Training 2019 Microsoft, WV, USA Hadoop Administration Certification Training 2016 Edureka.co Leadership Training for Managers 2016 Dale Carnegie, Tysons, USA Oracle Database 12c Admin, Install and Upgrade Accelerated 2015 Oracle, Reston, USA Management STEPS training 2013 Verisign, Reston, USA R12.x Oracle Applications System Administrator Fundamentals 2013 Oracle, Belmont, USA Oracle Database 11g: Performance Tuning 2012 Oracle, Reston, USA R12.x Install/Patch/Maintain Oracle E-Business Suite 2012 Oracle, Reston, USA Abhijit Kothari

*********@*****.***

703-***-**** (Cell)

Page 2 of 4

CERTIFICATIONS

1. CompTIA Security+ CE Certified

2. AWS Certified Solutions Architect - Associate

3. Oracle Certified Professional - (OCP-DBA) for Oracle 11g 4. Oracle Certified Professional - (OCP-DBA) for Oracle 10g/ 9i/ 8i/ 8/ 7.3 TECHNICAL SKILLS:

DBMS/RDBMS : Oracle 10g/11g/12c, SQL Server, PostgreSQL DBA Tools : Export/Import, SQL*Loader, RMAN, OEM/ Grid Control 11g/12c/13c Languages : SQL, PL/SQL, Shell script/Perl Script, Java. Operating Systems : Windows, UNIX, Sun Solaris, AIX, Linux. Tuning Tools : AWR, ADDM and TKPROF

Third Party Tools : SQLLAB, TOAD, Erwin, Informatica Big Data : HDFS, Hive, Impala, Spark, YARN, Cloudera Manager WORK EXPERIENCE:

Database Specialist, Synergy BIS, VA June 2019 – Current Client : US Coast Guard, WV, USA

Fingerprint adjudication and US Coast Guard (DHS) Public Trust Security Clearance completed. Responsibilities involve:

Installing OEM 13c to verify STIG Compliance for Oracle Databases

Leading Tiger team to resolve performance issue users are experiencing while using the Vessel Documentation System.

Sr. Operations DBA, Verisign Inc, VA Jan 2010 – Apr 2019 Corporate Information Systems : CIS manages multiple systems/production databases that support the business application systems for the entire company which includes Oracle E-business Suite for Finance/Procurement, Enterprise Data Warehouse, Time management system, Equity Edge, Quality Center, Essbase/Hyperion reporting.

Responsibilities involve:

Technical Lead for Oracle DW databases, Informatica, OBIEE/OBIA, Clarity, Intranet Apps

Production support of 10 oracle databases including 3 TB Enterprise data warehouse Oracle database

Maintaining/Monitoring/Backing Primary and standby Oracle production databases

Installing Oracle Database 12c on Linux

Upgrading Oracle database 11gR2, 10gR2 to 12c on Linux

Maintaining/Monitoring/Refreshing Oracle Dev/Test/UAT databases

Installing/Monitoring/Maintaining/upgrading Informatica 9.0.1/9.5/9.6.1/10.1 Environments

Installing/Monitoring/Maintaining OBIEE 11g/12c production environment for HR reporting

Installing, configuring and maintaining Oracle E-Business Suite R12 environment Abhijit Kothari

*********@*****.***

703-***-**** (Cell)

Page 3 of 4

Setting up Oracle Business Intelligence application (BI Apps) 7.9.6 for Finance and Procurement.

Installing, upgrading and maintaining OEM Grid control 11g/12c/13c for monitoring Oracle databases

Installing and maintaining OEM Plug in for E-Business Suite.

Create Business case for Management review for new Oracle Products.

Ongoing support for optimizing and automating operational processes and configurations to minimize accidental incidents and alleviate problem management.

Working with stake holders to meet production deployment dates and schedules

Setting up/testing Avamar backup for production databases.

Supporting Internal/External Audits (Quarterly/SOX) and Oracle/Informatica License reviews.

On-call rotation to support the production environment. Environment: Oracle 10g/11g/12c on Linux/AIX server, Oracle EBS Suite, OBIEE 11g/12c, Informatica 9.6.1, OEM 11g/12c/13c, Clarity, Quest STAT Primary Oracle DBA, Credence LLC, USA Sep 2008 – Dec 2009 Client : DC Government-OCTO, DC, USA

Citywide Data Warehouse: The CityDW (part of the Office of the Chief Technology Officer/OCTO) provides data feeds, reporting services and serves as the backend data repository for several real time applications serving DC government employees. Daily Management Reports, dynamic reporting through Business objects, Neighborhood View, Mobile View, GIS address encoding and a data catalog containing over 250 distinct data feeds are all provided by the CityDW. Responsibilities involve:

Production support of 5 Oracle production and 4 test and development environment databases.

Maintaining 2 Node 10g RAC on SAN on Windows.

Maintaining 10g Data Guard for 5 production databases on Windows.

Creating table spaces in ASM and maintaining ASM disk groups/disks.

Setting up streams between different agencies database on Windows and Linux

Establishing and maintaining sound database backup and recovery policies including very large databases using User Managed Backup Scripts/RMAN and logic backup using Export/Data Pump.

Maintaining 1.2TB data warehouse.

Managing database software installation, configuration and upgrades

Setup OEM 9i/Grid Control 10g for database monitoring/ performance /diagnostics Environment: VB Script with Oracle 10g on Linux/Windows, Oracle RAC/ Data Guard/ RAC, OEM 9i Primary Oracle DBA, Megasoft Inc, VA, USA Dec 2005 – Aug 2008 Client : Eurofins Medinet, VA, USA

Eurofins Medinet: The Company provides global central laboratory and custom microbiology services to help biopharmaceutical researchers expedite the discovery, development and commercialization of new therapeutics. The backend is Oracle 10g/9i on Windows. Responsibilities involve:

Abhijit Kothari

*********@*****.***

703-***-**** (Cell)

Page 4 of 4

Production support of 10 Oracle production and 23 test & development environment databases.

Installing and configuring 10g RAC/Data Guard on windows.

Establishing database backup & recovery using User Managed Backups/RMAN, Export/Data Pump.

Maintaining 300G data warehouse.

Managing database software installation, configuration and upgrades

Setup OEM 9i/Grid Control 10g for database monitoring/ performance /diagnostics

Performance tuning of queries using SQL Lab/Grid Control/Statistics Collection/Explain Plan.

Writing and optimizing Oracle stored procedures, functions, triggers and packages Environment: Java with Oracle 10g, 9i, OEM 9i/Grid Control 10g on AIX/Windows. Oracle DBA/Team Lead, Megasoft Inc, VA, USA May 2001 – Nov 2005 Client : World Bank, DC, USA

Responsibilities involved

Managing 2 teams, 6 member Database team and 4 member Metadata team.

Production support of critical production databases used by external web and Intranet.

Managing database software installation, configuration and upgrades

Establishing and maintaining sound database backup and recovery policies

Creating and maintaining data mining routines

Performance tuning of queries including Oracle InterMedia Queries.

Writing Procedure/Function/Packages/Triggers/Types for enhancements of the systems. Environment: Java/Jsp/Perl/Lotus Notes with Oracle 9i (9.2.0.5.) on IBM AIX. Primary Oracle DBA, Megasoft Inc, VA, USA May 2000 – Apr 2001 Client : PowerTrust, VA, USA

Responsibilities involved

Maintain Oracle instances supporting the production, test and development environment.

Establishing and maintaining sound database backup and recovery policies

Managing database software installation, configuration and upgrades

Writing and optimizing Oracle stored procedures, functions, triggers and packages;

Migrating Data from SQL Server/ Microsoft Access to Oracle and Vice Versa. Environment: ASP/VB with Oracle 8i (8.1.6.) on Sun Solaris UNIX. Module Leader, CMC Limited, India Aug 1996 – Apr 2000 Responsibilities involved:

Module Leader for a team of 10 developers.

Developed forms in Forms 4.5 and Reports (in reports 2.5) of the sales module.

Developed procedures using Procedure Builder/ SQL*Plus 3.3.

Involved in the development of ERD, DFD, Table design for the Sales module. Environment: Windows NT4.0/Windows 95, Developer 2000 (Forms 4.5, Reports 2.5) and Oracle 7.3 HONORS : Multiple CIO Recognition awards for Oracle E-Business Suite upgrade, Database upgrades.

Contact this candidate