SUMMARY OF QUALIFICATIONS:

7 years of hands on experience in Oracle 9i/10g/11g database administration, schema implementation, tuning, backup, recovery, cloning and performance monitoring.

• Experienced in maintaining large Production, UAT, QA, SIT and DEV environments.
• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
• Planned and Implemented DR High Availability oracle solutions using Data Guard, Streams.
• Proficieny using Flash-Back Recovery, Automatic Storage Manager ASM Automatic Database Diagnostic Manager ADDM .
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control OEM .
• Have working knowledge on data replication using SHAREPLEX.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Implemented data transfer using Export/Import utilities and Data Pump.
• Automated database periodic maintenance and activities using Korn, Perl Shell Scripts, Autosys.
• Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Designed and developed PL/SQL scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Worked extensively on Oracle Version Upgradation, Migrations and Patching.
• Configured and implemented different types of Advanced Replication Models of distributed databases.
• Used Repository manager to build Repository and managed Very Large Scale Databases VLSD .
• Configured Oracle on different Operating Systems for OLTP Data Warehousing environments.
• Experienced in loading data from flat files into database tables using SQL Loader and ETL Tools like Informatica, Dataflux, Data Stage.
• Assisted in designing conceptual, Logical and physical data models using Erwin, Pl/Sql Programming, and Shell Scripts.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Worked as a team member to provide 24x7 on call support production database support.
• Oracle Certified Professional for Oracle 9i DBA
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Experience in Data Modelling Logical and Physical Design of Databases , Normalization and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good T-SQL Programming skills. Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures.
• Experience in Replication Snapshot, Merge and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.
• Worked in OLTP OLAP environment that includes Production 24x7 , QA and development databases in SQL Server.

SKILL SET:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Senior Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 11g/10g/9i on Windows and AIX series.
• Monitoring and supporting more than 40 databases.
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design tablespaces, datafiles, extents, redo logs, archive logs and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and stand alone database
• Recovered huge Database 1 Terabyte when UNDO table space got corrupted in Real Application Cluster RAC .
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Experience with streams in enqueuing and dequiuing messages.Starting and stoping streams processes.
• Perform troubleshooting of streams environment.
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Successfully implemented Backup Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Performed point-in-time recovery for a production database with the help of Archiving.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Configured and maintained archive logging for several production databases where the loss of a transaction might be fatal and are crucial at the point of Disaster Recovery.
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Involved in installation and configuration of SQL server 2000 on Dell Servers. Applied patches and service packs to keep the database at current patch level.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.

Environment: Oracle 11g/10g, Oracle 10g/RAC, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, DataGuard.

Confidential

Role: Oracle DBA

Responsibilities:

• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor ADDM , Automatic Workload Repository AWR for monitoring database performance.
• Installed and setup 10g Oracle Enterprise Manager Grid Control 10.2.0.3 and Mass Agent Deployment on several hosts.
• Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL and UNIX Shell Scripts for backups.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Created PL/SQL, SQL Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Working Experience with Latest TOAD 9.6 having new features PLSQL SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents,Logminer, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects database backup and recovery, monitoring and optimizing database performance
• Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.
• Implemented Oracle database backup recovery solutions using RMAN and Exports/Imports.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Monitored data transfer between the Database servers using DataStage, Oracle Streams/CDC, SQL Loader, MS SQL Log shipping and DTS packages.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Installed and Configured Oracle 10g databases on Linux.
• Performed automated backups and scheduling using Perl scripting.
• Upgraded Oracle databases from 9i to 10g.
• Migrated data from MS SQL Servers to Oracle, and vice versa.
• Involved in designing logical and physical data models using power designer.
• Implemented Oracle Database 10g two node Real Application Cluster RAC on a Linux system
• Installed and configured Oracle Enterprise Manager 10g Grid Control.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x, AIX 5.2, OEM, PL/SQL, Oracle 9i/10g RAC, TOAD, Erwin, Perl,STATSPACK, EXPLAINPLAN, IBM DataStage,C , Weblogic, SQL Server 2005.

Confidential

Role: Oracle DBA

Responsibilities:

• Installation and configuration of Oracle server software 9.2.0.1 and10.1.0.2 on UNIX and LINUX platforms.
• Created Oracle 9i and 10g databases, allocated system storage and planned future storage requirements for the database.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.
• Implemented the specs functionality by developing complex PL/SQL code like functions, procedures and packages.
• Automated hourly, daily, weekly system health reporting using crontab, PL/SQL and shell scripts.
• Developed UNIX shell scripts with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database. Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
• Implemented OEM for Database.
• Adjusted data models when necessary under direction of data architects.
• Implemented Recovery Manager RMAN . Created recovery catalog, performed complete and incomplete recovery using RMAN. Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Implemented replication using shareplex.
• Implemented and maintained Database security. Created / Altered / Dropped Users as and when required and administer their respective quotas.
• Implemented cloning using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
• Implemented shell scripts for backup and recovery, Imported and exported procedure, implementing transportable tablespaces.
• Created Database Links and Snapshots Materialized views using OEM and manually.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN STATSPACK.
• Knowledge in Data warehousing and implementation and supported as Oracle Database administrator Datawarehouse projects.
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.
• Implemented changes to the init parameters as per the requirements. Part of on-call team and provided 24/7 support.

Environment: Oracle 9i/10g, UNIX, LINUX, Windows 2003 server, SQL server, Shell Scripting, PL/SQL, RAC, OEM, QUEST tools, Erwin, SQL Loader, Toad, SQL Plus, Data Mover, Object Security, Import Manager, Oracle Configuration Assistant, PeopleSoft, Oracle Data guard, Oracle Universal Installer.

Confidential

Role: Oracle DBA

Responsibilities:

• Installation of Oracle 9i and creation of database.

• Performed regular Backups and Recovery as per Organization Strategy to support the database and also maintain 24 hours uptime for the database while carrying out the activities.
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Performed Partial, Complete and Metadata Exports Imports.
• Capacity Planning, Storage Allocation and Space Monitoring Management.
• Responsible for Oracle 9i logical and physical databases design, implementation and maintenance.
• Created Tables with appropriate Tablespace and Index.
• Created Users, Roles and Schemas with suitable Permissions.
• Responsible for Partitions on tables and Indexes for managing large tables.
• Maintained Logs/Backups using Imp/Exp Utilities.
• Coordinated with Unix Administrators for Space Management on various servers help in Oracle.
• Automating processes, Scheduling Jobs per user requirements using DBMS JOB.
• Database monitoring for Deadlocked process.
• Installation and configuration of Statspack and analysis of Statspack.
• Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
• Responsible for Data Integrity and Concurrent Data, Locks, Latches and Deadlocks.
• Created Users and Roles with appropriate Privileges.
• Created Materialized views and database links.
• Wrote shell scripts for monitoring the database.
• Designed logical and physical Data Models using ERWIN.

Environment: Oracle 9i, AIX 5, Sun OS 5.6, Exp/Imp, ERWIN, SQL Developer, OEM, SQL LOADER, FTP