PROFESSIONAL SUMMARY:

• Sr. Database Administrator (DBA) with more than 15 years of experience designing, development and supporting High Availability database solutions in Oracle Enterprise environments including financial and retail industry.
• Excellent team building, leadership and problem solving skills. Ability toplan and manage at the operational level
• Supported Highly critical systems for critical application /global markets
• Deployed/Implemented and currently maintaining Oracle Database on Redhat Linux, Sun Solaris and AIX environments for a variety of tier - 1 applications.
• Worked as Database administration with DSS type environments.
• Database Installation, Creation, Upgradation, Applying Patches, Cross platform Database Migrations and supporting physical standby databases with Dataguard Environments
• Planned and Implementation of Backup and Recovery plan for 24X7 environment
• Worked oracle RMAN Backup and Recovery Scenario
• Experience in Database Performance Tuning: SQL*Trace, TK *Prof, Explain Plan, Staspack and by 12c grid control (SQL Tuning advisor, ADDM)
• Handled VLDB’s with Table, Index Partitioning and Database reorganization
• Worked in Database Maintenance operation: Database Analyzing, Index Rebuilding Table Reorganization,
• Experienced in Oracle Utilities: Exp/imp/SQL*Loader, OEM
• Experienced in Database Security, Role Management, and Auditing using Audit Trail and Complex Triggers/Procedures
• Debugging of Unix Shell Scripting and fixing errors in script
• Strong analytical skills, excellent ability to debug and resolve technical problems in complex systems. Able to learn new technologies and business terminologies quickly.
• Data migration from Legacy Database to Oracle Database using Sqlloader and Pl/sql programming
• Created Datamodel based on the Functional specs. DataModelling done using tools like Erwin, Rational Rose
• Experienced in FoxPro and DbaseIII programming.
• Experienced in Oracle 11g RAC.

TECHNICAL SKILLS:

RDBMS: Oracle8i/9i/10g/11g, Oracle 11g RAC, 12c. Golden Gate

O/S: Sun Solaris, SCO*UNIX, RHEL 5, AIX, Linux

Languages Known: Shell scripting in UNIX

Oracle Tools: RMAN, SQL, PL/SQL, OEM, OID

Third Party Tools: DB Art, TOAD, Pl/Sql Developer

DB Designing Tools: Oracle Designer, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Senior Database Administrator

Responsibilities:

• Successfully completed Linux to AIX and Data centre migration projects of Citibank, Japan within a given time frame
• Led an upgrade project from Lower versions to 11.2.0.4 /12 c
• Managed Critical RAC 11g RAC databases with sizes upto 5TB
• Migration of Databases from Aix to Linux. Max size of DB migrated is 3TB
• Identifying PATCH requirements and applied patches to all the databases as necessary and applied security/fix CPU Patches
• Managed Physical Standby with Dataguard and participation in yearly DR testing.
• Performing day to day Database Best Practices
• Monitoring of Small, Medium, Larger Size Oracle Production databases in 365X24X7 environment
• Database Installation, Database Creation, Up gradation, Migration, Applying of Patches including standby databases
• Planning, Implementation, Automation of Backup and Recovery Policy using RMAN
• Performing different types of database recovery thru RMAN as per business needs
• Resolving of Database Alert Proactively and Reactively
• Performing Database Tuning using TK*Prof, Explain Plan, SQL*Trace, Optimizer Hints, Auto trace,
• Performing of Ongoing Tuning of the database instances
• Monitoring and Optimizing Performance of the Database
• Performing various database Maintenance Activity
• Setting up of database Security, Roles, Auditing
• Metrics Preparation: Monthly DB Growth Metrics, Database Problem metrics
• Creation and maintenance of Standby database for Business continuity purposes
• Creation and maintenance monitoring of Golden gate replication

Environment: Sun Solaris, Windows, Oracle/10g/11g Exp/Imp, Toad, Shell Scripting, DBArtisian, Jira, RMAN, Sql Developer

Confidential, New York

Senior Database Administrator

Responsibilities:

• Essential Duties and Responsibilities include the following.
• Creation of Partitions for history tables
• Conversion of few non-partitioned tables into Partitioned tables,
• Splitting large partitions into smaller partitions.
• Written and implemented a Pl/Sql program to synchronize all the database users/passwords/role/privileges from production to non-production databases.
• Upon user requests Dev/QA/UAT databases are refreshed from production
• Analyze blocking sessions and report the cause of the blockings.
• Provide development and testing support to programmers and engineers to efficiently utilize databases.
• Troubleshoot database and application performance, tuning of Oracle Instances and application SQL
• Mentor the DBA(s)
• Co-ordination with Offshore Team

Environment: Windows, Oracle/9i/10g/11g, Datpump, SQL*Net, Pl/Sql Developer, Shell Scripting, DBArtisian, Jira, RMAN, Sql Developer

Confidential

Team Lead /Oracle DBA

Responsibilities:

• Performing day to day Database Best Practices
• Monitoring of Small, Medium, Larger Size 500+ SAP/ NON-SAP databases Oracle database with combinations of Production, Development and Quality environment for our customer.
• Database Installation, Database Creation, Up gradation, Migration, Applying of Patches
• Live re-org using quest live re-org tool / brtools for database objects to improving the database performance.
• Planning, Implementation, Automation of Backup and Recovery Policy using RMAN
• DB administrations Using Brtools and sapdba in SAP database
• Database Sizing, Memory Sizing, Database Growth, Capacity Planning
• Resolving of Database Alert Proactively and Reactively
• Providing support for Build tasks for go-live and production releases, Granting and Revoking the privileges,
• Backup monitoring using tools like Autosys and RMAN,
• Resolving Database performance issues
• Schema refreshes for future application releases,
• Performing BCV Snapshots,
• Database STATSPACK Configuration,
• Performing Database Tuning using TK*Prof, Explain Plan, SQL*Trace, Optimizer Hints, Auto trace, Dynamic Performance View
• Advising of Table Partitioning, Index Partition to Production Application Monitoring Team
• Evaluation of different types of Indexing Methods
• Performing various database Maintenance Activity
• Setting up of database Security, Roles, Auditing
• Metrics Preparation: Monthly DB Growth Metrics, Database Problem metrics
• Preparation of Database Induction Manual, Database Best Practices manual
• Onsite-Offshore Coordination
• Handling Clarify Cases and adherence to SLAs Following escalation procedures, working with Corporate Helpdesk and resolving OS related issues
• Prepare Weekly and Monthly Project status reports related to technical issues solved
• Preparing shift roasters of the Members to support in 24/7 operations

Environment: AIX, HP-UX, PC-Pentium 4.Sun Solaris 2.8, Tools, Oracle8i/9i/10g,OEM10g Grid control, SQL, PL/SQL, Shell Scripting, Autosys, Exp/Imp, SQL*Net, Toad

Confidential

Production Database DBA Support and Team Lead

Responsibilities:

• Performing day to day Database Best Practices
• Monitoring of Small, Medium, Larger Size 50 Oracle Production databases in 365X24X7 environment
• Database Installation, Database Creation, Up gradation, Migration, Applying of Patches including standby databases
• Planning, Implementation, Automation of Backup and Recovery Policy using RMAN
• Performing different types of database recovery thru RMAN as per business needs
• Resolving of Database Alert Proactively and Reactively
• Database STATSPACK Configuration,
• Performing Database Tuning using TK*Prof, Explain Plan, SQL*Trace, Optimizer Hints, Auto trace,
• Performing of Ongoing Tuning of the database instances
• Monitoring and Optimizing Performance of the Database
• Performing various database Maintenance Activity
• Setting up of database Security, Roles, Auditing
• Metrics Preparation: Monthly DB Growth Metrics, Database Problem metrics
• Preparation of Database Induction Manual, Database Best Practices manual
• Onsite-Offshore Coordination
• Prepare Weekly and Monthly Project status reports related to technical issues solved
• Preparing shift roasters of the Members to support in 24/7 operations

Environment: AIX Oracle9i/10g, OEM10g SQL, PL/SQL, Shell Scripting, Expdp/Impdp, SQL*Net, Toad, Tivoli Job management. Toad, sqlDeveloper

Confidential

Oracle Production DBA

Responsibilities:

• Performing day to day Database Best Practices
• Monitoring of Small, Medium, Larger Size 50 Oracle Production databases in 365X24X7 environment
• Database Installation, Database Creation, Up gradation, Migration, Applying of Patches
• Planning, Implementation, Automation of Backup and Recovery Policy using RMAN
• Performing different types of database recovery thru RMAN as per business needs
• Database Sizing, Memory Sizing, Database Growth, Capacity Planning
• Resolving of Database Alert Proactively and Reactively
• Database STATSPACK Configuration,
• Performing Database Tuning using TK*Prof, Explain Plan, SQL*Trace, Optimizer Hints, Auto trace,
• Performing of Ongoing Tuning of the database instances
• Monitoring and Optimizing Performance of the Database
• Performing various database Maintenance Activity
• Setting up of database Security, Roles, Auditing
• Metrics Preparation: Monthly DB Growth Metrics, Database Problem metrics
• Preparation of Database Induction Manual, Database Best Practices manual
• Onsite-Offshore Coordination

Environment: AIX Oracle9i/10g, OEM10g SQL, PL/SQL, Shell Scripting, Exp/Imp, SQL*Net, Toad, Sql Developer, Windows 2000

Confidential

Database Administrator and Pl/Sql Programmer

Responsibilities:

• Performing day to day Database Best Practices
• Writing various SQL, PL/SQL
• Design Data Model based on the given Functional specification using Erwin
• Database Installation, Database Creation, Up gradation, Migration, Applying of Patches
• Prepare Sql scripts for Loading Master data into QA and UAT environments
• Create Database and load Master data for QA and UAT environments
• Database Sizing, Memory Sizing, Database Growth, Capacity Planning
• Preparation, Testing different Benchmark for Database Performance Testing
• Resolving of Database Alert Proactively and Reactively
• Database STATSPACK Configuration,
• Performing Database Tuning using TK*Prof, Explain Plan, SQL*Trace, Optimizer Hints, Auto trace, Dynamic Performance View
• Performing of Ongoing Tuning of the database instances
• Monitoring and Optimizing Performance of the Database
• Advising of Table Partitioning, Index Partition to Production Application Monitoring Team

Environment: Oracle9i/10g, OEM10g SQL, PL/SQL, Exp/Imp, SQL*Net, Toad, Windows, Linux, Toad, Sql Developer

Confidential

Database Administrator and Pl/Sql Programmer

Responsibilities:

• Logical and Physical design model of the database
• Database Migration from Legacy database to Oracle using sqlloader and pl/sql procedures
• Creation of Production and Test Database
• Design Data Model based on the given Functional specification using Erwin
• Writing various SQL, PL/SQL for Data Migration from old system to New Oracle Database structure
• Load data using SqlLoader into temporary staging tables for Migration
• Monitoring and Management of Database logical components: Tablespaces, Tables, Indexes, Roles, Schema, User creation and enforcing security privileges and roles etc
• Automation of day to day DBA Activity using Unix Shell Script
• Performance Monitoring and Tuning of Database

Environment: Windows 2000, Sun Solaris Oracle9i OEM 9i SQL, PL/SQL, Shell Scripting, Exp/Imp, SQL*Net, Toad

Confidential

Database Administrator and Pl/Sql Programmer

Responsibilities:

• Performing day to day Database Best Practices
• Writing various SQL, PL/SQL code for report requirements
• Backup databases using exp/imp utility
• Monitoring and Management of Database logical components: Tablespaces, Tables, Indexes, Roles, Schema, User creation and enforcing security privileges and roles etc
• Performance Monitoring and Tuning of Database

Environment: Sun Solaris Oracle9i OEM 9i SQL, PL/SQL, Shell Scripting, Exp/Imp, SQL*Net, Toad