SUMMARY

• 5 Years of IT Experience as an Oracle Database Administrator of real time challenging projects with system analysis, design including Monitoring and Maintenance of Database Activities.
• Highly motivated Oracle DBA with extensive knowledge and experience managing oracle 10g and 11g database environment on Windows and Nix - based OS (Linux &UNIX) Have good exposure to all stages of designing and implementation of Database and ability to understand Functional Requirements and Design Documents of Oracle (DBA, PL/SQL).
• Have been working primarily in the domain of financial services like Leasing\Loaning and Insurance
• Database administration, development, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing and space management.
• Installation and configuration of Oracle 8i, 9i, 10g, 11g, 12c databases in SOLARIS environments.
• Expertise on performing cold backups, hot backups, advanced recovery with flash back recovery method.
• Planned and implemented Oracle 10g, 11g, 12c and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
• Upgrading the database from Oracle 9i to Oracle 10g & Oracle 10g to Oracle 11g and migration of the databases using transportable database, Tablespace export/import, and DataPump utilities.
• Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).
• Creating database objects like tables, views, indexes, constraints.
• Installed and configured Oracle Grid control and deployed agents on managed targets.
• Good experience with Oracle Grid Control, Oracle Enterprise Manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.
• Experienced on creating DB links across databases.
• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).
• Configured RAC with 2 nodes.
• Cloning/replication of the databases.
• Experience in using and creating SQL, PL/SQL stored procedures, functions indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
• Create, maintain and refresh required Oracle instances/databases for development, test and production environments.
• Performance Tuning: Experience in identifying poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.
• Experience in using the Oracle Support for Service Requests for database log files related performance issues, Remote Diagnostic Agent (RDA).
• Good experience in managing large OLTP and Datawarehousing databases.
• Creating shell scripts for monitoring purposes.
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNICAL SKILLS

Databases: Oracle 7i, 8i, 9i, 10g, 11g, 12c

Operating Systems: Red Hat Linux, HP-UX, AIX, Sun Solaris and Windows

Languages: SQL, PL/SQL, C/C++, Shell Scripting, Java, Perl

Utilities: Oracle Application Express, Oracle RMAN, Oracle 10g Grid, Control, Data Guard, SQL*Loader, EXP, IMP, DataPump, SQL developer, VERITAS NetBackup

Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace, Toad, PL/SQL, Oracle Enterprise Manager, ERWIN, Putty

PROFESSIONAL EXPERIENCE

Confidential, Bowie, MD

ORACLE DBA

Responsibilities:

• I work as an Oracle DBA in this company. In this role, I have the ability to utilize my problem solving and analytical skills to solve complex relational database issues.
• Ensure adequate storage by performing capacity planning and database growth trending
• Setup and configure OEM to manage enterprise database environments
• Responsible for schema object management
• Proactive in documenting database procedures to promote knowledge transfer among DBA team
• Implementing RMAN backup and supplementing datapump exports to comply with business requirements
• Worked on 9i, 10g and 11g version
• Using AWR, ADDM and Iostat to explain and plan OS utilities for performance tuning
• Perform weekend incremental Level 0 and daily incremental Level 1 backup using Oracle backup utility RMAN
• Evaluate Oracle features and Oracle related products to ascertain benefit for company
• Establishand maintain sound backup and recovery policies and procedures
• Configure various RMAN parameters as per the requirement
• Play a vital part of Database design and implementation team
• Implement and maintain database security (created and maintained users and roles, assigned privileges)
• Perform database tuning and performance monitoring
• Work as part of a team and provided 24 support when required
• Responsible for patch management and Version Control
• Perform Complete Media Recovery of Database depends on the nature of failure
• Monitor wait sessions for performance purposes
• Clone database for purpose of testing backup scenarios

Environment: Oracle 9i, 10g and 11g, OEM, Oracle RMAN, Oracle 10g Grid, RAC, Data Center, PL/SQL, Windows

Confidential, MN

Oracle DBA

Responsibilities:

• Database Monitoring and administration of database using Enterprise Manager Grid control (OEM), APEX applications and automated UNIX shell scripts
• Upgrading Oracle Database from 7i to 10g and 11g, 8i to 10g, 9i to 10g, 10g to 11g
• Managing and supporting more than 1000 databases including Test, QA, Dev and Prod
• Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods
• Applying security related CPU and One-off patches using Opatch utility
• Installation and configuration of Oracle Grid Control
• Resolving problem tickets logged by the end users
• Conducting load test for new applications and managing Oracle Applications
• Performing Cold backup, Hot backup using conventional backups and RMAN, recovering various critical Production databases
• Preparing backup schedule which included offline, online and logical backups
• Using Export/Import, Data Pump Utilities to move the data between different databases and for backups
• Working on transportation of Tablespaces, Data Archival, Re-organization of tables and restoration
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Generating performance reports and Daily health check up of the database using utilities like AWR, Statspack and ADDM to gather performance statistics
• Identifying and tuning poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzing tables, indexes for improving the performance of the query
• Analyzing SQL statements, re-organizing database objects and creating indexes to improve the performance of the queries
• Partitioning tables to improve performance
• Creating database objects like tables, views, indexes and constraints
• Creating users and allocating appropriate Tablespace quotas with necessary privileges and roles for all databases
• Producing Design Documents and Test plans
• Working with Oracle Support for resolving the database related issues
• Working on SQL* Loader to load data from flat files, checking for Row Migration and Chaining on highly used transaction tables
• Creating new databases and configuration of TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity
• Creating PL/SQL stored procedures, functions, packages for applications
• Using supplied packages to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL file to read and write from database, DBMS SQL to write dynamic SQL etc
• Monitoring overall system performance and Database growth
• Providing 24X7 support for production environment
• Checking alert logs and background trace files on daily basis and resolving problems
• Carrying out monitoring activities for space check for database growth, backups monitoring, Materialized Views refresh, DB uptime check
• Creating shell scripts for monitoring purposes

Environment: Oracle 9i, 10g and 11g, OEM, APEX, UNIX shell scripts, QA, RMAN, Oracle Grid Control, AWR, PL/SQL, SQL* Loader

Confidential, San Antonio, TX

Oracle DBA

Responsibilities:

• Managing over 100 databases
• Work on standardization of database login setup
• DR testing
• Configuring RMAN backups
• Troubleshooting performance related issues for applications
• Implementing OEM 12c for the existing production and development databases
• Worked on 9i, 10g and 11g version
• Administration of RAC databases
• Coordinating with Data Center and application teams
• Scheduling jobs through Crontab
• Being on call support for production database critical issue
• Scheduling and applying Oracle Security Patches quarterly on Dev, Test and Prod databases
• Ensuring application team’s validation post any database maintenance activity
• Leading the team in Onsite-Offshore and Nearshore model

Environment: Oracle 9i, 10g and 11g, OEM, Oracle RMAN, Oracle 10g Grid, RAC, Data Center, PL/SQL, Windows