SUMMARY:

• Over 16 yrs of experience as an Oracle Database Architect/DBA in Oracle 11g (11.2.0.3, 11.2.0.2 and 11.1.0.7)/ 10g (10.2.0.5, 10.2.0.4 and 10.2.0.2)/ 9i / 8i and 8. Data management skills on HP Unix, Sun Solaris, AIX, Red Hat enterprise Linux and Windows environment.
• Specialization in Datawarehouse Architecture design and administration
• Expertise in Oracle Database Infrastructure Sizing, Migration, Database upgrades, and Optimization.
• Proficient in Installation, Configuration, Maintenance and Tuning of Oracle 11g (11.2.0.3, 11.2.0.2 and 11.1.0.7)/ 10g (10.2.0.5, 10.2.0.4 and 10.2.0.2)/ 9i / 8i and 8 on AIX, HP UNIX (HP UX IA64 11.31, HP UX 11.23, HP UX 11.11, Sun Solaris (5.9, 5.10 and 5.11), Linux and Windows platforms. Migration and maintenance of Oracle Databases (11g, 10g, 9i, 8i).
• Experience in Oracle 10g, 11g RAC installations, ASM, and OEM grid control.
• Experience with very large database environments (VLDB) of size in Tera Bytes (TB).
• Experience in instance configurations, tuning, and capacity planning, physical, logical database designs, Server software upgrade, one off patches, quarterly patches, monitoring database and OS (UNIX / Windows) performance.
• Proficient in developing efficient logical database designs.
• Supported and maintained data consistency in Production, Development, and Backup and Test databases.
• Experience with Database reorganization, collecting statistics and monitoring database performance using STATSPACK, OEM, and TOAD.
• Adept in Application and Database tuning, use of SQL diagnostic and tuning tools like Automatic Workload Repository AWR, Automatic Database Diagnostic Monitor ADDM, TKPROF, EXPLAIN PLAN, AUTOTRACE, and trend analysis.
• Developed programs to load data using PL/SQL and SQL*Loader to transaction processing databases.
• Knowledge of Data modeling and Software design methodology, UML, TOAD and software like Rational Rose, Erwin 4.x, Data - warehousing methodologies.
• Excellent communication, presentation, technical writing & team work skills with ability to adapt to the nature of the job.
• Experience in Information Systems, repositories, Oracle Database Administration, and Data warehouse design and complete software development life cycle.
• Possess effective verbal and writing skills and strong diagnostic and problem solving ability

TECHNICAL SUMMARY:

Hardware: HP-UX Servers, AIX servers, SUN Solaris servers, Linux servers, Windows 2000 Servers, and NAS Filer, Tivoli servers, Tape backup servers.

Operating Systems: HP UNIX (HP UX IA64 11.31, HP UX 11.23, HP UX 11 11.11, Sun Solaris (5.9, 5.10 and 5.11), AIX 5.3, AIX 6.1. Linux x86, Linux x86 64, Windows 2000 Server, Windows 2003 Server, Windows XP, SuSE Linux, RHEL Linux and Windows NT.

Databases: Oracle 11g (11.2.0.3, 11.2.0.2 and 11.1.0.7), Oracle 10g (10.2.0.5, 10.2.0.4 and 10.2.0.2) Oracle 9i/ 8i/ 8 and 7.3.

Languages: SQL, Advanced PL/SQL.

Tools: Oracle DBA tools: OEM, OMS, DBArtisan, Oracle Failsafe, Hp-ux Service guard, Cluster failover software, VERITAS net backup, PRTG monitoring tool, RICMS REMEDY ticket. Standby, RAC, AQUAS. OEM GRID monitoring tool, Borland star team, TOAD 9.7.5, Remedy SERVICE NOW- Incident management, Custom tools, TOAD 10.6

DBMS Utilities: SQL*Loader, Import/Export utility, Data pump, RMAN.

Database and SQL tuning/diagnostic utilities: TKPROF, SQL Trace, STATSPACK, AWR, OEM Diagnostic Pack, UNIX performance utilities- sar, vmstat, UNIX Shell scripts, Cron, topas, top. Prtdiag. Nmon, iostat.

Other Tools: UML, Rational Rose Data Modeler 5.0, Windows At scheduler, MS Project 2000, Erwin Data Modeler 4.1.4, TOAD, Spotlight, SQL Navigator, Quest Central, Oracle Developer 2K Forms and Reports, Jdeveloper, Visio, SQL Developer, isql*plus, Wincvs, Test Director, Exceed Hummingbird, Service center Client, Unix cron scheduler., EVO access, VPN connection, Autosys job scheduler

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Supporting Datawarehouse platforms, Transactional databases for upstream and downstream processing with data propagation through different intermediate systems .
• Developed and Modified optimized SQL, PL/SQL code implementation with necessary validation criteria's, apply relevant configuration changes .
• Supported ERWIN data modeling. Monitoring a surveillance system for generation of TRADE sales that do not meet compliance rules .
• Implemented infrastructure activities as enhancements to existing systems.
• Extend datawarehouse models across other systems for duplication, re processing and re load of data for Maintenance and Testing purposes. Maintained defect list for development of code models and new releases.
• Incorporated additional business logic to existing models as part of new features.
• Extended functionality, scalability and supportability of system to meet customer usability .
• Supported various Global regions for alerts generation .
• Supported data loads via batches to
• Data ware house . Maintained increasing data volumes across environments, Created new 11gr2 RAC databases, 11GR2 ASM disks, 11GR2 Dataguard . Monitored system performance with 11GR2 AWR, ASH, ADDM reports, OEM .Supported tuning, and multi-tier system development .
• Supported mission critical applications .
• Database size ranges in the order of multi terra bytes. Supported oracle 11gR2 upgrades in standalone, RAC environments.
• Performed many installs and creations of Oracle RAC (Release 11g) on Linux.Worked with Oracle Scan, LDAP / OID, Oracle high availability solutions (i.e., RAC, DataGuard) Worked with database performance tuning, including query tuning and optimization.Assisted in resolution of simple to complex issues. Identified operational instability.Proposed/implemented solutions to stabilize the environment/infrastructure.
• Created partitions, identified schema object locks, resource contentions in RAC . Supported Oracle Enterprise Grid control, SQL Loader, Import/Export, Backup and recovery methods, and Oracle scheduler. Setup 11GR2 PHYSICAL STANDBY databases for availability. Maintained Datawarehouse/table partitioning/partitioning operations. Supported patching activity. Performed refresh of databases from one to another environment. Supported incident resolutions . Created logical data models and converted them to physical data models.

Environment: Sun Solaris 5.10, Sun Solaris 5.9, Linux 5, Linux x86-64, RedHat EL 5, Oracle Database Enterprise Edition (, 11gr2- 11.2.01, 11.2.0.3,11.2.0.4), Oracle client 11g,11gR2, Sun sparc servers, Sun fire servers, Linux Servers, SQL Developer, TOAD 10.6, Informatica, RAC databases,11g r2 DataGuard, Oracle 11gr2 RMAN, Unix Shell scripts, Autosys Job scheduler,, Oracle 11gR2 RAC, Oracle 11GR2 ASM,, 11GR2 OEM

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Supporting migration activities of legacy platforms to oracle applications-Flexcube . Assisting developers with the code implementation, verifications, error compilations, configuration changes to various app features. Restricting access of developers to limited functionalities of the banking system via security controls. Supporting various regular and extended functions co-ordination, change propagations to occur online and offline, Plan activations, infrastructure activities, enable websphere functions across various global regions . Supporting a global environment to propagate a conversion/transformation into an ORACLE platform for client-oriented financial banking transaction processing purposes. Supported ERWIN data modeling.
• Maintain operational and functional validations of databases to enable application testing, performance testing. Periodically refreshed different environments to release code, fix errors, development of other functions,Testing and validations . Monitor databases/OS - space usages .Troubleshoot system faults, setup automated jobs, perform backups and restores. Planned for patching. Maintained batches of changes release across different in-house and external partner systems. Running EOD,EOC,EOY for different countries distributed across the globe. Migrated database across large data centers. Overseen database infrastructure . Tested oracle queues .
• Setup various markers criteria, checkpoints for the flow of changes. Co-ordinated with other infrastructure, messaging, application components, internal support Teams .Tuned Databases for performance slowness experienced, gathered performance reports, baselined operational stability. Monitored for high peak usage of system memory, other successive highlighting trends . Deployed patches . Maintained the code cyclic changes (via deployments) . Supported legacy conversion activities - pre/post for testing, PROD. Interacted with teams for migrations, production releases, env system updates . Training newcomers. Prepare and effectively communicate performance results. Ensure timely escalation of critical issues to performance team management. Coordinate environment readiness with all support teams to ensure alignment for tests. Partner closely with development leads to create and refresh a quarterly delivery roadmap. Work with management in estimating effort required for specific development projects. Performance tested with AWR / ASH reports. Keeping the database up to date on Patches and supported the roll-out of new versions.
• Optimized the database for the transactions. Managed the activities of the dba teams. Coordinate the implementation of technical controls to support and enforce defined security policies . Maintained Golden gate replication, shareplex replication jobs. Participate in architecture of test environments needed and co-ordinate implementation. Administered OEM .
• Created and maintained oracle 11G RAC databases for supporting failover, high availability. Setup and maintained 11g ASM for disk storage. Maintained storage space across ASM. Performed rolling upgrades of 11gr2 RAC .Configured and troubleshooted multi node RAC systems. Databases sizes vary in TB. Worked on Sitescope, perfmon, vmstat . Working knowledge of application server technologies such as WebSphere. Infrastructure knowledge to facilitate environment build out. In-depth understanding of performance testing methodology.

Environment: Sun Solaris 5.10, Sun Solaris 5.9, AIX 6.1, Oracle Database Enterprise Edition (, 11gr2- 11.2.01, 11.2.0.3), Oracle client 11g,11gr2, Sun sparc servers,Sun fire servers, AIX servers, Java JRE, SQL Developer, Data stage, custom monitoring scripts, custom backup toolscustom health check tools, RAC databases,11g r2 DataGuard, Oracle 11gr2 RMAN, Unix Shell scripts, Autosys Job scheduler,Oracle Flexcube V12,Oracle 11gR2 RAC, Oracle 11GR2 ASM, Websphere

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• As Oracle database administrator, responsible for various database administration activities, roles on a rotation basis.
• Provided support for global database. Interacting with different Global regions, such as Asia, Europe, Australia, Africa for supporting databases .
• Troubleshooted backup issues, installations /creations/migrations/upgrades/capacity management, DR tests, storage /OS maintenance .
• Created 11gr2 RAC databases, managed 11gr2 ASM storage, and managed OEM grid control . Adept in installations of latest version of oracle software, oem12c .
• Managed various red category alerts.
• Handled 11gr2 RAC database, Data guard, exadata..Interacted with oracle support for SR’s to closure and with other vendors for technical problems.
• Effectively deployed VTL, PTL for backups. Supported data modeling by ERWIN. Monitored OEM .

Environment: Sun Solaris 5.10, Sun Solaris 5.9, Linux x86, Linux x86 64, Windows 7, Oracle Database Enterprise Edition ( 9.2.0.8,10.2.0.1, 10.2.0.2,10.1.0.5, 10.2.0.3,10.2.0.4, 10.2.0.5, 11g,11gr2- 11.2.01, 11.2.0.3), Oracle client 8i,9i,(10g),11g,11gr2, Sun sparc servers,Sun fire servers, Linux servers, AIX servers, windows servers, Toad 9.7,ODBC for oracle ., Java JRE, Shareplex, Golden gate, customized monitoring tools, customized backup tools, customized health check tools, 11gr2/10gr2 RAC databases, EXADATA, 11gr2/10gr2 ASM.

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Maintained Development, QA, PQ, Production, Stress Testing .
• Provided 24x7 Production On call support on a rotation basis.
• Worked on 11gr2, 10gr2 RAC clusters, ASM and standby databases .
• Performed data modeling with ERWIN and ER diagrams.
• Monitored OEM .
• Supported database upgrades to 11g, migrations to Exadata servers.
• Supported transactional processing, data warehouse, and reporting systems .Maintained RMAN backups.
• Maintained Golden gate / shareplex replication jobs.
• Supported Informatica workflows.
• Worked on 8x, 9i, 10g, 10gr2, 11g, 11gr2 2 node, 3 node oracle RAC clusters, grid control, ASM, OEM .

Environment: Sun Solaris 5.10, Sun Solaris 5.9, Linux x86, Linux x86 64, Windows NT, Oracle Database Enterprise Edition ( 7.3, 8.1.7.4, 8.0.6, 9.2.0.8,10.2.0.1, 10.2.0.2,10.1.0.5, 10.2.0.3,10.2.0.4, 10.2.0.5, 11g,11gr2), Oracle client 8i,9i,(10g),11g,11gr2 Sun sparc servers, . Linux servers, windows servers, Toad 9.7,ODBC for oracle ., Shareplex, Golden gate, Borland star team .

Confidential, Emeryville, CA

Oracle Database Administrator

Responsibilities:

• Installed 11g R2 RAC build setup along with the 11g R2 cluster ware. Migration of Oracle Databases (11g, 10g, 9i, 8i).
• Upgraded from 10.2.0.1 to 10.2.0.5, 10.2.0.5 to 11.2.0.2.
• Performed regular Database Administration activities -. Installation of 11g r2, Cloning Databases, Dataguard, Database Reorg and Backup and Recovery. Data .
• Maintained filer space of 8TB for disk/tape backups and 3 RMAN catalog databases . Installed 10g, 10gr2, 11g, 11gr2 oracle RAC cluster setups, grid control, ASM, OEM and oracle clients.

Environment: Sun Solaris 5.10, Sun Solaris 5.9, Linux x86, Linux x 86 64, Windows NT, Windows 2000, Windows 2003, Oracle Database Enterprise Edition ( 7.3, 8.1.7.4, 8.0.6, 9.2.0.8,10.2.0.1, 10.2.0.2,10.1.0.5, 10.2.0.3,10.2.0.4, 10.2.0.5, 11g,11gr2), Oracle client 8i,9i,(10g),11g,11gr2 Sun sparc servers, AIX servers . Linux servers, windows servers.

Confidential, San Francisco, CA

Oracle Database Administrator

Responsibilities:

• Supported production databases in Confidential group .
• Migrated, and copied pre-production performance testing databases for data center move to Tempe,Arizona.SIZES-600 GB to 6 TB.

Environment: Sun Solaris 5.8, 5.10, Windows NT, Oracle Database Enterprise Edition ( 9.2.0.8, 10.2.0.2, 10.2.0.3 ), Oracle client (10g), Exceed Hummingbird connectivity, Sun sparc servers, Sun netra t-12 servers, Secure-FX, Secure CRT .

Confidential, NY

Database Administrator

Responsibilities:

• Maintained high availability for 10g version 3, 9.2.0.6 databases on Solaris, AIX, and Linux Servers.
• Supported releases with change processes to QA, UAT, DEV, production as SME. Handled 10.2.0.3 for very large database sizes. Sizes of databases range from 10 to 20 TB .
• Performed DR test. Provided support as ON-CALL DBA on rotation. Supported oracle 10g rac .

Environment: Sun Solaris 5.8, 5.10, Windows NT, Oracle Database Enterprise Edition( 9.2.0.4, 9.2.0.6, 9.2.0.8,10.2.0.1, 10.2.0.3, 10.2.0.4 ), Oracle client (10g), OEM r2, Foglight v4.1, DBArtisan, Gas Job Client, Gas Job Manager, Service center client, NAS filer, AIX 5.3.0.0, Sun sparc servers, cron scheduler, perl .