Sagi Pavan Kumar
Visakhapatnam
Summary
3.6 years of experience as Database Administrator with solid background in managing and maintaining complex database systems. Successfully ensured data integrity and optimized database performance across various platforms. Demonstrated expertise in SQL and database security, effectively collaborating with teams to achieve project goals.
Overview
4
4
years of professional experience
Work History
Database Administrator
Company Name
03.2023 - Current
- Provided 24x7 production DBA support along working with the development teams for test, production databases.
- Responsible for Oracle 12c/19c Database Administration on Production, Development and Test Databases including Disaster recovery (Data Guard) and Backup & Recovery using RMAN.
- Expertise in Planned and Unplanned downtime using Oracle Data guard(Switchover and
Failover). - Migrated Oracle Database production boxes from Windows to Linux servers .
- Involved in Performance Tuning of Oracle database using Oracle utilities
ADDM, AWR, STATSPACK, SQL Access Adviser, EXPLAIN PLAN, SQL TRACE & TKPROF. - Set up backup procedure using RMAN, Export/import and Data Pump.
- Monitored production thresholds like tablespaces growth periodically and added resizing datafiles.
- Recovered production database from primary HD failure with RMAN.
- Loading data from flat files to Oracle Database using SQLLOADER.
- Applying Security Patches for Oracle Bugs.
- Checking Alert Log errors and make necessary steps to rectify them.
- Created variance shell scripts and automated process using CRON jobs on Linux.
- Creating and maintaining the Database links and working with Database refreshes.
Database Administrator
JSW Steel Dolvi Works
08.2021 - 02.2023
- Installation of oracle 12c and creating databases on UNIX Environments.
- Configuring init.ora parameters.
- Creating table spaces & Adding data files.
- Monitoring table space size.
- Creating users, schemas, profiles, roles. Locking and unlocking the accounts.
- Granting the necessary privileges and assigning the profile to users.
- Monitoring alert log and trace files and archive Logs.
- Enabling the listener parameters and reloading the listeners.
- Taking cold backup and Performed logical backup using export/import & Data pump.
- Restore and Recovery of Databases by various methods including EXPORT/IMPORT, DATAPUMP and RMAN Backups.
- Providing 24X7 supports for production database.
Education
Bachelor of Technology - Mechanical Engineering
National Institute of Technology Durgapur
Durgapur, West Bengal05-2021
Intermediate - MPC
Sri Chaitanya Junior College
Visakhapatnam, Andhra Pradesh05-2017
10th - SSC
Dr. KKR Gowtham Concept School
Visakhapatnam, Andhra Pradesh05-2015
Skills
- OEM, Nagios, Toad, Putty, SQL Loader
- RAC, Dataguard, RMAN
DBA Tools:
DBA Technologies:
- Oracle Versions 12c/19c
- UNIX, Linux, Windows
Databases:
Operating Systems:
Technical Summary
• Creating a database using manual and DBCA methods.|
• Installing Oracle12c/19c software in graphical mode and silent mode.
• Having good knowledge in table space management.
• Creating users with restricted access with required privileges.
• Creating profiles and attaching them with users and monitoring the users.
• Managing Control files, Online Redo logs, Archive Redo logs.
• Having good knowledge of Oracle Architecture.
• Good knowledge on regular off-line, online Backups.
• Expertise in Performing Logical Backups like EXP/IMP and Data pump.
• Expertise in RMAN CONFIGURATION and Performing RMAN backups.
• Taking the compressed backups and Incremental backups using RMAN.
• Maintaining listener.ora and tnsnames.ora files.
• Configuration of ASM and maintaining the database using ASM.
• Cloning of a database using hot cloning and RMAN cloning.
• Having knowledge on setting up & managing oracle physical standby databases.
• Good knowledge in applying Patches and Patch sets.
• Cloning/ Refresh from production instance to test instances using both Hot and Cold
Backup.
• Having good knowledge in creating DB links and Materialized Views.
• Having good knowledge on RAC Installation in Oracle 12c using ASM, Maintaining the Cluster databases using SRVCTL and CRSCTL.
• Having good knowledge on maintaining load balancing, OCR file and voting disk.
Timeline
Database Administrator
Company Name
03.2023 - Current
Database Administrator
JSW Steel Dolvi Works
08.2021 - 02.2023
Bachelor of Technology - Mechanical Engineering
National Institute of Technology Durgapur
Intermediate - MPC
Sri Chaitanya Junior College
10th - SSC
Dr. KKR Gowtham Concept School
Similar Profiles
Rebecca RandolphRebecca Randolph
Job Title at Company NameJob Title at Company Name
Shanice VernonShanice Vernon
Customer Support Specialist at Company NameCustomer Support Specialist at Company Name
Micah BallardMicah Ballard
Vinyl Technician at Company NameVinyl Technician at Company Name