SUMMARY

• 7 years of experience as Oracle Database administration.
• Capacity planning, Architect, Installation, configuration and perform upgrades of Oracle RDBMS on different environments and platforms.
• Extensive experience of working on Oracle 8i/9i, 10g on Sun Solaris, UNIX, IBM AIX, HP - UX, Red Hat Linux, virtual machine (VMWare) and Windows.
• Setup physical stand by database using Data Guard for disaster recovery (DR).
• Installation, configuration and Proficient use Oracle Enterprise Manager (OEM) and Grid control for managing and monitoring Oracle database.
• Used Oracle Enterprise Manager (OEM) for database performance monitoring, job scheduling etc.
• Hands on experience with Installation and Configuration of Golden Gate software for Data Replication and oracle Streams for sharing information among multiple databases and applications.
• Data synchronization using Golden Gate which includes Capture, Delivery, and Manager.
• Installed, configured and tested Oracle 10g Streams/Multimaster replication using updateable Materialized views of OLTP Environment as a proof of concept.
• Database replication for distributed database system for fast availability and data protection.
• Upgrade database, Clusterware, RAC and ASM from oracle 10g to 11g.
• Applied oracle patches for DST, upgradation and migration of databases.
• Database migration from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Designed and implemented Database Backup and Recovery strategies using RMAN, OEM, Veritas Netbackup and TSM (Tivoli storage manager) backup.
• Experience in advanced recovery methods like PITR using Flashback and SQL Backtrack.
• Schedule Parallel backup for the same file using Oracle 11g RMAN feature.
• Logical backup using and full/ partial backup export/import and Data Pump.
• Designed and implemented Backup and strategy using RMAN (Recovery Manager)
• Wrote Shell script for automated hot backup using RMAN.
• Performance tuning of RAC at cluster level and OS level by setting different cluster parameter and Kernel parameters.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and ASH Report.
• Efficient in SQL query optimization using explain plan, TKPROF, Statspack reports, gathering statistics, pinning the objects.
• Worked for Tablespace Encryption and case-sensitive passwords for better security of data.
• Communicate with Oracle, generate RDA Report and Web conference for TAR Support.
• Used database tuning advisor and SQL Profiler for performance optimization.
• Designed logical and physical Data Models using ERWIN, ER studio, DBArtisan, Rational clear case and Rational Rose forward-engineered into DDL and executed on large scale to create database.
• Layout application flow with database by ER diagram and DFD (Data flow diagram) using UML and Visio.
• Wrote UNIX shell script with and SQL scripts for monitor database and automat backup.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Monitor Database using hand written scripts, OEM, Spot light, Quest Foglight and BMC Patrol.
• Experience in various stages of Software Development Life Cycle (SDLC) and full life cycle of database administration. Advanced knowledge of SDLC.
• Working knowledge of MYSQL, Sybase, UDB and DB2.
• Worked both as a development and Production Support DBA.
• Installed, configured, administrated and maintained SQL Server databases.
• Configured standby database for SQL Server 2005 & 2008 production databases using log shipping.
• Administrated large Production database (200G to 10TB) and Large Dataware housing databases and VLDB.
• 24x7 Environment support for oracle and SQL Server. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and Confidential regular hours.
• Excellent communication and interpersonal skills Good team player analytical, and presentation skills with strong aptitude towards learning new technologies.

TECHNICAL SKILLS

RDBMS: Oracle 8i, 9i, 10g R2, Oracle 11gR1/11gR2, SQL Server 2005/2008

OS: Windows XP, 2000, SUN SOLARIS 8/9/10, HP-UX Itanium 11.31, Red Hat Linux 4/5, AIX 4.3, 5.2, 6.3

Tools: OEM, TOAD, SQL Developer, F-Secure client, Hummingbird, Smart FTP, Cute FTP, Putty, Cygwin, Spot Light, fog light, BMC Patrol Erwin, ER Studio, DBArtisan, Rational clear case, Rational Rose, Crystal reports, UML, Microsoft Visio, Rational clear quest.

DB Utilities: SQL * Loader, Exp/Imp, Datapump Utilities, RMAN, Tkprof, OLTP, ETL, data warehouse

Language: SQL, PL/SQL for Oracle, Shell programming, C/C++. Java (JDBC), .NET Framework

Scripting language: HTML, XML, VB Script, Java Script, Perl

Shell script: Unix Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Sr Oracle Database administrator

Responsibilities:

• Worked on to gather requirements for Database upgrades from 10g to 11g. Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, password (security).
• Improve performance by selectively reorganizing and defragmenting databases objects. Create and maintain the standby database to minimize damages caused by the downtime of the production database.
• Write shell scripts to implement strategies for backup.
• Provide Primary CARE DBA support for Oracle Applications and Administration, Configuration and Maintenance of RAC (Real Application Cluster) and Non-RAC Databases. Work within the production support team and maintain operational consistency and efficiency.
• Provide input to Project and Enhancement teams to define database storage structures (table spaces) after application developers have designed an application. Implementation of reviewed changes to production databases. Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Used Export/Import to do table level and full database defragmentation. Provided on-call production database support. Creating Indexes and Monitoring Performance. Data loading using SQL Loader (from Text files to Database). Perform Daily Logical backups using exp.
• Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish connection to Oracle database. Performed SQL Tuning by using explain plan and TKPROOF.
• Daily Monitoring Database and Table spaces Growth & Monitoring Space Availability at operating System.

Environment: Oracle 11g/10g, RedHat Linux 5.x, Sun Solaris, RAC, Toad 9.5, Erwin7.1, PL/SQL, SQL*LOADER, SQL PLUS, UNIX shell scripts.

Confidential, Tampa, FL

Oracle DBA

Responsibilities:

• Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.
• Performed upgrades from Oracle 10.2.0.3 to 11.1.0.1 on IBM-AIX.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Support and Monitor Oracle 11.1.0.1 Application instances.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Data Modeling, Database Design and Creation using ER-Win, Visio.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Based on the thresholds configured, notifications and alarms are generated. Actions are executed and gathering performance data for planning, analysis, and reporting.
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing, and performance tools in physical/logical databases
• Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases
• Designing the security and database access strategies using tools like ESM
• Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.
• 24x7 production support for several mission critical systems which utilize multiple Oracle 9i, 10g and 11g databases.

Environment: Oracle Server 11g/10g, SQL, PL/SQL, Sun Solaris 10, RedHat Linux 5.x

Confidential, Dublin, OH

Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Applying patches for both Server side and Client side.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrading of the oracle databases from Oracle 9i to Oracle 10g.
• Standby Database (Data Guard) setup and configuration.
• Global operations and maintaining database using Oracle RAC and Data Guard/Standby databases.
• Involved in the implementation of High availability with Real Applications Clusters (oracle 11g RAC, 10g RAC), Disaster Recovery solutions with Standby Databases (DataGuard).
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF
• Working alongside programmers and contributing to the development process
• Involved in the Oracle GoldenGate installation, configuration, troubleshooting GG issues
• Creation of the Test, Development and Production Oracle 8i/9i/10g databases.
• Installed and configured of oracle 10gR2 RAC.
• Proactive Support, tuning & troubleshooting of production database.
• Managed backup recoveries, replication, data integrity validation,
• Upgraded databases, Applied patches
• Scripted proactive & DBA related health analysis & monitoring including instance, index and log health, Maintenance (Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Scheduled & coordinated database maintenance activities including such items as database reorganizations, restructures, migrations, tuning, SOX (Sarbanes-Oxley Act) sensitive views, materialized views & staged data refresh.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Monitored the growth of the database objects for capacity planning.
• Migrated databases from windows environment to HP-UNIX servers.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Developed and implemented a backup and recovery strategy and tested.
• Loading data from flat files into Oracle Database using SQL*Loader, External Tables and automated the process by using UNIX Shell scripting.

Environment: Oracle 10gRAC, 9i, RedHat Linux, HP-UX, IBM Aix, OEM, RMAN, SQL*Loader, Oracle GoldenGate

Confidential

Jr. Oracle DBA

Responsibilities:

• Design and creation of client Database instances per requirements including production and test environments.
• Organizing Oracle Database operations, installation, creation, and configuration of Databases.
• Configuration of Oracle Instance with SGA, PGA and Background Processes.
• Managing Logical objects like Tablespaces, segments, and extents.
• Maintaining indexes and performing management of Undo Data.
• Estimating table sizes, table spaces.
• Create Users and Roles with appropriate privileges and roles.
• Also define Database level authentication and OS level authentication using password file.
• Create user profiles and assign to appropriate user.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery (Instance, media).
• Performing hot/cold backup.
• Setting up of RMAN on the database to perform necessary back-up.
• Integrated the Backup Status Reporting for all the databases using shell script in Korn Shells.
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata.
• SQL query optimizing using CBO (cost base optimizer), bind variable, Explain Plan, TKPROF, stats pack and instance as per company’s requirement for high tuning.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, and production environments.
• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures, Functions and Triggers.
• Create table, view, and materialize view, private and public synonyms.
• Create user define packages and use pre-define packages.
• Different kind of Exception handling.
• Responsible for integrity and concurrency of data, locks and latches.
• Managing Oracle Forms and Reports Services
• Working with management system like DBMS and RDBMS with specific functions, database tools and utilities.
• Managed and resolved design issues during development.
• Load Data from flat file to the Database using SQL * Loader.
• Also maintain 24 X 7 uptime for the database while carrying out the activities.

Environment: SCO UNIX, Oracle 8i, 9i, 10g RMAN, SQL Server 2005, 2008 Crystal Reports 5.0, SQL * Loader, Erwin, Toad.