PROFESSIONAL SUMMARY:

• Oracle Database Administrator with over six years of experience of Oracle Administration including RAC 11g/ 10g/9i on platforms including Unix/Linux, HP - UX and windows, Sun Solaris in environments up to 15 TBs
• Extensive experience in database administration including production support, staging, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, and Shell Scripting as well as full documentation.
• Strong in developing Recovery Manager (RMAN) scripts for database backup and disaster Recovery including HOT and COLD backup options for both RAC and standalone Instances.
• Proficient in the installation, configuration and technical support for Oracle 10g and 11g databases as well as non-RAC databases.
• Experienced in installing and maintaining Oracle Data Guard to implement physical Standby Database for
• Disaster Recovery in 9i, 10g, 11g and Providing Critical Solutions with strategic Disaster Recovery Plans.
• Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP and experience in loading data from flat files to database using Oracle utility SQL*Loader .
• Solid experience with routine maintenance of Oracle databases including gathering stats and monitoring the databases using OEM.
• Excellent experience of data migration, data archiving and data access techniques
• Hands on experience in Hot/Cold Backup, Recovery & Cloning of databases using RMAN Skilled in setting up
• Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both
• Physical and Logical supported by Data Guard.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery using Data Guard.
• Experience in performance tuning of Different components and identifying bottle necks in performance of databases on OS, Storage, and SGA levels.
• Hands on Experience in Performance tuning and optimization using DBMS STATS, AWR and optimizer hint and tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.
• Creating and Managing Users, Roles and Privileges with required security implementations
• Strong in creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle
• Strong in writing shell scripts to setup CRON jobs for checking Adaptive server's availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.

TECHNICAL SUMMARY:

RDBMS: Oracle 11g/10g/9i, SQL Server 2000/ 2005, MS Access

OS: Red Hat Linux RHEL 3x, 4x, 5x, HP-UX 10.x, Sun Solaris 5.8,9, 10, AIX 5.1, 5.2, 5.3, WINDOWS NT/2000/2003/XP 

Technologies:  Data Guard, Grid Control, GoldenGate, Flashback

Tools:  OEM, TOAD, RMAN, SQL Developer, Hummingbird, Smart FTP, Cute FTP, Putty, Spot Light, UML, DBCA, Data guard, ASM, SQL Plus, SQL developer

DB Utilities: SQL * Loader, Exp/Imp, Datapump Utilities, RMAN, Tkprof

Languages: SQL, PL/SQL, C.

Shell scripting: Shell Script (Bourne shell & Korn Shell)

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Quincy, MA

Responsibilities:

• Worked with one another senior DBA administering all the databases (Production, Development and Quality) taking ownership of databases, problem analysis, resolution.
• Monitored database and server health through NAGIOS and TOAD
• Applied changes to database on customer requests on daily basis
• Supported portal releases in coordination with developers
• Troubleshoot the issues which are escalated by other teams.
• Administered and maintained Production instances, 24/7 Production Database Support and maintenance.
• Responsible for data migration on weekly basis from UAT to PROD environment
• Performed database backup’s using RMAN, EXPDP and TTS
• Installation of databases to Oracle 11g.
• Refresh of the database using DATAPUMP and RMAN duplicate.
• Performing development, quality and test cloning from Production databases.
• Monitored alert logs for errors and fixing them
• Monitored automated several routine tasks - Automating hot backup, Monitoring scripts - file system at OS level, archive issues, daily and weekly export, tablespace issues, and issues related to Database down, validating backup and taking action when there is backup failure. Tracking them through email.
• Applied database bug patches using OPATCH utility.
• Ran long scripts and providing the log to the requested user and monitoring Sid’s.
• Performed Refresh from production to development and quality databases as per the user request.
• Free space monitoring - adding and resizing data files.
• Managed the archived redo log files when archive destination is full.
• Gathered Statistics for tables & schemas using DBMS STATS.
• Exported and imported for the schema, table, transportable tablespace and database refresh using Datapump.
• Troubleshoot issues facing by development and testing team and resolving and providing the root cause.

Environment: Oracle Application R12.1.3, RMAN, DB Oracle 11g, 10g, SQL, SQL* Plus, Red hat Enterprise LINUX

Oracle Database Administrator

Confidential, Midland, Michigan

Responsibilities:

• Responsible for administration and supporting Oracle RAC 9i/10g/11g databases.
• Coordinated system support and performance
• Coordinated system changes with Customers and other system areas
• Performance tuning of applications and the databases Oracle 10g/9i
• Proactive database monitoring using 10g grid monitoring tool.
• Installed Oracle supplied tools to assist in database and SQL Tuning like SQLT.
• Ensured technology roadmaps are incorporated into data and database designs Leads team tasks
• Led the development of database solutions, within the guidelines identified in the Information Systems
• Development Life Cycle (ISDLC), that have high availability and scalability consistent with Customer needs,
• Mentors and develops Associates
• Installed ASM environment and migrating database from NON-ASM to ASM.
• Models compliance with company policies and procedures and supports company mission, values, and standards of ethics and integrity
• Provides and supports the implementation of business solutions
• Upgrade/Migration databases from Oracle 9i to Oracle 10g
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring
• (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• Applied various recovery scenarios for complete and incomplete recovery in case of failure
• Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota
• Monitored data files, logical data storage and data growth activities
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM
• Database links (db links) were created to access the data from remote databases.
• Monitored Cold and Hot backup scripts of the databases supporting different applications.
• Performed the logical backup at different levels like table, schema and database level.
• Interacted with other teams frequently in order to resolve different issues.
• Used Shell Scripting extensively to set up various jobs like backups, Housekeeping, and user deletion.
• Created database triggers, Indexes after analyzing SQL for optimization.
• Monitored the database lock related issues.

Environment: Oracle 9i, 10g Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, UNIX, ASM, Solaris 10, Oracle Streams, RAC, Shell Scripting. Data Guard, OEM, Oracle 10g r2, non-ASM and ASM, AIX, Linux Servers.

Oracle DBA

Confidential

Responsibilities:

• Installation of Oracle on Linux and Windows.
• Performed installations of Oracle 8i and SQL server databases.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Analyzed and suggest improvements to SQL queries and statements written by others.
• Developed stored procedures to pull the data from the distributed systems.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Maintaining daily batch cycle and providing 24/7 support.
• Developed various form-level and DML triggers to perform validation checks
• Developed Templates for new forms and generate scripts for database objects using oracle designer 10g
• Developed and implemented complex data models and logical database designs.
• Used Perl to upload files to various servers and use comprehensive error handling on failures.
• Involved in unit testing and integrated testing.
• Involved in preparing the User Test plans.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Defined database requirements and designed data model.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Provided production support to the clients on Oracle 9i database administration aspects such as database
• backup using Oracle Export Utility and database crash recovery from the backup dumps and redo logs.
• Installation of Solaris, Linux and Windows on the servers.
• Monitored tablespace related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Involved in creating the new user management and security enforcement.
• Database links (db links) were created to access the data from remote databases.
• Solved different database related issues like taking care of different processes resources, listener and connect string.
• Monitored Cold and Hot backup scripts of the databases supporting different applications.

Environment: Oracle 11gR2, 10g Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, UNIX, ASM, Linux, Oracle Streams, RAC, Shell Scripting. Data Guard, OEM, non-ASM and ASM, AIX, Linux Servers