SUMMARY

• 16 years overall IT experience out of which 9+ years with expertise in Oracle Database Administration.
• Oracle Certified DBA for Oracle 11g database
• Extensive knowledge on database administration for Oracle8i, Oracle9i, Oracle 10g and Oracle 11g on a wide range of operating systems (Windows 2000, 2003, NT Server, UNIX, Sun Solaris, AIX, Linux).
• Experience with very large scale database environment and mission critical large systems.
• Experience in full life cycle development of enterprise level applications.
• Experienced in database design, development, and maintenance.
• Experience in maintaining data warehouses and creating data mining routines.
• Provided 24x7 DBA support for Production and Development environments.
• Upgraded and migrated databases from Oracle 8.x to Oracle 8i and from Oracle 8i to 9i and to 10g. Upgraded 9i database to 11g.
• Expertise in Oracle Backup and Recovery techniques using export/import and advanced backup strategies like RMAN.
• Extensive Performance tuning of oracle queries.
• Experience in advance technologies such as Oracle ASM/ Oracle Data Guard/ RAC/ Grid Control/ Streams.
• Expertise in Oracle PL/SQL (Procedure/functions/Packages/Triggers) Programming
• Expertise in installing, configuring and maintaining Informatica 9.0.1/9.5 environments
• Expertise in installing, configuring and maintaining OBIEE/DAC/OBIA 11g environments
• Expertise in installing, configuring and maintaining Oracle EBS R12 environment
• Experience in Shell script/Perl Script.
• Dedicated and Motivated Individual who delivers quality products on time
• Takes ownership of product from beginning to end and does everything to meet or exceed SLA’s
• Good Communication and Interpersonal Skills.

TECHNICAL SKILLS

DBMS/RDBMS: Oracle 7.x/8.0/8i/9i/10g/11g, SQL Server.

DBA Tools: Export/Import, SQL*Loader, RMAN, OEM, Grid Control

Languages: SQL, PL/SQL, Shell script/Perl Script, VB 6.0, Java.

Operating Systems: Windows NT/2000/2003, UNIX, Sun Solaris, AIX, Linux.

Development Tools: Developer/2000, Forms 4.5/6i, Reports 2.5/6i.

Tuning Tools: AWR, ADDM and TKPROF

Third Party Tools: SQLLAB, TOAD, Erwin, Informatica

PROFESSIONAL EXPERIENCE

Sr. Operations DBA

Confidential, VA

Responsibilities:

• Technical Lead for Oracle DW databases, Informatica, OBIEE/OBIA, Equity Edge, Clarity, Intranet Apps
• Production support of 10 oracle databases including 3 TB Enterprise data warehouse Oracle database
• Maintaining/Monitoring/Backing Primary and standby Oracle production databases
• Installing/Cloning Oracle 11.1.3 E - Business Suite
• Maintaining/Monitoring/Refreshing Oracle Dev/Test/UAT databases
• Installing/Monitoring/Maintaining Informatica 9.0.1/9.5 Environments
• Installing/Monitoring/Maintaining OBIEE 11g production environment for HR reporting
• Installing/Monitoring/Maintaining Equity Edge, Clarity, Quest STAT tools
• Installing, configuring and maintaining Oracle E-Business Suite R12 environment
• Setting up Oracle Business Intelligence application (BI Apps) 7.9.6 for Finance and Procurement.
• Setting up OEM Grid control 11g/12c for monitoring Oracle databases and E-Business Suite.
• Create Business case for Management review for new Oracle Products.
• Upgrading Oracle databases from 9i to 11g on Linux/AIX server
• Ongoing support for optimizing and automating operational processes and configurations to minimize accidental incidents and alleviate problem management.
• Working with System Admin/Developers/Project Managers/Business owners to meet production deployment dates and schedules
• Identifying gaps and enhancing monitoring of production environment
• Setting up/testing Avamar backup for production databases.
• Data modeling, design and development of Data Warehouse and OLTP applications on an Oracle/Unix-based platform.
• Architecting ETL processes for Data Warehouse applications using Oracle Warehouse Builder/PL SQL routines
• Create dashboard/reports using Oracle Business Intelligence suite/BI Publisher.
• Supporting Internal/External Audits (Quarterly/SOX)
• Supporting Oracle/Informatica License reviews.
• On-call rotation to support the production environment.

Environment: Oracle 10g/11g on Linux/AIX server, Oracle EBS Suite, OBIEE 11g, Informatica 9.0.1, OEM 11g/12c, Clarity, Equity Edge, Quest STAT

Primary Oracle DBA

Confidential, DC

Responsibilities:

• Production support of 5 Oracle production databases and 4 test and development environment databases.
• Maintaining 2 Node 10g RAC on SAN on Windows.
• Maintaining 10g Data Guard for 5 production databases on Windows.
• Creating table spaces in ASM and maintaining ASM disk groups/disks.
• Setting up streams between different agencies database on Windows and Linux
• Establishing and maintaining sound database backup and recovery policies including very large databases using User Managed Backup Scripts/RMAN
• Setting up logic backup using Export/Data Pump.
• Maintaining 1.2TB data warehouse.
• Managing database software installation, configuration and upgrades
• Setup OEM 9i/Grid Control 10g for database monitoring/ performance /diagnostics
• Analyze data requirements, develop logical and physical data models and implement the data models and load scripts using PL/SQL and VB Script to load data from different agencies in data warehouse.

Environment: VB Script with Oracle 10g on Linux/Windows, Oracle RAC/ Data Guard/ RAC.

Primary Oracle DBA

Confidential, VA

Responsibilities:

• Production support of 10 Oracle production databases and 23 test and development environment databases.
• Installing and configuring 10g RAC/Data Guard on windows.
• Establishing database backup and recovery using User Managed Backups/RMAN, Export/Data Pump.
• Maintaining 300G data warehouse.
• Managing database software installation, configuration and upgrades
• Performance tuning of the database
• Maintaining oracle schema structures in Erwin.
• Setup OEM 9i/Grid Control 10g for database monitoring/ performance /diagnostics
• Performance tuning of oracle queries using SQL Lab/Grid Control/Statistics Collection /Explain Plan.
• Writing and optimizing Oracle stored procedures, functions, triggers and packages;

Environment: Java with Oracle 10g (10.2.0.1.0 ), 9i (9.2.0.5) on AIX/Windows.

Oracle DBA/Team Lead

Confidential, DC

Responsibilities:

• Managing 2 teams, 6 member Database team and 4 member Metadata team.
• Production support of critical production databases used by external web and Intranet.
• Managing database software installation, configuration and upgrades
• Establishing and maintaining sound database backup and recovery policies
• Creating and maintaining data mining routines
• Performance tuning of the databases
• Planning and devising methodology for migration of system to next version of Oracle.
• Performance tuning of queries including Oracle InterMedia Queries.
• Data modeling for new system and detailing the integration with other existing systems in the Bank.
• Interacting with offshore team to provide system requirements and doing Unit testing and Integration testing before deploying the code to production.
• Setting up processes for Change Request/Production deployment for the database objects.
• Maintaining Metadata to be uniformly used across different systems in the Bank.
• Writing Procedure/Function/Packages/Triggers/Types for enhancements of the systems.
• Updating Data from Other Oracle Databases like HR, Consolidated data source through UNIX Cron Jobs/Shell Scripts/ PERL scripts running every night.
• Migrating Data from Lotus Notes to Oracle and creating files to migrate the Data from Oracle to Lotus Notes using Notrix Job

Environment: Java/Jsp/Perl/Lotus Notes with Oracle 9i (9.2.0.5.) on IBM AIX.

Primary Oracle DBA

Confidential, VA

Responsibilities:

• Maintain Oracle instances supporting the production, test and development environment.
• Establishing and maintaining sound database backup and recovery policies
• Planning and monitoring database security policies and procedures
• Managing database software installation, configuration and upgrades
• Writing and optimizing Oracle stored procedures, functions, triggers and packages;
• Migrating Data from SQL Server/ Microsoft Access to Oracle and Vice Versa.

Environment: ASP/VB with Oracle 8i (8.1.6.) on Sun Solaris UNIX.

Production Support

Confidential

Responsibilities:

• Created Procedure/Functions/Triggers in Oracle for the new functionality.
• Wrote VB code to call Oracle Procedures.
• Debugged and corrected the VB code and Oracle Procedure for bug fixing.
• Tested the functionality for the bugs fixed by others.

Environment: Visual Basic 6.0 and Oracle 7.x, Operating System: Windows NT4 - Server, Windows 95 - Client

Developer

Confidential

Responsibilities:

• Created a technical document to be followed as standard in Oracle Developer applications.
• Involved in the development of Amortization Module.
• Optimized the reports considering parameters like frequency time taken for execution.
• Involved in bug fixing in Forms and Reports as per the feedback received from the client.
• Converted the programs to optimize programs by writing the database functions so as to improve the performance of overall program.

Environment: Oracle 7.3 with Developer 2000 (Forms 4.5, Reports 2.5).

Module Leader

Confidential

Responsibilities:

• Module Leader for a team of 10 developers.
• Preparation of Software requirement study, prototype, development, testing and implementation at head office and at two regional offices.
• Developed forms in Forms 4.5, which include automatic generation of invoice, dispatch instruction generation, retail sales module and sales analysis query.
• Also developed Reports (in reports 2.5) of the sales module that included sales analysis across various parameters.
• Developed procedures for the Sales Module in Procedure Builder, which will be used throughout the system using Procedure Builder/ SQL*Plus 3.3.
• Involved in the development of ERD, DFD, Table design for the Sales module, Subsidy Module and Import Module.

Environment: The IBM Netfinity 7000 Series running Windows NT4.0 at Server level and Windows 95 at Client level using Developer 2000 (Forms 4.5, Reports 2.5) and Oracle 7.3 as backend database.