SUMMARY:

• Over 5 years aggregate IT experience with strong troubleshooting skills and 4 years of extensive knowledge and proficiency in oracle 10g,11g and 12c database design, administration and systems analysis.
• I have excellent communication skills and I am a great team player with a fast learning curve.
• I can work perfectly and effectively under stressful conditions where speed and accuracy are necessary for mission critical databases.
• My attention to detail and the ability to maximize system resources can be beneficial in the following areas.
• Database installation/creation/configuration
• Implementing database backup/recovery automations
• Monitoring / troubleshooting and tuning of database performance issues
• Database Upgrade / patching and Migration
• Job Automation in both ORACLE and MS SQL SERVER
• Data / database integrity and security base on compliance
• Designed, implemented and deployed HADR databases for Oracle in different data centers/customers ( RAC, Data Guard, ASM )
• Deployed oracle databases using different cloud platform technologies like AZURE and AWS.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11gR2, 10gR2 RAC, 9i, SQL Server 2005 Oracle Database

Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control

Tools & Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN, DBCA, DBUA, ADDM, Remedy.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Houston, TX

Responsibilities:

• Installation, configuration, and upgrades of Oracle databases 10g, 11g and 12c RDBMS software. 
• Experience in upgrading databases and applied PSU to multiple databases. 
• Monitored health of database by keep an eye on all Alert log and trace files and if any error comes find out the root cause & analysis for resolution. 
• Regular maintenance activities like cloning, patching and custom code migration provide by developer and working with their issues. 
• Successfully implemented Backup & Recovery using RMAN, which includes hot backups and Cold backups. 
• Proficiency in backup and recovery procedures including RMAN techniques. 
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process. 
• Implemented and managed optimum physical database design (tablespace, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space. 
• Monitored Day-Day Backups, Log's & recovering them as per the requirement. 
• Gathered, analyzed, and normalized relevant information related to, and from business processes. 
• Identified poor SQL and pass to development teams for review. 
• Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN. 
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration. 
• Performed Database Refresh in RAC Environment using transportable tablespaces, expdp, impdp on Solaris, Red Hat Linux and UNIX Platforms. 
• Successfully Implemented key RMAN 11g and 12c new features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals. 
• Experience on Performance tuning tools like AWR, ADDM, ASH, Stats packs, TKPROF, Explain Plan. 
• Generated DDL statements for creation of new database objects like tables, views, sequences, synonyms, indexes and created triggers, packages, procedures, functions and granted privileges. 
• Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance. 
• Storage and space management including tablespaces and data files. 
• Used Oracle 11g Enterprise Manager db console tools such as ADDM, AWR for diagnosing & monitoring events, jobs & performance related problems. 
• Certified and applied CPU patches on Solaris, UNIX and Red Hat Linux platforms in RAC and Non-RAC Environment. 
• Sound knowledge on refreshes using expdp/impdp. 
• Ability to troubleshoot the oracle alerts. 
• Migrated database objects from development to production instances. 
• Performed Databases Refresh and Schema level refresh as per the User request from Production 
• UAT and DEV Environments for testing purposes. 
• 24X7 production support and on call rotation.

Oracle DBA

Confidential, Columbia, MD

Responsibilities: 

• Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration. 
• Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required. 
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms. 
• Performed upgradation / Migration of 10g to 11g on brand new VM’s. 
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports. 
• Automated routine DBA tasks like backup's and stats by using Grid control job's 
• Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture. 
• 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 switchover and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration 
• Adding and removing nodes to existing Oracle database RAC configurations 
• Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment 
• Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT. 
• Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases. 
• Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates. 
• Performed activities like monitoring the database and provide maximum uptime. 
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth. 
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability.
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes.
• Created primary database objects (tables, views, indexes) once application developers have designed an application.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 11g Grid Control & SQL*Plus, as well as UNIX shell scripts. 
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.  

Oracle DBA

Confidential, Baltimore MD

Responsibilities: 

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g. 
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too. 
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables. 
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the 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 the same using AWR, ASH Explain Plan, TKPROF and SQL tuning advisor. 
• Involved in De fragmenting 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. 
• Implemented the resizing the online redo logs in production and in standby database. 
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures. 
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11gR2. 
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11g . 
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2. 
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN. 
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs. 
• Applied oracle quarterly PSU patches. 
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups. 
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files. 
• Used to run the scripts to check the 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 the databases. 
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries. 
• Maintained the data integrity and security using integrity constraints and database triggers. 
• Provided 24X7 support for all the production and development databases.