Professional Profile

An Oracle Certified Professional Database Administrator with 18+ years of experience. I have experience working on production databases, development & test databases. Also have very good exposure to database programming using PL/SQL (Triggers, Packages, Procedures and Functions) and I am Certified in Oracle Internet Application development 6i.

• Oracle Certified Professional DBA in Oracle 10g with more than 18 years of experience on all releases of Oracle database starting from 7.3 to 11g (Release 2)on Red Hat Linux, Sun Solaris 10/9/8 and Windows.
• Extensive Experience in installing, configuring, patching, upgrading and administering Terabyte Oracle Databases on Oracle 11g,10g/9i/8.x.
• Expert in installing, configuring, patching and managing Oracle 10g RAC (Rel.1&2) on SUN Solaris and LINUX platforms.
• Strong Experience in Oracle 10g and 9i Data Guard Configurations.
• Experience in Performance Tuning such as tuning of memory, CPU, I/O distribution, Undo, redo management, sorting, swapping & paging, semaphore and shared memory segments, locks, contentions etc,using oracle provided tools like Stats pack, OEM, AWR, ADDM, ASMM, and by using third party tools like DBARTISAN.
• Expert in RMAN and Third Party Media Management vendors (TSM, Netback up) integration, planning backup strategies for Mission Critical databases and configuring Flashback databases for immediate rollback of database and faster recovery.
• Proficient in Administering, Trouble shooting, Tuning Terabyte Databases in a 24x7 environment.
• Skilled in upgrading Oracle Databases to Oracle 10g Release 2 and 1 to 11g
• Extensive experience in maintaining Disaster Recovery (DR) Sites with physical Standby Databases.
• Extensive experience in UNIX shell scripting, and in developing PL/SQL packages, stored procedures and triggers.
• Proficient in Operating System Administration on Solaris, AIX and Linux platforms.
• SQL Server Administration Version 2000, 2005 including Procedure, Function and packages.
• Web logic and Discoverer experience for Installation and configuration
• Experience as team lead.

Technical Skills

• Operating Systems: Sun Solaris, Linux, Fedora, Ubuntu UNIX, Windows 2000, Windows XP.
• Programming Languages.: Oracle SQL, PL/SQL, T-SQL
• Web Design Tools: Html, Java Script, Active Server Page, IIS
• Databases:Oracle (11g,10g, 9i, 8i, 8, 7.3 v), SQL Server(2005, 2000 & 7.0v)
• Data Modeling Tools: Data Modeling (Erwin Tool), MS- Visio
• Data Integration Tools: Informatica , Hyprion Pillar
• Reporting Tools: Crystal, Oracle, Cognos
• Other Applications: Ultipro, DBArtisan

Educational Qualification and Certifications

• M.S
• Informatics - Professional Training on Oracle DBA
• CMS Professional Training for database management
• Oracle Certified Associate—11g(database admin) ,10g(database admin) ,6i(Internet application development)

Work Experience

Client: Confidential,Virginia (Nov 2010- Present)
Role: Senior Database Administrator & Architecture
Responsibilities:

• Export Import of Schemas
• Upgrade Oracle database 10.2.0.1 to 10.2.0.4
• Setup of staging database from Production
• Backup of Databases Oracle and SQL Server
• Administration of Databases Oracle 10g and SQL Server 2005
• Performance Tuning of databases using tools like AWR and ADDM

Clients: Confidential,Virginia (Nov 2009-July 2010)
Role: Senior Database Administrator & Architecture
Responsibilities:

• Currently working for Data Architecture for upgrade of 10g system to 11g.
• Sole DBA for Installing ,upgrading ,data architecture for test and production environments.
• Database size estimation, planning, Installation & configuration Oracle 11g.
• Performed tuning of memory, CPU, I/O distribution, Undo, redo management, sorting, swapping & paging, memory leak, Semaphore and Shared Memory, locks and contentions.
• Designed and implemented a comprehensive Oracle backup & recovery architecture backup using RMAN.
• Patching, capacity planning, proactive support for maintenance of Oracle databases.
• Worked on Auditing and security with Oracle databases.
• Used oracle provided tools like ADDM, Statspack, Tkprof, Explain plan, SQL Analyze, Oracle packages and tools like oracle enterprise manager and data control.
• Implemented Oracle 10g flash recovery area and flash back feature.
• Captured the database statistics and metrics for proactive database management.
• Using RMAN, Veritas NetBackup along with SQL BackTrack for backup and recovery.
• Configured Data Guard broker to manage the Data Guard configuration Estimated failover time in seconds.
• Managed archive gaps using the Fetch Archive Log (FAL) to resolve gaps.
• Monitored the performance of redo transport services.
• Configured Oracle Data Guard to ensure high availability, data protection, and disaster recovery for enterprise data.
• Configured standby databases as physical standby and logical standby databases.
• Log apply service in real-time was enabled to apply the redo data on the standby database to maintain consistency with the primary database without requiring the redo data to be archived first on the standby database.
• Writing documentation for Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, ASM setup, Agent Deployment, SOP and so on.

Clients: Confidential,Virginia (April2008- Sep 2009)
Role: Team Lead (Senior Database Administrator and Architecture)
Responsibilities:

• Handled database size ranging from 25 GB to 4 TB.
• Responsible for RAC installation on Sun Solaris.
• Added of a node to an existing 2 node Production RAC Database.
• Added and managed database services on production RAC databases.
• Load Balancing of Services on production RAC Database.
• Creation & implementation of PL/SQL & Shell scripts with respect to automate scheduled jobs.
• Planning, communication & technical presentation for the clients.
• Database size estimation, planning, Installation & configuration.
• Migration of Oracle database from version 10g to 11g
• Database rollouts, load testing, backup strategy & contingency plan.
• Created RMAN based backup & recovery scripts for database.
• Performance Tuning of Production Databases using oracle provided tools like Statspack, Tkprof, Explain plan, SQL Analyze, Oracle packages
• Writing documentation for Clusterware installation, RAC RDBMS installation, RAC Database creation, ASM setup
• Writing production support documentation for supporting production RAC databases.
• Worked in 24/7 environment.

Environment: Sun Solaris, Oracle 9i & 10g, RAC,DATA GUARD, Streams, RMAN, Data Pump, AWR/ADDM/Statspack & TKPROF, SQL*LOADER, TKPROF, OEM, PLSQL.

Clients: Confidential, Washington DC (Sep2005- March 2008)
Role: Senior Database Administrator
Responsibilities:

• Supported Payroll , HR and Planning departments clients (39)
• Interacting with development team and estimate database size and space Requirements
• Memory management using SGA parameters (db_cache_size, shared_pool, log_buffer) before & after go-live of production server.
• Establish and maintain backup and recovery policies and procedures.
  RMAN Implementation with recovery catalog.
• Performance & Tuning of Database using AWR/ADDM/Stats pack & TKPROF.
• Migration of database using DBUA from 9i to 10g, Export/Import, Data pump & using scripts.
• Database upgrades using patches (Manual Upgrade).
• SQL tuning using explained plan, TKPROF, AWR, ADDM
• Space management issues involving resizing table spaces, data files
• Administration of all database objects, including tables, clusters, Indexes, views,Sequences, packages and procedures
  

Environment: Windows, Oracle 9i & 10g and M.S SQL Server 2000