Summary
Overview
Work History
Education
Skills
Certification
Websites
Timeline
Generic
KARAN SONI

KARAN SONI

New Delhi

Summary

A highly motivated and results-oriented Oracle Database Administrator (DBA) with 5 years of experience in designing, implementing, managing, and optimizing complex Oracle databases. Proven ability to ensure database availability, security, performance, and scalability. Strong analytical and problem-solving skills with a focus on continuous improvement.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Oracle Database Administrator

Wipro Limited
06.2019 - Current
  • Provided comprehensive database administration for Oracle [12C, 19C] databases.
  • Designed, implemented, and maintained database objects (tables, indexes, views, etc.) to ensure efficient data storage and retrieval.
  • Managed multiple databases across different environments like development, testing and production.
  • Managed user accounts, roles, and privileges to enforce data security and access control.
  • Performed backup and recovery operations using RMAN utility.
  • Implemented data replication solutions like GoldenGate or DataGuard.
  • Monitored database performance and tuned accordingly.
  • Provided 24x7 on-call support for critical incidents related to databases.
  • Created and altered database storage structures to meet user needs.
  • Automated routine tasks using PL/SQL and shell scripting to improve efficiency and reduce manual errors.

Education

B. Tech - Computer Science

Rajiv Gandhi Proudyogiki Vishwavidyalaya
Bhopal
05-2019

Skills

  • Oracle Database Administration
  • Oracle RAC & ASM Administration
  • Backup and Recovery: RMAN, Data Guard, Recovery Manager (RMAN)
  • Performance Tuning & Capacity Monitoring
  • Automation and Scripting: PL/SQL, Shell Scripting (Bash)
  • Standby / Failover Administration
  • Analytics:
  • Analyzed existing SQL queries to identify opportunities for improvements
  • Built visualizations that enabled users to quickly interpret results from complex analyses
  • Developed dashboards with Power BI & Excel to monitor key performance indicators
  • Analyzed large datasets to identify trends, patterns and correlations for business insights

Certification

  • Oracle Cloud Infrastructure Foundations 2020 Certified Associate
  • Oracle Cloud Infrastructure2019 Certified Architect Associate

Timeline

Oracle Database Administrator

Wipro Limited
06.2019 - Current

B. Tech - Computer Science

Rajiv Gandhi Proudyogiki Vishwavidyalaya
KARAN SONI