PROFESSIONAL SUMMARY:

• Over 6 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c.
• Experience as On - Call 24x7 production DBA support, application/development DBA, system administrator.
• Monitored physical I/O and Proper sizing of rollback segments.
• Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.
• Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
• Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
• Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have 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.
• Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.
• Created Users, Roles and Profiles, Privilege management with role-based security.
• Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.
• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
• Upgraded Oracle 10g database version to 11g.
• Upgraded Oracle 11g database version to 12c version
• Provided database related services to their development & QA environments.
• Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
• Upgraded various databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades
• Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC
• Configured Offline and Online Disaster recovery sites to maximized the database availability
• Applied Oracle Patches (CPU/PSUs and One-off patches)
• Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.
• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Resolve the bottlenecks in all the database environments.
• Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Over 2 years of AWS experience with IAAS which contains computer services, database services, network services to name just a few.
• Carried out several backups and recovery on databases hosted in the cloud
• I have also Done patching and backups using Amazon RDS
• Supported web applications like static websites, website hosting and dynamic web application
• Done Elastic load balancing which enable many users to access the db and avoid traffic
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

TECHNICAL PROFICIENCIES:

Operating Systems: Red Hat Linux RHEL 5.x, AIX 5.1, 5.2, 5.3 and 6.1, SOLARIS 2.5, 2.6, Windows

RDBMS: Oracle 10g, 11g and 12c

Languages: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

Software/ Applications/ Tools: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump and G olden Gate (expdp,impdp),SRVCTL,SQL*Plus

Autosys (Job scheduling): CADLP Dataminder, AWS (IAAS) with Exadat Exposure

Tuning Tools: AUTOSYS SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, WASH, DC

Oracle DBA

Environment: Oracle 11g/10g/9i, Windows, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), Service now,CA Data Minder, CMS servers, OEM, Statspack, RMAN, AWR, ADDM, DataPump, Autosys and TS (task scheduler)

Responsibilities:

• Supervision of level 2 and 1 DBA’s
• 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
• 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 The uat1 environment to uat2 to ust3
• Making sure the CMS runs on a daily base
• Applying of hotfixes 0216 to severs
• Downloading of Orchestra messaging into bloomberg servers
• Carry out COB testing once every two months for performance issues
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Creating of Autosys jobs scheduling those jobs making sure they run smoothly.
• Taking jobs off and on ice, killing jobs when necessary using Autosys.
• Running of Sql scrips such pre processing scripts and gathering the messaging evidence for the messaging team
• GoldenGate - Involved in GoldenGate setup and monitoring and administering. Hands on Troubleshooting replication errors, Networking errors & reading Trail files to identify replication issues. Performance/Latency test of GG. Hands on GoldenGate director experience. Write parameter files for EXTRACT/DATAPUMP/REPLICAT process to perform Replication/Transformation /exception handling.
• Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Preparation of High Level & Low Level Design documents.
• Scheduling most of the reboots of servers for L2 Exchange team.
• Installation of Ochestraia that is CADLP into newly build servers.
• Creating changes for production using service now.
• Creating INC’s for uat’s and self assigned tickets.
• Doing most of the installations using PS ( Power Shell)

Confidential, COLLEDGE PARK, MD

Oracle DBA

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsibilities:

• Capacity planning: Allocate system storage and plan future storage requirements.
• 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
• Exadata X6 appliance which is the latest version exposure with my team
• 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
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archivelogs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• GoldenGate - Involved in GoldenGate setup and monitoring. Hands on Troubleshooting replication errors & reading Trail files to identify replication issues. Performance/Latency test of GG. Hands on GoldenGate director experience. Write parameter files for EXTRACT/DATAPUMP/REPLICAT process to perform Replication/Transformation /exception handling.
• GRID - Oracle Cloud Control 12c installation, configuration and maintenance.
• RMAN advanced features - Implementation of RMAN duplicate from active database feature for migration.
• Backup/Recovery - Write Rman Backup script as required. Restore backupset to Local server from Tape. Recover database to point-in-time on different host. Restore tables from Old backup. Recover corrupted Blocks from Rman backup. Restore backup of 10g on 11g. Involved in Corporate DR exercise. Implement Flashback features. Used backup-based duplication method for 11R2 databases.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Performed database recovery using GRP (Guarantee Restore Point)
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Experience in designing and configuring high-availability systems using DataGuard with physical standby effectively configured and used DataGuard Broker utility.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Performed logical backups using Export/Import and Data Pump
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.