Looking for a position to utilize Oracle databases, Oracle Applications, cloud computing/migration skills in challenging environment to work as individual contributor or to lead the team as Sr. Principle Oracle DBA/Lead DBA/Cloud architect or Oracle EBS Application DBA.
Deep understanding about Oracle Exadata specific features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
First hands-on experience in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching. Provide and implement performance tuning recommendations of all components in Exadata database machine.
More than five years’ experiences and solid hands-on experience in Installation / Configuration / Performance Tuning / Trouble shooting Oracle Golden gate technology. Extensive skills to configure and build one-way, two-way, active-to-active Oracle Golden Gate Extract/Replicate for multiple databases.
More than 10 years’ experiences in supporting large-scale up to 8 nodes, mission critical production RAC environment using 9i to 12c Oracle RAC on Redhat Linux and Sun SPARC Solaris. Installed, configured and maintained Oracle 10g/11g/12c Real Application Cluster RAC / ASM on Redhat Enterprise Linux 5.x boxes and Solaris servers.
Implemented 10g/11g/12c DataGuard Physical standby using DG Broker, and experience with 10g/11gR2/12c Data Guard new features Active Data Guard and Snapshot Standby. Deep knowledge of Oracle 11g/12c Grid Infrastructure, Clusterware, ASM, RAC internal, Active Data Guard in RAC environment.
Implemented Oracle Transparent Data Encryption (TDE) to encrypt column and tablespaces in Oracle 11g/12c Databases.
Solid experience with Partitioned Table Maintenance, adding new partitions, exchanging one-year-old partitions, archiving of the exchanged partitions, dropping and truncating of old portions.
Solid Experience backing and restoring Oracle databases on Oracle ZDLRA devices. Configured Database backup of 11g/12c databases onto ZDLRA device. Solid skills in upgrading 11g Grid Infrastructure and Databases to 12c.
Strong experience in installing, managing and upgrading Oracle E-business suite Applications release R12, 11.5.10, 11.5.9 and 11.5.8.
Successfully upgrade Oracle E-business suite application from Oracle release 11i to Release 12. Upgrade Oracle database to oracle 10g(10.2.0.3) as a part of this upgrade. Solid experience in administering and maintaining Oracle application server, forms server, report server and concurrent manager. Experience maintaining autoconfig enabled environment. Solid experience cloning Oracle application Release 12 from production environment to test/development environment as well as performing Data refresh from production environment to test/development environment.
Solid experience of encrypting credit card data in the Oracle databases using Ingrian devices and Ingrian Credit Card Encryption Solution.
I have installed, administered and managed 200+ MySQL Databases in production environment. I have installed, setup and configured replication for 50+ MySQL databases. I have used mysqlcheck, myisamcheck, mysqldump, mysqladmin, etc… utility to administer and manage MySQL databases. I have setup multiple MySQL instances on same server..
Strong experience includes working with EMC Storage Array using DMX 3 and Symmetric 8830 frame. Also used EMC BCV technique to create Backup BCV and reporting BCV.
Solid experience includes backup and recovery using EMC/BCV technology, traditional hot/cold backup/recovery and backup and recovery using RMAN.
Strong experience in implementation of IBM Tivoli monitoring in Oracle and MySQL databases and Oracle Applications Release 12 and 11i systems for monitoring purpose. SKILL SETS: Hardware: Oracle Exadata servers 2 nodes, 4 nodes, 6 nodes and 8 nodes, IBM hardware, ZDLRA Backup device
Currently working as Oracle contractor with Presidio networked solutions supporting Customs and Border protection’s (Department of Homeland Security) mission critical applications and databases.
Administered, managed and maintained over 150 databases on over 30 Oracle Exadata hardware. Installed, configured and maintained Oracle GRID infrastructure and RAC software on Linux commodity hardware.
Build out Local Standby databases on different Exadata hardware for each of the Primary databases in local data center. Build out Remote standby databases for each of the primary databases at Remote data center. Performed switch-overs from primary database to local standby database. Performed switch-over from Primary database over to remote database at remote data center.
Setup and configured Transparent Data Encryption to perform column level and tablespace level encryption for all databases.
Deployed Databases schema changes to support various applications for all different program offices.
Performed quarterly PSU patching to database and GI software stacks each quarter to 30+ Oracle Exadata to over 150 database nodes.
Performed Upgrade of GRID Infrastructure software from Oracle 11g to 12c Release 1. Also, upgraded database software from Oracle 11g to 12c.
Used Golden Gate and Oracle Data pump to migrate databases from one Exadata to another.
Used Oracle OEM to monitor, troubleshoot performance issue, collect diagnostic information and customize template for custom alerts.
Configured and performed backups of all production databases on Oracle ZDLRA devices.
Worked on Oracle E-Business suite applications. Database Manager/Lead Oracle DBA (NOV 2003 to June 2011) – Network Solutions
Worked as a Oracle database Manager/Lead oracle DBA managing/administering appx. 25 oracle databases ranging from 10G to 1.5TB, running in various Oracle 10g, 9i and 8i release on IBM/AIX, Linux and Solaris platform. These instances include 24 X 7 mission critical storefront and billing database. Currently, I am leading team of 4 Oracle database administrators.
Configured and setup Oracle 9i Data Guard and Oracle 8i Standby database to support Company's Data Center Move project to minimize outage requirement. I have configured 9i database as primary on IBM p680 in existing data center and 9i standby database in future data center on IBM p570 using oracle DataGuard technology. During Cut-over activated the Standby database on IBM p570 at new data center.
I have performed several Oracle 10g, 9i and 8i install on IBM/AIX, Solaris, and Linux and Windows platform. Performed several Oracle upgraded from 8i to 9i, 9i to 10g, from AIX 4.3.3. to 5L. Applied one-off and Security patches using Oracle utility opatch on Oracle databases running on AIX, Linux and Solaris platform. Scheduled and performed several deployment activities with minimum downtime.
My experience includes EMC DMX 3 storage array for production databases and CX-700/CX-600 EMC Clariion storage array for QA databases. I have participated actively in capacity planning of all the databases and file system layout and storage allocation of EMC Storage DMX-3 and CX-700/600 array. I have evaluated database growth for large databases in production environment.
I have performed Oracle application Release 12 and 11i (11.5.8, 11.5.9 and 11.5.10) installation using RapidInstall. Configuration includes form and web server on one application server and database, concurrent manager and report server on another application server. Experience includes adpatch to apply one-off and family pack. I have used Oracle Application Manager (OAM) to administer Oracle application Release 12/11i. I have managed Oracle application Release 12/11i using adadmin and performed cloning of R12/11.5.10/11.5.8 oracle application using RapidClone.
Developed backup and recover strategy for large databases ranging from 100G to 1.5TB using EMC - BCV technology. I have developed backup and recovery strategy for mid-size databases using Oracle RMAN backup and recovery solution. Experience includes use of traditional hot backup solutions for small size databases. I have performed most of the recovery test scenarios in test environment.
Experience during this period includes installing several MySQL instances in 3.23.47, 4.0.18 and 5.0.45 version. I have created several MySQL databases in several MySQL versions. I have setup and configured MySQL replication for several MySQL databases.
My experience includes implementation of ingrian Encryption Solution to encrypt credit card data in Oracle databases. I have configured oracle databases which contains credit card data talks to 2 Ingrian devices in which key is stored. Databases must talk to Ingrian devices to get the key and to store encrypt/decrypt data in Oracle databases. Privileged Oracle and NAE user can only encrypt/decrypt credit card data. Lead/Sr. Oracle DBA (Feb 2001 to Oct 2003) Verisign Inc. Implemented Multi-Threaded server and configured dispatchers and shared server in several oracle databases to reduce memory requirement. Implemented table partitioning in several oracle 9i and 8i databases. Implemented Advance Queuing in Oracle 9i databases. Routinely, Executed statspack reports to address performance tuning issues.
Performed migration of several 8i and 9i databases from Sun Solaris operating System to IBM/AIX(4.3.3) Operating System. Used Quest Product Shareplax to migrate several large databases across the platform to reduce downtime.
Developed Backup and Recovery strategy in the Organization. Tested Backup and Recovery solution for all the databases in the Organizations. Periodically recovered all the databases to ensure good backup set. Tested all the recovery scenario (for example recovery from missing/corrupt datafile, missing or corrupt control files, missing archive logs) on Test servers. Recovered databases using backup controlfile. Re-created controlfile etc.. Used EMC/BCV Technology for back up and recovery purposes. Also, used RMAN as backup and recovery solutions.
Developed strategy to create reporting instance everyday for several mission critical storefront very large production databases using EMC BCV technology in less than 30 minutes.
Performed analysis of Oracle statspack reports and did performance tuning of key SGA parameters. Turned on DB CACHE ADVISORY and tuned db_cache_size. Turned on PGA_AGGREGATE_TARGET advisory and tuned PGA_AGGREGATE_TARGET in the database. Tuned shared_pool_size in the database. Used Oracle spfile to startup database. Ensured that SQL's which are used are using bind variables instead of literals in the database. Turned on Table monitoring and Index monitoring for analze and find out Index usage in the database.
Deployed Advance Queuing in several mission critical production databases. Developed several scripts to monitor Queue depth of several queues. Also, Implemented several Tivoli monitors to check free space deficit, to check dispatcher and shared server busy rate, to check space on several file systems and to load data using SQL*LOADER.
Developed many useful Unix shell scripts to monitor databases. Developed shell scripts to perform Hot Backup, to executed SQL scripts against databases and to analyze databases. Also, developed shell script which sends logger event to Tivoli for CRITICAL and WARNING messages. Developed serveral shell script to generate report from the databases and for day to day oracle database monitoring. Senior DBA (June 1999 to Jan 2001 ) Network Solutions. I have created read-only snapshot database in Oracle release 8i. Created snapshot logs on Master side for each tables and created snapshot on snapshot side.
Configured and setup Oracle Management server and repository to manage and administer many Oracle databases. Setup and started an Oracle agent on multiple Oracle databases. I have configured Oracle Management server to discover multiple nodes. I have setup and configured Jobs by logging on to Oracle Management Server. Shutdown/Startup and performed database administration tasks from Oracle Management Server.
performed User and Security management, Created users, roles, granted appropriate privileges, Created Temp tablespaces using temp files, Created Undo tablespaces in Oracle 9i and Rollback segments in Oracle 8i etc..
I have worked with AIX and Solaris System administrator to implement High Availability solutions for 8i and 9i mission critical storefront databases on Solaris operating system using VCS. Performed and tested database fail-over from One server to another. Ensure successful startup of the databases on another server.
My experience includes performing routine Oracle database deployment and SQL Tuning to improve performance. Performed schema, database and table level analyze and have scheduled job for periodic analyze. Turned on table monitoring and implemented STALE analyze.
I have worked with third party vendor ADC to implement Singleview application and database as billing solution in the organization. I have participated in several database reviews meeting for Singleview database implementation. Also, used SingleView application to perform several functionalities like BillRun and Apply and allocate.
Used Third Party tools like TOAD, Spotlight, Statspack Viewer, OEM to develop, monitor and administor Oracle database. Oracle DBA (May 1997 to May 1999) -- Perot Systems, Europe I have traveled to England on Oracle database administrator assignment with Perot System. Developed scripts to create several objects including tables, indexes, synonyms, sequences, procedures and packages. Performed lot of coding in PL/SQL during this period.
Performed Oracle database upgrade from Oracle version 7.3.4 to Oracle 8.0.
Database Administrator: Nov 1994 to Apr 1997 – Reliance Industries Ltd. Performed Oracle database administration for 3 oracle instances running in Oracle version 7. Also, Worked as developer during this period and I have done lot of coding in Oracle PL/SQL.
During this period I have also, worked as programmer and developed front end application using Ingres ABF and Ingres 4L language. Also, worked as Ingres DBA and performed Ingres database administration task including creating, upgrading and maintaining large Ingres databases. Also, migrated Ingres databases from HP Unix to Digital DEC Unix OS.
EDUCATION: 1994 – Master’s in Computer Application Rollwalla Computer Center, Ahmedabad - India 1990 – Bachelor’s of Science in Electronics - India.