PROFESSIONAL SUMMARY:

• 9+ years ORACLE DBA experience in install/maintain Oracle 7,8,8i,9i,10g and 11g databases on various UNIX/LINUX platforms.
• 4+ years ORACLE RAC experience in setup/configure Oracle 10g & 11g with ASM OCFS and ACFS file system.
• 4+ years DATA GUARD experience in setting up and managing Oracle 10g & 11g primary and standby databases.
• 3+ years Oracle Enterprise Manager (OEM) and Grid Control 10g & 11g experience in Installation and configuration.
• 2+ years GOLDENGATE replication experience for Oracle 10g and 11g and SQL Server.
• 5+ years RMAN expertise in setting up backup & recovery and cloning.
• 4+ years performance tuning using EXPLAIN PLAN, TKPROF, AWR Reports, ADDM, ASH and SGA tuning.
• 6+ years solid experience as Production/Operations DBA and On - call support in 24x7 environment.
• 3+ years SQL SERVER DBA experience in install/maintain SQL Server 2000, 2005 and 2008 databases.
• Hands on experience in SQL, PL/SQL, Shell Scripting and scheduling CRONJOB.
• DB design experience creating logical and physical design using Erwin data modeler.
• Excellent experience in managing large-scale databases 5+TB size in HA and DR setup.
• Strong administration experience in OLTP and Data warehouse environments.
• Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities.
• Maintained Oracle 11g databases in cloud environment hosted in Amazon EC2.
• Involved in full SDLC (requirement gathering/design/implement) for DB activities.
• Experience in SQL Server T-SQL, DTS, SSIS, SSRS, mirroring and clustering technology.
• Administration experience in installing TIMESTEN server, setting up DataStore and IMDB cache for Oracle.
• DBA knowledge in NoSQL database, Mongo DB.

TECHNICAL SKILLS:

Platforms: HP-UX 11, Solaris 8/9/10, AIX 5/6, RHEL 4/5, Windows NT/ 2000/2003/2008

RDBMS: Oracle 7.3/8i/9i/10g/11g, TimesTen 11g, SQL Server 6.5/7/2000/2005/2008

Languages: SQL, PL/SQL, T-SQL, HTML, XML, C, C++, Java Script, UNIX shell scripting

Networking: TCP/IP, SSH, Oracle Net Services (SQL * NET, TNS), JDBC, ODBC

Database Utilities: RMAN, SRVCTL, LSNRCTL, SQL PLUS, ASMCMD, ggsci, ttisql, expdp/impdp, OEM, OPatch, AWR, ADDM

Tools: Toad, HP OpenView, Control-M, putty, Cygwin, secure CRT, WinSCP, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Oracle DBA

Environment: Oracle 10g and 11g, 11g and 12c OEM, 10g and 11g RAC, RMAN, ASM, Active Data Guard, Golden Gate 11.2, Amazon VPC, SQL Server 2000,2005 and 2008.

Role/Key Activities:

• As an Operations DBA supporting 500+ Oracle 10g & 11g stand-alone, 2-5 node RAC databases.
• Install/Configure Oracle 11g R2 RAC (Grid Infrastructure) with ASM and ACFS file system.
• Setup/maintain Active Data Guard between primary and DR site.
• Install/maintain Oracle 11g databases in Amazon EC2 Virtual Private Cloud (VPC).
• Configure/maintain OEM 11g and 12c and install agents for database servers.
• Managing 50+ Goldengate V11.2 instances and processes used for replication.
• Setup/maintain Goldengate EXTRACT and REPLICAT groups through GGSCI.
• Performing Root Cause Analysis (RCA) and break fixes and DB releases.

Confidential, San Jose, CA

Oracle DBA

Environment: Oracle 10g, 11g R1 and R2, TimesTen 11g R2, Solaris, 11g OEM, RMAN, ttisql.

Role/Key Activities:

• Install/maintain Oracle 11g databases, 11g OEM, Configure OEM jobs for RMAN backups.
• Installation of TimesTen Server, configuring DataStore and configuring IMDB Cache for oracle.
• Setting up Data Store Name (DSN), creating TimesTen users and cachegroups.
• Configuring TimesTen Replication Active-Standby pair scheme.
• Configuring TimesTen plug-in for Oracle Enterprise manager (OEM) Grid Control.

Confidential, San Diego, CA

Senior Oracle DBA

Environment: Oracle 10g and 11g, Oracle 10g and 11g RAC, ASM, 11g OEM, RMAN, Golden Gate, RHEL 4.5

Role/Key Activities:

• Performed installation of 2-4 node Oracle 11g RAC databases with ASM.
• Maintain ASM disk groups, add and delete nodes, CRS upgrade from 10gR2 to 11gR2.
• Setup Golden Gate replication, configured REPLICAT, DATAPUMP and EXTRACT groups.
• Data extracts/load using expdp and impdp.
• Performance tuning/monitoring using AWR, EXPLAIN PLAN and ADDM.
• Performed POC on zero-downtime db upgrade/migration using golden gate initial data load, configured initial-load extract, initial-load replicat and change replicat.

Confidential, San Jose, CA

Senior Oracle DBA

Environment: Oracle 9i, 10g and 11g, OEM, RMAN, AIX 5.3/6.1, Windows 2003/2008 server

Role/Key Activities:

• Install/maintain Oracle 9i,10g and 11g databases in prod, QA and development environment which caters Peoplesoft application Environment.
• Performed 10g OEM Install, applied patches using OPatch, periodic Db health checkup, db refresh, scheduling jobs through OEM, monitoring alert log, resolving log sync up issues in stand-by databases.
• Create SR with Oracle support to resolve critical issues
• Perform/Validate backup & recovery (RMAN) strategy

Confidential, Nashua, NH

Oracle DBA

Environment: Oracle 8i, 9i, 10g R2, 11g R1 and R2, RHEL 4, BASH Shell Scripting

Role/Key Activities:

• Administering Oracle 9i, 10g and 11g databases in production, test, development environment.
• Writing BASH Shell Scripts for manual pull and push of DATA.
• Applied patches, patchsets and Critical Patch Update using OPatch and OUI.
• Tuning SQLs using Explain Plan, SQL Trace, TKPROF reports and SQL Tuning Advisor.
• Upgraded production and development database from 10.2.0.1 to 10.2.0.4.
• Monitoring and Tuning UNIX servers using TOP, PRSTAT, IOSTAT, NETSTAT, VMSTAT.
• Migrated databases from UNIX file system to Automatic Storage Management (ASM).
• Performing manual db recovery as part of EOD process for stand-by databases.
• Partitioning of large tables, indexes & rebuilding Indexes to improve the performance.

Confidential, Chelmsford, MA

DBA Lead

Environment: Oracle 9i, 10g, SQL Server 2000, 2005, Oracle EBS 11i, 10g OEM Grid Control, 10g RAC, RMAN, Control-M, Solaris 8, Windows 2003 Server

Role/Key Activities:

• Involved in database capacity planning and devising Disaster Recovery (DR) plan
• Providing L2/L3 support for 250+ oracle database instances, 20+ Oracle 11i Apps. and 50+ sql server databases
• Install/maintain 2 and 4 node 10g RAC databases with ASM
• Install/maintain Oracle Enterprise Manager (OEM) Grid Control and create/maintain repository database
• Duties include, managing data guard standby databases, monitor/validate RMAN backups, apply db patches, data refresh using exp/imp

Confidential, Fort Worth, TX

Oracle DBA

Environment: Oracle 9i, 10g, RMAN, Erwin, AIX 5.x, SQL, PL/SQL

Role/Key Activities:

• Install/Maintain Oracle 9i, 10g databases in development, QA and Production environment.
• Data Modeling for use cases, creating logical and physical design, schema mapping between existing legacy system and new application schema.
• Activities include DB Build/Release, space management, tablespace/data file addition, database objects creation (tables, indexes, user and profile management), setup backup and recovery policy, sql tuning.