Data Engineer Technical Support
Resume:
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)
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.
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: ********@*****.***
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