SUMMARY

• Dedicated professional with extensive experience supporting production and development environments as an Oracle Database Administrator.
• Effective team player with excellent communication, analysis and problem - solving skills.
• Outstanding project and team leader.
• Able to coordinate and direct all phases of project-based efforts while managing, motivating, and guiding teams.
• Exceptional corporate citizen actively helping the department and the company to go from good to great.
• 14 years of experience managing and supporting 24x7 production and development environments as an Oracle Database Administrator
• Experience in Oracle software installation, configuration and patch application
• Good knowledge of Oracle EDQ
• Experience in upgrading Oracle software to higher versions 7.x -> 8i -> 9i -> 10g -> 11g à 12c
• Good knowledge of Oracle Architecture
• Experience with database tools like OEM, TOAD, SQL*Plus, Explain Plan, AWR, STATSPACK, ADDM, SQL*Loader, Export/Import, Data Pump
• Implementation of 10g OEM Control for database monitoring and alert notification
• Expert knowledge in OMM and OBI
• Sound knowledge of PL/SQL i.e., writing packages, procedures, functions and triggers.
• Experience with Data Guard setup and configuration with RAC
• Install and configuration of Hyperion application
• Experience with database backup, cloning and schema refresh
• Expertize in database Migration and Consolidation
• Ability to work on all flavors of Unix
• Working knowledge of SQL Server
• Remote database connectivity management using tnsnames, OID LDAP and Names Server
• Good understanding of UNIX Kernel parameters
• Expert in Data Migration from Sql server and DB2 to Oracle done several for IBM and IRS
• Generate and analyze Oracle STATSPACK,AWR,ADDM,ASH Reports
• Ability to work on multiple projects and with multiple development teams simultaneously
• Automation of day-to-day DBA tasks using SHELL scripts and CRON jobs
• Expertise in troubleshooting the problems related to databases and applications
• Manage onsite and offshore co-ordination and communication
• Good Knowledge in installing, configuring oracle applications UIM, IPSA, OSM, IPM, Metasolv, WFM
• Expert Knowledge in setting up databases for these applications UIM, IPSA, OSM, IPM, Metasolv, WFM
• Maintaining good relationships with application owners and developers
• Good working knowledge of RMAN
• Good working knowledge of Oracle Golden Gate setup
• Good Knowledge of Oracle Transparent Gateways
• Expert in Performance Tuning. Completed multiple HOTSOS Training
• Expert in Conducting DR activities.
• Good working knowledge of SAP Support on Oracle Databases
• Good Knowledge of working On Call Shifts.

TECHNICAL SKILLS

Platform/OS: Sun Solaris, HP-UX 11.0, LINUX, Tru-64, Windows

Databases/RDBMS: Oracle 12c, 11g, 10g, 9i, 8i, 7.x

Tools: /Utilities:: TOAD,PL/SQL Developer, 10g OEM Console, SQL*Plus, Explain Plan, TKPROF, STATSPACK, ADDM,ASH,AWR RMAN, SQL*Loader, Export/Import, Data Pump

Programming/Languages: UNIX Shell Programming

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA/Architect

Responsibilities:

• Clone Production database to LoadTest and Dev using Rman
• Installed and Configured Oracle Metadata Management (OMM)
• Fixed MDS Repository Issues.
• Diagnosed exceptions with OMR.
• Upgrade 4 node Rac from 10.2.0.4 (AIX) to 11gR2 (Linux)
• SQL Optimization and interpret AWR reports
• Implement Data Guard and Activate DR database.
• Used Rman for Backups and Recovery during DR Exercise.
• Oracle Cloud Infrastructure Setup. Setup instances/VM/databases/Migrated databases
• Monitor database 24x7 through various SQL scripts which checks for CPU, I/O, memory, rollback, latch contention, redo log buffer area, archive log monitoring, alerts through email when system is experiencing bottleneck/performance degradation.
• Extensive PL/SQL scripts writing for Batch processing using Pocedures,Packages,functions,Triggers
• Fine tune the system for optimized performance involved in troubleshooting database and network issues.
• Good knowledge with Oracle support and opening Oracle SR
• Involved in tuning complex queries and Stats and histogram collection.
• Good working knowledge of Oracle Clusterware administration
• Database refresh from Prod to lower environments and vice versa.
• Database deployments
• Database upgrades and applying Patches
• PL/SQL Programming including creating Packages, Procedures and Functions.
• Cloning and restoring databases using hot and cold backup.
• Worked on creating lot of Ad-hoc queries.
• Application and SQL query tuning.
• Supported MYSQL/SQL SERVER / POSTGRES DB.
• Applying Oracle PSU Patches.
• Handled client escalations and Bridge Calls related to database activities
• Physical and Logical backups using RMAN
• Day to day database administration tasks
• ASM Configuration and Setup.
• Generate AWR, ADDM and ASH reports
• Cloning Database from production to development
• Applying Quarterly CPU Patches.
• Setting up superdomes and blade servers.
• Application and SQL query tuning to help development
• Setting up Linux Servers for Oracle databases
• Participated in Successful DR activities
• Document processes and procedures for reuse
• Adhered to predefined deliverables and SLA’s
• Oracle Installation, Data Warehouse Installation CPU Patches, Cloning, Upgrading and interim patches on (9i,10g,10g RAC,11.5.9,11.5.10)
• Writing Functions, Packages, Procedures, Sql statements for ad hoc reports.
• Loading Data into Database using Sql*Loader and import export
• Dimensional data modeling
• Loaded data using cron jobs and scheduling procedures/packages as per business requirements.
• Copying Schemas to new environments as required.
• Client Installs
• Creating new Databases standalone as well as RAC environments

Confidential

Oracle DBA

Environment: Linux/Aix/Hp Unix/Sun Solaris, Oracle 8,9,10g RAC,11

Responsibilities:

• Extracted data from db2 environment to oracle environment.
• Familiar using control center in db2 and also used aqua data studio.
• Worked extensively to resolve Help Desk Tickets.
• Involved in new requirements like ICE screen, Brad Ford Group & national reports as per business requirements.
• Setting up SAP databases on Unix Servers.
• Having very good exposure to star and snow flake schemas (using primary and foreign keys)
• Tuned sql statements, Suggested and Implemented indexes for faster retrieval of data in various procedures/packages as per business requirements.
• Troubleshoot Issues with help desk based on user requirements.
• Scheduled Cron jobs as per business requirements.
• Wrote, Modified and troubleshooting the existing stored procedures/packages based on user requirement.
• Loaded data using cron jobs and scheduling procedures/packages as per business requirements.
• Maintained several versions of Banner ERP software and the associatedoracle databases and Application Servers appropriate for the version. The modules that I was involved in were General, AR, Position Control, Document Management, Payroll, HR, Finance, Web Tailor, Web for General, Employee Self Service, Finance Self Service, and CALBHR. This included setting up Cascade for the Self Service Products.
• Drawn flow diagrams as per business requirements.
• Migrating 9i databases to 10g
• Developing procedures and functions in 11i
• Copying Schemas to new environments as required by developers.
• Applying Patches.
• Managedthe Banner software code tree
• Writing PL/SQL code (Functions, Packages, Procedures)
• Using OEM to setup jobs.
• Logical and Physical Database design for Rapid Roadside Assistance Program.
• Provided a data architecture design to eliminate discrepancies in managerial and legal results.
• Dimensional Data modeling for Cubes and hierarchies designing the database using star schema and snow flake schema.

Confidential

Oracle DBA

Responsibilities:

• Writing Korn Shell Scripting setting Crontab jobs to monitor the database Setting up jobs through OEM
• Applying new schema changes
• Tuning Scripts
• Cloning and Restoring Databases using hot and cold backups.
• Writing functions, packages, procedures extensively.
• Provided an evaluation and Proof of Concept (built a Star Schema for the Billing Database )
• Refreshing the database.
• Database Archiving using Optim.

Confidential

Oracle DBA

Responsibilities:

• This company is a government contractor for the US Air Force and Navy responsible for maintaining parts and tooling information for all combat aircrafts.
• Databases: Oracle 8i/9i/10g/11i Windows environment
• Daily Backups (hot and cold backups) of the database using Veritas and arc serve.
• Data Modeling utilizing Dimensional Data Marts, modeled in ERwin and creation & use of metadata.
• Migration of the database to new versions.
• Using Oracle Warehouse Builder to perform data conversion and migrate legacy DB2 data to Oracle 10G database.
• Data modeling included dimensional models using Oracle Warehouse Builder ETL capabilities for Cubes and Hierarchies.
• Applying Patches to the database.
• Writing tons of Adhoc queries
• Cloning and Restoring Databases using hot and cold backups.
• Wrote Batch Processes for Boeing Co. for the refresh of parts and tool information.
• Performance tuning.
• Extensive use of OEM and PL/SQL Developer.
• Did contract work for BOEING.CO (Feedback process, Special Tooling Process, Refresh process) used functions, packages, procedures extensively.
• Writing complex queries using PL/SQL for the generation of the reports, created tables, triggers, indexes, synonyms, sequences, writing control files, exports, imports, RMAN
• Loading huge sets of data using SQL*loader.
• Did Contract work for local agency for Medicaid with conversion of data from old legacy system to Oracle Database.
• Multi-node installation.
• Used Visio to reverse engineer the database
• Load Balancing and configuring JVMs
• Worked on a project with Lockheed Martin (F-16) as a third party contractor.
• Installing oracle 11i, upgrades, patches.