• Over Eleven plus years of IT experience focusing on Oracle Database Degisn, Management and Administration with experience in the Health Care , Financials and Telecom domain as Database Architect /Lead DBA.
• Excellent Leader and team player with analytical, inter-personal, communication skills and ability to work with cross-functional teams.
• Oracle Certified Associate in Oracle 11g Database.
• Experience in Oracle 9i/10g/11g Database Administration on Production, Development and Test Databases including Disaster Recovery, and Backup Recovery RMAN .
• Setup and configure Physical Data Guard with RMAN Duplicate.
• Exceptional experience in supporting Oracle RAC 10g/11g as a Infrastructure and Operational DBA.
• Installed and configured Golden gate 11.2.0.4 Active Active Replication.
• Complete Oracle lifecycle from concept to design, architecture, database performance monitoring, from production to test databases.
• Hands on experience in all stages of system development efforts, including requirement analysis, design, data modeling, testing and implementation.
• Work with project managers and vendors to define projects implementations plans and impacts on the business systems.
• Design, Implement and maintain Oracle 10G/11gR2 Multi nodes RAC environments using ASM and Netapp on SAN and NAS storage.

Areas of Expertise

• Operating Systems: Linux, Solaris Windows NT, Windows Server 2003, AIX, Solaris, RHEL Linux, Windows 7/ 8, Windows XP. Agile, Scrum.
• Databases: Oracle 9i/10g/11g,11gR2, RAC, MS-SQL, MYSQL, Cassandra, Mongo DB, Sybase, Postgree
• Database Tools: Oracle Enterprise Manager-Database Control, OEM 10g/11g Grid,AWR, ADDM, RMAN, Golden gate 11.2.0.4,Weblogic 11x,SSO, OAM,Oracle Forms Reports. ER Studio 8/7 x., ERWIN, ETL Informatica,
• GUI Tools: OEM Grid Control, TOAD, VMWare, Apigee. SQL Developer.

Confidential

Sr. Database Architect

Responsibilities:

• Involved in vital planning for infrastructure setup for the National level Health care system.

• Established data standards and policies, data modeling, systems architecture design, and migration system architectures to ensure access to and integrity of data assets for security and confidentiality compliance.
• Manage a onsite/offsite team of database administrators and developers.
• Responsible for data modeling of several new and modified systems including OLTP and data warehouses using ERWIN.
• Designed and developed multiple database objects including tables, indexes, views etc. in Oracle 11 g R2 databases on Amazon cloud for new module in web facing application.
• Conducted data cleansing to eliminate duplicate and bad data, as well as purge systems of unused, and duplicated data for better management and quicker query response times.
• Fine tunes the sql queries and cache on application side and improve performance of a critical application by 500 time.
• Designed and implemented a potential 20,000 concurrent users application on Oracle RAC and Exadata on RHEL 5x.
• Design a Multi TB Reporting Database using MIDAS Integration and Hadoop and setup ETL Process.

Environment : Oracle Exadata, Oracle 11g R2 RAC, RHEL, Physical Data Guard, SQL Developer, Java, J2ee, Maven, Hibernate,Swing, JDK, ERWIN, Amazon RDS Cloud, Agile, Scrum,ETL, Informatica, MIDAS, Weblogic, Tomcat.

Confidential Application DBA III

Responsibilities:

• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Supported mission critical applications in a 24 7 production environment.
• Developed the PL-SQL stored procedures/functions to process the data and populate them in the appropriate destination tables.
• Manages a seven members offsite DBA team.
• Refreshed Production databases using Datapump/export/import
• Reverse engineered, compared schemas in large DW databases using ER studio.
• Improved System performance by optimizing and tunning sql queries using AWR Report and Explain plan on large sized OLTP databases.

Environment Oracle 11gR2/10g RAC, OLTP, OLAP, ER Studio 8x, Data guard, RHEL 6x,Toad, DB Artisan, OEM Grid, 10g, 12c, Data Pump,Weblogic, Mongo DB, RMAN, SQL Plus, Sybase, SQL Developer.

Confidential

Sr. Oracle DBA

Responsibilities:

• Understand business requirements, implement new products to improve customer experience and reduce overall efforts throughout the Business.
• Installed, configure and manage multiple Oracle 11G R2 RAC databases ranging from 2 to 6 nodes on RHEL 6.3 using Vcloud.
• Installed and configure Active Data Guard on two nodes Oracle 11g RAC Databases using RMAN duplicate.
• Created various monitoring scripts to check overall health of Databases and incremental backup.
• Implemented, executed and tested continuous Active Active replication using Golden gate 11.2.0.4. on two nodes Oracle RAC 11gR2 databases.
• Planning and patching Grid and RAC Oracle databases using Rolling upgrade.
• Migrated two three nodes Databases using Duplicate RMAN.
• Define and implemented Oracle Access Manager and Single sign on.
• Configure Oracle Wallet and setup keys for Motorola Key Management system on Oracle RAC databases.

Environment Oracle 11gR2 RAC, OLTP, RHEL 6.3,OLAP, Goldengate 11.2.0.4, Datapump, RMAN, SQL, OAM, MYSQL, Postgre Sql, Single sign on,Websphere ,Apigee, RCU,ER Studio, Data Guard.

Confidential

Database Admin III

Responsibilities:

• Managed Golden Gate Replication between Oracle 11g and DB2 9.1
• Backup/Recovery setup using RMAN scripts, export/import using Datapump.
• Managed and administered Active data Guard on 11G Oracle Databases.
• Moved multiple datafiles from Oracle Filesystem to ASM.
• Administered, Maintained, developed, and implemented Oracle Policies and procedures for ensuring high security and integrity of the multi TB Oracle 10g/11g RAC multi nodes critical databases.
• Loaded data from legacy system in to Teradata Development warehouse using databridge.
• Execute, troubleshoot Stored Procedures and Triggers on developers demand.
• Monitored and troubleshoot heavy data through ETL processing.
• Administered and monitored multi plateform databases including Unisys DMSii and DB2.

Environment: Oracle 11g R2 RAC, Oracle10g, OEM Grid, DATA PUMP, ASM, SQL Plus, OLTP, OLAP, Grid Control, Databridge, Golden Gate, Data Guard, RMAN, Oracle TOAD, RMAN, Windows 2003, Red Hat Linux 6x, DB2 9.1,Clearpath, ER Studio,Unisys DMSii, ETL, Teradata,Data Modeling, MYSQL.

Confidential

Sr Oracle DBA

Intersections Inc is a leading provider of consumer and corporate identity risk management services.

Responsibilities:

• Maintain and monitor Oracle 10g/11g RAC three nodes production environment.
• Installed and maintain Oracle 11g RAC R2 Grid on Red Hat Linux 5x using ASM.
• Administered and managed SQL Server using SQL server Management Studio.
• Manage and apply archive logs to target database in active data guard setup.
• Frequently load bulk data from SQL to Oracle using SQL Loader.
• Restored the schema and database using Data pump.
• Monitor multiple DB's including Oracle RAC 10g/11g R2, Weblogic Application server and middleware using OEM Grid.

Environment: Oracle 11g R2 RAC, Oracle10g, OEM Grid, DATA PUMP, AWR, ASM, SQL Plus, OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD, RMAN, Windows 2003, Red Hat Linux 5x, VM Ware, SQL Server 7.0 and 8.0,MYSQL, ER Studio 8.0.3

Confidential Lead Oracle DBA

Database Administration for Internet Weblogic Application managing orders for high bandwidth cable connections.

Responsibilities:

• Installed and maintain Oracle 11g R2 using SAN storage.
• Maintained team of five Database Administartors.
• Upgrade, patch Oracle 9i and 10g databases.
• Configure and setup Physical Data Guard on Oracle 11gR2.
• Review the Logical model with Business Users and created the Physical model and tables.
• Created DDL using ER Studio and source to Target Mapping.

Environment: Oracle 10g/11gR2 RAC, Oracle 9i/10g,OEM, AWR, ASM, SQL Plus, OLTP, OLAP, Grid Control, Data Guard, RMAN, TOAD, ER Studio 7.1.1, Autosys 4.5, Database Cloning, Windows 2003, Oracle Enterprise Linux

Confidential

Responsibilities:

• Creating primary database storage structures table spaces once developers have designed an application.
• Designed and implemented hot backups using a combination of incremental, differential and full backups using RMAN.
• Creation, maintenance and administration of databases under UNIX and Windows environments.
• Cloning of production database to the test environment using Recovery Manager RMAN

Environment: Oracle 9i/10g, Windows XP/NT, Solaris, TOAD,Cognos, MS Visio, MS Office, Import/Export, Data pump, TOAD, OEM, RMAN

Confidential

Oracle Developer/DBA

Responsibilities:

• Managing and configuring database user accounts and permissions.
• Performance tuning of SQL queries used in extracting data from different source systems as well as in transformation of data using SQL and PL, SQL code.
• Development and maintenance of existing code for system.
• Wrote Unix Scripts for the calling of packages, sql, or sql loader.

Environment : Windows XP/NT, Solaris, MS Visio, MS office, Import/export, RMAN,