Oracle DBA

GOLAM RABBANI

***** ********* **, ****** ****, FL-33026-4903, Mobile: 754-***-****

*****-*******@****.*** & http://rabbanis.blog.com

Oracle Certified Professional & Oracle Certified Expert with experience in project lead

SUMMARY OF QUALIFICATION

14+ years of extensive 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 with EXADATA, RAC, DATA GUARD in Oracle Enterprise Linux, Red Hat & Sun Solaris UNIX (SAN storage, RAID).

Oracle server and storage configuration with 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, 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.

Self-motivated team player with excellent verbal and writing communication skills.

Strong interpersonal skills, highly adept at diplomatically facilitating discussions and negotiations with stakeholders.

TRAINING AND CERTIFICATIONS

EXADATA Database Machine Administration (Mar 2014, Oracle Corporation)

OCE, ORACLE CERTIFIED EXPERT, Oracle RAC 11g and Grid Infrastructure Administrator (Testing ID: I00090407) (Jan 2014, Oracle Corporation).

ITIL v3 Awareness/Overview (Sep 2013, Quint).

Project Management Skills. (Jan 2012, Grameenphone, Telenor).

OCP, Oracle Database 10g Administrator Certified Professional (Testing ID: I00090407) (Oct 2009, Oracle Corporation).

Leadership Skills Course (Jan 2008, British Council, Dhaka).

Team Building Program (Apr 2006, Teamswork, Malaysia).

Advanced Training Program on Linux Networking and ISP Setup (Jun 2003, Proshika, Dhaka).

OCP, Oracle 8i Certified Professional Database Administrator (Testing ID: I00090407) (Jul 2002, Oracle Corporation).

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, 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 9/10-SPARC, HP-UX, Oracle & Red Hat Linux 6.4/6.6/7.2, Microsoft Windows NT/2000/2008.

PROFESSIONAL EXPERIENCE

Jan, 2014 – Jan, 2016 (Oracle Database Architect and Administrator Consultant, Directorate of Secondary and Higher Education, Bangladesh – Synesis IT, Dhaka, Bangladesh):

Duties:

Oracle Database Administration, Performance Tuning, Backup and Recovery.

Real Application Cluster (RAC) Administration with 3 Servers running 24x7.

Data Center Administration with network security.

Report writing and projection to higher management.

Achievements:

Lead and successfully completed Oracle 12cR1 RAC installation, DNS configuration, Pool Configuration with RAID 10 in Dell Storage Server SC4020 and Two IIS Server reconfiguration.

Without single error, upgraded Oracle database 11gR2 to 12cR1, Migrated Financial Database from traditional 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 with 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.

Jan, 2005 – Dec, 2013 (Lead Engineer, DBA – Operation System Support, GrameenPhone Ltd, Telenor Group – Dhaka, Bangladesh):

Duties:

Administer Oracle 11g RAC (two nodes) with 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.

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 with RAID, ASM, DM-Multipath.

Hardware Requirement Analysis for Oracle 10g/11g and SQL Server 2005/2008.

Dealing with 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.

Achievements:

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 without service hampering.

Oracle Data Guard upgrade from 9i and 10.1g to 11.2g without service hampering.

Migrate Databases from 18 Oracle and SQL Servers to only 7 Database Servers. Operational Expenditure (OPEX) and Capital Expenditure (CAPEX) achieved within 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 this 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.

ACADEMIC QUALIFICATION

Bachelor of Science in Computer Science.

North South University (NSU), Dhaka, Bangladesh, Nov, 2001

REFERENCES

Engr. Shohorab Ahmed Chowdhury

Managing Director, Synesis IT, Dhaka, Bangladesh

Mobile: +880 (191-***-****, Email: ***@*********.***.**

Mohammed Zakir Hussain

Pharmacy Manager, CVS Pharmacy, Florida

Mobile: 954-***-****, Email: ********@*****.***

Mohammad Mazharul Islam

Civil Engineer, Department of Transportation, NY City Corporation

Mobile: 908-***-****, Email: ***********@*****.***

Contact this candidate