SUMMARY

• 14+ years of experience as Senior Database Architect & Administrator in planning, designing, installing, configuring, upgrades and patches, performance tuning including RMAN backup and recovery, cloning, Database Security and administering multiple Oracle databases wif EXADATA, RAC, DATA GUARD in Oracle Enterprise Linux, Red Hat & Sun Solaris UNIX (SAN storage, RAID).
• Oracle server and storage configuration wif Storage Pool, RAID, ASM, space management and administration.
• Solid skills in database design, optimization and performance tuning, design and developed applications, and SQL queries, Flash - Back Recovery, Data Pump, ASM, OEM, ASH, AWR, ADDM, Automatic Undo management, OEM Grid Monitoring and Recycle Bin, SCAN, FAN, TAF, RAC ONE NODE, Server pools.
• Ability to write quickly for PL/SQL and SHELL Script in Oracle and Solaris/Linux.
• Strong interpersonal skills, adept at diplomatic discussions and negotiations wif stakeholders.
• EXADATA Database Machine Administration (Mar 2014, Confidential )
• OCE, ORACLE CERTIFIED EXPERT, Oracle RAC 11g and Grid Infrastructure Administrator (Testing ID: I00090407) (Jan 2014, Confidential ).
• ITIL v3 Awareness/Overview (Sep 2013, Quint).
• Project Management Skills. (Jan 2012, Telenor).
• OCP, Oracle Database 10g Administrator Certified Professional (Testing ID: I00090407) (Oct 2009, Confidential ).
• Leadership Skills Course (Jan 2008, British Council).
• Team Building Program (Apr 2006, Teamswork).
• Advanced Training Program on Linux Networking and ISP Setup (Jun 2003, Proshika).
• OCP, Oracle 8i Certified Professional Database Administrator (Testing ID: I00090407) (Jul 2002, Confidential ).

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c (RAC/EXADATA/Data Guard in UNIX (Solaris/HP-UX) / Linux (Oracle Enterprise Linux/Red Hat), SQL Server 2005/2008/2012, PostgreSQL, MySQL, MS Access.

Servers: Oracle EXADATA, Oracle M2000, SPARC, Sunfire, HP servers and storage.

Languages / Tools: PERL/SHELL Script, Visual Basic 6.0,.NET.

Operating Systems: Solaris, HP-UX, AIX, Oracle & Red Hat Linux, Microsoft Windows.

PROFESSIONAL EXPERIENCE

Oracle RAC DBA

Confidential

Responsibilities:

• Oracle Real Application Cluster (RAC) Administration, Performance Tuning, DB Dismantling.
• Install, Upgrade and Patch update for Oracle DBs in Linux/AIX/Solaris wif VMware and VirtualBox.
• Database Migration from Oracle 10g/11g to 12c of the Production server and EXADATA.
• Check wait events and resolve, use HCC for performance improvement in EXADATA.
• Monitor EXADATA Storage/Cell servers and Database server, Flashcache, OEM Cloud Control.
• Participate 24x7 On Call database issues, resolve security vulnerabilities, ticket and project support.
• Database Modeling and Designing, RMAN Backup and Recovery, OEM Configuring and monitoring.
• MS SQL server Administration, Backup and Upgrade.
• Migrate database into new server, SQL Performance Analysis and Tuning.
• Wifout single error, upgraded Oracle database 10g/11g to New 12cR1 RAC Database.
• Migrated Financial Database from traditional file system to ASM and from Solaris to Linux Server.
• EXADATA database and Cell Server patching.
• Clone Oracle software binaries and Database into new server which reduced time drastically.

Oracle Database Architect and Administrator Consultant

Confidential

Responsibilities:

• Oracle Database Administration, Performance Tuning, Backup and Recovery.
• Real Application Cluster (RAC) Administration wif 3 Servers running 24x7.
• Oracle Enterprise Manager Installing, Configuring and Performance Monitoring.
• Data Center Administration wif network security.
• Report writing and projection to higher management.
• Lead and successfully completed Oracle 12cR1 RAC installation, DNS configuration, Pool Configuration wif RAID 10 in Dell Storage Server SC4020 and Two IIS Server reconfiguration.
• Upgraded Oracle database 11gR2 to 12cR1, Migrated Database from file system to ASM.
• Three Dell storage server configurations for Oracle RAC.
• Successfully complete Oracle 11gR2 RAC installation and Performance tuning in two Dell PowerEdge R910 Servers wif Red Hat 6.6 installation and DNS configuration.
• From 73 locations through WAN connection hourly data backup in central Database.
• Database redesign and performance increased more than 60% after table partitioning, caching, Multithreaded Server configuring and Application tuning.

Lead Engineer, DBA/Operation System Support

Confidential

Responsibilities:

• Administer Oracle 11g RAC (two nodes) wif Automatic Storage Management (ASM) on Oracle Enterprise Linux 6.2.
• Administer Oracle 11g DATA GUARD between two nodes in different geographical locations.
• EXADATA database server and cellserver performance monitoring, other database migration into EXADATA and index, flashcache, celldisk management.
• Administer Oracle11g GlodenGate wif MS SQL Server 2008 for migration and to keep legacy data.
• Oracle DB Upgrade and Patchsets installation in single/multiple instances.
• Administer and Configure Oracle Linux, Solaris-SPARC, HP-UX, SunFire servers.
• Storage array configuration and administration wif RAID, ASM, DM-Multipath.
• Hardware Requirement Analysis for Oracle 10g/11g and SQL Server 2005/2008.
• Dealing wif Vendors and Stack holders to negotiate cost, savings and support.
• Performed SQL tuning and other database activities like tables/users/indexes creation using ORACLE Enterprise Manager, TOAD and ORACLE SQL Developer.
• PERL (SHELL) scripting for data loading from non-oracle to oracle database, job scheduling activities from the database and operating system.
• Backup/recovery (RMAN, expdp/impdp) database replication for high availability.
• Create users, roles, profiles, procedures and functions as per business requirements.
• Audit user and session to monitor CPU and resource consumer status.
• Trainer of following courses to the mentors: Oracle SQL/PL-SQL, Database Backup and Recovery, Performance Tuning, SUN SERVER Installation and Configuration, Solaris & Linux Administration, RAID, ZONE, CONTAINER configuration.
• Oracle RAC Database upgrade from 10.1g to 11.2g wifout service hampering.
• Oracle Data Guard upgrade from 9i and 10.1g to 11.2g wifout service hampering.
• Migrate Databases from 18 Oracle and SQL Servers to only 7 Database Servers. Operational Expenditure (OPEX) and Capital Expenditure (CAPEX) achieved wifin Seven Months due to Hardware/Software reduction and low power consumption.
• Project Name: Oracle DB Backup (Plan, Design and Implemented): All Seven Databases backup to geographically remote locations through Fiber network. Saves cost in perspective of Man and Machine. Engineers do not need to go onsite to collect backup as dis is already geographically remote location backup. Test Server also incorporated for DBVERIFY and backup testing.
• Awarded as a Trainer of Oracle Database 9i: SQL and PL/SQL.