SUMMARY:

• Experienced IT Professional with 14 years experience contributing to the success of various engagements.
• Proven ability to provide business knowledge and technical support for business requirements development, working closely with developers to identify functional requirements in the design of database solutions.
• Resilient Database Administrator with proven technical and project leadership capabilities. Possess solid quantitative and analytical skills combined with the ability to formulate insights, present a compelling case for action, and deliver expert advice and recommendations to key Management personnel.
• Experience with all versions of Oracle RAC and Standalone Installations, Administration, Monitoring, Maintenance, Performance Tuning, Database Backup and Recovery, Oracle Advance security features and Setting up databases in SOX environment.
• Excellent knowledge on Oracle Database internals and Administration. In - depth knowledge of Relational Database Systems, Logical and physical data modeling.
• Solid experience in managing Oracle in High Availability environments using Data Guard and cloning technologies.
• Designed, documented, implemented, and maintained all disaster recovery procedures.
• Evaluated technology and techniques to implement and maintain databases and database environment.
• Building Technology roadmaps decks and holding discussions with the Business block leads.
• Very good experience in building project activity plans and working with PM s on the projects.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long-term business and system requirements.

TECHNICAL SKILLS:

Software / Databases: Oracle 11GR1,R2, 10g, 9i, 8i, 7, Sybase, Forms/Reports/SQL Loader/OEM, SQL, SQL Server,WEBLOGIC,OBIEE and SAP

Programming Languages: C, C++, Perl, Pro*C, Bourne/C/Korn Shell.

OPERATINGSYSTEMS: Solaris/SunOS, IBM AIX, HP - UX, REDHAT, SuSe Linux, Windows 2000/2003/XP/NT

Tools: Tivoli Monitoring, RMAN,DATAPUMP, SQLLOADER, PL/SQL, TOAD, DBARTISIAN,OEM, GRID CONTROL, SQL, EMC TIMEFINDER AUTOSY S, BMC Patrol, Clarify, REMEDY, Omniback, BRTOOL,SAPDBA

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Lead Oracle DBA

Responsibilities:

• Strategizing and managing team of people to implement Confidential ’s data security features.
• Setup Audit and compliance standards at enterprise level.
• Setting up profiles which limit various resource limits for the application users and individual users.
• Create VPD policies to mask sensitive data as required by PCI.Methodologies for the pci data.
• Designing and implementing security monitoring tasks.React appropriately to the security monitoring reports.
• Make sure sensitive data is scrubbed during refreshes.Roles and privileges are evaluated before it is provided to the individual users.Following proper security policies in terms of key encryption policies for external data feeds.

Confidential, NYC

Sr. Oracle DBA / Manager

Responsibilities:

• Create / Overseeing / Installation / Configuration of infrastructure, Load balancing and Capacity design for the project.
• Install and support ORACLE RAC 11gR2 GRID,Standby databases.
• Install,configure and support Linux, Weblogic, Oracle BI and data warehouse environment.
• Planning and overseeing codes to Development / Test / QA and Production environments.
• Setup backups using RMAN / DATAPUMP.
• Setup database refresh between OLTP and DW environment.
• Upgrade HP firmware.
• Setup tuning standards for Oracle DB, reports for the entire DOI Applications.

Confidential

SENIOR ORACLE DBA

Responsibilities:

• Setup ORACLE 11gR1,11gR2 RAC / DATAGUARD / ASM cluster on Dev / QA / Production Sarbanes Oxley (SOX) environment.
• Implemented Oracle Wallet and TDE(Transparent Data Encryption) security features in networks, Oracle table spaces and in tables to meet PCI compliance.
• Implement Data Mask, Encryption, decryption solutions in RMAN, DATAPUMP oracle backups.
• Migrate Oracle 10g databases to Oracle 11g(11.1.0.7) and moving the databases from File systems to ASM.
• Automate most of the database monitoring using Shell scripts.
• Performance monitors / tune using OEM, Sql Scripts, AWR and ADDM reports.
• Support / Trouble shoot Databases 24/7.

Confidential, NEW YORK, NY

DBA Manager

Responsibilities:

• Work as Oracle DBA Manager. Responsible for 10 oracle DBAs, managing about 400 in - house and about 100 client databases.
• Lead team of 10 DBAs.
• Allocate and delegate day to day DBA tasks to team members based on the work load.
• Evaluate performance of the team and constantly update to upper management.
• Decide clients infrastructure based on their needs and expectations.
• Install, create, and manage Oracle 10g and 11g databases on Linux 4 and 5, Windows, ASM, OCFS2, RAC, Multipath (ISCSI) and Raw disk environment.
• Database Administration including SQL review, index creation and optimization, proper table space, sizing, partitioning and Logical and Physical Design, disk placement for I/O optimization.
• Provided onsite and on call production DBA support.

Confidential, NEW YORK, NY

LEAD ORACLE / SYBASE DATABASE ADMINISTRATOR

Responsibilities:

• Create and support databases for Time / People / Entertainment and other magazines Web based environment.
• Project lead for Oracle 10g RAC migration project.
• Design, Implement, install and support Oracle 10.x RAC databases on Solaris 9 / Linux / ASM/RAW devices.
• Support Oracle 10.x 9.x Data Guard / Data warehouse databases.
• Create UNIX shell scripts for various database administrative jobs.
• Support, Install, Create and Administration of Sybase 12.5.x/ Replication 12.6 servers.
• Copy / Create Sybase Test / QA / Prod databases per user request.
• Backup / Recovery Sybase database using Dump/Load and BCP.
• Create and maintain Sybase logins / Users.
• Installation, configuration, administration and troubleshoot SYBASE Server (11.5/12.0).

Confidential, CLIFTON, NJ

LEAD ORACLE DBA

Responsibilities:

• Implemented and supported Oracle 9i / 10g (RAC) / Solaris databases under data warehouse environment.
• Worked closely with application developers and created Materialized views and Partitions.
• Install / Support Create databases for Drug Development Systems.

Confidential, LIVINGSTON, NJ

LEAD ORACLE DBA

Responsibilities:

• Create / Architect / Implement and migrate the Confidential Databases on Solaris / ORACLE 10g RAC Server.
• Document the change using Remedy change management
• 24 X 7 support to all the oracle databases.

Confidential, NJ

SR. ORACLE DBA

Responsibilities:

• Install / Create/ Architect / upgrade and administration of Oracle databases in a SAP environment.
• Support more than 80 SAP production and development oracle databases.
• Install and Support 1600 Oracle production/development/test databases Under Sun Solaris / HP UNIX environment.
• Regular Reorg of SAP and other Oracle databases.
• 24 x 7 production support.
• Database size from 10GB to 3TB.

Confidential, MI

ORACLE DBA / PROJECT LEAD

Responsibilities:

• Outsourced DBA project focused on SAP environment.
• Trained / Managed 6 offshore Database / SAP Basis team members.
• Implement standards in the database / SAP environment.
• Liaison between Client and offshore team members.
• Support 60 Oracle production and development databases in a 24/7 environment

Confidential, BOSTON, MA

SENIOR ORACLE DBA

Responsibilities:

• Supporting more than 200 production and development databases on 24 x 7 environments.
• Installation Oracle/Sybase/ Sql server 2000 databases.
• Supporting SAP application environment.
• Backup & Recovery Using SAP DBA Tool.
• Extensive knowledge on SAP based Databases and SAPDBA tool.
• Installing and troubleshooting SQL backtrack.
• Formulating backup and recovery strategy using Rman, Sqlbacktrack and export/ Import.
• Setting up remote Disaster recovery ( Confidential )sites and testing the backups regularly.
• Creation of volume groups, Logical volume and physical volume in HP, AIX environment.
• Scheduling various jobs through Autosys.
• Monitoring the Jobs through BMC Patrol.