Divesh Khatri
Delhi
Summary
Experienced Database Developer with two years of expertise in designing, engineering architecture, and data modeling. Proficiently managed all phases of the software development lifecycle (SDLC), demonstrating a solid track record. Highly analytical thinker skilled at swiftly and efficiently identifying and resolving technical issues.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Database Administrator
AurionPro Solutions
03.2024 - Current
- Work in project Swachh Bharat Mission under department of drinking water and sanitation (Ministry of jal Shakti)
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
- Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
- Installed MYSQL in both linux and windows environment
- Installed postgresql in both linux and windows environment
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance
- Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions
- Optimized database performance by monitoring health and implementing tuning recommendations
- Implemented capacity planning strategies to accommodate growth in data volume without compromising system performance or reliability
- Ensured database security with implementation of role-based access control and regular vulnerability assessments
- Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations
- Streamlined backup and recovery processes, enhancing overall system stability and availability
- Maintained high levels of client satisfaction by consistently meeting service level agreements for database performance and availability
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements
- Created and updated database designs and data models
- Authored and coded database descriptions
- Installed and configured middleware in Linux and Windows environments
- Built databases and table structures for web applications
- Implemented security measures to protect vital business data
- Developed and updated databases to handle client data
Database Administrator
NETPROPHETS CYBER WORKS PVT.LTD
07.2023 - 02.2024
- Name of the client: NIC(National Informatics Centre)
- Name of the project: Egov support to SUPREME COURT OF INDIA
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
- Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
- Installed postgresql in both linux and windows environment
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance
- Built databases and table structures for web applications
- Determined database structural requirements, working with business stakeholders to identify optimal database specifications
- Implemented streaming replication in postgres, having one master and one standby database
- Refreshed testing database with fresh data from production database
- Coordinated with project management on database development timelines
- Implemented user security by setting up of strong passwords for database users and by making appropriate changes to the pg_hba.conf file
- Carried out performance tuning on queries which were not performing upto the marks
- Backed up database objects like tables,schema using utility like pg_dump
- Tested programs and databases to identify issues and make necessary modifications
- Installation of PostgreSQL RDBMS software on Windows &Linux machines
- Provided database SQL query outputs to various stakeholders on demand
- Prepared monthly report for business heads
- Populated database tables with data from CSV files
- Setup the entire database cluster a fresh using data provided
- Data extraction query with demand
- Query optimization and tuning
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability
- Installed and configured middleware in Linux and Windows
- Implemented high availability in using replication manager
Education
Bachelor of Technology - Electrical Engineering
Deenbandhu Chotu Ram University of Science & Tech
Murthal, Haryana05.2023
High School Diploma -
National Public School
New Delhi05.2017
MATRICULATION - CBSE
JAIN BHARTI MARIGYAVATI VIDHYALAYA
New Delhi04.2015
Skills
- Python
- Linux
- ETL development
- Data modeling
- PostgreSQL Database administration
- MYSQL Database administration
- Document Management
- SQL language
- Query writing
- Query performance tuning
- Database Mirroring
- RedHat linux
- MS Office
- C programming language
- C programming language
- Database troubleshooting
- Database monitoring
- Linux operating system
- PHP
Utilities
- PG_DUMP
- PG_CRON
- PG_DUMPALL
- PG_RESTORE
- Replication Manager(REPMGR),
- PGPOOL
- Recovery Manager(RMAN)
Administration Tools
- Linux
- PostgreSQL
- PSQL
- Oracle SqlPlus
- toad
- putty
- WinSCP
- PGADMIN
Certification
- Certificate in C and C++ on programming languages
- Certificate in Building additional dashboards in Power BI
- Certificate in Ethics and Governance of Artificial Intelligence for Health
Disclaimer
05/06/24, New Delhi, I hereby declare that the details and information given above are complete and true to the best of my knowledge.
Training
- National Informatics Centre (NIC, Govt. of India), 6 months, IT Operations, specializing in Database operations
- Royal SPM Automation Solution, Gurugram, 6 weeks
Timeline
Database Administrator
AurionPro Solutions
03.2024 - Current
Database Administrator
NETPROPHETS CYBER WORKS PVT.LTD
07.2023 - 02.2024
- Certificate in C and C++ on programming languages
- Certificate in Building additional dashboards in Power BI
- Certificate in Ethics and Governance of Artificial Intelligence for Health
Bachelor of Technology - Electrical Engineering
Deenbandhu Chotu Ram University of Science & Tech
High School Diploma -
National Public School
MATRICULATION - CBSE
JAIN BHARTI MARIGYAVATI VIDHYALAYA
Similar Profiles
Pankaj TripathiPankaj Tripathi
Quality Control Manager at Aurionpro Solutions LimitedQuality Control Manager at Aurionpro Solutions Limited
Swarnava PalitSwarnava Palit
Sr. Associate at Aurionpro Solutions LtdSr. Associate at Aurionpro Solutions Ltd
Subrata SenSubrata Sen
ASSISTANT MARKETING MANAGER at AURIONPRO SOLUTIONS LTDASSISTANT MARKETING MANAGER at AURIONPRO SOLUTIONS LTD