Summary
Overview
Work History
Education
Skills
Certification
Interests
Work Availability
Timeline
Generic

Saumitra Kumar

Oracle DBA
Pune

Summary

Efficient administrator eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup and recovery with good understanding of automation and containerization tools. Team-oriented with stong work ethic. Top-notch [Job Title] with solid background in designing and implementing data management solutions. Strong knowledge of database security, backup and recovery. Collaborative and dedicated to improving and optimizing database performance.

Overview

14
14
years of professional experience
5
5
years of post-secondary education
1
1
Certification

Work History

Oracle DBA

Vodafone
Pune
02.2017 - Current
  • Established working relationships across various departments to understand existing and emerging IT requirements.
  • Provided resources and skill sets to support DBA functions for applications.
  • Proposed database changes to ease monitoring and administrative effort.
  • Troubleshot database issues to create and resolve trouble tickets.
  • DB migration from oracle 9i/10g/11g/12c to 19c and migration of on prem DB's to OCI or AWS.
  • Troubleshot performance related issue like creating sql profile,baseline,changing the execution plan for problematic application sqls and SGA tuning
  • Table partitioning
  • Defragmentation of tables and indexes for improved performance and effective space management Oracle database creation.
  • Export/Import/DB refresh/Schema refresh
  • Oracle user management
  • Golden gate implementation and troubleshooting
  • Golden gate initial load
  • Maintaining MIR/P1 tracker/CRQ
  • Golden gate performance issue troubleshooting
  • Adding new table in live replication.
  • Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
  • Reviewed database design to recommend enhancements or improvements.
  • Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
  • Developed automated processes to manage database creation in virtualized or cloud environment.
  • Set up and controlled user access levels across databases to protect important data.
  • Modified databases to meet needs and goals determined during planning process.
  • Conducted tests to identify issues and make necessary modifications.
  • Developed and updated databases to handle customer data.
  • Adhered to set schedules to test databases for flaws and reduce downtime.

Oracle DBA

Cognizant
Kolkata
08.2015 - 01.2017
  • DB migration from oracle 9i/10g/11g to 12c
  • Monitor the health of database after migration
  • Using the feature of Datapump for migration (Parallel,Query,Attach,remap_schema,remap_tablespace
    etc.)
  • Proposed database changes to ease monitoring and administrative effort.
  • Performed SQL tuning by using Explain Plan and Tkprof Estimate the downtime for migration activity
  • Migration of other oracle tool like oracle workspace manager from lower version to 12c.
  • Adhered to set schedules to test databases for flaws and reduce downtime.
  • Standby database creation using data guard.

Oracle DBA

hp (Payroll=Talbros)
Jamshedpur
04.2012 - 08.2015
  • Installation and administration of the oracle database systems and tools.
  • Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i/10g to 11g and 12c
  • Standby database creation using data guard.
  • Planning for backup and recovery of database information.
  • RMAN Backup and restoration of oracle database.
  • Export and Import.
  • Upgrade oracle database.
  • Estimating storage requirements for an application.
  • Managing database security and creating and assigning appropriate roles and privileges as required by the application.
  • Database and SQL tuning to improve performance of loads.
  • Analyzing tables on a regular basis for the Oracle optimizer.
  • Scheduling of Jobs in DBA jobs and oracle scheduler
  • Monitoring and optimizing the performance of the database.
  • Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space Contacting Oracle Corporation for technical support.

Oracle DBA

hp (Payroll=NH Info)
Delhi
01.2011 - 03.2012
  • RMAN Backup and restoration of oracle database.
  • Installation and administration of the oracle database systems and tools.
  • Upgrade oracle database
  • Managing Oracle data base on HP-Unix, Sun Solaris and Linux.
  • Creating and maintaining users profile on oracle database.
  • Making standby database.
  • Export and Import in oracle database 10G
  • Oracle database creation.
  • SQL/SGA/SESSON/PROCESS/Shared Pool Tuning
  • Monitoring and optimizing the performance of the database Planning for backup and recovery of database information

Oracle DBA

hp (Payroll= INS solution)
Gurgaon
10.2009 - 12.2010
  • Reviewed database design to recommend enhancements or improvements.
  • RMAN Backup and restoration of oracle database.
  • Installation and administration of the oracle database systems and tools.
  • Creating and maintaining users profile on oracle database.
  • Work closely with the business areas to understand the requirements and to write complex SQL queries.
  • Oracle user management
  • Monitoring and optimizing the performance of the database
  • Using Data protector for backup all server (windows, oracle and exchange data base)
  • Tablespace managemen
  • Contacting Oracle Corporation for technical support

Education

Bachelor of Science - BCA

CCS University Meerut, India
Meerut
07.2004 - 07.2007

Math/Physics/Chemistry

DAV
06.2001 - 07.2002

Kendriya Vidyalaya
Ranchi
06.1999 - 06.2000

Skills

Systems administration

undefined

Certification

OCP

Interests

Oracle Cloud

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

OCP

06-2017

Oracle DBA

Vodafone
02.2017 - Current

Oracle DBA

Cognizant
08.2015 - 01.2017

Oracle DBA

hp (Payroll=Talbros)
04.2012 - 08.2015

Oracle DBA

hp (Payroll=NH Info)
01.2011 - 03.2012

Oracle DBA

hp (Payroll= INS solution)
10.2009 - 12.2010

Bachelor of Science - BCA

CCS University Meerut, India
07.2004 - 07.2007

Math/Physics/Chemistry

DAV
06.2001 - 07.2002

Kendriya Vidyalaya
06.1999 - 06.2000

Similar Profiles

CREATE PROFILE
Saumitra KumarOracle DBA