Headline

Oracle DBA | Technology Lead

About

Experience Certified Oracle DBA with 12 years experience. Domain of expertise covers Banking,Pharmaceutical and Telecommunication. Skills Oracle Database Administration Database Virtualization Budgeting Performance Tuning Scalability Upgrades Multitenant Architecture RAC Dataguard Patching Cloning Backup and Recovery | RMAN | Datapump Oracle Cloud AWS RDS - Oracle SE, SE2 and EE Amazon Aurora

Location

Hyderabad

AI stack

antigravity

codex

claudecode

Work experience

Technology Lead at Infosys, Mar 2012 - Present · 14 yrs 6 mos, Hyderabad Area, India, Title: Application Engineering DBA Client: Pfizer Inc. USA Responsibilities Provide database technical expertise and direction for development team members and external contacts Impact Shared the use of OEM Cloud Control 13c for GCC DB and Host Health checks and to troubleshoot Critical"ORA-" errors instead of manual efforts Resolved the Performance issues post SLM Patching | Upgrades by the VBlock Team owing to VMwareSnapshots which has spanned to multiple databases, Cost losses and efforts have been reduced Increased the restore time using Set DBID option when performing tablespace PITR. Thetransport_set_violations and dbms_tts.transport_set_check have been avoided with this technique. Resolved the ETL database performance problems when Truncate was running for longer durations, REUSESTORAGE clause was the culprit. Awards Bravo, RCLIMS, Infosys Best Team, Oracle DBA Engineering, CIS RnR 2015, Infosys

Associate, DBA, Oracle at Softenger, Aug 2009 - Feb 2012 · 2 yrs 7 mos, Pune, Maharashtra, India, Responsibilities Monthend activity: Daily | Monthly | Quarterly partitions and Partitioned Index, Tablespace, View creationbased on the policy BCV(Business Continuance Volume) configuration: Shell scripts for hot backup. Bringing up the database aerrecovery in read-write mode. Oracle RAC(Real Application Clusters):Srvctl(db and asm start| shutdown),crs_stat command,Starting andstopping cluster services on each node Oracle Automatic Storage Management(ASM):Asmcmd utility,Disk group creation-3 modes of redundancy,mount/unmount Impact Scheduled jobs in cron(unix):Monitoring-Archives, Tablespace, Mview, Standy lagging, Votedisk/ocr backup,Trace (BDUMP | UDUMP | CDUMP), Listener logs purge. Conceptualized the use of database links. Synonyms,and performed table creation using database links, usednetwork link parameter in data pump. Drove Oracle 10gR2 Two-Node RAC Standby installation VTOPUP DR Activity. VTOPUP was one of the criticaldatabases handled at the site. Disaster recovery database was created for the Hyderabad site.

Education

Bachelor of Technology (BTech), Mechatronics, Robotics, and Automation Engineering, Mahatma Gandhi Institute of technology

Bharatiya Vidya Bhavans Public School