Summary
Overview
Work History
Education
Skills
Certification
Roles And Responsibilities
Awards
References
Timeline
Generic

Tejas Lokhande

Pune

Summary

Dedicated and skilled Database Administrator with approximately 4 years of hands-on experience in the installation, migration, design, backup, recovery, scripting, and performance tuning across various database environments. Possesses proficiency in managing multiple databases, particularly MongoDB and PostgreSQL, with expertise in working on enterprise and community editions.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Database Administrator

Techberry Infotech
Pune
08.2019 - 06.2020

Working Technology & Clients :
MongoDB: Lentra AI Private LTD Dr. Batra, ShopperStop
PostgreSQL: Softcell Technology

Database Administrator

Clover Infotech
07.2018 - 07.2019

Working Technology & Clients :
MongoDB: NSDL
MySQL: Capital First,NSDL
PostgreSQL: NSDL,Edelweiss.
DB2: NSDL

Network Support Engineer

Orient Technology
06.2015 - 07.2018

Senior Database Administrator (Level 3)

Lentra AI PVT LTD
  • Implemented change management processes to ensure smooth transition between different stages of development life cycle.
  • Designed and implemented disaster recovery plans in case of system failure or data corruption.
  • Maintained multiple versions of the same database while ensuring data consistency across them.
  • Implemented backup procedures for databases and monitored their success rate.
  • Monitored system performance, identified potential bottlenecks, implemented solutions to improve efficiency.
  • Performed regular maintenance activities such as index rebuilds, statistics updates.
  • Ensured compliance with all applicable regulatory standards regarding data protection and privacy.
  • Assessed data processing proposals and requirements to determine project feasibility.
  • Evaluated new technologies related to Database Administration that can be used in organization's environment.
  • Detected and resolved data quality issues and discrepancies for integrity and quality control.
  • Created complex stored procedures and triggers to automate various tasks within the database.
  • Analyzed query execution plans to identify potential areas for improvement or optimization.
  • Trained junior DBA team members on best practices related to database administration.
  • Analyzed and developed technical and functional specifications for databases.
  • Developed and maintained database security policies to ensure data integrity, confidentiality and availability.
  • Configured high-availability systems such as replication clusters and log shipping for mission critical databases.
  • Resolved conflicts arising from concurrent access by multiple users to shared resources.
  • Participated in capacity planning exercises to determine future hardware requirements based on current trends.
  • Wrote scripts and processes for data integration and bug fixes.
  • Developed and implemented security initiatives to protect important company data.
  • Analyzed workflows and established priorities for daily operations.
  • Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
  • Maintained knowledge of advances in information technology systems and applications.
  • Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
  • Provided technical support for database users, troubleshooting issues as they arise.
  • Partnered with project management teams on development of scope and timelines.
  • Assisted application developers in designing efficient SQL queries for better performance.
  • Developed data models and database designs to plan projects.
  • Devised reports and visualizations to present requested data in sleek format.
  • Optimized existing queries to ensure maximum performance and scalability of the databases.
  • Installed new software releases, patches and upgrades on production servers as required.
  • Displayed strong telephone etiquette, effectively handling difficult calls.
  • Completed day-to-day duties accurately and efficiently.
  • Prioritized and organized tasks to efficiently accomplish service goals.
  • Worked with cross-functional teams to achieve goals.
  • Maintained updated knowledge through continuing education and advanced training.
  • Exceeded customer satisfaction by finding creative solutions to problems.
  • Collaborated with others to discuss new opportunities.
  • Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
  • Planned and completed group projects, working smoothly with others.

Education

Bachelor of Science in Information Technology [BSc(IT)] -

D.G.Ruparel College

Skills

  • MongoDB Ops Manager
  • PostgreSQL Enterprise Manager
  • Database TDE /TLS Security
  • High Availability Database Using Patroni ETCD and EFM
  • Seamless DB Upgrade
  • Disaster Recovery
  • Replication
  • MongoDB
  • PostgreSQL
  • Proficient in Linux Scripting
  • Java scripting

Certification

ORACLE CERTIFIED (SQL EXPERT): 2017

Roles And Responsibilities

  • Executed installations, migrations, and designs for development, test, and production databases.
  • Conducted backup and recovery procedures, implemented scripting solutions, and fine-tuned performance.
  • Managed databases across various versions, platforms, and environments.
  • Designed and implemented MongoDB and PostgreSQL replication strategies.
  • Successfully scaled MongoDB across data centers and implemented MongoDB HA strategies.
  • Implemented PostgreSQL HA strategies using ETCD-Patroni and EFM.
  • Installed and configured MongoDB Ops Manager, overseeing deployment management.
  • Utilized third-party tools and built-in binaries for monitoring and analyzing MongoDB performance.
  • Conducted extensive query optimization and performance tuning for both MongoDB and PostgreSQL.
  • Implemented PostgreSQL partitioning for large tables to enhance database performance.
  • Maintained database security through compliance auditing, profile management, and password complexity.
  • Scheduled, tuned, and conducted backups using PostgreSQL Enterprise Manager (PEM).
  • Developed alerts for database uptime/downtime and sizing issues using PostgreSQL Grid Control (PEM).
  • Proven expertise in troubleshooting analysis and quick issue resolution.

Awards

Rising Star Awards in Database Technology. Got awarded for handling performance and slowness level issues at client side.

References

Available upon request.

Timeline

Database Administrator

Techberry Infotech
08.2019 - 06.2020

Database Administrator

Clover Infotech
07.2018 - 07.2019

Network Support Engineer

Orient Technology
06.2015 - 07.2018

Senior Database Administrator (Level 3)

Lentra AI PVT LTD

Bachelor of Science in Information Technology [BSc(IT)] -

D.G.Ruparel College
Tejas Lokhande