Resume

Sign in

Oracle Data

Location:
Toronto, ON, Canada
Posted:
February 18, 2020

Contact this candidate

Resume:

RAJA MOHAMED ALI MOHAMED

Experience:**+ years

Oracle DBA, Big Data Hadoop Admin & NoSQL Couchbase, MongoDB, AWS Dynamo DBA

adbukt@r.postjobfree.com

Mob: +1-647-***-****

Objective:

Over 12 years of experience as an Oracle Database Administrator - performing various tasks like RAC configuration, administration, upgrades, patching, RMAN backup and recovery, OEM monitoring, performance tuning, cloning and production support. Also working as Big Data Hadoop Administrator & NoSQL database (Couchbase, AWS Dynamo DB, Mongo DB Administrator).

Technical Skills:

ORACLE RAC DBA 11g & 12c, 19c ORACLE OEM 12c & 13c Data Guard & Oracle GoldenGate

BIGDATA Hadoop Administration (Hortonworks)

NoSQL Databases: Couchbase Database, AWS DynamoDB & Mongo DB Administration

AWS Cloud Services: Cloud Databases migrations, MySQL RDS & S3, DMS, EC2 services.

Work Experience:

Wipro Technologies, Canada – (Jun 2015 – till present & Apr 2007 – Dec 2009)

(Oracle DBA, AWS Cloud - NoSQL DBA (Couchbase, Dynamo DB & MongoDB) & Big Data Hadoop Admin)

Oracle DBA

Provided architecture design and implemented the all production database replication, backup and contingency recovery strategies for all OLTP& Data Warehouse databases in the company.

Providing L3 level production & Non-production Database support.

Configured & administrating ORACLE 12c, 11G RAC (Real Application Cluster).

Experience on ORACLE Standby /Data Guard for RAC and Non-RAC environments

Experience on ORACLE UPGRADE from / to ORACLE 10G,11G & 12c,19c & Applied many ORACLE PATCHING (PSU & one off)

Experience on configuration & Integration, Monitoring using OEM 12c & 13c Cloud Control.

Worked on Oracle DataWarehousing.

Done configuration & Administrating of GOLDENGATE 11g Replication

Analyse the database performance and performed database performance tuning

Experience on RMAN Backup & Recovery, CLONING/DB refreshes using RMAN DUPLICATE, Data Pump.

Managing ORACLE ASM on 3-PAR, PURE storage environments & Experienced in ASM storage migrations.

Experience on ITIL (Incident/Change/Problem) management process.

Big Data Hadoop Admin (Hortonworks)

Working closely with the BI team and application teams to make sure that all the big data applications are highly available and performing as expected.

Responsible for capacity planning and estimating the requirements for lowering or increasing the capacity of the Hadoop cluster and deciding the size of the Hadoop cluster based on the data to be stored in HDFS.

Troubleshooting application errors and ensuring that they do not occur again.

Working with data delivery teams to setup new Hadoop users. This job includes setting up Linux users, setting up Kerberos principals and testing HDFS, Hive, Oozie and Map Reduce access for the new users.

Setup Ambari Horton works administrative tool for all Hadoop clusters

Performance tuning of Hadoop clusters and Hadoop MapReduce routines.

Screen Hadoop cluster job performances and capacity planning

Monitor Hadoop cluster connectivity and security

Manage and review Hadoop log files.

File system management and monitoring.

HDFS support and maintenance.

Diligently teaming with the infrastructure, network, database, application and business intelligence teams to guarantee high data quality and availability.

NoSQL Databases (Couchbase DB, MongoDB & AWS DynamoDB)

Configuring the couchbase cluster for Nonprod & prod environments.

Upgrading the couchbase cluster to higher couchbase releases for enhancing the cluster performances.

Configuring Prometheus exporter for monitoring the couchbase cluster

Handling a failover, Data nodes rebalance situation

Scaling up / down the couchbase cluster size on demands.

Working closely with the application team in microservices environment.

Creating & managing the couchbase buckets.

Backing up and restoring couchbase Bucket data

Configuring the XDCR data replication with another cluster buckets

Responsible for providing the technical support MongoDB.

Configuring & upgrading the MongoDB clusters for Staging & prod environments.

Configuring & monitoring the MongoDB & Couchbase using Grafana dashboard.

Defines, designs, and implements cluster solutions, as well as, proposes and implements system enhancements that will improve the performance and reliability of the system.

Resolves issues regarding patches and impact analysis, and application issue resolution and with developers, business analysts, and end users to provide system administration support.

AWS Cloud Services (RDS, S3, EC2 & IAM, SCT, DMS)

Migrating the on-premises Oracle, MySQL databases to AWS cloud RDS databases

Configured open-source NoSQL databases like Couchbase, MongoDB databases on AWS EC2.

Storing the database backups on AWS S3 storage bucket and Restoring the backup from S3.

Migrating the on-premises Oracle Schema to MySQL RDS 8 using AWS SCT & AWS DMS services. Scaling up /down the AWS EC2 instances for Couchbase clusters using Ansible scripts.

Working on AWS events during maintenance window.

Creating IAM users and assigning the roles for accessing the AWS services.

SONY (Network Entertainment America) Mindtree Ltd, Bangalore – (Apr 2013 – Jun 2015)

Oracle DBA

Oracle 11gR2 RAC configuration and Administration

Adding & deleting nodes to/from RAC environment.

Administrating ASM for oracle 11gR2 RAC DB environments

Configuration & Administration of ORACLE DATA GUARD for RAC & Non-RAC.

Database SWITCHOVER & FAILOVER using DATAGUARD utility.

Administrating oracle 11gR2 GOLDENGATE Replication

ORACLE INSTALLATIONS for 9i/10g/11g server and Database creations.

Upgrading ORACLE Databases to 11gR2.

Patching Oracle GRID & RDBMS (PSU, One off)

Integrating OEM 12c with GoldenGate and shell scripts

Writing shell scripts for automating oracle monitoring and scheduler jobs.

Working on RMAN backups and Recovery

Database REFRESH/CLONE using RMAN DUPLICATE and ORACLE DATA PUMP

Oracle 10g and 11g database performance tuning.

Handling Database Incidents / Changes /Service requests through ticketing tool.

Attending customer meetings and coordinating with Application team for all.

DB & GoldenGate related deployments and issues.

Supporting L2 and L3 levels of Oracle DBA support.

Working in Server/Storage level DR (HACMP) Fail over and Database administration.

Oracle Physical Standby database creation for the replication of the primary database.

Recovering dropped data (table) by using Flashback table.

Automating Housekeeping activities for archive log files, Trace files.

Checking the alert log file for any errors, warnings and providing corrective action.

Administrating & Troubleshooting the Oracle Standby databases.

Analyzing Database performance by using AWR and ADDM features on demands.

Capacity Planning and recommendations to the customer

British GAS UK – IBM, Bangalore – (Apr 2013 – Jun 2015)

Oracle DBA

Configuration & Administration of ORACLE DATA GUARD for RAC & Non-RAC.

Database SWITCHOVER & FAILOVER using DATAGUARD utility.

ORACLE INSTALLATIONS for 9i/10g/11g server and Database creations.

Upgrade the ORACLE Databases from ORACLE 9i/10g to new release 11gR2.

ORACLE RAC Configuration

Adding & deleting nodes to/from RAC environment.

Applying ORACLE PATCH on quarter basis for all ORACLE Database environments.

Implementation and Administration of ORACLE ASM Storage.

Database REFRESH/CLONE using RMAN DUPLICATE and ORACLE DATA PUMP, EXP/IMP.

RMAN Backup and Recovery.

Oracle 10g and 11g database performance tuning.

Handling Database Incidents / Changes /Service requests through ticketing tool.

Attending customer meetings and coordinating with Application team for all.

DB related deployments and issues.

Supporting L2 and L3 levels of Oracle DBA support.

Working in Server/Storage level DR (HACMP) Fail over and Database administration.

TCS (TATA Consultancy Services) Chennai, India Client Details

Malaysia Airlines is the world-famous Airline system. MAS -MH operates flights from its home base, Kuala Lumpur.

Administrating ORACLE 9i/10g/11g production and Non-Production environments.

Handling Large ORACLE database production environments.

Installation & configuration of ORACLE 9i/10g/11g server and creation of Databases.

Configuration & Administrating of ORACLE Data guard environment

Installation &Administration of ORACLE RAC Database environment

Adding & deleting node to/from RAC cluster ware environment

Database Switchover & Failover using ORACLE Data guard

Upgrading the ORACLE Databases from ORACLE 9i/10g to new release 11gR2.

Applying the CPU patches on quarter basis for all ORACLE Database environments

Implementation and Administration of ORACLE ASM Storage

Database Refresh using RMAN duplicate and ORACLE Data pump, EXP/IMP

Database Clone using RMAN duplicate and HOT Backup

RMAN Backup and Recovery

Handling Database Incidents / Changes /Service requests through ticketing tool.

Attending customer meetings and co-coordinating with Application team for all

DB related deployments and issues

Supporting L2 and L3 levels of Oracle DBA support

Working in Server/Storage level DR (HACMP) Failover and Database administration

Oracle Physical Standby database creation for the replication of the primary database.

Administrating & Troubleshooting the Oracle Standby databases.

Oracle 10g and 11g database performance tuning

Analyzing Database performance by using AWR and ADDM features on demands.

Capacity Planning and recommendations to the customer

Managing schemas on granting & revoking privileges, roles

Recovering dropped data(table) by using Flashback table

Automating Housekeeping activities for archive log files, Trace files

Checking the alert log file for any errors, warnings and providing corrective action

Raffles Solutions Bangalore, India - IBM

Client Details:

Traditionally known as a strong diamond financing bank, ABN AMRO today offers unparalleled suite of client services in India. ABN AMRO Bank ranks among the top 10 banks in the world in size and strength.

Installing and configuring oracle server/database.

Maintaining control files redo log files and data files.

Regular monitoring of alert log files

Managing table spaces, segments and storage clauses.

Security management-creating users, roles, privileges.

Logical backups (export & import).

Performing of database backups on disks and tapes.

User managed backups & recoveries (cold & hot).

Backup and recovery using RMAN.

Educational Background:

Completed MSc (Computer Science) from Bharathidasan University.

Completed BSc (Computer Science) from Bharathidasan University.



Contact this candidate