SUMMARY

• Highly motivated individual with excellent communication skills and a strong desire for perfection at work activities, friendly and reliable team player with exceptional work ethics.
• Excelent understanding of RDBMS systems and working experience on Oracle database administration including Real Application Clusters,Golden Gate on 11G / 12C versions and 12C Oracle Enterprise Manager.

TECHNICAL SKILLS

Operating Systems: RHEL 6.x/5.x/4.x, Sun Solaris 9.0/10.0

Technologies: Oracle 12C/11G, GRID 12C/11G, ASM, RAC, GOLDENGATE, DATAGUARD, Entity Relationship Modeling

Programing Languages: SQL, PL/SQL, Unix shell scripting, Java, C++, C, HTML.

Tools: /Utilities: RMAN, Data Pump, SQL*Loader, Oracle Enterprise Manager, Toad, Putty, DBCA, RMAN

Backup Tools: RMAN, Datapump, Export/Import

Monitoring Tools: OEM 12c, TOAD, ASH, AWR, ADDM

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Installed and configured 12.1.0.2 grid on two node Real Application cluster and created cluster databases.
• Creating, configuration and management of 11.2.0.4 and 12.1.0.2 oracle on RHEL and SOLARIS servers.
• Performed database upgrades of single instance database from 11.2.0.4 to 12.1.0.2 databases
• Responsible for configuring and taking Full database, Incremental and Cumulative backups using RMAN utility.
• Implemented Flashback on database to support rolling back the database in case of application upgrade failures
• Performed adding and removing hosts, databases, targets and creating administration groups in oracle enterprise manager 12c
• Applied patches on 12.1.0.2 cluster nodes provided by oracle support for bug resolution
• Performed Refresh of Schema from production environment to lower environments using datapump
• Debugged Real application cluster node reboots to find root cause for node eviction
• Generated AWR reports, ADDM reports for fine performance tuning and worked closely with PL/SQL developers to tune top resource intensive SQL queries in databases.
• Enabled archive log mode on production databases allowing to replace RMAN cold backups with hot backups thus reducing database downtime.
• Monitoring the database for growth and added space to the table spaces as per demand.
• Responsible for configuring and backing up database using RMAN and performed Hot backups, Cold backups and Logical backups.
• Performed Application Tuning by tuning sql queries, identifying problematic code, creation of indexes, re - writing queries to use an optimized path
• Created change and incident tickets in Remedy and coordinated with UNIX support on server level requirements
• Experience in monitoring Oracle Database 11G and 12C using Oracle Enterprise Manager (OEM).
• Utilized OEM Advisory home to fine tune SGA, PGA memory sizes and undo tablespace size
• Managed and modified Automatic scheduler jobs, windows using DBMS SCHEDULAR package
• Collected statistics on tables using DBMS STATS and purged explain plan from shared pool to cause hard parsing and generate new explain plan
• Hands on experience in performance tuning using EXPLAIN PLAN,Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM).
• Extensively utilized server control utility SRVCTL to manage Database, ASM and LISTENER targets
• Created new range partitions on tables on yearly basis to support incoming data for the coming year
• Experience as On-Call 24x7 production DBA, monitoring OEM alerts and responding in time to resolve the underlying issue.
• Implemented Automatic memory management and set minimum values to SGA and PGA
• Modified dynamic and static parameter in both pfile and spfile to make in memory and permanent changes.
• Implemented numerous application code deployments and reviewed application scripts for potential issues.
• Created and dropped restore point in databases before performing code changes on the databases
• Created par files and set up daily expdp metadata and schema backups using CRONTAB
• Backed up spfile by creating a pfile whenever parameter changes are required
• Performed various tasks on ASM, creation of disk groups, Adding disks to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.
• Experience in designing and implementing PL/SQL stored procedures, functions, packages, triggers
• Performed Data load on different databases from flat file using SQL*Loader.
• Created db links between databases and utilized them to retrieve objects from remote databases.
• Conducted daily routine checks using alert logs and trace files for database errors and performed necessary actions to resolve the issue.
• Designed table structures, applied foreign key relationships between tables and included unique constraint to avoid data duplication.
• Created 11G/12C databases using Database Upgrade Assistance (DBUA) and manually with create database statements.
• Created indexes on columns that are used in the data retrieval condition clause to improve data retrieval speeds.
• Created and maintained oracle databases 11g and 12C on ASM and Non-ASM hosts
• Extensively utilized CRONTAB to schedule and automate maintenance jobs
• Modified extract and replicat parameter file to add tables to setup table replication
• Stopped goldengate extract, replicate and manager process to allow unix to perform server patching and brought up golden gate process once the patching was complete.
• Performed blackout on targets in OEM to avoid alerts while performing maintenance tasks
• Performed debugging of status pending on targets and restarted agent in cases where agent could not start automatically.
• Created change tickets, incident tickets using BMC remedy and presented high risk production changes in CAB - Change Review Board meetings for approval.
• Created and Managed users accounts, roles, privileges, and assigned, revoked roles and privileges from users.
• Assisted developers in creation of schema objects such as tables, indexes, materialized views, sequences and making them aware how the objects can be created, modified to provide optimal application performance.
• Involved in capacity planing and specifying CPU, memory and space requirements by considering database workload metrics.
• Raised Service requests and worked with oracle support on critical issues/bugs to analyze the cause and obtain permanent fix
• Manage agents using emctl utility and creating incident rules in enterprise manager 12c
• Application of PSU's on 11G,12C environments on single instance and mutli node RAC systems to adhere to oracle security standards and to implement bug fixes
• Performance Tuning for the SQL queries which are Running slow and consuming high resources
• Worked on day to day activities like Space management, managing user privileges managing tablespace quotas, table partitioning to improve I/O access.

Confidential

Intern Jr DBA

Responsibilities:

• Assisted in Installing and configuring oracle 11.2.0.4 software home
• Created and performed user maintenance tasks like creating users, unlocking users and assigning profiles to users.
• Performed resource management and applied user level security recommendations on user accounts using profiles.
• Implemented range partition and hash partition to improve performance.
• Created Packages, Stored procedures for automating regular developer tasks such as table truncation, statistics gathering, enabling/disabling constraints and rebuilding indexes.
• Created and Managed Schema objects like tables, indexes, constraints, views, materialized views, synonyms, DB links, sequences and triggers.
• Created DML queries to retrieve/load/update/delete data while implementing complex conditional clauses