Experience Summary

• Having 13 years of vast experience in Oracle Database Technologies as DBA, Team Lead and Architect
• Responsible for managing large size Oracle Production databases 7.3 to 11g with RAC and Data Guard options.
• Having very good experience with Oracle E-Business Suite 11i 12.1.3 as Apps DBA Financials and Order Management with Global implementation rollout and support.
• Designed applications and databases to achieve High availability and Scalability for supporting critical Databases in 24 7 environments.
• Architected and delivered multiple projects like E-Business Suite global implementations, storage Migration to ASM, Server Migrations, EMC snap cloning, DR setup, Security Auditing, Partitioning and Archiving, Replication Shareplex and Streams , Reporting, Gateway to AS400, Compression, and other custom applications.
• Team Lead for multiple E-Business suite projects and well versed with BI Discoverer integration, SOA Suite implementation, integrating with multiple third party applications, Workflow, SSL Implementation, Cloning, Patching and Upgrades, Load Balancing, iproduct implementation, Multilanguage implementation, Forms personalization, Extension, Migration and system administration.
• Authored chapters for Oracle press book 'Oracle9i OCP DBA Fundamentals II'
• Having very good experience in development and played key role in developing product called Remote vigil to monitor Databases Remotely.
• Having extensive experience as DBA 7.x to 11g , Forms 6i/10g, Report 6i/10g, BI Publisher, PL/SQL, RMAN, OEM, Real Application Testing and Automating tasks using shell scripting,
• Provided extensive support in Installations, Upgrades, Backup and recovery, Troubleshooting and resolving problems related to Performance and Tuning.
• Worked in Financial, Wireless, Insurance and Energy sectors
• Having good Knowledge of Fusion Middleware Products- Weblogic server and SOA suite
• Having very good data Modeling, Development, Core DBA, Apps DBA and Fusion Middleware administration skills.
• Implementing and improving Standards, Best practices, procedures, automating tasks and mentoring other team members.
• Leveraging technology advancements and working with cross teams to meet Business needs.
• Very energetic, having excellent analytical, problem solving, communication and leadership skills.

Professional Experience

Confidential

Database Architect

• Responsible for managing multiple Oracle 10g 11g RAC Databases OLTP Dataware House on Sun Solaris 10 both Development and Production environments of sizes ranging from 200GB to 6TB with thousands of transactions per second.
• Upgraded multiple Databases RAC and Non RAC from 10g to 11.2.0.2 with planning, coordinating and implementing it by minimizing the risks and reducing downtime with transient logical standby.
• Having strong skills in Performance tuning and troubleshooting issues caused by very high concurrency. Tuned multiple queries and reduced the execution times from hours to minutes.
• Reduced monthly refresh time from 18 hours to 2 hours and space usage from 18TB to 6TB for building 6 different environments Dev, Test Project environment each of 3 TB by leveraging combination of ASM, EMC Snap clones and standby database, and intermediate database for post steps and automating using shell scripts.
• Leveraging ZFS pool to make snaps for long running patches on oracle apps to rollback point in time and ZFS compression to reduce backup space and time by 60 .
• Implemented 11g Active Dataguard and 10g Dataguard and carried out dry run for switchover and automated steps to monitor log gap and deletion of archive logs, and tuning of network settings based on BDP.
• Reduced CAPEX by Converting VERITAS powerpath to Solaris mpxio, VERITAS File system to ASM and carried out this conversion in the least amount of time.
• Reduced RACK space by server consolidation and zoning, and making this effort of migration of large databases to be accomplished in less than an hour.
• Evaluated the options to improve backup operations, and worked with Unix Team to create private LAN and server free backups to segregate backup traffic and Database Link traffic.
• Implemented 11g Gateway to establish connectivity between Oracle and AS400.
• Configured and installed 11g RAC with multiple interconnects for HA and Jumbo Frames for interconnects to improve cluster performance by 20 .
• Prepared script to migrate database changes from dev-test-prod in regular and E-Business suite environments. This Reduced turn around time for day to day operation - It works based on OS member ship, password protected roles, shared Mail folder, checks for standard rules, validating objects at the end, mailing to requestor with log files, and highlighting any errors, centralized report to show what changes were implemented in each databases by whom. This task reduced the time spent by DBA from approximately 8hrs to 1 hr each day on average with added benefit of improving change management process.
• Implemented security using TDE, AES, and FGA to meet security compliance and supported Federal auditing.
• Automated consolidated report for Monthly DB usage and daily Backup report of all Databases highlighting any failures.
• Capacity planning based on space, IOPS and throughput needs and working with SAN admins
• Proactive monitoring of databases and providing RCA on critical issues.
• Monitoring Databases using OSwatcher, Procwatcher, AWR, hanganalyze, systemstate dumps, cluster Health Monitor, racdiag, SQL Tuning advisor etc
• Automated Daily report to execute SQL Tuning Tasks on resource intensive queries and send recommendations as Email including Index creation scripts.
• Troubleshooting Database issues using utilities like LTOM, Hanganalyze, oradebug dumps Heap dump, process state, error stack , stackx, Pstack, OSwatcher, procwatcher, sqlt, awrsqlt, AWR, SPM.
• Helped Dev project Teams in data modeling, designing and tuning and working with cross technology teams, Oracle warehouse Builder, Informatica, Cognos, ETL Team, UNIX and SAN Teams as needed.
• Proactive monitoring of databases and providing Root cause analysis on critical issues.
• E-Business suite upgraded from11.5.10 to 12.1.3 and coordinating the efforts with Business Team.
• Prepared Presentations for Technical Team and Functional Teams for R12 Upgrade showing the differences and new features in the stack.
• Prepared project plan for R12 upgrade and working with cross teams to resolve the issues while upgrading.
• Maintain Databases and Oracle E-Business Suite up to date by applying quarterly PSU and CPU patches, upgrades related to weblogic server, ATG, Forms, JDK and family Product patches and cloning.
• Responsible for Creating custom reports using BI Publisher XML Publisher in E-business suite.
• Implemented SSL on Oracle Apps and split Concurrent manager and Web Forms of E-Business suite.
• Upgraded OEM from 10g to 11g and implemented E-Business suite Application Management packs.
• Administrating Weblogic server 10.3.3 which includes installation, application deployments, Domain Creation with templates, cluster servers management, nodemanager and troubleshooting.
• Installation and configuration of SOA, OSB, OHS, and resources like JDBC, JNDI and JMS.
• Troubleshooting performance issues related to JVM with the help of jmap and jhat utilities
• Generating wsdl and deploying services to integrate E-Business suite with other Financial products
• Creation and deployment of BPEL composite application having DB and Oracle Apps adapter.
• Integrating E-Business suite 12.1.3 and legacy code on Oracle Databases and services running on other financial applications.
• Clear understanding of SOAP, WSDL, XML, XSD, Business Rules, WLST, UDDI, Weblogic security architecture and implementation of policies.

Confidential

Team Lead/Senior Oracle Apps DBA

• Administrating Oracle Databases development, Test and Production.
• Technical Lead for Global rollout of Oracle applications in Asia pacific region and Upgrade project.
• Working with Functional and Development teams to meet AIM deliverables.
• Supporting Development team with Apps conversions, Migrations and interface tables.
• Implemented Solix Archival solution for Oracle Apps.
• Implemented Oracle streams on 10g RAC
• Configured Load balancing on web and forms nodes using Cisco load balancer and Parallel Concurrent processing on CM node
• Regular maintenance activities like Cloning and patching of Oracle applications and custom migrations.
• Maintained application using AD utilities Adadmin, Adpatch, Adctrl, Adident, Adsplice, Adautocfg , administration
• Upgrading Oracle Apps to 11.5.10 using staged APPL TOP to minimize Upgrade time
• Managing and troubleshooting Paralel Concurrent processing and shared APPL TOP
• Performance and tuning of OAF based custom modules using multiple JVM's and tuning GC
• Created shell scripts to monitor logfiles and long running jobs, and other production jobs
• Converting of RAC to Non RAC databases and viseversa
• Integrating with multiple 3 rd party products and other systems like Sabrix tax engine, Agile, Logility.etc.
• Installing SOA components and doing the feasibility study.
• Tuning SQL and PL/SQL code and helping development team.

Confidential

Senior DBA

• Managing Development, Test and Production Databases
• Tuning Oracle Queries and doing scheduled maintenances.
• Deep analysis of Shared pool contention and Errors using Heap dumps
• Implemented RMAN backups using Tivoli Storage manager and created extensive reporting on RMAN.
• Carried out Capacity planning, Automation of managing Partitions for a database of size 1TB.
• Carried out Tablespace Point in time recovery by creating auxiliary database
• Successfully carried out Billing system conversions involving millions of customer accounts.
• Supporting Data warehousing systems and Informatica 7.1.4
• Providing support as on call DBA 24 7 for business critical databases on rotation basis.
• Created shell scripts to monitor shareplex replication, Rman backup purges, Lock monitoring, database refreshes and other requirements.
• Configured and supported Oracle Applications 11.5.10
• Up gradation of 11.5.9 environment to 11.5.10.2 on Sun Solaris and reduced patching time by using staged APPL TOP
• Implemented OID/SSO and Integrated with E-Business suite and Windows Active Directory
• Regular maintenance of E-Business suite including installation, patching, cloning and up gradation.
• Troubleshooting of Concurrent manager process, Forms, Web and Database servers.
• Development and Production Support of Oracle Apps 11i environments
• Installation and Configuration of Application Desktop Integrator ADI , workflow notification mailer.
• Implemented 10gAS, 10g RAC, OEM grid control and VCS.
• Carrying out patch analysis and applied one of patches, mini packs and maintenance packs.
• Configured database replication using Sharable and troubleshooting.
• Implemented sun LDAP directory server 5.2, and developed interface scripts between LDAP and Oracle database.

Confidential

Database Administrator

• Setting up and maintaining Standby database and RAC on Linux.
• Installing the Oracle software and Creation of databases as per OFA
• Upgrading, applying patches and Cloning of databases.
• Resolving production problems related to performance corruption and space related issues.
• Carrying out backups and recovery using SQL Backtrack.
• Performance and tuning of SQL queries using staspack, tkprof.etc.
• Troubleshooting and fixing up production problems and providing support using chat service, alert monitoring, Hotline support and ticketing services
• Carrying out production changes raised using change control systems viz-Global Request service and Global Change Management system.
• Raising Tars and liaising with Oracle.
• Implemented Security standards and database auditing.

Confidential

Database Administrator

• Prepared the content for Osborne/McGraw-Hill book 'Oracle9i OCP DBA Fundamentals II'
• Supported major clients in Saudi - MOI Ministry of Interiors , Coast Guard, ABBOT Labs, SABB Saudi British Bank .
• Implemented Replication between DB2 on AS/400 and Oracle using Generic connectivity.
• Migrated Arabic data from DBASE III to Oracle 8i database
• Developed various scripts for Remote vigil, a database-monitoring product. It monitors changes in Configuration and Layout, Contention Management, Database Availability, Memory Management, Object Management, Process Management, Resource Management, Security Management and Space Management

Confidential

Senior Software Engineer

• Developed various web and client server applications for insurance sector.
• As a team lead I was responsible to manage a team of technical team of 5 members.
• Installed and managed SQL Server, Oracle Server and Web Servers.
• Carried out System Analysis and Design using Entity Relationship diagrams and Process flow Diagrams.
• Created Procedures, Triggers, Indexes and tuned complex queries
• Designed application using HTML, Javascript, JDBC and Servlets
• Setting up and managing Database replication in SQL server.

Confidential

Software Engineer

• Responsible for coding using SQL, Pl/SQL, Procedures and Triggers in Oracle 7.3, C, Pro C.
• Developing Front end screens using Forms 4.5 and Reports 2.5
• Developed various software applications for the Electrical Sector.