BHEEM AITHA

Dublin, CA • +1-925-***-**** • ad0jff@r.postjobfree.com

linkedin.com/in/bheemsen

Database Engineer

Summary

A proven Database Engineer/Team Leader who offers a track record of accomplishment in managing full SDLC methodology for system analysis, database design/administration, performance tuning, SQL analysis, development, and testing of business software solutions. Experience includes developing BI solutions and ETL tasks using SQL (SQL Server, Oracle and MySQL) in multiple environments.

Skills

Cloud

AWS Cloud, Oracle Cloud

Oracle 11gR2 and 12c

Single Instances, RAC, ASM, Oracle as RDS

MySQL 5.7 and NDB Cluster 7.3

Multi-master replication

MongoDB 3.5

MongoDB cluster with replica sets

SQL Server 2014 and 2017

SQL Server with replication

Teradata 15.10

Teradata appliance and Teradata on IntelliCloud

Replication Tools

HVR, GoldenGate, Attunity, Informatica, MySQL

Tools

Snaplogic, Percona Toolkit, Toad, MySQL Workbench, MySQL Cluster Manager, MySQL Enterprise Monitor, Rapid SQL, OEM, Puppet

Portfolio

Managed installation and configuration of MySQL NDB cluster on Redhat Linux 5.8 with three data nodes, two management nodes, and two SQL nodes for a high volume, 24/7 environment

Managed Informatica ETL jobs for data mart from SQL Server to Teradata using stored procedures and SQL.

Led the automation of multiple MySQL tasks using Percona Toolkit and configured/monitored multi-master MySQL replications

Completed PoCs for critical applications, including GoldenGate, Attunity, Informatica, and HVR

Architected and built from scratch a 4 node, 25 TB Teradata 13.10 system with multiple databases for a critical enterprise data warehouse

Migrated 20 TB Teradata 13.10 system to Teradata 15.10 on IntelliCloud and saved 200k for Itradenetwork

Managed and monitored 50+ Oracle database scripts by installing, configuring, and tuning Oracle Enterprise Manager (OEM12c)

Installed and designed SQL Server database with replication for extremely busy web application

Automated many SQL jobs using Unix shell scripts

Migrated a 10 TB Teradata system to Amazon Redshift cluster on AWS

Supported and did the performance tuning of SQL Server 2014 and 2017 for a 24 X 7 .net application Mentored and supervised junior database administrators on multiple teams

Migrated SQL Server databases into AWS cloud as RDS instances and on EC2

Automated MySQL (Xtrabackup, mysqldump, enterprise backup) and Oracle (RMAN and storage snapshots) backups Oversaw the refreshing of Teradata Prod databases to lower environments using Arcmain

Delivered multiple standby databases and Active Data Guard implementations for Oracle primary databases

Key Strengths

Very good at understanding business requirements

Expertise in SQL tuning of RDBMS like MySQL 5.6 (InnoDB), Oracle 19c, PostgreSQL 12, MongoDB 4.0, SQL Server 2014 and 2017, Amazon RedShift, Amazon Aurora

Expertise in Physical and Logical Database design, Performance Tuning and capacity planning.

Expertise in SQL*PLUS, SQL, PL/SQL, Percona Toolkit, AWS Lambda

Extensive experience in UNIX, Shell scripting, Python and Perl Scripting.

Expertise in MySQL Workbench, MySQL Cluster Manager and MySQL Utilities.

Experience in IBM AIX, SUN Solaris (SPARC 9,10,11), and Linux (Redhat 4, 5, 6 and Suse 11, Oracle Linux 4, 5, 6)

environments.

Expertise in Oracle standby technologies

Expertise in SQL Server development and Administration.

Excellent communication skills and ability to work in a group as well as independently. Energetic, self-motivated, self-starter and a good team player.

Experience with Visio, ER Diagrams and UML methodology. Expertise in ticket tracking systems like Jira, Salesforce, Zendesk. Expertise in source control systems, Github, SVN

Expertise in DevOps tools like Jenkins, Splunk, Xymon, Nagios

Work Experience

2018-06 –Present Database Architect

Client: One Medical, CA

Key Responsibilities:

Monitor and support data migration process from on-premises to AWS.

Involved in ETL jobs creation and monitoring using Informatica for SQL Server.

Implement data migration process from SQL Server to Oracle RDS on AWS.

Setup, configure and support replication process using HVR from SQL Server 2017 to Teradata 14.10 in production environment. Also, support Active-Active data replication from Oracle to Oracle

Develop stored procedures in SQL Server 2017.

Provide database support for Oracle 12c, Teradata 14.10 and SQL Server 2017.

2007-09 – 2018-04 Database Engineer

Itradenetwork, Dublin CA

Key Responsibilities:

Served as Database Engineer for Itradenetwork simplifying complex supply chains with cloud-based software serving 10,000+ food and beverage companies.

Oversaw backup and restore of databases, performance tuning, and replication setup while maintaining development, UAT, SQE, and production environments with several database instances. Drove installation and configuration of Oracle 12c as RDS on AWS. Configured, installed and monitored HVR replication from Oracle to SQL Server.

Supervised the monitoring and tuning of MySQL databases and replication, and led the automation of database tasks using Percona Toolkit and shell scripts catering to 20,000+ concurrent users.

Oversaw installation, configuration, tuning, and maintenance of MongoDB Cluster along with backup/recovery processes.

Supervised the implementation of a data warehouse application built for highly available enterprise- wide reports using 25 TB Teradata Database in IntelliCloud (AWS market place).

Implemented, configured, and monitored High Volume Replication (HVR) tool to replicate data from SQL Server to Teradata Cloud.

Led the automation of ETL jobs using shell and perl scripts and managed performance tuning of Teradata databases.

Managed implementation of EDI catalog application utilizing elastic search feature using MongoDB Cluster as back-end with four nodes and four replica sets.

Oversaw adoption of a critical .net application built with SQL Server and PostgreSQL as back-end.

Facilitated performance tuning of SQL Server 2014 and 2017 for a 24/7 .net application. Supervised and delivered a highly available MySQL Cluster database OLTP system capable of serving 200 million transactions per minute.

Installed, setup, and maintained MySQL instances, including MyISAM, InnoDB, and NDB engines, as well as MySQL Cluster using MCM.

Upgraded MySQL NDB Cluster from 7.1 to 7.2 on Redhat Linux 6; used MySQL cluster manager and management client.

Facilitated MySQL monitoring using Nagios.

Automated many Oracle DBA tasks for monitoring, backup, and partitioning using

shell/perl/python scripts and Xymon.

Managed and delivered a replication project to replicate data fromOracle 11gR2 to

MySQL/PostgreSQL/Teradata using Informatica and Attunity.

2001-04 - 2007-09 Sr. Analyst

AT&T Services Inc, San Ramon CA

Key Responsibilities:

Led installation, upgrade, and monitoring of Oracle 10g RAC

Managed Python/Shell scripts for automating DBA tasks.

Supervised the team for tuning project and performed database tuning usingOEM and custom scripts.

Automated enterprise-wide monitoring infrastructure using several key technologies, including

UNIX shell scripts, perl scripts, and SQL.

Developed, designed, and implemented the company’s internal search portal which is a huge 3 TB database with millions of transactions on a daily basis, using MySQL and UNIX scripts.

Created best practices documents for Oracle database environments based on Oracle recommendations.

Documented standard procedures for DBA Operations Group, including installing/upgrading Oracle databases, creating databases/DBA tools, administrating and monitoring databases, and overseeing coding standards, policies, and practices.

Technologies used:

Oracle 10g, MySQL 5.1, MySQL 5.5, MySQL Workbench, Redhat Linux, Unix, Javascript, Python, Shell Scripts, and Perl Scripts.

Education

1997 - 1999

MS in Mechanical Engineering

1995 - 1996

IIT Kharagpur, India

Diploma in Computer Science, Bhopal, India

Contact this candidate