M.R.ABRAHAM.

E-mail: ad1z4z@r.postjobfree.com

Mobile # : +91-974*******

Career Objective:

A responsible and challenging position in an organization that would enable me to augment my already acquired knowledge, bring to forefront my skills and offer opportunities for growth based on achievements.

Strength: Smart working, Trustworthy, Positive and Creative Thinking to complete the assigned task and open to learn new technologies.

Certifications & Training: Oracle Certified Professional (Oracle DBA)

AWS Certified Solutions Architect - Associate (SAA)

Microsoft Azure Administrator

GOOGLE CLOUD CERTIFIED DATA ENGINEER PROFESSIONAL

Python (Certified)

Cassandra (Certified)

Oracle cloud

Experience Summary:

Over 15 years of working experience as a corporate trainer, senior and Cluster Database Administrator, data engineer and Architect, with a progressive management experience and technical skills.

MYSQL & ORACLE & NoSQL darabases:

●MySQL (5.x, 8.X) – Began MySQL DBA career with the 5.x public release of MySQL.

●Performance Tuning, Query Analysis, Server Optimization.

●Replication setups and optimization.

●InnoDB Engine, MyISAM, MEMORY, XTRADB and NDB etc.

●Views, Triggers, Stored Procedures, Stored Functions.

●MySQL Multiple Instance Manager.

●Server Installation, Redhat & Fedora Linux, Solaris platforms.

●Security Auditing, User Access management.

●Backup Procedures: mysqldump, xtrabackup, meb

●MySQL Enterprise Monitor, Query Analyzer

●Master / Slave Replication, Master – Master Active / Passive Replication

●Schema Design, MySQL Workbench Data Modeling

●Referential Integrity, ACID Compliance, Foreign Keys, Primary Keys, etc.

●Developed backup, archival, and validation procedures

●Audited and improved queries and schema.

●Verifying MySQL replication integrity with pt-table-checksum.

●Standardized development and staging environments.

●Added internationalization features.

●Audited and repaired production database schema.

●Improved developer debugging tools.

●Audited and tuned production MySQL servers.

●Mysql cluster (NDB) installation and configuration.

ORACLE & EXADATA DBA: Experience as Database Administration in an ORACLE environment as DBA, responsible for Performance Tuning, Database Development, Backups, and SQL code design.

●Installation of Oracle software.

●Creation of Oracle Database.

●Control and Redo Log file management.

●Creating and managing tablespaces and data files.

●Database objects creation.

●Over viewing security and resources.

●Managing users, privileged and roles.

●Over viewing basic Oracle net server client configuration.

●Using Export / Import utility for taking logical backup.

●Understanding and Configuring Cold and Hot backup procedures.

●Using RMAN to create backups.

●Creation and monitoring of Standby Database

●Configuring and managing high availability and performance tuning

●Provide technical resolution to Oracle database related problems.

POSTGRES DBA: Supported the following clients for POSTGRESQL (SAMSUNG, HARMONEY, KULIZA)

●POSTGRESQL server installation and configuration and administration (Versions: 11,12)

●POSTGRESQL database and schema management

●POSTGRESQL Roles Administration

●Postgres backup and restore databases

●Postgres tablespace management

●Postgres tools: PGADMIN

●High Availability, Load Balancing, and Replication setup and configuration

●Slony replication configuration

●Monitoring Database Activity

●Reliability and the Write-Ahead Log management

●Performance Tuning and Query optimization

●Routine Database Maintenance Tasks

● Routine Vacuuming

● Routine Reindexing

● Log File Maintenance

●Designed, developed and migrated existing SQL databases.

●Automated DBA activities and upgraded existing databases.

●Maintained and optimized database application performance through tuning.

●Generated database reports such as financial data statements and user data.

●Administered and executed complex databases for critical problems.

●Implemented system backup procedures and updated site resources.

●Prepared automation scripts and developed PostgreSQL database architecture.

●Implemented migration tasks from Oracle database to PostgreSQL databases.

●Designed, developed and maintained PostgreSQL database architecture.

●Prepared and updated scripts for various administrative tasks.

●Maintained documentation of scripts in all source repositories.

●Developed scripts for database monitoring and tuning procedures.

●Conducted Linux administration activities and managed test databases.

●Evaluated database performance and executed table maintenance processes.

●Oracle to Postgres migration.

Educational Qualification:

B.Tech (Information Technology)

Year of passing: 2006

University: JNTU, Hyderabad (AP).

Work Experience:

Organization: HCL, Bangalore INDIA

Designation : Technical Architect

Dept : Technical lead and Architect

Date : 27-Nov-2020 to 22-Aug-2022

Organization: MINDTREE Limited, Bangalore INDIA

Designation : Technical Lead

Dept : Technical lead and Architect

Date : 05-Dec-2016 to June 2020

Organization: ONEBILL Software Solutions, Bangalore INDIA

Designation : Data Architect

Dept : Dev Ops

Date : 22-Sep-2015 to 05-Dec-2016

Organization: Minjar Cloud Solutions, Bangalore INDIA

Designation : Database Tech Lead

Dept : Cloud Ops

Date : 13-Jul-2013 to 20-Sep-2015

Organization: IPSOFT India Pvt Ltd, Bangalore INDIA

Designation : Senior Database Administrator

Dept : Database

Date : 17-Feb-2011 to 15-Apr-2013

Organization: Zeta Interactive, Hyderabad INDIA

Designation : Database Administrator

Dept : NOC

Date : 10-Feb-2010 to 11-Feb-2011

Organization: TeleDNA Communications Pvt ltd, Bangalore INDIA

Designation : Database Administrator

Dept : NOC

Date : 16-Mar-2009 to 05-Feb-2010

Roles and Responsibilities:

●Data engineering, design and administration.

●Database design, scaling, redundancy and high availability for MySQL,Postgres and Oracle etc.

●Writing Pl/SQL Queries, Functions, Procedures triggers etc.

●Support in technical issues and fixing replication incompatibility and porting to newer versions of MySQL.

●Database health check and audit.

●Development of database sharing both in the application layer and schema

●Implementation and management of numerous replication schemes and topographies

●Schema and index optimization

●Implementation and management of database backup systems.

●Provide expertise in operating system and database configurations

●Development of information such as customer procedural documents as well as information and tips available to the public via blogging.

●Physical and logical database administration experience including: Installation and configuration on Linux and Windows.

●Creating and maintaining of database, data files and log files, control file, tablespaces.

●Experience of creating and maintenance of Database Instance.

●Experience in logical and physical database design and implementation.

●Database shutdown & startup

●Creating and Managing primary objects (Tables, Indexes, Views etc)

●Implementing and maintaining database security

●(Creating and maintaining users and roles, assign privileges)

●Database Cloning (Replication)

●Backup tasks Mysqldump-Full/Incremental/Hot/Cold Database backup (Xtrabackup and Meb)

●Establishing and maintaining Backup and Recovery.

●Experience working with: Red Hat Linux, Solaris & Windows NT

●Database backup through Export-Import utilities.

●Data migration

●Shell scripting.

●Supporting the developer team for tuning the SQL queries, evaluating Performance of SQL statements and PL/SQL modules by Explain Plan, Mysql Enterprise Monitor, MEM Analyzer.

●Performing general technical trouble shooting and give consultation to development teams.

●Establish and maintain sound backup and recovery policies and procedures.

●Take care of the Database design and implementation.

●Implement and maintain database security (create and maintain users and roles, assign privileges).

●Database tuning and performance monitoring.

●Application tuning and performance monitoring.

●Setup and maintain documentation and standards.

●Plan growth and changes (capacity planning).

●Work as part of a team and provide 7 24 supports when required.

●Do general technical trouble shooting and give consultation to development teams.

●Interface with MySQL/Oracle for technical support.

Professional details:

Details

Full Name

ABRAHAM RATHNA MURAHARY

Contact No. & Alternate Contact No.

974-***-****

Total working Experience

14+

Current Organization Name & Current Location

freelancer and consultant

DOB: 12-Aug-1983

Technical Skills:

SKILL SET

No. of Yrs Worked

Exp as Database administration and cloud Architect

14

Linux

14

Oracle and MySQL

14

Postgres DB

8

MongoDB, CASSANDRA and Other NOSQL databases

8

AWS, GCP, AZURE cloud

7

scripting (python and bash)

8

Team Management Exp

8

Team Size Handled

20

Experience on working on complex scalable, distributed systems/products

11

Personal Information:

Name : M.R.ABRAHAM.

Father’s Name : M.S.JAYAKARA RAO.

Date of Birth : 12/08/1983.

Nationality : India

PASSPORT NUMBER : H6251856

Permanent Address:

M.R.ABRAHAM. Email ID: ad1z4z@r.postjobfree.com

S/O M.S.JAYAKARA RAO, Mobile: 91-974*******

Shantha Bhagya Nilayam,

Plot.No: 621, Bhavani Nagar,

Railway Layout - Phase 2,

Mallathalli,

Bangalore -560056,

Karnataka, INDIA.

Contact this candidate