SHWATANK BHASIN
Delhi NCR,DL
Summary
Dynamic Oracle Database Administrator with 9+ years of experience in Oracle and PostgreSQL environments. Specialized in performance tuning, automation scripting, and high-availability solutions. Proven expertise in database migrations, disaster recovery, and cross-functional collaboration to ensure secure, efficient, and scalable systems.
Overview
10
10
years of professional experience
Work History
Assistant Consultant
TCS
04.2025 - Current
- Administered Oracle databases, enhancing performance and ensuring high availability.
- Collaborated with development teams on database design and optimization.
- Conducted security assessments to protect sensitive data.
- Managed user access and permissions to maintain confidentiality.
- Implemented backup and recovery procedures, minimizing downtime.
- Monitored database health and resolved issues proactively.
- Upgraded databases with minimal downtime.
- Installed and configured Oracle Database software and tools.
- Developed automation scripts using PL/SQL and shell scripting.
- Tested new database features before production rollout.
- Implemented replication solutions (GoldenGate, DataGuard).
- Partnered with project management teams on scope and timelines.
Database Administrator
Amdocs Development Centre India LLP
06.2022 - 04.2025
- Oversaw installation, configuration, and management of Oracle and PostgreSQL databases.
- Administered Oracle RMAN for backup, restore, and recovery operations.
- Led upgrades and migrations (Oracle 11g → 12c → 19c).
- Applied and tested security patches and updates.
- Conducted performance tuning using AWR and ADDM.
- Performed logical and physical data refreshes across environments.
- Automated DBA tasks with shell scripts and Python.
- Managed user accounts, tablespaces, and routine maintenance.
Senior Database Administrator
Instant Systems Inc
11.2021 - 06.2022
- Delivered continuous on-call support for production environments.
- Installed and maintained Oracle 19c with standby databases.
- Utilized Oracle ASM for efficient storage management.
- Managed logical backups and migrations using Oracle Data Pump.
- Developed shell scripts for automating monitoring tasks.
- Created automated systems for monitoring Oracle and MySQL health.
- Analyzed slow SQL queries, collaborating with application teams for optimization.
- Managed database refreshes, patching, and cloning activities.
Oracle Database Administrator Analyst
HCL Technologies Pvt Ltd
09.2016 - 11.2021
- Upgraded databases (Oracle 12c → 19c), implemented Data Guard and RAC.
- Created and maintained databases across dev, test, and production environments.
- Led refresh and migration activities using RMAN and Data Pump.
- Performed manual backups and recovery during failures.
- Conducted proactive monitoring of tablespaces, backups, sessions, and locks.
- Performed housekeeping tasks including cleanup, space optimization, and retention management.
- Managed user creation, role assignments, and privileges.
- Applied CPU patches to ensure compliance and security.
Education
MBA - HR & IT
Swami Vivekanand Subharti University
Meerut01-2019
B.Tech - Bioinformatics
Shoolini University
Solan01-2017
Intermediate - CBSE
Ganga International School
Delhi01-2012
Matriculation - CBSE
Rosary Senior Secondary School
Delhi01-2010
Skills
Oracle & PostgreSQL Administration
Database Migrations & Upgrades (11g → 12c → 19c)
Backup & Recovery (RMAN, Data Pump)
High Availability (Data Guard, RAC, GoldenGate)
Performance Tuning (AWR, ADDM, Indexing)
Cloud Databases (AWS RDS)
Linux, Shell Scripting, Python
Storage & User Management
Disaster Recovery & Security Compliance
Data integration
Python and Shell scripting
Timeline
Assistant Consultant
TCS
04.2025 - Current
Database Administrator
Amdocs Development Centre India LLP
06.2022 - 04.2025
Senior Database Administrator
Instant Systems Inc
11.2021 - 06.2022
Oracle Database Administrator Analyst
HCL Technologies Pvt Ltd
09.2016 - 11.2021
B.Tech - Bioinformatics
Shoolini University
Intermediate - CBSE
Ganga International School
Matriculation - CBSE
Rosary Senior Secondary School
MBA - HR & IT
Swami Vivekanand Subharti University