SUMMARY

• I do have banking experience as oracle DBA / Developer .
• Good experience in Gathering and Analyzing Business Requirements, Database Design, developing and implementing projects on time.
• Experience in Installation, Configuration and Re - Configuration of Oracle Database on Solaris OS, Enterprise Linux and Windows.
• Good at Implementing PL-SQL Coding Standards and writing policies and procedures like Stored Procedures, Functions, Triggers, packages, Indexes and Views.
• Experience in Design, Creating and maintaining the Oracle Database.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer.
• Oracle 10g and 11g RAC implementation & administration using Oracle Clusterware (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery)
• Experienced on ASM, RAID and golden gate.
• Expertise in configuring Oracle Streams.
• Experience in configuring Data Guard .
• Experience working on Golden gate for replication and data migration.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
• Data Modelling and normalization of tables.
• Monitoring and optimising the Database Performances through Database Tuning, System Tuning, Application/SQL Tuning.
• Planning and scheduling Physical Backups (offline/online) and Logical Backups (with Export/Import utilities).
• Expertise in UNIX shell Scripting (Bourne Shell).
• Experience in application design using Unified Modeling language (UML), Sequence diagrams, Case diagrams, Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD).
• Involved in logical and physical data modeling and schema design using Erwin tool.
• Provided support for implementing and upgrading various new and third party application in client site.
• Experience in working with Large Tables and VLDBs.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK, AWR SQL Loader etc.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Hands on experience working on High Availability Environments.
• Working experience on VMWARE Server and workstation.
• Experience in Data Transfer from Flat Files and other DBs to Oracle Database.
• Experience in applying Patches on database.
• 24 X 7 Production Database on Call Support.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL, and Windows OS, Sun Solaris, AIX

RDBMS: Oracle 11g,10g,9i,8i

Languages: SQL, PL/SQL, C, HTML, UNIX Shell Scripting.

Tools: /Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, SQL Developer, MS Access, Oracle Streams, VMWARE, VERITAS Net Backup, Putty.

Tuning Tools: AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK.

Database Modeling: Erwin 4.0, 7.3; Oracle Designer.

ORACLE EXADATA: V2 and X2

PROFESSIONAL EXPERIENCE

Confidential

Sr Database Administrator

Responsibilities:

• Installation, Configuration, Designing and Maintaining of Oracle 10g and 11g on RHEL 5.4.
• Installed and Configured, 11g RAC (2 node cluster), along with grid Infrastructure.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog for QA databases.
• Setting up and managing RMAN and Imports for Dev DB’s.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Involved in capacity planning and resource planning.
• Replication using Oracle Streams.
• Oracle Application Express 4.0.2 (APEX) installation and maintenance on both 10g and11gR2.
• Performed database tuning for daily loads and slow response issues.
• Backup and recovery of databases using RMAN.
• Monitor Alert logs for issues.
• Create Shell scripts for database maintenance tasks (Streams, Dump Destinations).
• RDA (Remote Diagnostics Agent) to collect diagnostics info from 11gR2 Exadata to report a bug on Streams Apply.

Environment: RHEL 5.4, Oracle 10g, 11g, RAC, OEM, RMAN, Data Pump, Diagnostic and Tuning Advisors,APEX, Streams.

Confidential

Lead Oracle Production Database Administrator

Responsibilities:

• Manage the team as a lead for Siemens energy projects.
• Installation, Configuration, Designing and Maintaining of Oracle 10g and 11g on RHEL 5.4.
• Installed and Configured Oracle 10g, 11g RAC (2 node cluster), CRS using ASM.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM
• Implemented the Oracle Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintain primary and standby databases.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
• Setting up and managing Hot Backups, Exports, Imports.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility
• Successfully maintained multiple databases. Implemented Grid Control for managing databases.
• Replication and data loading using Golden gate.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Involved in capacity planning and resource planning.
• Generated weekly performance reports to identify and solve the problems with performance.
• Implemented PL/SQL stored procedures, triggers to monitor the performance of Oracle databases.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Created and troubleshoot DB Links’ issues in Oracle for communicating with external databases.
• Establishing connectivity to databases and monitoring system performance
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases.
• Provided 24*7 Production Support.

Environment: RHEL 5.4, Oracle 10g, 11g, RAC, OEM, RMAN, Data Pump, Diagnostic and Tuning Advisors, Golden Gate.

Confidential

Oracle Production Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle 10g on IBM-AIX and Windows platforms.
• Installation, Configuration, Designing and Maintaining of ASM on Oracle 10g.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Performed replication using golden gate.
• Tuned SQL queries & PL/SQL Applications using AWR, ADDM, Statspack and Execution Plans.
• Applied Patches on RAC, Standalone, Standby databases.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios.
• Wrote scripts for Backup of databases, export of databases and maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Used Data Pump for export and import.
• Database Refreshing / Replication from production to testing using hot backup.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Managed undo segments, processes, memory, online redo log files, data files.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Created logical and physical design, installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN).
• Documented the Standard Processes for peers to follow.

Environment: IBM-AIX, Windows 2003, Oracle 10g, RAC, TOAD, Erwin, OEM, RMAN, Data Pump, Diagnostic and Tuning Advisors

Confidential, SanJose, CA

Oracle DBA/Developer, Oracle Production Database Administrator

Responsibilities:

• Installed and configured oracle rdbms on UNIX and windows environments.
• Responsible for administering and supporting production and development Oracle 9i, 10g Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Creating primary database storage structures (table spaces, rollback segments, etc.)
• Monitoring Scheduled jobs of the daily activities for the performance ofall the databases.
• Writing and maintaining PL/SQL blocks (Stored Procedures, Triggers, Functions)
• Prepare the documents of the process and knowledge transferring about the project to the new team members
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Developing Hot/Cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• SQL Loader to load Data.
• Tuning the databases for optimal performance.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Data Modelling and normalization of tables.
• Monitoring the Database storage and Day to Day activities.
• Configured scripts to monitor activity with database.
• Cloned Environments to create Patch Test, Development and QA Environments
• Partitioned large tables to increase the performance.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: Oracle 9i, 10g, PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, RMAN, ASMSBI

Jr. Oracle DBA/Developer

Confidential

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used STATSPACK, PERFSTAT, TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: ORACLE 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Import/Export, UNIX AIX 5.1, Windows NT.