OVERVIEW:

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.

SUMMARY:

• 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
• 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
• 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 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,AWRRMAN, SQL*Loader, Export/Import, Data Pump

Programming/Languages: UNIX Shell Programming

EXPERIENCE:

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 associated oracle 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.
• Managed the 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:

• 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 Confidential Co. for the refresh of parts and tool information.
• Performance tuning.
• Extensive use of OEM and PL/SQL Developer.
• Did contract work for Confidential .CO (Feedback process, Special Tooling Process, Refresh process) used functions, packages, procedures extensively.
• 10.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