Data Engineer Technical Support

M.R.ABRAHAM.

E-mail: ********@*****.***

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)

Google cloud certified professional data engineer

Microsoft Azure Administrator

Python (Certified)

Cassandra (Certified)

Experience Summary:

Over 15+ years of working experience as a DBA, Data Architect, Cloud Architect and Data engineer with a progressive management experience and technical skills.

MYSQL DBA:

·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.

ANNEXURE

Project #1: Data Architect & Administrator

Client: Matellio

Duration: Nov 2022 to Oct 2023

Role and responsibilities – Data Architect

Description: Achieves organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases. Maintains database by determining structural requirements, and developing and installing solutions.

Project #2: Data Engineer & Cloud Architect

Client: Google

Duration: Aug 2020 to SEP 2022

Role and responsibilities – Data Engineer

Description: Migration and transformation of data from different sources to GCP. Working on different tools and methods in optimal way for data transformation (ETL) as per the application requirement. Build systems that collect, manage, and convert raw data into usable information for data scientists and business analysts to interpret.

Project #3: Data Architect & Administrator

Client: HCL

Duration: Dec 2016 to Mar 2020

Role and responsibilities – Data Architect

Description: Achieves organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases. Maintains database by determining structural requirements, and developing and installing solutions.

Other Projects #4: Technical Lead and DBA

Client: Commonfloor, QGO, Mariott etc.

Duration: Dec 2009 to Dec 2016

Role and responsibilities – Database Administration

Description: Managing and optimizing the performance, integrity and security of a database and application as per the requirements. Involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. As a DBA ensuring that data remains consistent across the databases.

Educational Qualification:

B.Tech (Information Technology)

Year of passing: 2006

University: JNTU, Hyderabad (AP)

Technical Skills:

SKILL SET

No. of Yrs Worked

Exp as Database administration and Architect

15

Linux

15

Oracle and MySQL

15

Postgres DB

8

MongoDB, CASSANDRA and Other NOSQL databases

6

Microsoft Azure

4

AWS, GCP cloud

5

scripting (python and bash)

8

Team Management Exp

8

Team Size Handled

20

Experience on working on complex scalable, distributed systems/products

15

Work Experience:

1) Organization: Matellio India Pvt. Ltd, Jodhpur INDIA

Designation : Technical Lead

Date : 16-Nov-2022 to15-Oct-2023

2) Organization: HCL Technologies Limited, Bangalore INDIA

Designation : Data Engineer

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

3) Organization: MINDTREE Limited, Bangalore INDIA

Designation : Technical Lead

Date : 05-Dec-2016 to 15-June 2020

4) Organization: ONEBILL Software Solutions, Bangalore INDIA

Designation : Data Architect

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

5) Organization: Minjar Cloud Solutions, Bangalore INDIA

Designation : Database Tech Lead

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

6) Organization: IPSOFT India Pvt Ltd, Bangalore INDIA

Designation : Senior Database Administrator

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

7) Organization: Zeta Interactive, Hyderabad INDIA

Designation : Database Administrator

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

8) Organization: TeleDNA Communications Pvt ltd, Bangalore INDIA

Designation : Database Administrator

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

9) Organization: Software Technology Group International ltd, Bangalore INDIA

Designation : Technical Executive and Corporate Trainer

Date : 01-Nov-2007 to 25-Nov-2008

Personal Information:

Name :M.R.ABRAHAM.

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

Date of Birth : 12/08/1983.

Languages known : English, Telugu, Kannada, Hindi.

Nationality : Indian

PANCARD : AOXPR2433K

PASSPORT NUMBER : H6251856

Permanent Address:

M.R.ABRAHAM. Email ID: ********@*****.***

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