SUMMARY

Over 8 years of experience in Database, Software Development including Analysis, Design, Development and Testing of various applications in Oracle Forms/Reports environment

• Having 6 years of relevant experience in development Infrastructures and production database environments.

• As a Database Administrator, manage and support database systems, develop and design database and related infrastructure and delivery of database change. Responsible for own learning and development. Have a working knowledge of the Bank's IT infrastructure components and the processes required to maintain the infrastructure. Have an awareness of current IT development and live systems, banks architectures and strategies and computing trends.
• Have experience of different databases types associated management techniques data warehouses, Online transaction processing databases . Have experience in database administration on distributed platforms. Participating in on-call rotations. Have a working knowledge of the technical interfaces to other business and computer systems and infrastructure components to be able to assess risk factors of a change, specify changes and support other areas in their implementation of change
• Strong analytical ability, Excellent communication skills. Good team player and experienced in liaising with Principals.

TECHNICAL SKILLS

Languages Operating Systems

SQL, PL/SQL, SQL Plus UNIX, Linux, Sun Solaris, HP-Unix

Tools/Software Databases

SQL Navigator, PL/SQL Developer, Oracle 8, 8i, 9i, 10g, 11g

TOAD SQL Developer

Protocols

TELNET, FTP

EXPERIENCE

Confidential

Oracle DBA

Offshore Oracle DBA Development/UAT Datawarehousing Environment

Responsibilities:

• Assisting development team
• Index rebuilding and analyzing tables as per Client's request
• Creating / add / split / rename partitions as per the requirement
• Creating read-only schemas as per the requirement
• Grant access privilege for schema objects as per the requirement
• Monitoring user sessions duing peak hours as per user request
• Troubleshooting errors after implementing in dev environment.
• Managing development and UAT databases at OFFSHORE
• Performing all DB tasks as per all OFFSHORE development team Cochin/Bangalore/Hyd
• Coordinating with ETL admin team and monitor informatica sessions
• SQL tuning as per user requirement
• Backup and restore at schema / object level as per users requirements
• Monitor daily backups Lvl-0 archive backups thro RMAN
• Generate AWR reports and analyze as per user request
• Communicating with Oracle support for SRs as per onsite team request
• Schema refresh / object refresh as per user request
• Tablespace defragmentation activities as per onsite team request
• Executing Migration scripts as per the schedule DB changes only , as per user request
• Managing partitions and troubleshoot exchange partitions issues through PACKAGE

Other responsibilities:

• REFRESH/CLONING of Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.
• Verifying RMAN backups
• Bouncing cluster and database instances during server reboot as per the request
• Tuning Heavy database loads
• Verifying archive log deletion script RMAN on daily basis
• Construction of Standby database maximum availability

Environment: Oracle 11g 2,3 4 node cluster , OEM-GC, Exadata , ASM, Streams linux 2.6

Confidential

Oracle DBA Development Environment

Other Responsibilities:

• Development Database support Database monitoring as per the requirement
• Schema Refresh as per client request
• Export / Import through exp / expdp utility
• Index rebuilding and analyzing tables as per Client's request.
• Troubleshooting errors after implementing in live environment.
• Applying the Configuration releases as per development team request.
• Running application Batches written by developers as per Client's request.

Environment: Oracle 10g, Data Guard Physical Logical , IBM AIX, 5.3.

Confidential

Sr. Oracle DBA Implementation

Build Responsibilities:

• Building database environment in R.A.C. / non R.A.C with ASM/non-ASM
• Building Data Guard Physical standby servers for production servers as per specifications with RMAN backup ASM / non-ASM
• Deploying Shell scripts for RMAN backup database backup, archive log backup ,catalog re-sync
• Deploying Shell scripts for monitoring and other activities i.e. disk clean-up, ASM disk group size monitoring , purging old archives in standby

Task Responsibilities:

• Configuring RMAN settings for backup for every server environments.
• Deploying backup automation scripts with AutoSYS according to database environment.
• Changing protection modes Data Guard of standby server.
• Checking Switchover activity of Standby server to production before implementing in live environment.
• Performing Failover in case of primary database failure and reconfigure failed primary as standby Data guard Broker

Other Responsibilities:

• Troubleshooting errors after implementing in live environment.
• Database support includes warranty support after implementing in Live environment
• Database monitoring as per the requirement
• Schema Refresh as per client request
• RMAN cold backup restoration as per client request
• Export / Import through exp / expdp utility

Environment:

Oracle 11g , Data Guard Physical , RMAN, AIX 5.3 , Linux, Veritas NetBackup, AutoSYS