SUMMARY

• Over Eight years of experience in Oracle Database Administration, installation, configuration, upgrades, performance tuning, backup and recovery, production support, cloning, refresh, space management, database security
• Experience in providing 24/7 production and development support of Oracle 11g RAC, Oracle 10g RAC, 9i, 8i
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Excellent experience as an Oracle DBA in various platforms such as Sun Solaris, HP-UX, AIX, Red Hat Linux, Windows etc.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database, Data Guard, Materialized views, Bi Directional Streams Replication, GoldenGate.
• Installation, Configuration and Administration of GoldenGate
• Replication using GoldenGate
• Experience in database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis, Design and Data Modeling.
• Recovery of Databases from Media failure, Block Corruptions, User errors.
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and 10g OEM Grid Monitoring.
• Experience with writing Packages, Stored Procedures, Functions and Database Triggers.
• Proficient in SQL, PL/SQL Shell Scripting and analyzed Batch programs.
• Proficient in Database Design Physical and Logical Database Design and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager TSM .
• Used EXPDP IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.
• Experience in Extracting, Transforming and Loading ETL data using SQL loader utility.
• Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases VLDB .
• Good Knowledge of SQL Server.
• Ability to work independently with Strong analytical and problem solving skills.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

RESPONSIBILITIES:

• Worked on Planning Database, Sizing table space, Create database, scripts, Monitor databases, 24x7 production support.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Responsible for DBA functions and ETL development in Data ware housing.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Configured and Upgraded to Oracle 11gR2 from 10g and from 11.2.0.2 to 11.2.0.3
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager OEM .
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Installed Golden gate as replication process for the Client's Data Store method.
• Monitored Replication Issues using Golden Gate Director, Golden gate logs and Supplemental Logging.
• Expertise in configuring Golden gate Extract, Pump Replicate.
• Performed initial load using exp/imp, Data pump, DBlinks and Golden gate proprietary initial load process.
• Used Golden agate to achieve zero/minimal downtime migration for large databases.
• Created materialized views, table partition for Tuned databases.
• Written, tested and implemented various PL/SQL and SQL scripts to monitor the pulse of the database and system.

ENVIRONMENT: Oracle 10g, 11.1, 11.2.0.2, 11.2.0.3, ASM, RMAN, OEM 11g, Golden Gate, SQL Developer, Data Modeling.

Confidential

Sr. Oracle DBA

Responsibilities:

• 24x7 production database and applications support
• Installation and configuration of Oracle 11g RAC, 10g RAC
• Converted a single instance database to Oracle 11g RAC.
• Upgraded Oracle different version from 8i, 9i to 10g and 9i to 11g, 10g to 11g.
• Involved in Capacity Planning and Optimal setting of Storage Parameters.
• Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Involved in RAC administration including Oracle 11g and 10g database, cloning, tuning, patching and monitoring.
• Applied CPU patches
• Performing Backup/Recovery of Oracle databases.
• Implemented Standby Database Active Data Guard for high availability/ disaster recovery purpose.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Developed stored procedures, packages and database triggers.
• Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention.
• Create table spaces, tables and indexes, sizing the system table space, allocating default table space for users.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Knowledge of writing Automated Scripts in the cron for backups and restoration, arch to TSM.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM to improve the performance.
• Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
• Performing SQL Loader jobs for loading data from text files.
• Installation, Configuration and Administration of GoldenGate
• Replication using GoldenGate
• Writing SQL scripts to monitor Archive log gaps in DR, monitor table space and extent growth.
• Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc
• Involved in the migration of cluster databases and single instance databases.
• Automation of Startup, Shutdown, Backup, Cloning of the databases.
• Handling day-to-day activities.

Environment: Oracle 11g RAC, 10g RAC,9i, Sun Solaris, RedHat Linux, IBM AIX, RMAN, ASM, SQL Loader, DataPump, ERWIN, TOAD, GoldenGate

Confidential

Oracle DBA.

Responsibilities:

• 24x7 production database and applications support
• Involved in Database Design with Data Architects.
• Evaluating database products and third party tools for the Project.
• Setup of the database environments for the Dev and QA teams.
• Installation and configuration of Oracle 10g RAC for High Availability
• Involved in migration of the database from Oracle 9i to Oracle 10g.
• Reorganizing Tables and Indexes for improving performance.
• Created the database objects based on the requirements for project requirement.
• Table space analysis, space allocations for tables, rollback segment monitoring and as member of application development team.
• Implemented complex business rules using database triggers and constraints.
• Adding, dropping users, creating Roles, Profiles and Grants based on the Role of the user.
• Planned and implemented database Backup on development and preproduction databases.
• Implemented Snapshots for remote objects for Reporting team.
• Testing of Backup's and Documenting backup strategies.
• Developed stored procedures, packages and database triggers.
• v Performed Diagnosis Tuned database and SQL statements as and when required.
• v Managing Production as well as Development Instances.
• v Identified and provided solutions for poorly written queries.

Environment: Oracle 11g RAC, 10g RAC,9i, Sun Solaris, RedHat Linux, IBM AIX, RMAN, ASM, SQL Loader, DataPump, ERWIN, TOAD, Oracle Streams

Confidential

Oracle DBA.

Responsibilities:

• Provided 24x7 Database Administration and support.
• Load data into Oracle using SQL Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Monitor the scheduled oracle jobs, manage data feeds, verify the log tables and tune the performance of the database.
• Provide user account administration, optimizing SQL queries optimizing developer code, manage table partitions, large data sets and provide manual reports using SQL.
• Backup and Recovery via RMAN scripts and troubleshooting.
• The size of the production databases ranges from 1TB to 6TB.
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
• Handle service requests from the business using CIT Helpdesk Service Management.
• Database Administration on application side, Web Server/Messenger Express Server Administration.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Upgrade of Database from 9.2.0.6 and to 10.2.0.2.
• Partitioned large table spaces to increase the performance of the database.
• Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
• Performed Tuning of various SQL queries to improve the performance of the database.
• Installation of Oracle 10g on HP-UX and AIX.
• Logical and Physical data modeling.
• Hard disk and Database space monitoring.
• Migrated file systems to ASM Automatic Storage Management .
• General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.

Environment: Oracle 10g RAC,9i,8i, Sun Solaris, RedHat Linux, HP-UX, IBM AIX, RMAN, ASM, SQL Loader, DataPump, ERWIN, TOAD

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration, Upgrade, Patching of Oracle RDBMS and Applications.
• The work involves overall ORACLE Database Maintenance, Performance Tuning, Backup, Recovery and other Database related activities.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Installation of Oracle version 10g on Solaris, HP-UX
• Database dot release upgrades using oracle universal installer and catpatch.sql
• Upgrade of Database from 9.2.0.6 and to 10.2.0.2
• Designing the logical and physical database structure.
• Designing the security and database access strategies.
• Logical and Physical data modeling.
• Create table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• REFRESH/CLONING of Database and applications for development, testing
• Performance Tuning of the database Memory Allocation Tuning, I/O Tuning, Tuning Contentions
• Using TKPROF, EXPLAIN PLAN, STATSPACK for the Better performance.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Partitioning Strategies for very large tables.
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Performing SQL Loader jobs for data loading.
• Data refresh from production to test and development, maintain Database Security.
• Assist Programmers and Developers with Oracle problems.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Write SQL scripts to Monitor Tablespace and Extent Growth.
• Resolve various application failures due to data entry errors or system errors.
• Involves identifying problems and implementing corrective actions.
• Providing Solutions to the Problem Faced by End Users Or Programmers.
• OS level activities like space monitoring of Mount points.
• Automation of Startup Shutdown on all Production and Development Database.
• Daily Health Check of the Database.
• Diagnose and troubleshoot Database problems and failures.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment: Oracle 10g RAC,9i,8i, RedHat Linux, HP-UX, IBM AIX, RMAN, ASM, SQL Loader, DataPump

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle Database and Oracle products.
• Creating users and maintaining database security.
• Maintained in-house Oracle Databases running on various operating systems like Windows NT and Linux.
• Designing and enforcing standards and naming conventions.
• Testing of Backup's and Documenting backup strategies.
• Implementing Backup/Recovery Strategies.
• Writing UNIX shell scripts for backup and recovery.
• Monitored SGA, Shared Memory, Memory Segments, LRUs and Buffers etc.
• System tuning for better performance.
• Creating stored procedures, packages and database triggers.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Supervised the installation and configuration of Oracle databases on Linux and Windows NT.
• Writing SQL scripts to monitor database performance.
• Writing SQL Loader control files for data loading to the payroll system.
• Database tuning, backup and recovery and general day to day running of the system.
• Used Oracle Enterprise Manager to start up and shut down databases, to check for locks, monitor and kill user sessions, monitor database performance and other day-to-day tasks.
• Systems analysis and design.
• Creating project plans and implementation schedules.

Environment: Oracle 10g, 9i, 8i, PL/SQL, RMAN, ASM, Sun Solaris, RedHat Linux, Windows