SUMMARY

• Database Administrator with 8 years of experience in Installation, upgrade/migration, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle and SQL Server RDBMS.
• Experience in supporting Oracle databases 8i/9i/10g/11g in variety of different environments including UNIX, Sun Solaris, Microsoft Windows 2000/NTServers and Linux.
• Extensive expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance Tuning, Backups, Recovery,RMAN backups, Optimization, Networking, Troubleshooting.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Experience in installing Oracle patches, Migration of database across different platforms and Cloning/Data Refresh from production environment to setup test and development environments.
• Proven ability of providing production support for 24X7 on multiple databases.
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.
• Migrated single instance databases to multinode 10g RAC Real Application Cluster environment for high availability and load balancing.
• Planned and implemented high availability solutions using Oracle 10g RAC, Standby Database using Oracle Data Guard.
• Designed, installed and configured high-performance data replication solutions using Oracle GoldenGate
• Experienced in Monitoring/Analyzing performance periodically and to tune, debug and optimize the databases, applications, SQL, and PL/SQL code from time to time.
• Excellent working knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using Recovery Manager.
• Point-In-Time Recovery through RMAN.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.
• Experience with Oracle 10g features: Flash-Back Recovery, Datapump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Ability to work on own initiative and as a part of team. Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.

BS & MS Computer Science

Operating System : Windows (NT 4, 2003/2008 Prof/Adv Server, XP, 7 Professional), RedHat Linux
UNIX, Solaris.
Databases : Oracle 11g/10g/9i/8i, MS Access, SQL Server 2005.
DBA tools : SQL Navigator, SQL*Loader, Sql *Plus, 10g OEM, Grid
RMAN, DBCA, 10g Data Pump, Toad, Data
Guard, Export / Import, TKPROF, Statspack

Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH
Languages : SQL, PL/SQL, C, C++, UNIX Shell Scripting, Core java.
Web : ASP.NET, HTML, XML, Dreamweaver.
Packages : MS Office, Adobe Photoshop.

PROFESSIONAL EXPERIENCE:

Responsibilities:

• Oracle installation, creation of database, which includes physical and logical design.
• Oracle Security Patches Installation on Oracle 10g R2.
• Involved in the implementation of High Availability solutions with Oracle 10g RAC

Real Application Cluster.

• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Modify, and update database structure with respect to the following tasks: Re-Organization Database, Transfer object from tablespace to another one, changing storage parameters.
• Responsible for maintenance and support for corporate Data Warehouse.
• Involved in support for 1TB 2 Node production RAC database.
• Extracting, transforming and Loading (ETL) of data from source systems in the Data Warehouse.
• Planned, redesigned and reorganized the Oracle database.
• Installed and Configured Golden gate extracted and replicated the data across various Topologies and as well as exchanged and manipulated of data at the transactional level
  between varieties of database platforms.

• Managing Oracle database administration function involving resolution of database start-up problems; managing disk space, user profile creation and user rights management.
• Recovery management and supervision of the technical team to restore the database in-case of system failure.
• Created primary database storage structure and plan future storage requirements.
• Created database instances using appropriate INIT.ORA parameters for efficient database operations
• Assisted developers in tuning SQL statements in the applications.
• Designed and implemented crash recovery strategies, hot and cold backups.
• Support and advice the development teams on database related issues.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.
• Tuning SGA, Rollback segments, Latch contention Issues, Optimize Sort Operation
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment
• Create appropriate indexes for queries and suggesting changes to application developer.
• Implemented and maintained high availability of databases for global operation using Oracle RAC and Data Guard/Standby databases.
• Provided production support for 24X7 database availability.
• Carried out the setting up of RMAN back up schedules of databases.
• Formulated & implemented best practice guidelines for Oracle Database.
• Installed and configured oracle9i databases on Red-Hat Linux servers.

Environment: SQL*Loader, SQL*Plus, Oracle 10g/9i, Oracle Enterprise Manager, ASM, PL/SQL, RMAN, LINUX, Sun Solaris, My SQL, Erwin, Windows 2000.

Responsibilities:

• Tasked with the Oracle database administration of Oracle 10g databases.
• Performed Database creation on Unix, Solaris
• Upgraded from 9i to 10g
• Database refreshes from production
• Performed Database recovery
• Oracle 10g installations, patch application/upgrades
• On call DBA support
• Rebuilding of indexes, elimination of chaining and migrated rows
• Reviewing of PL/SQL codes
• Backup of database Logical (Import and Export) and Physical (hot and cold) procedures
• Implementation of optimization techniques to resolve performance issues
• Performed database tuning.
• Suggested concept of DBMS_STATS which comprised complete testing of suggesting technique resulted in time elapsed reduction by 60% in comparison to analyze.
• Recovery manager implementation both with and without recovery catalog, Scripting for backups (backup sets, backup pieces) and recovery scripts.
• Extensive implementation and administration of materialized views.
• Monitoring Undo segments (OEM).
• Use of Explain Plan, and Tkprof to find out performance bottleneck
• Index maintenance (implementation of Btree, Bitmap indexes as per application )
• Proposed the plan to optimize the system resources by usage of profiles and database Resource Manager.
• Experience with DATAGUARD/STANDBY databases.

Environment: Sun Solaris. Oracle Versions: Oracle 8i, 9i, 10g.

Responsibilities:

• 24x7 Production Database Administration and support
• The work involves overall maintenance of ORACLE database, performance, tuning, backup, recoveries and other database related activities.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviours
• Day to day performance monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespaces
• Diagnose and troubleshoot Database problems and failures
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database
• Handling day-to-day activities.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Solaris platform.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles
• Space management
• Maintained DATAGUARD/STANDBY Databases.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)

Environment: Oracle 9i, Linux, PL/SQL, RMAN