Mukesh Chhatani
Chicago,IL
Summary
15 years of experience in database development, maintenance, and administration. Highly skilled in Relational, NoSQL, Graph, and Data Warehouse databases. Expertise in PostgreSQL, Oracle, Redshift, Snowflake, DynamoDB, Neo4j (Graph), and Big Data (Hive database). Strong understanding of database design and data modeling. Proficient in troubleshooting and well-versed in Agile Development Methodologies and source control software such as GIT. Self-motivated professional with a proven track record of delivering results independently.
Overview
16
16
years of professional experience
Work History
Principal Database Reliability Engineer
Clearcover
Chicago, IL
08.2021 - Current
- Streamlined database creation by leveraging Infrastructure as code principles via Terraform and Cloudformation.
- Utilized both native tools like pg_backup and cloud-based AWS backup services to ensure reliable data backups
- Implemented automation techniques to facilitate seamless quarterly minor version upgrades for RDS, Redis, and Kafka databases.
- Successfully managed the annual planning, testing, and implementation of major version database software upgrades using a blue/green methodology to ensure minimal downtime.
- Achieved cost savings by efficiently managing and freeing up resources
- Documentation for repetitive database operations for DevOps and Devs to handle tasks like database migration, no-downtime index creation, column data type changes, etc.
- Created innovative tools and automated processes to streamline database accessibility for on-call engineers
- Drove the implementation of monitoring and alerting systems utilizing efficient tools such as Datadog, AWS CloudWatch dashboards, and PagerDuty schedules.
- Applied various strategies and techniques to increase query speed and functionality
Principal Database Administrator
Rally Health
Chicago, IL
05.2019 - 08.2021
- Successfully handled the establishment and maintenance of numerous Postgres RDS instances supporting various web and mobile platforms.
- Maintained and updated the logical backup pipeline for optimal performance
- Implemented automated procedures to facilitate quarterly version upgrades and reboots for RDS databases in lower and PROD environments.
- Successfully executed regular major version upgrades every 15-18 months through effective planning, testing, and utilization of logical replication and CNAME switch technique.
- Implemented resource allocation strategy that resulted in significant cost savings on infrastructure for small apps.
- Implemented effective strategies to ensure seamless capacity utilization during key launches.
- Created comprehensive documentation and runbooks for daily operations to facilitate Ops team in performing specific tasks.
- Integrated new design tools and automation to enhance run-time user access in databases for on-call engineers.
- Enhanced system stability by implementing efficient monitoring processes.
- Raised awareness and increased usage of postgres through brown bag sessions.
Senior Database Administrator
Lumere
Chicago, IL
04.2018 - 05.2019
- Developed a data model that accommodates complicated business issues and is compatible with Postgres database.
- Provided recommendations for improving database performance by analyzing performance reports. This includes Postgres (pgbadger) and Redshift metadata tables.
- Facilitated the restoration of prod databases on diverse non-prod channels implementing RDS snapshot techniques alongside pg_restore tactics.
- Established a warehouse on Postgres through logical replication from multiple production databases.
- Revamped data structures and optimized programming queries by engaging with developers and architects, successfully achieving SLA targets.
- Contributed to the design and optimization of data warehouse queries on AWS Redshift (Periscope) for the DataOps team.
- Ensured reliability of backup process through consistent testing
- Raised awareness among ETL engineers and DataOps about PostgreSQL architecture to optimize ETL processes.
- Created and executed a secure password rotation tool utilizing credstash, DynamoDB, shell scripting and Lambda functions.
Senior Database Administrator
PowerReviews
Chicago, IL
05.2016 - 04.2018
- Performed data modeling for RDBMS (Postgres, MySQL), NoSQL databases (DynamoDB), and data warehouse (Redshift).
- Assisting the analytics team to design, maintain, and optimize data warehouse queries on AWS Redshift.
- Setting up and maintaining replication solutions for high availability and load balancing.
- Migrate databases from physical servers (rackspace) to AWS cloud.
- Maintained production, test, and development databases.
- Performing bulk data changes via SQL queries in PROD to achieve desired business results.
- Managing databases in AWS Cloud and periodically optimizing infrastructure for cost savings.
- Managing Neo4j graph databases as a caching layer for the application logic.
- Investigated and implemented third-party reporting solutions with an overall strategy for integration.
Database Administrator
PCTEL
Chicago, IL
10.2014 - 02.2016
- Provided database design, development, and administration for Mobile Meridian and Seahawk Analytics applications.
- Performed data modeling for RDBMS and NoSQL databases, and established standards across modules.
- Created customized modules for automated application data processing.
- Developed big data loading processes using Hive and/or Impala.
- Recommended database performance improvements after checking database performance reports
- Reviewed PL/SQL code and offered performance-related improvements with the team as needed.
- Developed JAVA APIs for providing data access to the application layer.
Project Leader
IGATE Technologies
Chicago, IL
09.2008 - 10.2014
- Developed required PL/SQL modules and created database logical and physical objects according to the data model
- Performed SQL tuning using standard techniques (i.e Execution plans, session trace, hints)
- Worked with Senior DBA for infrastructure planning and future data growth and collaborated with the Infrastructure team for the procurement of database infrastructure in the data center.
- Developed ETL jobs and customized reports using Shell Scripting + Oracle, SSIS, SSRS.
- Analyzed data growth in database tables and validated usage frequency of the tables in core functional queries and defined group wise purging criteria for tables
- Performed maintenance tasks (i.e Rebuild/Reorganize indexes; analyze/compute stats if required after deleting the required data).
- Analyzed hardware installed and used in multiple environments (i.e CPU & Memory usage, SAN usage, Licensing cost, maintenance cost etc.)
- Recycle unused/unwanted objects (i.e Tables, tablespaces, users, files etc.) in the application and database servers and removed fragmentation in database objects
- Checked current usage on multiple Oracle databases and resized tablespaces & ASM disk groups based on estimates for future growth
- Changed non-production databases to Non Archive Mode and then reduced SAN allocated for FRA disk groups
- Worked with the infrastructure team for resizing of different NFS mount points to release some unused SAN from application servers
- Decommissioned multiple unused servers and reshuffled applications to achieve server utilization up to 80%
- Worked with the Infrastructure team for migration of the servers from physical bare metal solution to the virtual environment in Cloud
- Analyzed the current backup and restoration process and created documents for required changes as per database standards, modified current process for RMAN backup from control file to recovery catalog
- Developed automated process for backup & restoration of specific tables & schemas using EXPDP/IMPDP and transitioned usage of this automated process to support engineers for future purpose
Education
Bachelor of Science - Electronics & Communication
Dharmsinh Desai University
Gujarat, India05-2008
Skills
- Database Design
- Warehouse models
- Documentation And Reporting
- Data Security
- Data Warehousing
- Data Migration
- NoSQL Databases
- Data Analytics
- Data Modeling
- SQL
- Performance Tuning
- Relational databases
- Capacity Planning
- Database Administration
Timeline
Principal Database Reliability Engineer
Clearcover
08.2021 - Current
Principal Database Administrator
Rally Health
05.2019 - 08.2021
Senior Database Administrator
Lumere
04.2018 - 05.2019
Senior Database Administrator
PowerReviews
05.2016 - 04.2018
Database Administrator
PCTEL
10.2014 - 02.2016
Project Leader
IGATE Technologies
09.2008 - 10.2014
Bachelor of Science - Electronics & Communication
Dharmsinh Desai University
Similar Profiles
Eric EdsonEric Edson
Senior Data Scientist at ClearcoverSenior Data Scientist at Clearcover
Kait ELRODKait ELROD
Agent Advocate & Company Mentor at ClearcoverAgent Advocate & Company Mentor at Clearcover
Jillian MunzJillian Munz
Growth Operations Specialist at ClearcoverGrowth Operations Specialist at Clearcover