Hardik V Desai

Mobile: 9601474575 E-Mail:

LinkedIn Profile:

Git Profile:

A value driven and result oriented professional with 6+ years of experience in IT Sector; adept at handling the project from inception to completion effectively to achieve targets within often stringent constraints; Possess valuable insights, keen analysis and a team approach to implement best practices to achieve business excellence.

Looking forward to associate myself with an Organization where there is a scope for contributing and upgrading my knowledge for the development of self and Organization.

Strengths & Snapshots:

  • Database administration and backup administration of multiple servers in heterogeneous environment.
  • Performance planning, fine tuning & benchmarking
  • Performed bulk Data ingestion /Data integration projects from any source database to any destination
  • Error Troubleshooting & User Management
  • Worked upon messaging oriented middleware to enable messaging e.g. Kafka, RabbitMQ etc
  • Migration / switchover of production servers(Using replication, physical backup, logical backup, etc)
  • High availability / Load Balancing / Disaster recovery setup
  • RDBMS Database Concepts & Components design like database, table, triggers, stored procedures etc.
  • MySQL Galera Cluster, MySQL traditional Replication and ORACLE Data Guard
  • BigData & Hadoop technologies using Hortonworks Data Processing Platform
  • Data Processing as a Service using Ambari and Sahara
  • ETL & data auditing and BI related projects for recommendation generation of BNFC domain products
  • Data Warehouse server and business intelligence applications
  • Database related Policy Design & Administration
  • Database Audit & Change Management
  • Best Practices
  • Migration, Implementation and Support

ORGANISATIONAL SCAN:

Started working with Reliance Jio Infocomm Ltd, Navi Mumbai from Apr 2016 as DBA/DevOps

Dec 2010 – Apr 2016

Database Administrator at NJ Technologies Pvt Ltd, Surat, Gujarat.

Commenced Career for Harmony Multimedia Pvt Ltd from Dec-2009 to May-2010.

Accountabilities:

RDBMS Databases:

  • Database Administration and Backup activity for database servers, include OLTP and OLAP environment.
  • Developed & implemented MySQL Galera Cluster to achieve High Availability and Load Balancing
  • Designed & managing fully operational end to end data-warehouse solution using columnar database.
  • Executing SQL Scripts during Production release
  • Adding database objects on Production databases where required
  • Database/table Refresh from production to Dev and staging environments
  • Writing Triggers and Stored Procedures for DBA needs and for keeping track of deleted records in Logging tables & for In-house database reports
  • Database installation using ansible scripting approach
  • Data tracking and preparing list of sensitive data found in tables and make sure of masking data
  • MySQL Replications Setups
  • Managing backup & restoration
  • Data guard implementation both for SE and EE
  • Data replication using materialized view for read load balancing.

Database Administrator and DevOps at Reliance Jio Infocomm Pvt Ltd

April 2016 – Present, Mumbai

  • Working on multiple databases like MySQL, MSSQL,Oracle, Hadoop, Spark, Cassandra, MongoDB
  • Designed Openstack Cloud database with HA failover using MySQL Galera Cluster & HA-Proxy.
  • Maintaining Backups and Disaster Recovery.
  • Setup of Kafka clusters in Hortonworks using Ambari
  • Database installation using ansible approach.
  • Providing Data Processing as a Service (Hadoop and Spark) to various customers; managing and administering it as per client’s requests.
  • Working on Big Data cluster security using Ranger & Knox.
  • Setup of Cassandra cluster in Linux platforms
  • Working on HDFS tuning and various components of Hadoop like HIVE, Sqoop, Yarn, HBASE, ranger,knox,Kafka etc.
  • Worked on Performance Benchmarking of RDBMS & Hadoop Environment.
  • Installing, configuring and maintaining Private cloud infrastructure for RJIL with various Openstack version (Juno, Liberty & Ocata).
  • Complete hands-on experience on Horizon and CLI to maintain and manage various Openstack components like RabbitMq, Nova, Cinder,Neutron, and Glance.
  • Working on HA using HAProxy to support and manage the cluster in Openstack

Database Administrator @ NJ Technologies Pvt Ltd. (NJ Group of Companies)

DEC 2010 – APR 2016 (5 years 3 month)

  • Installation & configuration of RDBMS databases e.g.MySQL, MSSQL, Oracle
  • Developing, managing and testing back-up and recovery plans
  • SQL Code Optimization with Application Development Team & providing recommendations based on SQL Standards
  • Maintaining data standards, including adherence to the Data Protection policies.
  • Monitor and manage database replication and failover/recovery as needed. Run database consistency checks, Maintenance procedures and fix as needed.
  • Monitor and manage database server performance, availability, capacity and error logs. Identify, troubleshoot and resolve real-time database issues.
  • Perform complex replication troubleshooting.
  • Performing data migration from MS-SQL Database (source) to Oracle database tables(destination)
  • Written programs in Shell script to automate DBA tasks and the purpose of the scripts is to let non-DBAs understand their environment and
  • High Availability solutions using replication.
  • Backup and recovery
  • Performance tuning.
  • Production operations & support Security Administration.
  • Monitoring and optimizing the performance of the database.
  • Analyse and respond to performance and other maintenance issues.
  • Optimizing database performance at schema, service, OS, or hardware levels.
  • MySQL Database tuning, Backup & recovery procedures, Execution of utilities.
  • Database Migration & Up-gradation.
  • Exploring new technologies.
  • Managing databases with different storage engines such as MyISAM, InnoDB,Info bright etc.
  • Optimizing the configuration parameters to best utilize system's resources.

Technical Skills:

• Operating Systems: Ubuntu, RHEL, CentOS, Oracle Linux, Windows

• Scripting: Shell Scripting

• Version Control Tools: Git, Gerrit

• Monitoring Tools: Zabbix, Cacti, Sensu, Ceph Krekandash, Nagios

• Configuration Management Tools: Ansible, Salt stack, Jenkins

• Databases: MySQL 5.5/5.6, MS-SQL Server,Oracle 10g/11g/12c, Cassandra, Hbase, MongoDB

Certifications:

  • Oracle Certified Professionals (OCP) from Oracle Corporation Ltd at SQL Star International Ltd.

EDUCATION & CREDENTIALS:

Post Graduate Diploma in Business Administration (IT)

Symbiosis University, Pune

Bachelor of Computer Engineering in 2009

DDU, Nadiad. Gujarat