SUMMARY

• Over 6+ years of IT Experience as an oracle database administrator, participating in System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g & 11g in Production, Staging, and Development environments
• Prepared documentation of projects for Functional Requirement Spec (FRS), Use case Spec,
• ER - Diagram, test plan, test scripts and test Cases.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Highly motivated, excellent team player, enthusiastic, strong interpersonal and communication
• Skills in dealing with customers.
• Result-driven, reliable, resourceful, professional Oracle Database Administrator with experience in designing, implementing and maintaining Oracle 10g and 11g RDBMS. I Provide support to next-generation database solutions in Oracle at the Enterprise level. I also work across Red Hat Linux, Windows platform in development and test environment with responsibilities of Troubleshooting, Performance Monitoring & Tuning, Data Load & Migration, RMAN Backup and disaster recovery.

TECHNICAL SKILLS

RDBMS: Oracle database 11gR2/10g

LANGUAGES: Oracle SQL, Linux Shell Scripting

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows 2003

SOFTWARE/ APPLICATIONS/TOOLS: SQL*PLUS, DBCA, DBUA Netca, Net Manager, Recovery Manager (RMAN), Data Pump (expdp, impdp), SQL*Loader, OracleEnterprise Manager (OEM), Grid Control, TOAD AND SQLdevelper.

TUNING TOOLS: SQL TRACE, AWR, and ADDM.

WEB TOOLS: HTML, XML, and java.

CONTENT MNAGEMENT TOOLS: Contenful, JIRA.

AGILE: VersionOne.

PROFESSIONAL EXPERIENCE

ORACLE DATABASE ENGINEER

Confidential - Washington DC

Responsibilities:

• 24x7 Production database administration and support.
• Installed and Configured Oracle 11g databases, Standby Databases (Active Data Guard) for High Availability, Disaster Recovery and Reporting purpose.
• Extensive use of Oracle Enterprise Manager (OEM) for Monitoring SQl, Generating SQLs Explain plans, Generate AWR, ADDM and ASH reports, Generating Information Publisher Reports, Oracle database online patching etc.
• Daily monitoring of database, validating backups and monitoring performance.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Implemented Oracle database backup & recovery solutions using RMAN as well as conventional backup methods.
• Created user accounts, roles and granting required access permissions and privileges to the users based on the applications they are accessing.
• Responsible for configuring and backing up database using RMAN (Incremental Backups), Conventional Hot backups, Cold backups and Logical backups.
• Written PL/SQL Stored Procedures, functions, packages and triggers.
• Developing UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• Performed point-in-time recovery.
• Responsible for migration of databases.
• Configured Oracle Data Guard for disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Created indexes to facilitate optimal performance.
• Involved in gathering requirements from end users.
• Created, upgraded, and cloned Oracle databases for Development and testing databases.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Attending daily Agile Scrum meetings and biweekly stakeholder meetings.
• Daily, before start of business hours, I monitor the database to ensure availability and smooth functioning of databases. Daily monitoring includes checking whether all databases are running, listener is running, concurrent manager is running for Oracle databases, disk space availability, checking for errors in alert logs and trace files, checking for invalid objects, etc. Corrective action is taken for any of the problems before start of business hours.

Environment: Oracle 10g, Oracle11g RAC, Linux/Unix, Windows 2003, Data Guard, Grid Control/OracleEnterprise Manager (OEM) Cloud Control 12c, RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, SQL*Plus and SQL Developer.

Oracle DBA

Confidential - San Diego, CA

Responsibilities:

• Installation, configuration and upgrading of Oracle database server software and related
• Products
• Implement database security
• Perform backup and recovery according to policies and procedures using RMAN utility
• Performance tuning using ADDM/AWR reports
• Performed data migration usingOracle Export/Import utility
• Perform Plan growth and changes (Capacity Planning)
• Configure database network such tnsname and listener
• Apply CPU critical patch to GI and RDBMS database
• Use grid control and database control to manage databases
• Configured Exadata machine
• Maintain database integrity & security (Grant, Create User Role & Privileges)
• Refreshed the databases from PROD to UAT, QA, and DEV using RMAN

Environment: Oracle 11g, 10g, Linux, Solaris, ASM, Data Guard, RMAN, OEM

Oracle DBA

Confidential, Pittsburgh, PA

Responsibilities:

• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases on Linux and Windows platform
• Manage and monitor database storage usage (Capacity Planning)
• Cloning database with RMAN and without RMAN
• Perform bulk load into the database using SQL Loader
• Performing physical backups using RMAN Utility
• Performed data migration usingOracle Export/Import Utility
• Set up database auditing
• Managed database objects such as procedure and functions
• Communicate and coordinate with Oracle using My Oracle support for major database issues/ database Problems

Jr. Oracle Database ADMIN

Confidential  - Chicago, IL

Responsibilities:

• Installation of Solaris 10 server
• Creating directories and files in UNIX
• Inserting and editing text into files using the vi editor
• Assigning dynamic internet protocol addresses into solaris10 server
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and
• Automatic Database Diagnostics Monitor (ADDM) for optimum database performance.
• Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Created and Managed user, table spaces, data files and archive log
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.