SUMMARY:

• More than 16 years of progressive work experience in Oracle Database Administration, design and software development with over 5 years of experience as an Oracle Applications DBA.
• Have been working on Oracle Databases 9i/10g/11g/12c versions and Oracle Applications E - Business Suite 10.2/11.5.9/ R12.x versions.
• Over 5 years of experience in Microsoft SQL server administration on version 2005/2008/2012 and MySQL administration versions 4.x/5.x
• Used several Oracle 12c R1 new features like container/pluggable databases, creating invisible columns, multiple indexes on same columns, and point-in-time recovery of a single table/partition via RMAN etc.
• Experienced in Oracle Exadata, Oracle data appliance (ODA) servers (X3-2, X4-8, X4-2), migrated data, code and tables from Oracle 11g to Exadata for performance improvement, used hybrid column compression to reduce storage by data and I/O. Sound knowledge of Exadata features like Flash cache and smart Scan etc.
• Experienced in project management, developing capacity plans, taking initiatives & leading the team, defining project goals/objectives, formulating strategies for resources, associated budgets and timeline compliance. Formulating controls to stay on the "critical path", ensuring the plan is managed as desired.
• Major responsibilities have been designing database layouts; define storage requirements, Creating, Maintaining, Troubleshooting databases and developing Backup and Recovery strategies.
• Extensively working on Oracle database tuning and monitoring database activities, troubleshooting SQL*Net problems including the client-end Oracle software’s like Developer and Designer 2000.
• Expert in the knowledge of Golden Gate softwarev10x/11.1 for real time database replication. Creating extracts, data pumps and replicates on production servers, splitting replicates for efficient data transfer between servers, performance tuning using BATCHSQL,KEYCOLS, HANDLECOLLISIONS, CHECKPOINTSECS & troubleshooting extract / replicate ABEND issues.
• Working knowledge of Oracle Streams 10gR2 (10.2.0.4), create capture, propagate and apply processes, calculate apply lag, use DBMS CAPTURE ADM package to capture, propagate and apply LCRs/data transfer, DML and PL/SQL code changes between instances.
• Administered Oracle WebLogic server 11g/12c R2, work with administrative console to stop/start servers, monitor server and application performance, view server logs etc.
• Designing, installing, and supporting data security features like Oracle Vault and Data Encryption on various large databases (15TB+) running on multiple operating systems (Sun Solaris 10, Windows 2008 R2 and Red Hat Linux 5.8).
• Performance tuning Confidential the instance/SGA level, using MEMORY TARGET and MEMORY MAX TARGET parameters instead of separate SGA/PGA settings, making changes in the configuration file, optimizer mode, SQL statements tuning using TKPROF etc. These are Oracle 11g features.
• Setting up Oracle managed STANDBY DATABASE and automated log transport services using Data Guard for high availability. Use Oracle 11g ACTIVE DATAGUARD for reporting & SNAPSHOT STANDBY feature for application performance testing.
• Assisted developers & application team by using several Oracle 11g new features like adding invisible indexes, virtual columns in PL/SQL code for performance, change index to unusable for space efficiency etc.
• Extensive experience with SQL, PL/SQL, Oracle Diagnostic and Tuning Management, Oracle Developer 2000, Delphi, Crystal Reports, SQL* Forms, Import/Export, EXPDP/IMPDP, SQL*Loader, RMAN and UNIX Shell Scripting.
• Expert with Oracle Replication (materialized views), partitioning tables using DBMS REDEFINITION package, create composite partitioning like range-list (Oracle 10g) and list-list partitioning (Oracle11g) tables for manageability and performance enhancement.
• Performed Backup and Recovery process via EMC Data Domain, Veritas NetBackup & RMAN; make Backup strategies (full, incremental) for Oracle databases. Use RMAN to backup same data files in parallel, merge RMAN catalogs for simplicity, use asmcmd backup utility to backup & restore ASM metadata. These are all Oracle 11g features.
• Added, deleted or changed OCR (Oracle cluster repository) and VD (Voting disk) locations where both are on ASM (Oracle 12c feature). This is apart from installing 6 node RAC (Real Application Cluster) from scratch, upgrade & applying patches Confidential CRS, ASM and database instance level.
• Designed and Administrated of cloud computing using Amazon Web Services (AWS) for Software as a service (SaaS) and Platform as a Service (PaaS) delivery model. They are accessed by users via a thin client via web browser.
• Extensive experience with Microsoft Azure and Oracle Cloud Services components like Oracle Access Manager (OAM) which is Oracle Identity Management's (OIM) solution for web access management and user identity administration. Use OAM features of Web single sign-on, Mobile and social sign-on, real time external authorization and security (fraud detection).
• Experienced in Designing, Developing, Testing and managing database applications using Oracle 9i/10g/11g and 12c.
• Worked extensively on Oracle 9i, 10g, 11g and 12c versions, Application Tuning, Database triggers, procedures, Data Migration and Data Replication.
• Creating plans, evaluating and migrate Oracle database from version 9.2.0 (9i) to 10.2.0.5 (10g R2) and Oracle 11.2.0.1 (11g) to 12cR1 (12.0.0.1).
• Retrieving deleted records, tables or a dropped table using Oracle Flashback Technology (11g).
• Collecting performance statistics, tablespace usage, creating TIME MODEL to look and analyze time spent in parsing, PL/SQL compilation, and session time via AWR (Automatic Workload Repository). Using ADDM (Automatic Database Diagnostic Monitor) for the analysis.
• Solid understanding of Java technologies like JSP (Java Server Pages), JVM (Java Virtual Machines), Garbage collection in JVM, Applets, Servlets, Connectors, EJB (Enterprise JavaBeans), CSS (Cascading style sheets), import CSS file in JSP etc.
• Built from scratch and use Oracle Enterprise Manager’s 11g/ 12c Grid Control for managing multiple oracle instances from a single point.
• Transferred data and indexes between databases using transportable tablespace (TTS). Performed by copying data files and export/import with TTS option.
• Used Oracle Flashback technology to recover dropped tables & rows to a previous point in time, rollback a transaction & its dependencies, perform queries that return past data etc.
• Started and monitored database auditing Confidential Object and User level as part of security, documentation of changes made to the production database etc.
• Involved in all steps of Software Development Life Cycle (SLDC) with emphasis on diagnosing performance problems and troubleshoot databases.
• Excellent Technical & Communication skills, self-motivated with ability to lead from the front.

TECHNICAL SKILLS:

Operating System: SUN Solaris 8/9/10/11x, HP UNIX 10/11x, IBM-AIX 5.3/6.x, True64 HP 5.x UNIX, Red Hat Enterprise Linux 5.5/6.x, VMWare, LDAP SVR4.7.5, Windows2003/XP/Vista.

Database: Oracle 9i, 10g & 11g R1/R2&12c R1 versions, Oracle Exadata, Oracle ASO, TeraData14, SQL Server 2000/2005/2008/2012.

Languages: SQL, PL/SQL, C, C++, Java, HTML JavaScript.

GUI: Developer/2000, Visual Basic 6.x, ASP.NET 2.x, Delphi 6.x, Crystal Reports 10/11/2008/2012.

Tools: SQL*Forms5.0/6.x, PL/SQL 8.x, SQL*Plus, SQL*Loader, Rational Clear Case Suite, SQL*Report Writer 3.x, RMAN, Data Modeling Tools, Golden Gate software, HADR, ERWIN 7.x/8/9.x, Explain Plan, TOAD 9/10/11.x Quest Instance Monitor/Spotlight/Foglight, Informatica 7.x/8.1, WebLogic11g/12c, AWR reports, ADDM, Vendavo software, Oracle Streams, Oracle Enterprise Manager (OEM), 11g R2 &12c Grid Control, Server Manager, Amazon AWS, Microsoft Azure, IS, IAVM. Oracle Access Manager 11g/12c. OID.

Hardware: Intel 80x86, Pentium PC family, HP 9000 Superdome/RC4000/410, DRS- 8000 SPARC System.

PROFESSIONAL EXPERIENCE:

Confidential, VA

Oracle Database Administrator Architect

Responsibilities:

• Installed, upgraded, maintained, patched and administered database environments (production & test) running on Oracle 10g/11gR2 and Oracle 12c R1 versions.
• Planned and created the Architecture and Design of new production databases; evaluate hardware requirements for database server, create new Oracle databases with BIGFILE tablespace, recommend logical changes to current production databases in support of application enhancements.
• Installed 6 nodes Oracle 11g & 12c Real Application Cluster from scratch & then add a new node.
• The process included working with UNIX team in installing Network Cards, deciding the RAID level, configure VIP (Virtual Internet Protocol) OS patches, kernel parameters, raw devices, disk partitioning, SAN and/or NAS storage architecture, create groups and users etc. Facilitating load balancing and TAF (Transparent Application failover) set up. The operating system being Sun Solaris 10 and RHEL 6.x. Tuning SQL queries, performance tuning by using RESULT CACHE parameters, which enable SQL queries and PL/SQL, functions to be stored in the SGA. Also using the FIRST n rows WITH TIES.
• This is an Oracle 12c feature.
• Troubleshooting databases and performing DR, RMAN and developing Backup and Recovery strategies.
• Expert in setting up RAC (Real Application Clusters) for 24*7 production environment, disk partitioning, adding and deleting nodes, configuring the Shared Disks, Using the Oracle Universal Installer for RAC, high availability architect solutions (HADR) with Transparent Application Failover (TAF), load balancing, administering RAC Databases with the Server Control Utility (SRVCTL),SQL*Plus & OEM.
• Checked disk header visibility by kfred utility, use oracleasm to list disks, discover and configure Oracle ASM library driver, repair disk group and troubleshoot complex RAC/ASM related issues.
• Used Import/Export, EXPDP /IMPDP, SQL*Loader to load data into various tables.
• Installed Oracle 12c on various production instances, hands on experience with new features of 12c such as use of temporary UNDO tablespace, enable DDL logging, adding invisible columns, with SYSASM role in RAC environment etc.
• Used ERWin v8/9.x (Data Modeling tool) for reverse engineering, visualizes data structures, optimize referential integrity and create logical/physical database models, as needed.
• Implemented Transparent Data Encryption (TDE) and Key Vault, use Oracle Wallet for extended data security. Also create wrapper PL/SQL procedures and triggers to automatically open the wallet on instance startup.
• Implementing Symmetric Replication, Creating Database link and Materialized View for distributed databases across the network.
• In a Data Warehousing DWH environment, use Informatica (ETL tool) for faster &efficient extraction of a data set from one oracle database and loading into another DB.
• Resolved database performance issues by separating indexes, data files, rollback segments and redo log files on separate disks, minimize contention, monitor buffer cache hit ratio, change pinning the stored procedures/ packages in the SGA using DBMS SHARED POOL and using AWR, ADDM and ASSM (10g ) for performance monitoring.
• Experienced with Network Applications (SAN/NAS technologies), file systems, shared storage (ASM, OCFS2, Veritas), RAID levels, LUN masking etc. Used EMC Clarion and HP array configuration utilities.
• (ACU) for snapshot storage based replication technologies, access SAN etc.
• Familiarity with Oracle Single Sign On (SSO) and Oracle Internet Directory (OID) implementation and administration.
• Using TOAD, SPOTLIGHT and Oracle Enterprise Manager (OEM) to monitor users, Tablespaces, Rollback Segments, Redo Logs, Tables and Views.
• Offered 24*7 database support/services (via pager) to application developers/QA team in optimizing the application and meeting aggressive timelines.
• Provided leadership to monitor overall database heath & ensure service level agreements (SLAs) are met. Communicate the technical vision and best practices to the top management on a regular basis and assist them in making appropriate decisions.

Confidential, Moline, IL

Oracle Database Administrator Lead (DBA)

Responsibilities:

• Set up multiple Oracle Exadata Server X3-2 and Full Rack X2-2 from scratch. Achieved 200% better performance on resource intensive queries by transferring them to Oracle Exadata which uses smart scan feature. Used PARALLE FORCE LOCAL parameter Confidential the session level for performance improvement.
• Saved up to 20 time on storage by using Oracle Exadata column compression feature on CROP and DEVICE tables of the Enterprise Data Warehouse.
• Created new SQL Server 2012 databases, backup & restore process, DB monitoring for performance issues, working with developers to recommend changes in T-SQL procedures/functions for better performance.
• Troubleshooting databases and performing DR, RMAN and developing Backup and Recovery strategies.
• OMS (Order management system) application for Amdocs production database is more than 10 Terabytes. There are several other databases in range of 1-2 Terabyte for development and real time testing purposes. Tables like BPM STEP INST, TBAP ITEM, and TBORDER ACTION are 600 GB each storing BLOB and CLOB data. Extensively working & maintaining Confidential production databases, managing various performances & database related issues on a day to day basis.
• Used Oracle 10g Streams for data replication. Involved in various aspects of data Capture, Staging and Consumption to other production server. Used commands in DBMS STREAM ADM package to replicate environments Confidential schema and database level. Created user specific rules to selectively enqueue changes in the staging area etc.
• Installed Golden Gate replication software v11.1.1.x from scratch, add/delete/modify extracts / datapumps and or replicates, change trail file locations, start datapump / replicate from a specific trail sequence #, add new tables to the replication by using defgen utility, add supplementary logging troubleshoot DDL change failures, Networking and performance issues.
• Multinode Installation and Configuration of Oracle Applications 11i (11.5.10.2) on RHEL 5 from CD and staging area. Understanding of 11i & R12 architecture, file system ($APPL TOP, COMMON TOP, environmental & configuration file locations, Application tier & Database tier components.
• Adding new 11gAS report server using addNewServerTarget.sh utility, check status, stop, and start and reload report server, HTTP server, OC4J and WebCache processes by opmctl, add # of report engines in report configuration file etc.
• Installed, upgraded, maintained, patched and administered database environments (production & test) running on Oracle 10g/11gR2 and Oracle 12c R1 versions.
• Extensively worked with AD UTILITIES (adadmin, adrelink, adstrtal.sh, adstpal.sh, adautocfg.sh, adident.sh, adautocfg.sh etc.) to generate application files menu, recreate grants/synonyms, maintenance mode, generate message/forms/report files, relink application programs etc. Used FND UTILITIES (fndload, fndload etc.) to move concurrent programs, change application passwords etc.
• Applied on off, mini pack, family pack and maintenance pack patches using adpatch utility, reduce downtime by merging patches ( admrgpch ) and create a unified driver, skipping repetitive patch actions, patching non-interactively, using shared apps tier to distribute AD worker process.
• Both offline and online cloning (single multi node single node) by using utilities like adpreclone.pl, adcfgclone.pl on database and application tiers. Adding a new node (Form or Apache server) to the application by running adaddnode.sh. Also facilitate cloningautomationbyadclonrctx.pl script.
• 100% real time data replication through Golden Gate software - Confidential ’s primary DBA for all replication issues. Creating 8 extracts, data pumps and replicates on production and test servers for online data transfer. Successfully moving more than 90 GB of data per day.
• Actively involved in EBS upgradation from version 11.5.10.2 to R12. This is a complex, multi-step project involving database & application upgrades preferably done in stages. Some of the steps includes applying IOP ( Inter-operability patch )in maintenance mode (AppsTier), install 10g binaries and apply patch set to bring the DB to 9i to 10.2.0.2 (DB Tier), create appsutil directory by appsutil.pl(Apps Tier), create xml file by adbldxml.pl(Apps Tier), run autoconfig (DB tier), migrate custom forms/reports to the new application etc.
• Developed & implemented procedures for ensuring security and integrity of the company database, creating roles, granting privileges to users.
• Maintained User accounts, Managing space usage and Objects creation.
• Monitored Database operations using SQL*DBA, Server Manager and various SQL scripts.
• Used Oracle Flashback Technology to retrieve deleted records, tables or undo DROP table operations.
• Tested various database recovery scenarios including loss of data file, control file and/or redo log files, point-in-time data recovery, perform backup both Off-line and On-line.
• Managed Tablespaces, Rollback Segments, Redo Logs and other Database Objects, extend storage capacity of Oracle database (Space Management).
• Developed shell scripts to automatically export/import data dumps of development & test instances, disable triggers, drop and recreate environments, create new users, assign appropriate roles, recompile views, check sequences etc.
• Documentation of database processes, constant reporting to the technical directors/VP on procedures followed. Facilitating knowledge transfer to the team members.

Confidential, Lincolnshire, IL

Senior Oracle DBA Architect

Responsibilities:

• Installed, configured, upgraded and maintained Oracle software on RAC (Real Application Clusters) environment. The operating system being UNIX/Sun Solaris 9.
• Evaluated hardware requirements (RAM, CPU, RAID level) for database servers.
• Setup and maintained accounts, access levels, and security, with monthly/quarterly security auditing of terminated/non-current users Implement database design, build and maintain logical/ physical data models for large databases and also has good knowledge on Oracle 12c.
• Created Data Guard/STANDBY DATABASE from scratch and ensuring that the archive logs are being applied to the database automatically via MRP process.
• Selected appropriate INIT.ORA, spfile parameters for efficient database operations.
• Developed shell scripts/Croon jobs for Automatic Backup, batch processes and third party applications to run off peak hours.
• Maintained and created new SQL Server 2000 databases for application development and testing purposes.
• Troubleshooting databases and performing DR, RMAN and developing Backup and Recovery strategies.
• Managed snapshot for data synchronization and snapshot logs for better snapshot refreshes.
• Performed Database Migration of 9.2.0.2 database to 10.2.0.5 (upgrading database to a higher version).
• Performance tuning Confidential Application Design, Memory Usage, SQL and Data Storage levels.
• Created scripts for startup/shutdown procedures, daily backups and third party automated jobs.
• Configured SQL*Net for Client/Server and troubleshoot the Networking Environment.
• Installed DBMS patches as supplied by the vendor as needed, in coordination with systems administration & security policy. Ensuring all server builds and patches are current.
• Database Auditing Confidential schema and table level to track logins and records Update/Deletes.
• Developed several stored procedures, triggers or functions in PL/SQL for optimum functioning of database.
• Troubleshooting problems by interacting with the users to provide them an appropriate database Environment.
• Monitored and providing technical support to the developer team, as and when required.
• Maintained more than 12 databases in-house for development and 8 PROD databases (240-1.2 TB size) for our customers.

Environment: Oracle 10g/9i Database, Sun Solaris 9.x, Red Hat Linux 4.5/5.x, Windows 2003/XP, Sun Fire®E12K Server, Dell PowerEdge 1955, 6800,8450 servers, Dell PC’s.

Confidential, Chicago, IL

Oracle DBA

• Developed more than 50 SQL forms and reports for keeping status of Customers, Vendors and Product related details including their Inclusion, Modification and Removal from existing database.
• Developed PL/SQL procedures to check data consistency and evaluate Max/Min quantity of product criterion accepted from user for stock level fixing.
• Create tables with primary keys, foreign keys, indexes, and triggers to track data changes.
• Developed SQL reports for Cash/Bill invoices, payment tracking & their subsequent validations.