SUMMARY:

IT professional with over 18 years of industry experience. Functioned as a Database Administrator / Lead Database Administrator / Architect, providing extensive support in the areas of design, development, enhancement, and the implementation of systems developed in ORACLE/SQL Server. Excellent interpersonal skills leading application development teams as well as DBA teams.

TECHNICAL SKILLS:

Software: ORACLE 12c/11G/10G/10g RAC, ASM, Oracle Exadata, Amazon Web Services (AWS), Oracle 11g/10G RAC, Oracle 9i RAC, ORACLE Web DB 2.2,Oracle 9i/10g Application Server Reel 1,2, ORACLE “Names” Server, Oracle RMAN, ORACLE 12C Enterprise Manager (OEM) Grid Control, Database Console, Oracle Internet Directory, Oracle Advanced Replication, Oracle Streams 10G/11G, Oracle Golden Gate. Sharable 3.2/5.3, Oracle Data Guard, VERITAS Cluster Servers, EMC BCV SRDF, COGNOS 6, Informatics, SAS, ORACLE Developer 2000, SQL*Forms 2.3/3.0/4.5, database programming (PL/SQL, procedures, functions, packages, database triggers), SQL*Plus 3.1, Reports 2.5, SQL*Loader, SQL*Net, COBOL, C, Visual BASIC 5.0, Crystal Reports, shell programming (C shell, Bourne shell, AWK programming, corn),Perl programming, Java, HTML, ASP, SQL Server 2000.

Hardware/Operating Systems: Red Hat Linux 7.x/6.x, Sun Solaris 10, HP Superdome SD32000, HP 90 00 Series 80 0/700 Model I - 70, HP UX 11.11,11.00,10.20, AIX 6L/5L, AIX on RS 6000 RISC, SunOS 10.x/5.x, Open VMS 7.x/6.2, Alpha, Pentium, IBM 386/486, Zenith Mini, DOS 6.22,Wipro Mini 286 Series, SCO*UNIX, Windows NT/2000, PC Anywhere

ENTERPRISE BACKUP: RMAN and Legato’s Storage Manager, Tivoli TDP, Netback up Ver5.x, TSM

Exadata: Exadata X3-2, X5-2

DBA Tools: Erwin/ERX 3.5/4.1, Data Modeling, Quest Central Software, Informatics Power center, DB Artisan 4.02, Prism CDC for ORACLE 3.0, BMC SqlBacktrack 3.2,3.3,3.4, Recovery Manager RMAN, Veritas Netbackup 5, Oracle Statspack,Quest Live Reorg, Oracle 12c/11g Grid Control, BMC PATROL, PRECISE, TOAD, QUEST, sar, vmstat, HP GlancePlus, Delphix, Oracle Datawarehouse Builder 11g.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Lead Oracle DBA/Exadata DBA/AWS

Responsibilities:

• Install, configure and troubleshoot Oracle 12c/11G R2 RAC databases.
• Implemented Oracle Advanced Security - Created Oracle Wallet for user authentication logins.Uploading Wallets to an LDAP directory.
• Managing Oracle Databases on AWS on EC2 and RDS services.
• Provision and Support Databases on AWS RDS cloud environment.
• Migrating databases to AWS Cloud Environment.
• Install, configure and support Oracle Internet Directory (OID) for user authentication to Active Directory and Tnsnames resolution.
• Managing Oracle Exadata servers X3-2 and X5-2 servers on Half RAC environment.
• Supporting Oracle Exadata Cell Servers on 12c version.
• Applying patches on Exadata Cell and Database servers.
• Working with Confidential support to do maintenance on Oracle Exadata servers hardware.
• Worked on extensively application tuning and SQL queries. Analyze and troubleshoot tune SQL queries for most optimal performance using OEM, Toad and SQL profiles.
• Created SQL profile for bad execution plan SQL queries to use right plan all the time.
• Tuning Oracle SQL queries adding indexes if SQL is not using proper indexes for better plan.
• Oracle Exadata Database Machine - Migrating EDIFECS claim application from Oracle RAC databases to Oracle Exadata Database Machine for different clients.
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating.
• Setup, configure support Oracle standby databases on multiple locations using Oracle Data Guard and Active DataGuard in Oracle 11g/12c.
• Implemented Disaster Recovery Solutions using Oracle Active Guard technology.
• Upgrading Oracle 11g to 12c databases.
• Resolving Oracle database performance tuning issues. Creating profiles to stabilize SQL plans.
• Support and Monitor SQL server 2012 databases.
• Knowledge on Worked on Oracle Data warehouse Builder tool.
• Scripting using Oracle SQL and PL/SQL languages.

Confidential, New York

Senior Lead Oracle/SQL Server DBA

Responsibilities:

• Install, configure and troubleshoot Oracle 11G R2 RAC databases.
• Install, configure and setup monitoring for Oracle 11G/12C grid control databases.
• Oracle Exadata Database Machine Migrating databases to Oracle Exadata Database Machine for different clients.
• Supporting Oracle/SQL server databases on AWS cloud environment.
• Migrating standalone databases to AWS environment.
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating.
• Experience with cross platform Database Migration using Transportable tablespaces and Datapump, Migrating Oracle database from Solaris to Linux.
• Plugging the tablespaces between different platforms using Cross platform transportable tablespace Utility. Migration of Databases from Oracle 10G HP/Sun to Oracle 11G R2 RAC Linux environments.
• Setup, configure support Oracle standby databases on multiple locations.
• Refreshing production databases to Virtual databases for testing using Delphix software.
• Upgrading Oracle 10g to 11g R2 databases.
• Applying Oracle Security PSU patches.
• Migrated database from one data center to other using SRDF and Oracle data guard/backup restore.
• Resolving Oracle database performance tuning issues.
• Support and Monitor SQL server 2012 databases.
• Applying development changes to Oracle/SQL server databases using MicroSoft TFS tool.

Confidential, New Jersey

Database Administrator

Responsibilities:

• Installed, configured Oracle 11G RAC Release 2 databases on Sun/Linux/AIX environments.
• Applying PSU/CPU patches and TNS Poison security fixes.
• Worked with developer for database deployments.
• Creating change control process thru Remedy for database changes.
• RMAN backup setup/config thru TSM media.
• Restoring database using RMAN utility from TSM Tape backups.
• Setup, configure and monitor VCS clusters for Oracle Physical Standby databases on Oracle 11g databases.
• Installed, configured Oracle 12c Grid Control for monitoring databases.

Environment: Oracle 11g/10g RAC, Oracle 11g Data Guard, EMC SRDF, Oracle 11g/12c OEM Grid, Redhat Linux, AIX, Solaris, Oracle ASM, Veritas Cluster Servers

Confidential, Jersey City, New Jersey

Sr. Lead Oracle Database Administrator/Database Engineer

Responsibilities:

• As a Database administrator supporting UBS Trading,Prime Brokerage, Cash Equities and PeopleSoft ERP applications HRMS 9.3 on Oracle 11G RAC R2/R1 and 10G RAC.
• Install configure Oracle RAC 11G R2/R1 and 10G on Linux/Sun/AIX with ASM storage.
• Monitoring databases thru Oracle 11G/12c Grid control.
• Define various migration Strategies and Migrate PeopleSoft databases from Oracle 10G to 11G Rel 2. Migrating database from one data center to other.
• Monitor troubleshoots databases using Oracle 11g/10g Grid control.
• Setup Backup/Recovery strategy thru RMAN, restoring database using RMAN restore/recovery process.
• Troubleshoot performance issues in Production and development database.
• Setup Oracle 11G physical Data Guard, EMC SRDF, VCS high availability for DR solutions. Switchover/failover of databases using DataGuard Broker, EMC BCV SRDF.
• Monitoring and Sync up of Oracle Standby databases.
• Implement Oracle Streams for Replication between RAC nodes. Troubleshoot various Streams conflict resolutions and data issues sync issues.
• Implementing Databases changes (DDL’s), Releases thru Change management process.
• Automate database jobs thru Autosys job schedule.
• Preparing Unix Korn Shell scripts to maintain database jobs.
• Involved in Data Center migration from New York to Richmond,VA

Environment: Oracle 11g/10g RAC, Oracle 11g Data Guard, EMC BCV SRDF, Oracle 11g/10g OEM Grid, Redhat Linux 5.x, AIX 5/6.x, Oracle ASM, Veritas Cluster Servers, Oracle 11g Streams, Oracle Internet Directory.

Confidential, MD

Sr. Oracle Database Administrator/Database Engineer

Responsibilities:

• As a Database administrator supporting PBOCS Census 2010 Project on 8 Node Oracle 11G RAC R2/R1 and 10G RAC.
• Install configure Oracle RAC 11G R2/R1 on Linux with ASM storage.
• Monitor troubleshoots databases using Oracle 11g Grid control.
• Setup Backup/Recovery strategy thru RMAN.
• Troubleshoot performance issues in Production and development database.
• Setup Oracle 11G physical Data Guard solutions for DR solution.
• Monitoring and Sync up of Oracle Standby databases.
• Implement and Configure Oracle Streams Replication between 8 RAC nodes.
• Troubleshoot Oracle streams performance issues by implementing Streams parameter settings.
• Resolve Conflict Resolution in streams by implementing Rules.
• Implemented Oracle Streams TAGs to exclude data replication.
• Migrating Oracle databases from Oracle 10.x to Oracle 11G.

Confidential

Sr. Oracle Database Administrator/Database Engineer

Responsibilities:

• Currently supporting multiple Large mission critical Confidential Oracle database applications like Orchestria, Total Cost Ownership, GcaTs, NAS replication, Salesforce, MLR, trading applications etc.,
• Implemented and Supporting Oracle 10g RAC databases on Multinode environment for Merrill Email Orchestria application using Oracle 10gR2 RAC on LINUX RedHat 4.0 using OCFS, ASM, EMC-SRDF, Veritas Cluser Server for high availability and Disaster Recovery(C&R).
• Troubleshooting Oracle RAC environment issues on production databases, migrating Oracle RAC environment from Linux 4.0 to 5.0. Removing and adding nodes to RAC environment based on application and database load. Converting single node database to multinode RAC environment. Setting up multiple services to load balance and improving performance of RAC environment. Guideline application vendor and team to effectively write SQL queries to improve performance of RAC databases.
• Upgraded Oracle RAC cluster ware components.
• Upgraded Oracle 10g RAC database from OCFS filesystems to ASM storage.
• Architect and created IBM MLR content management application and database on AIX UNIX servers.
• Expert in Oracle database recovery using RMAN and Manual process.
• Involved in Monthly Capacity plan meetings with Merrill Oracle Managed Services to estimate CPU, Storage and adding nodes to the cluster. Used TeamQuest to analysis of server capacity.
• Implemented OMS migration project for all Merrill current service groups from current tier-1, tier-2 Dev, QA and Production, CNR environments to PA and Teleport Data Center. Provided timelines for the migration and prioritized the migration process.
• Implemented Oracle Range and Hash Partitioning, Automate the partition drop and create process.
• Created Materialized views to replicate data between databases.
• Analyze and Reorg the databases to gain space and improve the performances of application.
• Architect and Created Oracle Advanced replication synchronization process on 3 way replication process UK, EMEA, North America. Leading all regional DBA’s in Replication Environment.
• Setup and supported Oracle 10g Streams.
• Installed Oracle Software on Solaris, Linux, AIX and NT - Product installation Oracle 11g, 10g and 9i applied patches and upgrades.
• Implemented Oracle physical Data Gurad for database high availability.
• Migrated databases and application from Oracle 9i to 10g & 11g.
• Troubleshoot and Tuned Database Performance for optimal I/O and memory.
• Tuning and rewriting SQL queries for optimal performance issues. Fixing vendor application SQL queries for performance issues.
• Worked extensively on Performance tuning which involved in Session tracing, Query tuning using Oracle 10g AWR, ADDM, ASH, SQL Tuning Advisor, SQL profiles.
• Defined and Implemented Backup & Recovery using RMAN and Legato/TDP.
• Provided 24 hour support to database operations and the Development community to ensure daily production business requirements are met.
• Refreshing development and QA databases with Production data.
• Involved Data Center Migration from 101 Hudson to PA location using SRDF.
• Implemented Sarbanes Oxley audit and security procedures according to Merrill Complaint.
• Planned the Database related to performance during access, backup and recovery procedures, archivelog mode, replication, nightly refresh, disaster recovery-Oracle Replication/Streams
• Implemented logical and physcial Database Design - Created tablespaces, rollback segments and database objects, constraints, monitoring temp tablespace issues.
• Automate DBA tasks using Oracle PL/SQL and UNIX shell scripts.
• Involved in development team to implement ETL process on Data warehouse project.
• Design/Architect Merrill RecordsNet Data warehouse project on Oracle 10g database.
• Wrote PL/SQL Packages, Stored Procedures, Functions and Triggers for application releases like Total Cost Ownership, Orchestria, GCat etc.
• Co-ordinate with development team to assist application code changes and implementing Oracle 10g features.
• Implementing applications changes/releases on QA and Production databases.

Environment: Oracle 11g/10g/10g RAC/9i, Oracle 10g Data Guard, Oracle 10g OEM Grid, Redhat Linux 3.0/4.0/5.x, Sun Solaris, AIX, EMC-SRDF, Veritas Cluster Servers, Oracle Streams.

Confidential

Oracle Database Administrator

Responsibilities:

• Install and Configure Oracle Software 10g/9i/8i on HP-UX and RedHat Linux.
• Install and configure Oracle 9i/10g RAC software on RedHat Linux and HP-UX servers.
• Install and configuring Sybase Server ASE 12.5.
• Backup and load, recovery of Sybase databases.
• Implemented Auditing in all Sybase databases to audit sessions.
• Setup,configure, support mission critical Oracle 9i/10G RAC databases on Redhat Linux 3.0.
• Production & Application Development Database Support of Oracle 10gAS in HP-UX 11.11 environment with EMC Clustering.
• Installation and Administration of Oracle 10gAS (Oracle Application Server), Apache Web Server . Deploying J2EE applications and Oracle Portal using DCM and Startup Shutdown of Application server components using OPMN (opmnctl and dcmctl), setting up DAD etc.
• Implemented RMAN for One BMS Enterprise level with central catalog and to backup critical RAC databases.
• Supporting HA databases on Oracle 9i RAC environment.
• Troubleshoot different database problems and suggest alternate optimized solutions.
• Setup and configure Oracle Stream
• Setup and support Oracle 9i R2 Data Guard for SAP R/3 Physical/logical standby databases.
• Upgrade SAP R/3, SAP BW Oracle database from Oracle 8i to 9i.
• Upgraded SAP Business Warehouse database to SAP Unicode coversion.
• Migrated multiple Oracle databases from 8i to 9i and 9i to 10g.
• Maintain Oracle SAP R/3 database instances thru BRconnect/sapdba tools.
• Refreshing SAP R/3 VLDB instances from production to test, dev instances.
• Support, monitor and backup (RMAN) Oracle SAP R/3 instances and various other applications.
• Applying Oracle patches on SAP R/3 database instances according to the SAP recommendations.
• Leading multiple application developers teams as well as DBA teams.
• Writing PL/SQL Packages, Stored Procedures, Functions and Triggers according to applications changes.
• Automate Database as well as application tasks using UNIX shell and PL/SQL scripts.
• Working with development teams to assist application code changes for optimal performance.
• Performed query tuning using Oracle 10g AWR, ADDM, ASH, SQL Tuning Advisor, SQL profiles

Environment: Oracle 10g/9i/8i, Oracle 9i RAC, Oracle 9i Data Guard, SYBASE 12.5, Oracle 10g/9i OEM, Redhat Linux 2.1/2.4/3.0, HP-UX 11i, Sun Solaris

Confidential

Oracle DBA

Responsibilities:

• Install and Configure Oracle 10g,9i,8i and its patches on HP-UX and Windows servers.
• Created multiple Oracle instances for Argus Safety & Risk management application according FDA regulations.
• Setup and Configure HA solution using Oracle physical standby database.
• Recover standby database as and when required.
• Monitor and troubleshoot database performance issues and user requests.
• Refresh the development database with production database.
• Monitor Oracle database space issues and design capacity plan for future growth.

Confidential

Oracle DBA

Responsibilities:

• Install and configure Oracle 9i Rel2 Software on AIX 5L servers.
• Setup and Configure Oracle Internet Directory(OID) for Oracle Tns Service Names resolution.
• Migrated Oracle Names server domains into Oracle Internet Directory.
• Setup and configure High Availability thru Oracle Advanced Server Replication between nodes.
• Created multiple domains, user groups and implemented context level security.
• Trained DBA’s on Oracle Internet Directory and Advanced Replication.

Confidential

Oracle DBA

Responsibilities:

• Install and configure ORACLE Software Versions 9i Rel 1 &2, 8i(8.1.7.4,8.1.6) on HP Superdome, HP UX B.11i, 11.00 and Sun Solaris, Windows NT,2000.
• Lead and mentor different application developers teams as well as DBA teams.
• Installing Oracle 9iAS as well as LDAP to setup and configure Oracle Internet Directory for Global database access.
• Install, configure and support Oracle 9i RAC on test environment.
• Setup and configure Standby databases. Supporting VLDB’s for big size OLTP applications.
• Creating and configuring databases according OFA for production, testing and development for application like Documentum 4i, JDEdwards, Maximo MRO, Sales Force CRM, BMG Projx, Drug discovery, Remedy Picasso, SAP R/3, Oracle 11i Financial Applications and other Pharmaceutical applications.
• Preparing different validation IQ/OQ documents to meet the FDA regulations for validated systems.
• Setup and support Oracle Advanced replication for CRM Sales Force Application thru Master - Master groups with Confidential & Confidential, Dendrite and SAI companies to replicate data.
• Setup and configure SharePlex replication from primary node to failover node.
• Implementing Oracle backup/recovery strategy thru BMC SqlBacktrack ver 3.2,3,3,3,4 and RMAN catalogue.
• Installing configuring VERITAS Netbackup ver4 agent for SqlBacktrack OBSI and RMAN to automate Oracle backups/restore process thru Veritas netbackup.
• Migrating/upgrading databases from 8i(8.1.7) to 9i and 7.3.4 to 8.1.7.
• Designing physical database capacity planning for future database growth and implementing database security policies.
• Implementing e-Commerce Oracle Application database on high availability solutions using Veritias Cluter Servers.
• Setup OEM for monitoring, tuning, scheduling jobs for nodes, databases thru OEM alerts with failover database instance.
• Tune Oracle database using OEM as well as Statspack to analysis database health.
• Monitoring production databases using OEM.
• Setup Oracle Names server to distribute Oracle database instance services.
• Supporting Drug discovery Oracle databases applications on Open VMS environment and migrating from Open VMS to Sun OS Unix environment
• Setup,configure and support production, development, quality test database instances for JDEdwards OneWorld and JDEdwards APS for JDE Supply chain application.
• Implementing benchmark solutions to test the performance tuning of the JDEdwards, CRM sales force applications.
• Involved in writing PL/SQL Packages, Stored Procedures, Functions and Triggers.

Environment: ORACLE 10G/9i Rel 1, 2/8.1.7.4/8.1.7.2/8.1.6/8.1.5/8.0.5/7. x on HP 9000 Series, HP UX B.11.00, 10.20, Sun OS 5.x, Solaris 2.x, Windows NT/2000, Open VMS, Veritas Cluster Servers.

Confidential

Oracle DBA

Responsibilities:

• Installing ORACLE Software Release 2 (8.1.6) on HP UX B.11.0.
• Setting-up ORACLE Replication and replicating data using Prism CDC to the Confidential master sites.
• Creating databases for production and development according to OFA.
• Monitoring production databases and tuning the ORACLE Server.
• Performing back-up/recovery from EMC and Omni back-up.

Environment: ORACLE 8i/ 8.1.6/8.1.5/8.0.5 on HP 9000 Series, HP UX B.11.00

Confidential

Oracle DBA

Responsibilities:

• Installed database servers on UNIX/NT and created databases for testing, development, and production based on OFA recommendations.
• Monitored 70 instances including 25 production databases for object growth, extents and tablespace, using the Monitor (MON) database.
• Prepared a migration plan from ORACLE 7.x to 7.3.4/8.0/8.15.
• Archived BOSS archived tables based on different partitioning options.
• Designed and analyzed storage parameters, tablespaces, roll-back segments, and indexes for application.
• Tuned the ORACLE database and BOSS application using various diagnostic tools.
• Installed and configured SQL*Net 2.3.4 and Net 8.
• Resolved on-line production application programs using tools such as OEM, DBArtisan, and SQL*Tuner.
• Refreshed the databases for the development team to upgrade changes.
• Developed PL/SQL scripts for database physical layout changes according to the business analyst requirements of the application.
• Configured a multi-threaded server for production databases.
• Set-up a symmetric replication environment to replicate data in a distributed environment.
• Performed back-up and restore using EMC storage back-up utilities.
• Developed and implemented database back-up and recovery procedures and disaster recovery.
• Created shell scripts for the operation personnel to monitor, back-up, start-up and shut-down.
• Rebuilt and estimated the cardinality of indexes as part of the production database tuning.
• Created snapshots, snapshot logs, and refresh groups. Refreshed the snapshots on all instances of Confidential at specified intervals of time.
• Migration of ORACLE 7.x to ORACLE 7.3.4 under the platform of VAX/Open VMS Alpha to UNIX AIX on RS6000 server for 30 different databases.
• Migration of ORACLE 7.x to ORACLE 8.0.5 under the platform of UNIX AIX on RS 6000 server for all 45 databases.
• Migrating databases from one physical layout to other physical layouts.
• Installing and configuring the ORACLE database instances in a Y2K test environment.
• Evaluating data for Y2K compliance.
• Executing Y2K test plans/roll-out to verify Y2K compliance.
• Developing PL/SQL and shell scripts for BOSS application integration with PeopleSoft accounts payable/receivable database.

Environment: ORACLE 7.x/8.0.5/8i (8.1.5) on UNIX AIX 4.3 RS6000 RISC, VAX/OpenVMS Alpha