PostgreSQL DBA - Nusummit Technologies (formerly known as CloudXchange.io) - Mumbai
(2024-06 - 2025-02)
- Deploying and managing PostgreSQL databases in AWS RDS.
- Install PostgreSQL database On-Prim as well as cloud platform.
- Upgrading Major database Versions on AWS RDS.
- Managing point-in-time recovery (PITR) capabilities offered by cloud services.
- Creating planned a DR Drill (Disaster Recovery) is activity ensure that databases, applications, and infrastructure can successfully switch over to the DR site in case of a real disaster.
- Reviewing database performance metrics (CPU, memory, I/O, network usage).
- Setting up automated backups, monitoring, and replication.
- Optimizing performance with cloud-native monitoring tools (CloudWatch, Azure Monitor).
- Managing IAM roles, encryption, and compliance for secure databases.
- Configuring PostgreSQL parameters, optimizing queries, and ensuring efficient performance within the cloud environment.
- Analyzing slow queries and optimizing them, including index creation and monitoring index using Explain Plan to make better Performance of Queries.
- Experience in Vacuum, Vacuum Full and Reindex in Database for Maintenance Activities.
- Database health check and identify performance related issue by interpreting various report.
Database Administrator - Hitachi Systems India Pvt Ltd - Navi Mumbai
(2022-11 - 2024-06)
- Worked for Oracle Database as well as PostgreSQL on -prim.
- Installing the Oracle Database 12c.
- Creating an Oracle Database using DBCA.
- Managing Tablespaces, Administering User, roles, privileges, profiles.
- Performing Backup and Recovery through RMAN.
- Checking database sessions using rollback segments.
- Daily Check any session blocking the other session.
- Configure environment variables and network connectivity.
- Monitoring PostgreSQL DB availability and connections.
- Creating Streaming Replication in Primary server.
- Managed disk space and wal space on healthcheck report.
- Taking pg_basebackup for physical backups and pg_dump and pg_dumpall utilities for logical backups on PostgreSQL DB.
Frontend Support / IT Support - Vidarbha Infotech Pvt Ltd - Andheri
(2019-11 - 2021-11)
- Worked on the Property Tax Project, providing Frontend support through a ticketing tool.
- Managed and resolved user(BMC)-reported incidents, service requests, and system-related issues.
- Handled incident and service request tickets, ensuring timely resolution and user satisfaction.
- Validated property tax records and ensured data accuracy within the application.
- Coordinated with development and technical teams for issue escalation and resolution.
- Maintained ticket status updates, documentation, and resolution records to meet service-level requirements.
- Validated data, identified root causes of issues, and ensured timely issue resolution.
Administrative Officer - National English High School - Mankhurd
(2017-03 - 2019-05)
- Managed daily administrative and clerical operations of the school office.
- Maintained student records, admission documents, attendance registers, and staff records.
- Handled correspondence, documentation, filing, and data entry activities.
- Coordinated with students, parents, teachers, and management regarding administrative matters.
- Prepared reports, maintained office databases, and ensured accurate record-keeping.
- Assisted in fee management, scheduling, and general office administration.
- Supported smooth day-to-day school operations by manging office supplies and administrative processes.
