SUMMARY

• me has 7 years working as an Oracle Database Administrator and has complete life cycle experience working in Development, Test, UAT and Production environments.
• me has extensive knowledge in Installation, backup and recovery, performance tuning, data movement, upgrades, database migration, database security and patch administration.
• me has worked on Oracle 12c, 11g, and 10g versions on different Operating system platforms.
• Experienced in Performance Tuning using AWR, ASH, EXPLAIN PLAN AND SQL TUNING ADVISOR.
• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfill teh storage needs.
• GlodenGateinstallation, configuration and troubleshooting various GG issues.
• Proficient inOracleGloden Gate installation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• High ability to analyze and understand teh AWR reports and can fine tune teh databases for maximum performance.
• Extensive experience on high availability solutions with RAC, ASM & Data Guard in Oracle 12c.
• Extensive experience on RMAN Backup & Recovery in Oracle 12c with CDB & Non CDB environment.
• Strong Exposure in Oracle ASM 12c software installation and configuration (Grid Infrastructure) and partitioning Disks in Linux.
• Experienced on ASM redundancy, Managing ASM disk failures & replace failed ASM disk with a new disk.
• Strong Exposure in creation on an Oracle 12c Multi - tenant RAC data base with 2 node cluster and instances using ASM storage.
• Experienced to take backup and restore cluster ware storage (Voting Disk, OCR Disk).
• Experienced to take backup on Oracle RAC database by using RMAN utility in a CDB (Multi-tenant) environment.
• Experienced on performing health checks in Oracle RAC & monitoring Oracle Instance.
• Hand on experience in cloning teh non-multitenant container database to pluggable database in 12c using teh PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning Feature.
• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on teh above said versions.
• Unidirectional table replication using oracle streams and also performed proof of concept on teh replication using Oracle Gloden Gate.
• Expertise in Designing, implementing and managing Backup strategy using Oracle Utility RMAN, Export/Import and Data Pump.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for teh purpose of monitoring multiple databases and application servers.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C Cloud Control.
• Implementing 10g Data guard with one physical database.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).
• Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.
• Experience in Implementation of High Availability solutions with Oracle 10g &11g (RAC), Physical Standby Databases (Data Guard)
• Experience with supporting teh Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard. Expert in RMAN backups including full, incremental and cumulative.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to teh databases.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Proficient in complete, incomplete recovery of teh database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.
• Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: AWR, ASH, ADDM, EXPLAIN PLAN, SQL ACCESS. Toad, SQL developer, Putty, NX client, WinSCP.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump Export, Import

PROFESSIONAL EXPERIENCE

Confidential - FL

Oracle DBA

Responsibilities:

• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like PeopleSoft
• Provides support for PeopleSoft and to various units with customized databases or overarching database infrastructures. Establishes PeopleSoft system specifications. Confers with users. Analyzes workflow, access, information, and security requirements. Designs system infrastructure. Establishes teh PeopleSoft system.
• Plans and executes teh selection, installation, configuration and testing of server hardware, software, LAN and WAN networks connectivity, and operating and system management systems.
• Defines system and operational policies and procedures. Maintains PeopleSoft system performance. Performs system monitoring and analysis, and performance tuning. Troubleshoots system hardware, software, networks and operating and system management systems. Designs and runs system load/stress testing. Escalates application problems to a vendor
• Initial load - direct load, direct bulk load, file to replicate, file to database utility; avoiding and handling Collisions during initial load
• Configure and build Gloden Gate Extracts/Replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Gloden Gate.
• Commit change number (CSN), checkpoint file and checkpoint table.
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 3 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Upgrade DBs from 11.2.0.4 to 12.1.
• Migrate to Multitenant Architecture using CDB and PDB of applications dat otherwise has their own instances and qualify to be PDBs.
• Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams with RCA and proposed solutions.
• Resolve lock/latch and resource contention issues during production hours
• Configure Data Guard and Broker for administration of seamless switchovers.
• Upgrade Oracle GI and DBs from 11g to 12c with physical standby DBs in place
• Utilize SPM Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.
• Generate and analyze EXPLAIN PLAN, SQL ACCLES, and SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10G, 11G and 12C environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all teh databases.
• Refreshing DEV and TEST instances with data from Production on a regular basis.
• Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EMGrid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
• Usage of enhanced features in 12C like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging, Redo Log reduction on GTTs (GLOBAL TEMPORARY TABLES) using temp undo enabled.
• Perform LOB Compression, Secure File and Deduplication in a cost-saving effort
• Experience using enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating teh switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Database monitoring/maintenance, replication process and performance tuning are done using OEM.
• Ongoing performance monitoring and cost optimization
• Decommissioning of legacy environment.

Environment: Oracle 12.1.0.2, 11.2.0.3, Red Had Linux, Sun Solaris, Windows Server 2003, VMS, TOAD, RMAN, SQL server, OEM.

Confidential - Jersey City, NJ

Oracle DBA

Responsibilities:

• Cloned/Migrated databases using RMAN and conventionally using Data Pump and traditionally using export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling teh Physical backups (hot & cold) in CRONTAB using RMAN utility and monitoring teh scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning teh users to groups and grant necessary privileges to teh relevant groups.
• Used EXPLAIN PLAN, SQL TRACE, TKPROF utilities for optimizing and tuning SQL queries.
• Responsible for continuous Monitoring of CPU usage, me/O contention, memory paging and identify teh resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning teh same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3-->Opatch
• Responsible for Creating Users, Groups, Roles, Profiles and assigning teh users to groups and grant necessary privileges to teh relevant groups.
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh Databases and viewing Alert log files & Trace files.
• Maintained teh data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all teh production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU)/ Patch Set Updates (PSU), One-off Patch) using “runInstaller” and Perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace feature using Datapump, Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Used to run scripts to check teh status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of teh databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.