Ashish Kumar
Lead Database Administrator
Noida
Summary
Driven Database Architect /Administrator with 6+ years of experience in full lifecycle development. Goal-oriented team player succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities. Efficient administrator eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup and recovery with good understanding of automation and containerization tools. Team-oriented with strong work ethic.
Overview
7
7
years of professional experience
10
10
years of post-secondary education
3
3
Languages
Work History
Lead Database Administrator
Fareye Technologies
04.2021 - Current
- Leading Database Administration team which includes postgresql,redshift,cassandra,mysql,mongo
- Implemented proactive maintenance schedules, ensuring optimal database health and stability.
- Implemented data warehousing solutions that streamlined reporting capabilities while minimizing impact on production systems.
- Assisted in disaster recovery planning, contributing to business continuity objectives and risk mitigation strategies.
- Evaluated emerging technologies to identify potential improvements to existing systems and processes.
- Conducted regular audits of user access rights, safeguarding against unauthorized access or potential breaches of sensitive data.
- Streamlined database operations by implementing efficient backup and recovery strategies.
- Enhanced data security with advanced encryption techniques for sensitive information protection.
- Designed scalable database solutions that supported company growth without compromising performance or reliability.
- Managed capacity planning efforts, forecasting future needs and making recommendations to avoid resource constraints.
- Created and updated database designs and data models.
- Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
- Built databases and table structures for web applications.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Cost and performance improvement up to 1.5 x for customers like Bluedart and meesho
Sr. Engineer (postgres Database)
Byjus
09.2020 - 03.2021
- Implementing Postgresql Security ,Backup and recovery.
- Database tuning and importing and exporting data from postgresql
- Formation of SQL queries to analyze data and to give solution for reporting terms.
- Making of various shell scripts to automate task and to reduce timely efforts.
- Implemented cost-saving measures, reducing overall expenses without compromising quality or functionality of deliverables.
- Collaborated with stakeholders to define project requirements, establish goals, and develop actionable strategies for success.
- Making Views and shell scripts to carry out daily operations.
- Establish Replication among databases.
- Launching RDS instances of Postgresql on AWS and creating AZ and Read replicas
- Performance tuning and configuring parameters to increase performance of SQL queries and procedures.
- Troubleshooting of Application issue regarding Linux or Database.
- Monitoring of database with PgAdmin and AWS cloud watch.
- Reduced cost and performance up to 5x
Sr. Engineer (postgres Database)
Ameyo
07.2017 - 09.2020
- Migration from Oracle database to Postgresql for projects,which encapsulates schema,data, procedures, and triggers.
- Setup of complete failover systems through Pacemaker and corosync.
- Performance tuning and configuring parameters to increase performance of SQL queries and procedures.
- Troubleshooting of Application issues regarding Linux or Database.
- Formation of SQL queries to analyze data and procedures to give solution for reporting terms.
- Making of various shell scripts to automate task and to reduce timely efforts.
- Carrying out the understanding & analyses of client requirement designing Concept Document of requirement.
- Designing of architecture in terms of tables,table space,and schemas,partitioning and replication.
- Doing various Database Management activities like,DB Backup,Restore,Vacuuming,reindexing.
- Implemented cost-saving measures, reducing overall expenses without compromising quality or functionality of deliverables.
- Collaborated with stakeholders to define project requirements, establish goals, and develop actionable strategies for success.
- Managed customers like Myntra,OLA and onsite experience with IKEA morocco and POS malaysia
Education
B.Tech. (ECE) -
BCET Gurdaspur (An Autonomous Institute Under Punjab Goverment)
Punjab 07.2012 - 05.2020
Class XII -
Kendiya Vidyalaya NO 4 Jalandhar Cantt
Jalandhar 04.2010 - 03.2011
Class X -
Kendriya Vidyalaya No 4 Jalandhar Cantt
Jalandhar Cantt 04.2008 - 03.2009
Skills
RDS,AWS,Aurora,Azure
Shell scripting,PL/SQL
Postgres,Mysql,Mongo,Redshift
Administration and managementPerformance Tuning
Capacity Planning
Database Design
Disaster Recovery Planning
Backup and recovery
Database monitoring
Query Optimization
High Availability Solutions
Cloud Database Services
Database Security
Replication Strategies
Running backups
Database Management
DATA architectecturing and refactoring
Accomplishments
- Has been awarded the annual "Award of Excellence" by ameyo in the year of 2019.
- Created a consolidated database to improve efficiency 1.5x.
- Received promotion to Lead within 2 years.
- Has been rewarded multiple time
- Organized and participated in many cultural events at school and college level.
- Actively participated and won many awards in quiz/debate competitions at the school level.
- Awarded with a gold medal in kabaddi and cricket tournaments at school and college level.
- Organized and participated in a blood donation camp in college.
Preferred Location
No Bar
Strengths
- Leadership quality as well as Good Co-coordinating, Organizing and Management skills.
- Comfortable with a new assignment.
- Can work in pressure.
- International Exposure of various reputed clients
- Passionate about work.
- Excellent grasping power.
- Eager to learn new things and love to handle challenging tasks.
- Excellent communication skills.
Personal Information
- Date of Birth: 06/11/93
- Marital Status: Single
Timeline
Lead Database Administrator
Fareye Technologies
04.2021 - Current
Sr. Engineer (postgres Database)
Byjus
09.2020 - 03.2021
Sr. Engineer (postgres Database)
Ameyo
07.2017 - 09.2020
B.Tech. (ECE) -
BCET Gurdaspur (An Autonomous Institute Under Punjab Goverment)
07.2012 - 05.2020
Class XII -
Kendiya Vidyalaya NO 4 Jalandhar Cantt
04.2010 - 03.2011
Class X -
Kendriya Vidyalaya No 4 Jalandhar Cantt
04.2008 - 03.2009