Poonam Sharma
Bangalore
Summary
Dedicated and detail-oriented Database Administrator & Technical Support Engineer with 3.5 years of experience in managing and optimizing database systems for a leading cab aggregator company. Proficient implementation and maintenance, with a strong focus on ensuring data integrity, security, and performance. Adept at troubleshooting and resolving database-related issues, performing data migrations, and working with cross-functional teams to support business goals. Seeking to leverage my expertise in a challenging new role, where I can contribute to the success of an innovative organization.
Overview
4
4
years of professional experience
Work History
Database Administrator 1
ANI Technologies Private Limited [OLA]
Bangalore
12.2023 - Current
- Working as part of a team and providing 24/7 support in a production environment.
- Installation, configuration, maintenance, and administration; data directories; schema design of MySQL.
- AWS experience in EC2, RDS, S3, and snapshot.
- Good knowledge of MySQL Server clustering, replication, and conducting a walkthrough of database design, including the entire architecture, physical and logical schema, and selection of storage engines (InnoDB, MyISAM, NDBCluster), as well as coding of stored procedures and triggers prior to deploying the solution.
- Proficient in installing, configuring, and maintaining MySQL database servers to ensure reliability and high availability.
- DBA for multiple databases in a MySQL VM environment; job responsibilities include optimisation, creation of high availability with Microsoft Cluster Services, setup of master-to-master replication, master-to-slave replication, and Linux Ubuntu setups.
- Developed and maintained cooperative and collaborative relationships with networking, storage, software development, and project management teams.
- Skilled in monitoring database performance, identifying bottlenecks, and implementing optimizations to enhance speed and efficiency.
- Servers' activity includes clearing security logs, checking the disk space.
- Data compressing, backup, and recovery using the tar command. Interacted with the business team to understand business needs and to gather requirements.
- Manage all technical aspects of the ETL jobs process with other team members.
- Experienced in managing user roles, permissions, and data access, ensuring compliance with security standards, and maintaining data integrity.
- Proficient in maintaining and optimizing database schema (tables, indexes, views) for efficient query execution and data retrieval.
- Experienced in configuring and monitoring replication processes to maintain data consistency and ensure high availability.
- Proficient in diagnosing and resolving complex database issues to minimize downtime, ensure high availability, and maintain the seamless operation of mission-critical systems.
Senior Technical Engineer
2COMS Consulting Pvt. Ltd. [Contractor to OLA]
Bangalore
01.2023 - 11.2023
- Monitored database performance, proactively identifying and resolving bottlenecks to ensure optimal system performance and availability.
- Conducted regular backups, recovery tests, and disaster recovery planning to safeguard critical data.
- Performed routine database maintenance tasks, including patching, updates, and data migration, ensuring compatibility and security.
- Tuned SQL queries and optimized database schemas to improve application performance.
- Implemented and managed database security protocols, ensuring data integrity, and compliance with organizational policies.
- Troubleshot database-related issues, minimizing downtime, and ensuring high availability in production environments.
- Collaborated with development teams to support database design, query optimization, and deployment processes.
- Set up and maintained database replication and clustering for high availability and failover solutions.
- Maintained and updated database documentation, including schemas, configurations, and operational procedures.
- Utilized monitoring tools to track database metrics, identify anomalies, and generate performance reports.
- Configured user accounts, privileges, roles, profiles. in the database server.
Senior Technical Support Engineer
Microloan Limited PVT. LTD.
Bangalore
09.2021 - 12.2022
- Replied to customer queries via email, messaging systems and support ticket platforms
- Provided support via remote desktop software, diagnosing customer issues over private and public networks
- Collaborated with teams to solve technical customer problems across product suites
- Updated software versions with patches and new installations to close security loopholes and protect users
- Responded to assistance requests from users and directed individuals through basic troubleshooting tasks
- Fulfilled client customization requests for managed systems and software components according to internal business requirement policies
- Working as for providing telephone support and face to face solution to customers on operation or maintenance of window or mac or chrome book products
- Support customers with basic technical support related hardware and network and software releases
- Providing VPN access and helping to download the global protected connection as well
- Handling chat processes and resolving issues on the chat desk as well
- Knowledge about MS office, Wi-Fi issue, global protect, Zapper, security patch, Admin access ETC
- Resetting the password in Active directory and adding users in VPN group
- Working on software installation in user's machine Knowledge about noncompliance and working remotely and live users Working on window update and updating the security patch in user's machine Working on open and pending tickets, getting either software related or hardware as well.
Technical Support Engineer
DELL
Hyderabad
10.2020 - 08.2021
- Updated software versions with patches and new installations to close security loopholes and protect users
- Working as for providing telephone support for customers on operation or maintenance of Dell products Support customer with basic technical support for current and past software releases
- Assisted clients with general support for hardware, peripherals, network, connections, and external software
- Escalated help desk tickets to level2/tier2 support when outside the scope of L1/T1 Technical support
- Assisting phone customers by diagnosing problems, and providing resolutions for technical and service issues Performed work in accordance to standardized policies and procedures
- Handling inbound calls, emails, and web interface to drive numbers with existing and new customers
- Providing solution for technical issues on calls which may end with booking an order for paid repair services, renewal services and/or with relevant Dell products Cooperate and collaborates with colleagues, cross- functionally, to support the technical solution process.
Education
Masters in Computer Applications -
Lovely Professional University
01.2025
Bachelor in Computer Applications -
Khalsa College For Women (GNDU)
Punjab. Amritsar01.2015
Skills
- MYSQL
- AWS
- AWS RDS
- Terraform
- Learning PostgreSQL
- Linux
- Performance tuning
- Database monitoring
- Database troubleshooting
- Query optimisation
Timeline
Database Administrator 1
ANI Technologies Private Limited [OLA]
12.2023 - Current
Senior Technical Engineer
2COMS Consulting Pvt. Ltd. [Contractor to OLA]
01.2023 - 11.2023
Senior Technical Support Engineer
Microloan Limited PVT. LTD.
09.2021 - 12.2022
Technical Support Engineer
DELL
10.2020 - 08.2021
Masters in Computer Applications -
Lovely Professional University
Bachelor in Computer Applications -
Khalsa College For Women (GNDU)
Similar Profiles
DIKSHA JAISWALDIKSHA JAISWAL
Assistant Manager - Indirect Tax at OLA Electric Technologies Private Limited (OLA Electric)Assistant Manager - Indirect Tax at OLA Electric Technologies Private Limited (OLA Electric)
Santosh Pratap SinghSantosh Pratap Singh
Director Operations - B2B at Bycyshare Technologies PVT. LTD. (ZYPP ELECTRIC)Director Operations - B2B at Bycyshare Technologies PVT. LTD. (ZYPP ELECTRIC)
Casimir GCasimir G
Process Lead at Capgemini Technology Services India LimitedProcess Lead at Capgemini Technology Services India Limited