SUMMARY

• Over 5+ years of IT experience working as Oracle Database Administrator.
• Around 2 yrs of experience in PL SQL Development .
• Experience in database administration, installations, configuration, upgrades, performance tuning, backup & recovery , cloning , space management, & patching .
• Expertise in Oracle Database (9i/10g/11g/12c) Administration.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Experienced in ITIL framework like Incident Management and Change management.
• Generate and interpret Automatic Workload Repository ( AWR ), Active Session History ( ASH ) and Automatic Database Diagnostic Monitor ( ADDM) reports.
• Exposure to several high - end technologies like Database Migration, Cloning, Standby DB’s, Hot and cold Database Backup & Recovery, RMAN and Disaster Recovery.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard .
• Extensively coordinated database and OS support with global vendor support team of Oracle, HP-Unix and EMC SAN Storage.
• Creating Disaster Recovery Sites (DR) for production and critical database.
• Experience in SOX Controls, compliance reporting and audit validation.
• Installed and Configured 2 node 11.2.0.1 and 12.0.1 RAC setup on Linux.
• Installing ASM environment and migrating database from NON-ASM to ASM .
• Performed logical backup of database, schemas, tables using Export/Import and DATA PUMP utility. DB User Administration and Security management .
• Used SQL * Loaders to load data from flat files into database tables.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections
• Designed and Developed shell scripts to automate the processes and to proactively monitor the database. Worked on AIX, Linux, Solaris and Windows platform.
• Proficient in creating primary database storage structures (Tablespaces) and Managing database using Schemas, Tables, Views, Indexes, synonym, functions and Triggers.
• Controlling and maintaining system security through Profiles, Roles, Privileges and Auditing. Knowledge on using DBMS Packages
• Extensive experience in Database query and Performance tuning ( Explain Plan and TKPROF utility ) of Reports and troubleshooting Oracle Application issues on OLTP.
• Involved in database design and creation. Good knowledge in Software Development Life Cycle.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Database: Oracle 9i,10g, 11g R2,Oracle 12c

DB Tuning/Monitoring Tools: RAC, ASM,DATA GUARD, Oracle Enterprise Manager (OEM) 10g,11g & 12c, TKPROF, SQL Trace, STATSPACK, SAP BRtool, EMC Networker, BMC Remedy, TOAD, Golden gate, SQL *Plus, developer

Programming: PL SQL, Shell scripting, T-SQL,SQL/PLSQL

Operating Systems Platforms: Solaris 5.10, RHEL, AIX,HP-Unix, Microsoft Windows 2003 Server, LINUX, VM Ware 12

PROFESSIONAL EXPERIENCE

SR. Oracle DBA

Confidential

Responsibilities:

• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experienced with SRVCTL for monitoring and configuring RAC Environment .
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.Refreshed non-production environments from production database backup for developers.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Perform Database cloning to setup identical databases in the production and development environments.
• Monitor and troubleshoot database backups, disk space and server availability.
• Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Creating indexes on fields that are used most often for search criteria.
• Performing reorganization activity with SAP Brtools on production server.
• Troubleshooting database/table level deadlock, blocking issue.
• Experience in SOX Controls, compliance reporting and audit validation.
• Ability to demonstrate multi-tasking capability, contingency planning, risk assessment and cost benefit analysis.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation .
• Supported 400+ databases (Production, Dev, Test, QA) for Pitney Bowes.

Oracle DBA

Confidential

Responsibilities:

• Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans.
• Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup.
• Monitor all production Oracle Databases for disk usage to plan future disk space needs per database.
• Hands on experience with tools like SQL*Plus , Export and Import Utilities along with Oracle Enterprise Manager ( OEM ), and TOAD.
• Hands on Experience in Space Management, Capacity Planning.
• Maintain Oracle service patch levels on all production oracle servers based on the client requirements. Managing Tablespaces, Data files and OS File Systems.
• Monitor all production Oracle DB servers for performance bottlenecks.
• Scheduled shell scripts cronjobs for regular maintenance and automating backups.
• Monitor and schedule backup with EMC networke r.
• Maintain Backup Policies and procedures including Hot and Cold backup.
• Involved in Database sizing, Capacity Planning. Perform Database upgrade & apply patches . Perform Space Management & Troubleshooting the database issues.

System Admin

Confidential

Responsibilities:

• Manage product data and maintain record of all sales.
• Created and managed SCHEMA, TABLES, INDEXES,VIEWS.
• Proficient in SQL DDL, DML, DCL, TCL & SELECT statements.
• Managing Tablespaces, Data files and OS File Systems.
• User Administration and profile management.