SUMMARY:

• 15+ Years of experience as Information Technology Professional.
• Exposure to legacy Technology
• Strong database administrating & problem solving skills.
• Work effectively independently or as part of a team and manage team technically.
• Function well in fast - paced environment.
• Quick study, enjoy new challenges.
• Install & Upgrade Oracle including RAC
• Apply Security Patch/PSU
• Create New Databases
• Create DB Backup strategy using Hitachi SNAP technology for 400+ TB database
• Setup Golden Gate Replication between Oracle 11g databases
• Clone Databases
• Database version migration
• Datagurd Configuration using DGB and manual option
• Export/Import Database
• Backup & Recovery
• RMAN/Legato Backup
• SQL*Loader
• SGA Tuning
• Database/Query Tuning
• Writing CRON job
• PL/SQL programming
• SRM implementation for Oracle databases
• Installing Oracle in Solaris, Linux and Windows
• Oracle VERITAS Cluster environment
• Oracle Streams, Multi Master Snapshot replication
• Data-center consolidation
• RAC implementation
• Exadata/Super Cluser (Full/Half Rack) implementation
• Database in Oracle VM 3.2.8 Box with Linux

TECHNICAL SKILLS:

Operating System: Solaris, HP-Unix, Linux, AIX, Windows 98/2000/NT/XP

Languages: PL/SQL, T-SQL, Shell Script

Database: Oracle 12c/11g/10g/9i/8i/8, Exadata/ Super Cluser, MSSQL-Server 7/2000/2005/2008 , Ms-Access

Tools: Hitachi SNAP,IBM infosphere CDC, TOAD, Data Protector, Legato, DBSPI, WIH, Putty

Others: SQL*Loader, CellCli/dcli RMAN, Export/Import, Solaris Resource Manager, Oracle inVCS (VERITAS Cluster), RAC, DB on Oracle VM R3, Legato,BMC, WIH Gold

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Install 12c/11g RAC with data guard
• Migrated Oracle 11g Rac database to Super Cluster t5-8 and Exadata x4-8 full rack, configured DB and cell monitoring
• DB Creation/Monitoring in Super Cluser environment
• Production database support (on-call). migration/DB version upgrade
• Interact customer to understand new requirements
• Preparing and reviewing all documents deliverables to customer
• Create/Manage Unix Cron jobs
• Database install/upgrade/patches/migrate
• Critical tickets handling for all databases
• Oracle quarterly Security patch
• Datacenter migration

Technologies Used: Oracle 11g/12c, RAC, RMAN, DataGuard, Unix Shell Script, IBM infosphere CDC

Confidential

Oracle DBA

Responsibilities:

• Production database support (on-call). migration/DB version upgrade
• Interact customer to understand new requirements
• Preparing and reviewing all documents deliverables to customer
• Create/Manage Unix Cron jobs
• Database install/upgrade/patches/migrate
• Critical tickets handling for all databases
• Oracle quarterly Security patch
• Datacenter migration

Technologies Used: Oracle 10g/11g, RAC, RMAN, DataGuard, Oracle Streams, Unix Shell Script

Confidential, Atlanta

Onsite Oracle/SQL Server DBA Team Lead

Responsibilities:

• Successful migration of database for 40 databases
• Production database support for over 2 years (on-call).
• Manage Offshore team of 12 DBAs
• Manage most critical projects includes data-center migration/DB version upgrade
• Interact customer to understand new requirements
• Preparing and reviewing all documents deliverables to customer
• Create/Manage Unix Cron jobs
• Physical DataGuard Standby environment configuration and production support for GWS app.
• DataGuard broker configuration for WMS Asia application
• Database install/upgrade/patches/migrate
• Critical tickets handling for all databases
• Migration of database from 8i to 10g/11g
• Performed Proof of Concept(POC) for golden Gate to replicate between Oracle 11g databases for ETMS application, implemented in DEV and UAT environment successfully
• Oracle quarterly Security patch
• Install OEM and configure Grid Control, manage databases through grid control

Technologies Used: Oracle 8i/9i/10g/11g, Legato, HDFS, ShareFlex, Oracle Streaming, Unix Shell Script

Confidential

Senior DBA

Responsibilities:

• Served successfully as migration lead in T&T:MKT project for Oracle, MSSQL and Sybase.
• Served as technical expert to recruit entire new team of more than 20
• SME for Oracle, MSSQL and Sybase to finalize migration plan
• Preparing all documents for migration like ASMP, AOD
• Supporting databases after migration
• Several management activities like preparation Risk assessment documents, KT status report, attending different KT phase like GP(Guided Performance phase), AP (Assisted Performance phase), PP (Parallel Performance phase) review meeting, to analyze schedule and issues
• Managing new team and monitor support activities (like ticket handling and solving critical

Technologies USed: Oracle 8i/9i/10g, Data Protector, Legato, DBSPI, Perl, Unix Shell Script

Confidential

EPIS DBA

Responsibilities:

• Getting knowledge from existing team
• Preparing all documents for migration
• Supporting databases/applications after migration.
• Access control between different database environments
• Create/Manage Unix Cron jobs. Maintain inter application interfaces
• SPOC for EPIS DBA in IBM and on-demand help SPOC for other Oracle, MSSQL Databases in Ericsson account
• Writing Shell scripts for cron jobs
• Database upgrade from 8i to 10g
• New database creation
• Database cloning
• Performance Tuning
• Advance support to development team
• Installing Oracle in Solaris and Linux environment

Technologies Used: Oracle 8i/10g DBA, PL/SQL, Pro*C, Perl, Unix Shell Script, TOAD, MQ, Putty, SQL Loader, RMAN

Confidential

Oracle and MSSQL DBA, Team Lead

Responsibilities:

• Database administrator for Oracle and MSSQL
• PL/SQL and T-SQL code development
• Requirement analysis with customer and other stakeholders.
• SPOC for quality activities within the team, represented team for several audits
• Team Lead
• Preparation of several RFS and proposal
• Writing Shell scripts for cron jobs
• Database upgrade from 8i to 10g
• New database creation
• Database cloning
• Performance Tuning
• Advance support to development team
• Installing Oracle in Solaris and Linux environment

Technologies Used:Oracle 8i/9i DBA, Shell script, PL/SQL, SQL Server DBA, Oracle 11i Financial

Confidential

Application Migration lead

Responsibilities:

• Migration lead during migration planning phase
• Getting knowledge from existing team
• Application support lead after migration.
• Ticket handling using WIH
• Proposal of several small enhancements and implementation of these

Technologies Used:VB 6.0, ASP 3.0, HTML, SQL Server, Crystal Report (Web based application)

Confidential

.NET Developer and MSSQL DBA

Responsibilities:

• Developed 2 different modules
• Code review for other modules developed by other team member.
• Debugging and Testing various other module.
• T-SQL Procedure and functions creations
• Test case creation
• Development database management and help other members in database related issue

Technologies USed:SAGE Framework on .NET Framework, C#, SQL Server 2000

Confidential

.NET Developer and MSSQL DBA

Responsibilities:

• Technical Team lead
• Developed various module
• Manage team members, meet SLA and quality deliverables
• Interaction with Client for requirement analysis and status updates
• Several enhancements estimations
• Creation of test cases
• Coordinating Production roll-out activity
• Creating and maintaining development databases
• Database administration

Technologies used: ASP.NET, C#, VB.NET Oracle 9i, XML, Visual Studio .NET, Oracle 9i

Confidential, Tennessee

Developer and MSSQL DBA

Responsibilities:

• Developed various module
• Mentored team members
• Interaction with Client for requirement analysis and status updates
• Several enhancements estimations
• Creation of test cases
• Coordinating Production roll-out activity
• Creating and maintaining development databases
• Database administration
• Database Design

Technologies Used: ASP, VB, SQL Server 2000, XML, IIS5.0. HTML, Visual Studio .NET

Confidential

Developer and MSSQL DBA

Responsibilities:

• Developer
• Test case creation
• Testing/Peer Review
• Creation of T-SQL scripts for procedure and functions
• Several module development in ASP
• Database Design
• Database Administration

Technologies Used: ASP, VB, SQL Server 2000, XML, IIS5.0. HTML, DHTML, SQL Server, TSQL

Confidential

Technical Trainer

Responsibilities:

• Trains students in various technical skills, assist student practicing in Laboratory.
• Train students on HTML, DHTML,ASP, VB, SQL Server 2000, Oracle DBA
• Classes on part time basis only for Oracle DBA skills.
• Was a corporate trainer for several government organizations, namely LIC (Life Insurance Corporate), Corporation Bank etc.