Sr Oracle DBA AWS Solution Architect

Himanshu H Dave

PO Box **, Lake Hiawatha, New Jersey - 07034

973-***-**** (Mobile)

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

US Citizen

Over 11+ years Sr. ORACLE DBA, Architect experience in Production and Development environments, systems integration experience, deploying and integrating enterprise applications in several areas, customer-oriented with excellent written and verbal communication skills. Project Lead DBA supervised the team of DBA’s on project lifecycle.

Worked on (AWS) Amazon Web Services project as AWS Solution Architect.

Oracle Versions 19c/18c/12c/11g/10g/9i/8i/8/7 – Unix and Windows NT, VLDBs, Mid-Size Databases.

Microsoft SQL Server 2005/2000/7 – Worked as - MS Sql Server - Database Administrator

SAP ERP Ver 6.0, NET WEAVER VERSION 7.0 – Worked as - SAP Basis Administrator

Extensive experience with Oracle RAC NFS, ASM Storage Installations, Oracle installation, database performance, capacity planning, creation, upgrades, migrations, patches, analysis, quality assurance, scripting, backup and recovery strategies, logical/physical design, assigning user roles, privileges, maintenance of table spaces, objects, tuning, setting storage parameters, hard drive space allocation, forecasting, troubleshooting.

Upgrades, Migrations of Oracle Databases

Work as UDB DB2 DBA, also work as UNIX SA, provide beeper support on 24 x 7 databases on a weekly basis.

Exploring and working on initial studies on Open Source Databases such as MySQL, PostgreSQL Mongo DB, and Cassandra.

TECHNICAL EXPERIENCE:

AWS,VMware ESX 5, IBM AIX RS6000, SP2 NODES, P5 – 570, Sun Enterprise E5500, E3500, Sun SPARC Systems Ultra 5, Compaq servers, RHEL 5.0,6.0.7.0, HP 9000 Enterprise Servers, IBM Netfinity Servers, IBM Mainframe, DELL PowerEdge 6800, IBM AIX Ver 5.L, Sun Solaris 2.7, SunOS 5.7, HP-UX 11.0, Linux Red Hat 9, Windows – Win 2012, Win 2012 R2, XP Prof, 2003/2000/98/95, Windows NT.4.0, Mainframe - OS 390, MAC OS X.

Oracle 19c/18c/12c/11g/10g/9i/8i/8/7, Oracle Cloud Manager 13c (OEM), Oracle RAC (NFS and ASM), Oracle Grid Control, Oracle Data Guard, Oracle Golden Gate Replication, Oracle Partitioning, RMAN, Data Warehouse, Oracle Data Pump Export, Import, Oracle Partitioning Option, Apply Oracle Patches, QUEST TOAD, SQL SQL*Loader SQL*PLUS, iSQL*PLUS, PL/SQL, Unix Shell Scripts, Oracle Client, Oracle Export/Import, Oracle Enterprise Manager (OEM), SQL BACKTRACK, Datawarehouse – Teradata, SAP, PeopleSoft, Oracle Developer, Central, Spotlight, Oracle Navigator, Embarcadero for Oracle, SQL*NET, SQL Trace, Explain Plan, CVS, Multithreaded Server (MTS), UDB DB2 Version 8, Microsoft SQL Server 2005/2000/7, Veritas, SAN, Cloud, C, COBOL II, COBOL, JCL, Nagios Ticketing, JIRA Ticketing

PROFESSIONAL EXPERIENCE:

AT&T – Middletown, New Jersey - 07748

Sr. Production Oracle DBA, Architect July 2010 to Present

Beta Project - Migrate Oracle database 12c to AWS cloud for test projects using free - No Cost Options for AWS, Evaluating AWS for future Paid Options for hosting Oracle Databases on AWS

Install Oracle 19c, 18c on RHEL as beta project for testing AT&T in house applications.

Install MySql, PostgreSQL software, create databases as beta project for external AT&T Clients.

Apply Mandatory Oracle Security Patches on Oracle 12c Release 1 and Release 2 Databases.

Work on Custom Oracle RAC Installations, RHEL OS and ASM, NFS Storage, hardware configuration, software version customization per AT&T client request on Cloud.

Meet SLA per AT&T client requests on hardware and software support on Oracle Databases.

Work on Special Order Requests and POR’s generated internally by AT&T account executives.

Install 3rd Party Software (MobileIron) and integrate the same on Oracle Database software.

Install, configure and patch custom Oracle Exadata XM8-2 on Linux on beta Labs project for AT&T External Client, Patch Oracle Data Guard, RAC, Grid Control, E-Business Suites, Golden Gate on RHEL, AIX, SUN Solaris servers, HP Servers and Windows Servers.

Work on ETL tools DB Convert, SSIS – MS SQL SERVER, Data Warehouse, TeraData.

Create, Certify Documentation on Oracle custom Installs for AT&T clients.

Modify and maintain newer versions of software and documents on AT&T internal libraries.

Work with Veritas and SAN Storage for Oracle installations, Train entry level DBA.

Focus on newer patches and customizations needs of software for AT&T clients.

Worked on proof of concept setting up of multitenant database, installation, configuration.

Worked on pluggable, container database in labs beta project.

Meet on demand challenging requirements for new prototype custom software for AT&T.

Worked on AWS beta projects and completed self-training on the same as AWS Solutions Architect.

Party City Corporation - Rockaway, New Jersey - 07866

Sr. Production Oracle DBA - Consultant July 2006 to July 2010

Install Oracle and create database 11g on Win Server and 10g version 10.2.0.1 on AIX server with OS 5L. Install Oracle RAC 11g on Linux as a prototype project.

Install Oracle client software on dell desktops to connect to the database.

Move 4 data warehouse VLDBS from one server to another, re-design and implement new backup strategy on the new server, troubleshoot performance issues, reconfigure client machines to connect to new database servers.

Palisades Technology Partners – Englewood Cliffs, New Jersey - 07632

Sr. Production Oracle DBA - Consultant February 2005 to June 2006

Installed Oracle 10g version 10.1.0.2 on NT, Sun, and AIX platforms.

Upgraded Oracle 8i database to 9i databases on NT and AIX platforms (32 bit, 64 bit) operating systems.

Maintained databases for online 24 x 7 Mortgage applications, data warehousing applications. Providing beeper support over weekends.

Installed UDB DB2 software, UDB DB2 database creation on NT platforms.

UBS Paine Webber – Weehawken, New Jersey - 07086

Sr. Production Oracle DBA – Consultant October 2004 to February 2005

Worked on a project of applying Oracle Security Patches to existing 9i, 8i databases on financial and brokerage applications. Upgraded Oracle 8.0 to 9i, 8i to 9i, created standby databases.

Troubleshot and performance tuned Oracle 9i databases, implemented user requests for over 20 instances, database maintenance, monitoring tablespace growth reports.

Migrated Oracle databases to UDB DB2 platforms via UDB DB2 Data Migration tool.

Installed Microsoft SQL Server 7 software and worked on Microsoft SQL Server 7 databases. Executed production scripts for data loads.

IBM – Midtown - New York City, New York - 10138

Project Lead, Sr. Production Oracle DBA August 2000 to September 2004

Oracle installation 9i/8i/8, worked with Oracle databases on AIX, SUN, HP, NT boxes.

Project lead for various accounts for IBM’s external clients, supervised over 4 Dbas’, Implemented projects from concept, initialization, transition, production and Post productions phases. Met deadlines, troubleshoot project life cycle problems.

Created database, table spaces using scripts, daily monitoring of backups, alert logs, trace files.

Provided beeper support as per team allocation for all production databases.

Daily Racing Form – Wall Street - New York City, New York - 10005

Sr. Production Oracle DBA - Consultant June 2000 to August 2000

Worked on a project with Sun Solaris operating system (5.7), installation of Oracle 8i, creating database for a web based front end online 24 x 7 newspaper application.

Implemented backup strategy, daily hot backups, and alternate days full database exports.

Unilever Bestfoods – Englewood Cliffs, New Jersey - 07632

Sr. Production Oracle DBA January 1998 to June 2000

Installed and maintained multiple Oracle 8i,8,7 databases on IBM AIX, Sun OS, Windows NT for development, test and production environments using in house scripts.

Upgraded Oracle from 7.x to 8.x on development, test and production servers.

Migrated Oracle from one server to another.

Supported 24 x7 databases running on SAP R/3, PeopleSoft, Vista Nielsen, EDI applications. Reorgs of table spaces via Platinum’s tablespace reorg software.

UPS – Morristown, New Jersey - 07960

Production Oracle DBA/COBOL Programmer December 1995 to December 1997

Worked as an Oracle DBA and COBOL Programmer on Marketing Sales Application.

Installed Oracle 7 server and Oracle 7 client software on COMPAQ, IBM Netfinity and Sun boxes for production and development environments.

Created 12 databases and respective table spaces on development, test, production servers.

Prudential Preferred Financial Services – Liberty Corner, New Jersey - 07938

Help Desk – Consultant May 1995 to December 1995

Worked as MIS-HELP Desk Consultant.

Provided technical support to insurance agents from all over the country, generating performance reports, submitting sales reports to senior executives.

EDUCATION:

Self-Study / Self Education – From Home – New Jersey

AWS – Amazon Web Services – Solution Architect April 2019

DBA University – Chicago – Illinois

MS SQL Server Database Administration November 2016

LearnSAP – Houston - Texas

SAP Basis Administration September 2016

DBA University – Chicago – Illinois

Oracle ASM RAC Data Guard Administration February 2015

Oracle Corporation – Redwood City - California

Oracle Database 11gR2: RAC Administration October 2014

IBM Corporation – New York City – New York

DB2 UDB Advanced Administrators Course for Relational DBA’s March 2003

Sun Corporation – Santa Clara - California

Solaris 8 System Administrators Course - 1 - SA238 March 2001

Solaris 8 System Administrators Course - 2 - SA288

Oracle Corporation – Redwood City - California

Oracle 8 DBA – MASTERS August 1999

CompQuest – Parsippany – New Jersey

Oracle 7 DBA Course June 1997

The Chubb Institute – Parsippany – New Jersey

Computer Programmer March 1995

Bombay - India

Bachelor of Arts – Bombay - India June 1990

Contact this candidate