SUMMARY

• Over 11+ years of extensive experience as an Oracle DBA and Applications DBA
• 1+ Years of Hadoop Administration
• 3+ Years of Oracle Exadata experience in Patching and support.
• 4+ years of experience in implementation and installation RAC Database with 2 and 4 nodes.
• 4+ Years of Data Guard experience in implementation and support.
• 3+ years of solid experience in Oracle 11i Applications (Oracle EBS) DBA.
• 3+ Years of Oracle Golden Gate experience in configuration and support.
• 3+ Years of SQL Server DBA experience in implementation and support.
• 2+ Years of DB2 Database experience in installation and monitoring
• 3+ Years Oracle DBA Development experience
• Good knowledge on Data Modeling, Data mart, Designing data warehousing boundaries and Data Transformation.
• Installation and Configuration of Oracle 12c/11g/10g/9i/8i databases on RHEL, Solaris, AIX and Windows platforms.
• Responsible for implementation and ongoing administration of Hadoop infrastructure
• Hadoop HDFS Support and maintenance
• Hadoop Hbase, Hive, Pig, Mahout.
• Performed Installation and setup of Oracle Real Application Clusters (RAC) in Oracle 10g & 11g with ASM OCFS and ACFS file system.
• Expertise in Installing and managing physical and logical standby database for Disaster Recovery (DR) and setup Oracle 11g Active Data Guard.
• Experience in Oracle Enterprise Manager (OEM) 12c/11g/10g Installation and configuration.
• Oracle Golden Gate replication experience for Oracle 10g and 11g and SQL Server.
• Proactively managed and monitor databases and database services, taking appropriate action for well documented processes.
• Oracle Recovery Manager (RMAN) expertise in setting up backup & recovery and cloning.
• Experience in performance tuning using EXPLAIN PLAN, TKPROF, AWR Reports, ADDM, ASH and SGA tuning.
• Worked as Production/Operations DBA and On - call support in 24x7 environments.
• Implemented Business Continuity Plan (BCP) and standards.
• SQL SERVER DBA experience in install/maintain SQL Server 2000, 2005 and 2008 databases.
• Experience in writing SQL, PL/SQL Packages, Stored Procedures, functions and Shell Scripting.
• DB design experience creating logical and physical design using Erwin data modeler.
• Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.
• Managed 11+ TB Oracle 10g & 11g databases in Data warehousing environment.
• 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.
• Implemented SOX/HIPAA/PCI IT controls and compliance for Oracle databases.
• Effective communication skills and record for coordination between globally located teams.
• Manage Reports, analysis and decision-making for a change request.
• Successfully managed complex projects with global implementation, and rapidly evolving requirements.
• Project delivery under stringent time lines and high pressure.
• Adept in providing Analytically Support to key business Applications /solutions.
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences.

TECHNICAL SKILLS

Oracle Technologies: Oracle Real Application Clusters (RAC), Oracle Enterprise Manager (OEM)Oracle Recovery Manager (RMAN), Data Guard, Oracle Golden GateAutomatic Storage Management (ASM), Oracle Exadata, PL/SQL, Flash Recovery Area (FRA)

Operating Systems: HP-UX 11.x, Solaris 10/9/8, RHEL 6, AIX 5.x/6.x, MS Windows Server

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

RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server 2008/2005/2000 , MySQL 5.2

Tools: /Utilities: RMAN,OEM, SQL*Loader, ASM, Export/Import, SQL Developer, SQL Navigator, Data pump, Data guard, TKPROF, EXPLAIN PLAN, AWR, ADDMIdera SQL Server Diagnostic Manager, Idera SQLSafe, Crontab, HP OpenView, HP Service Manager, putty, WinSCP, Golden gate, Patch Management, Amazon EC2, Erwin, VERITAS Net backup, CommVault.

Hadoop: HBase, Hive, Pig, Mahout, Flume

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Technical Architect

Responsibilities:

• Migration of Sybase Database to Oracle 12c Database.
• Lead DBA for Datacenter Migration Project involved in project planning, POC for migration strategy.
• Collaborate with multiple teams, work with offshore teams, 24*7 on-call production support.
• Installed Oracle 12c on RHEL 6.5 for 11g to 12c database upgrade POC.
• Installed Golden gate, created Extracts/Replicats for replication of data.
• Plan and schedule RMAN backups (hot, cold and incremental backups)
• Setup 12c Oracle Enterprise Manager (OEM)
• Cloning / Database Refresh of Oracle 10g, 11g using RMAN and user managed

Environment: Oracle 12c, 11g, IBM AIX, RHEL, SQL, PL/SQL, RMAN, Erwin, PHP Scripting.

Confidential

Responsibilities:

• Responsible for implementation and ongoing administration of Hadoop infrastructure.
• Aligning with the systems engineering team to propose and deploy new hardware and software environments required for Hadoop and to expand existing environments.
• Working with data delivery teams to setup new Hadoop users. This job includes setting up Linux users, setting up Kerberos principals and testing HDFS, Hive, Pig and MapReduce access for the new users.
• Cluster maintenance as well as creation and removal of nodes using tools like Ganglia, Nagios, Cloudera Manager Enterprise, Dell Open Manage and other tools.
• Screen Hadoop cluster job performances and capacity planning
• Monitor Hadoop cluster connectivity and security
• Manage and review Hadoop log files.
• File system management and monitoring.
• HDFS support and maintenance.
• Point of Contact for Vendor escalation

Environment: Oracle 11g R2, Java, Hive, Sqoop, HDFS, Map Reduce, Pentaho Report Designer

Confidential, Woolworth, CA

Principal DBA

Responsibilities:

• Managed Oracle 11g databases on Exadata X3-2/X3-3 machines.
• Managing 1000 + enterprise level database systems, achieving the goal of 99.99% availability at acceptable level of performance
• Performing Root Cause Analysis (RCA) and break fixes and DB releases.
• 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.
• Incidents and Ticket resolution using HP OpenView and HPSM (Service Manager)
• Designed Backup and Restore process for point in time recovery of production database.
• Monitoring and Tuning the CPU, memory usage, disk optimization, I/O contention, paging, network statistics on UNIX servers using TOP, IOSTAT, NETSTAT, VMSTAT, TOPAS, NMON.
• Space management at Database level (Tablespace) as well as OS level
• Creating and review the Change and problem incident.
• Supported Application upgrade using Oracle Flashback database for faster rollback.
• Worked as a Project Lead for DR exercise including Tier -1 critical database.
• Define standard for Database file system layout by placing the database files to appropriate Tier-1/2/3 disks.
• Conduct Real Application Testing for Major database upgrades or regular performance fixes.
• Built shell script for Database build pre-checks and analyze various enterprise requirements.
• Wrote Perl script for Database server requirements check and firewall port scan, automated DB build using Perl module.
• Worked in setting up of automatic baseline gathering for 11g databases.
• Configured Database resource manager plan directives to improve the backup timing and performance during business hours.
• Installed Oracle Data Access Component for creating linked server with MS SQL server for backup reporting.
• Configured connect time failover for JDBC thin drivers to facilitate automatic failover of weblogic connections.
• Performed the space management of database containers as per business user requirements.
• Monitored capacity utilization and performed capacity analysis and reviews to ensure sufficient capacity is provided to meet the forecasted requirements.
• Effectively supported the client’s user security model by creating profiles, roles and assign appropriate access rights to them.

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

Confidential

Sr Oracle DBA

Responsibilities:

• 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
• Upgraded databases from SQL Server 2000 to SQL Server 2005 using backup/restore.
• Created SQL Server Database Maintenance Plans for Backup, Index rebuilding, Database consistency checks and statistics updates.
• Monitoring and troubleshooting SQL Server Jobs and alerts.
• Performed troubleshooting SQL Server DTS and SSIS.
• Oracle 8i, 9i, 10g, OEM grid control, RMAN, RAC, SAN - EMC Clarion, Solaris 8, HP UNIX 11, Windows 2003, SQL Server 2000, 2005, Shell Scripting.

Environment: HPUX, Linux, HP Service Guard, Business Copy BC, Sun Solaris, Remedy 7.1, Oracle 11G, 10G, 9i, 8i. Oracle RAC, ASM, GRID, DATA GUARD, Disaster Recovery. SOX, FDA, ITIL.

Confidential

Oracle DBA

Responsibilities:

• Managed Oracle/Teradata database and client software on Unix/Linux and Windows servers to provide for the accessibility, security and integrity of data in accordance with security requirements.
• Performed upgrades, patch maintenance and integration with vendor software on MP-RAS UNIX, AIX, HP-UNIX, SUSE Linux, and NT platforms.
• Setup RMAN backup using Tivoli Storage Manager (TSM) and VERITAS Net backup.
• Responsible for Design, setup of Disaster Recovery Systems for Oracle and Teradata.
• Implemented partitioning adjustments, materialized views, summary tables, Oracle parallelism, indexing improvements, as well as SQL performance techniques.
• Design and Implement and maintain database security by reviewing audit requirements and exception process.
• Configured intelligent agents for alerting, security health check and monitoring of oracle database.
• Tuned SQL queries and PL/SQL code for many applications using OEM, V$SQL, SQL developer, AWR, and explain plans.
• Worked as a RAC SME for other DBA members.
• Designed database architecture for Implementing Sun Role Manager database used for Profile/Role management.
• Designed the operational process for NPI/API data cleansing.
• Involved in migration of databases from individual UNIX servers to HP superdome.
• Performed numerous data loads to support provisioning/de-provisioning of native systems.
• Performed data archiving on Identity Management databases.
• Performance tuned SQL queries, PL/SQL procedures, triggers, functions using AWR report and awrrpt tool.
• Setup new database environments for Data warehouse and assisted the ETL team to configure ETL tools.
• Query tuning by utilizing different join techniques and choosing the correct join based on the SQL query.
• Optimized the performance of the Teradata platform by configuring Teradata Manager, PMON and Scheduler Manager Components and setting up the alerts.
• Designed and implemented the Backup, Archive and Recovery (BAR) solution for the Oracle/Teradata database systems.
• Served as a technical lead for the configuration of Viewpoint application for the monitoring of Teradata systems.
• Configured for SSL and LDAP user authentication mechanisms, system registration, data collectors, backups, roles manager, port lets, and metrics.

Environment: Oracle 11g/10g, OEM grid control, RMAN, RAC, SAN - EMC Clarion, Solaris 8, HP UNIX 11, Windows 2003, SQL Server 2000, 2005, Shell Scripting.

Confidential

Jr. Oracle DBA

Responsibilities:

• Upgraded oracle databases to 10g, 11g and performed query tuning after optimizer changes.
• Designed architecture for new database environments and gather software/hardware requirements.
• Performed Installation of Oracle 11g Grid Infrastructure to support High Availability.
• Setup new database environments for Data warehouse and assisted the ETL team to configure ETL tools.
• Tuned SQL queries and PL/SQL code for many applications using OEM, V$SQL, SQL developer, AWR, and explain plans.
• Setup and configure Multi master Streams replication environments to support different branches.
• Performance tuned RAC databases to minimize wait events related to GCS and GES.
• Designed data model for Reconciliation of user accounts provisioned from various native systems.
• Tuning the SQL queries using sqltrpt script, SQL Profiles and implement the tuning recommendations.
• Performance tuned SQL queries, PL/SQL procedures, triggers, functions using AWR report and awrrpt tool.
• Query tuning by utilizing different join techniques and choosing the correct join based on the SQL query.
• Performance tuned Data warehouse applications by tuning queries using star join and star transformation.
• Monitored wait events like db file scattered read/db file sequential read to identify missing indexes, index with wrong columns.
• Worked with IT Risk Office to configure the CTSA user (Account provisioning tool) to create accounts in 10g databases.
• Worked as Database Architect to convert Oracle RAC to stand alone database.
• Used optimizer hints extensively for query tuning and optimize joining of remote tables.
• Query tuning using V$SQL to identify bad SQL that performs excessive Disk reads/Logical reads/executions.
• Tuned SQL queries scanning skewed data but no histograms built/stagnant indexes on the

Environment: Oracle E Business suite 11.5.10, RAC (4 node, 2node) oracle 10G, 9i, 8i, SSO, OID, RMAN and HP-UX, Sun Solaris, Linux.

Confidential

Responsibilities:

• Installed and configured Oracle 9i, 10g on RHEL and AIX environments.
• Security via Roles with select privilege (Sox Environment)
• Maintaining Oracle names and LDAP.
• Data Modeling for use cases, creating logical and physical design, schema mapping between existing legacy system and new application schema.
• Activities include Capacity planning, DB Build/Release, space management, tables pace/data file addition, database objects creation (tables, indexes, user and profile management), setup backup and recovery policy, sql tuning.
• Experience in Oracle Names and LDAP, Identity management.
• Designing the security and database access strategies and Scheduling jobs using crontab.
• Tuning SQLs using Explain Plan, SQL Trace, TKPROF reports and SQL Tuning Advisor.
• Diagnose and troubleshoot database problems and failures.

Environment: Oracle 9i, 10g, IBM AIX, RHEL, SQL, PL/SQL, RMAN, Erwin, PHP Scripting.