Summary
Overview
Work History
Education
Skills
Timeline
SeniorSoftwareEngineer

Uttam Singh

DBA
Jaipur

Summary

Professional and highly motivated, having over 7+ years of Database and middleware Admin , having Development work experience in the software industry with MySQL, MongoDB and Middleware Administration. have Experience of Database Administration, design, development, maintenance, Upgradation, Migration and production support of relational and NoSQL databases, business applications, new server setup as Database Admin Admin. Have Middleware experience in project management (to build + automate + ship + deploy + monitor application ) on various Environments like stage , production ) , can drive projects from start to finish and maintain all DBA tasks and middleware activities as part of dynamic team.

Overview

7
7
years of professional experience

Work History

Senior Software Engineer

Nisum consulting PVT.LTD.
Pune
07.2019 - Current
  • Mysql , Mongo and middleware Administration and management of the entire development, QA and production environment.
  • Installed and configured MySQL , Mongo and Devops tools on Linux and Windows environments.
  • Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-
    view according to the business criteria.
  • Developed and tuned the stored procedure, triggers, user defined functions and queries in MySql.
  • Converted databases from MylSAM format to Innodb storage engine for databases that needed greater referential integrity.
    Managing database clustering on NDB technology.
  • Automated Data Import Script using shell scripting, PHP, MySQL and regular expressions.
  • MySQL database backup and recovery strategies and Replication and synchronization.
  • Created, tested, and maintained PHP scripts, MySQL programming, forms, reports, triggers and procedures for the Data Warehouse.
    Created database application using PHP and MySQL as the database to monitor customer profiles and complaints.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Troubleshooting performance problems over phone and via email.
  • MySQL processes, security management and queries optimization.
  • Recovering the databases from backup in disasters.
  • MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
  • Performed query analysis for slow and problematic queries.
  • Analyzed code to improve query optimization and to verify that tables are using indexes.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
  • Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of
    profiling plan.
  • Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
  • Effectively configured MySQL Replication as part of HA solution.
  • Designed databases for referential integrity and involved in logical design plan.
  • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
  • Worked with project managers, developers, quality assurance and customers to resolve technical issues.
  • Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
  • Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.
  • Trained and mentored junior developers and engineers, teaching skills and working to improve overall team performance.

Software Engineer

InfoVision Labs
Pune
04.2018 - 07.2019
  • Installation and configuration of mongoDB, MySql and Middleware tools
  • Implementation of MongoDB security mechanism with various Authentications.
  • Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-
    view according to the business criteria.
  • Backup and Recovery
  • Disaster Recovery & High Availability
  • Configured, tuned and maintained MySQL database server.
  • Configuration of Replication (Master-Slave & Master-Master).
  • Application deployment, maintenance and log analysis for Java based Monolithic and Microservices application in E-Commerce Platform.
  • Extensive hands-on in Linux based servers, commands while supporting the application hosted on it.
  • Good hands-on knowledge of Source Code Management tools like Git and Subversion.
  • Working with automation/ integration tools like Jenkins, Rundeck for CI/CD (Continuous Integration/Continuous Deployment).
  • Providing technical support for all customer queries using AppDynamics, ELK and from logs and Databases.
  • Created builds(version) using tools such as Buildsytem for Ecommerce Content/Product data and activating /scheduling using BGB(deployment tool) tool and then deploying it via Rundeck. Sanity testing post deployment.
  • Provided high-value 24x7x365 support to the overall enterprise.
  • Worked with Vendors like Akamai, Bloomreach etc., whenever it requires their support either in triaging a Production Issue or during deployment/upgrades.

DBA

SearchTech Now PVT.LTD.
Jaipur
06.2015 - 04.2018
  • Administration and management of the entire development, QA and production environment.
  • Installed and configured MySQL on Linux and Windows environments.
  • Creation of Database Objects: Tables, Store Procedure, Views, Triggers, Index, and Function.
  • Analyzed long running /slow queries and tune the same to optimize application and system performance.
  • Created Triggers to enforce data and referential integrity.
  • Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
  • Managing/Troubleshooting MySQL in production and developer environments on both Linux and Mac OS X.
  • Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
  • Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of
    profiling plan.
  • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
  • Proficiency in Unix/Linux shell commands.
  • Support all Linux admin activity.
  • created lots of Shell scripts to automate DB manual tasks.

Education

Master of Science - Computer Science

Suresh Gyan Vihar University
Jaipur, Rajasthan
04.2016

Bachelor of Science - Computer Science

Bansal School of Engineering And Technology
Jaipur, Rajasthan
04.2013

Skills

  • Databases: MySQL 50 - 58, MariaDB, MongoDB, PerconaDB , Cassandra
  • Operating Systems: Linux (Redhat/Ubuntu), Oracle Linux,
  • Tools: MySQL Workbench , MySQL
    Enterprise Monitor, MySQL Enterprise Audit, MySQL Enterprise
    Firewall, MySQL Enterprise Backup, Percona XtraDB Backup,
    MySQL command line tools (ie mysqladmin), MySQL utilities,
    Percona Toolkit , Google Cloud , MongoDB compass , MongoDB , Jenkins , GIT , Rundeck
  • Web Services : Apache Tomcat , Weblogics
  • Langurage : Shell script , Ansible , MySql script, WLST
  • Container Technology & Management : Dockers and Kubernete
  • Monitoring Tools : Percona Toolkit , MongoDB compass ,ELK ,Akamai, AppDynamics, Grafana, AppDynamics, Nagios

Timeline

Senior Software Engineer

Nisum consulting PVT.LTD.
07.2019 - Current

Software Engineer

InfoVision Labs
04.2018 - 07.2019

DBA

SearchTech Now PVT.LTD.
06.2015 - 04.2018

Master of Science - Computer Science

Suresh Gyan Vihar University

Bachelor of Science - Computer Science

Bansal School of Engineering And Technology

Similar Profiles

  • VINOD KUMAR REDDY PALLE

    VINOD KUMAR REDDY PALLEVINOD KUMAR REDDY PALLE

    Senior Software Engineer at NISUM Consulting Pvt LtdSenior Software Engineer at NISUM Consulting Pvt Ltd

    View Profile
  • Sridhar Pendyala

    Sridhar PendyalaSridhar Pendyala

    Technical Project Manager at Nisum Consulting Pvt LtdTechnical Project Manager at Nisum Consulting Pvt Ltd

    View Profile
  • Pradeep Kumar Pamidipalli

    Pradeep Kumar PamidipalliPradeep Kumar Pamidipalli

    QA Manager at Nisum Consulting Private LimitedQA Manager at Nisum Consulting Private Limited

    View Profile
Uttam SinghDBA