Objective: Looking for a position to utilize Oracle database and Oracle Application database skills in challenging environment to work as individual contributor or to lead the team as Sr. Oracle DBA/Lead DBA or Oracle Application DBA.
Senior Oracle Database Administrator with more than 10 years of experience in database administration using Oracle database release 10g, 9i ,8i ,7 and 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. I have solid experience in administering and maintaining Oracle application server, forms server, report server and concurrent manager. Experience maintaining autoconfig enabled environment. I have 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.
I have strong experience in installing, upgrading, patching and cloning of Oracle Applications release 12 (R 12), 11i --11.5.8, 11.5.9 and 11.5.10. I have applied number of mini packs, family pack, consolidated updates pack, one-off patches in oracle application release 12, 11.5.10/11.5.9 and 11.5.8.
I have solid experience installing, configuring and setting up ASM instance (Automatic Storage Management) to manage storage (Disk groups, disks etc...) for database/instance.
Solid Oracle database administration experience includes performance tuning and backup and recovery in Oracle databases size ranging from 10GB to 1.6TB running on IBM p570, p680, p660, p550, p570, Sun Solaris E6800, E4500 and IBM Linux Server.
Strong experience includes high availability (24X7) using High Availability Cluster Multiprocessing (HACMP) and Veritas Cluster Server (VCS).
Solid experience of encrypting credit card data in the Oracle databases using Ingrian devices and Ingrian Credit Card Encryption Solution.
Strong experience includes maintaining and working with mission critical storefront Oracle databases. Also, I have solid UNIX shell scripts experience.
Solid experience includes installing, setting, creating, maintaining and administering MySQL database environment using MySQL Replication technique. Experience includes MySQL version 5, 4.1, 4.0.18, 4.0.16, 3.23.47. I have used MyISAM and InnoDB storage structures/Engines for MySQL databases. 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.
I have solid understanding of networking and DNS, routing and firewall implementation in production, QA and Development environment.
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: Database Tools: Oracle Enterprise Manager Grid Control, TOAD, Spotlight, Statspack Viewer. Databases: Oracle 10g, Oracle 9i, Oracle 8i, Oracle 8, Oracle 7, Ingres, MySQL 5, 4. ERP: Oracle Applications Release 12/11i Release 11.5.8/11.5.9/11.5.10, SAP Certification Hardware: IBM RS/6000 p680, p660, p570, Sun Solaris 6800, Solaris 4500, Solaris 5000 Languages: SQL, PL/SQL, Unix Shell Scripting, C, SAP ABAP/4 Operating Systems: AIX 5L (5.3, 5.2), AIX 4.3.3, Solaris 9, Solaris 8, Linux Oracle Technologies Used: Oracle DataGuard, Shareplex, ReadOnly Snapshot, Advance Queuing, MTS, Table partitioning. Storage Tier: EMC DMX 3, EMC Symmetrics 8830, EMC Clarion CX-600/CX-700, D-1000 Storage, NetApp Storage Work Experience Lead/Senior Oracle Database Administrator (NOV 2003 to Present) – Network Solutions
Currently, I am working as a lead oracle database administrator 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 in stead of literals in the database. Turned on Table monitoring and Index monitoring for analze and find out Index usage in the database.
Consolidated/migrated many small databases into Enterprise database. Monitored CPU utilization, Load Average, Memory utilization, Swap usage on the IBM/AIX server where databases are resided. Troubleshooted Problems related to application startup and application connectivity issues with the databases. Troubleshooted DNS/Firewall issues which are preventing applications to talk to databases.
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.
Worked with Oracle Support on Oracle Internal Error like ORA-00600 and ORA-07445. Performed RDA for several databases and send the output to Oracle Support. I have worked with Oracle Support to identify the problem and to identify the resolution using one-off patches. Downloaded multiple one-off patched for specific issue related to database crashes, snapshot too old and other errors.
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.
Lead the Migration Project to Migrate data from Ingres legacy database into Oracle database. Performed analysis and converted Ingres Schema definition into Oracle Schema. Studied Ingres legacy schema definition, performed Entity Relation diagram and designed new Oracle schema (table, Index, constraint) definition. Dumped Ingres data into flat file and Used Oracle SQL*LOADER to load data into new Oracle schema. Ensure successful Data and application migration from Ingres legacy database into Oracle Database. Lead the de-commission effort of Ingres legacy database after successful migration to Oracle database.
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.
Also, Used SQL loader to load data into database. Used Oracle export and import utility to migrate data and schema from one oracle database to another Oracle database. Also, tuned export and import process to speed up migration in short time.
Created several procedures and packages using Oracle PL/SQL. Installed Oracle version 7.3.4 and Oracle 8.0 during this period. Also, configured listener and tnsnames.ora. 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.