Oracle DBA Administrator Resume

SUMMARY

Confident and resourceful with an experience in Administering and Maintaining Oracle 9i, 10g, 11g Databases
Proficient in database administration, production support, space management, file system management, database security, Unix/Linux commands
Have good knowledge in RMAN Backup and recovery, Export, import and Cloning of databases
Having a good knowledge and work experience in RAC, ASM, Goldengate and Data guard in Oracle 10g and 11g databases
Hands - on in Aerospike and Couchbase database.
24x 7Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Experienced in ITIL framework like Incident Management and Change Management.
Willingness to learn new concepts and technology and apply them to yield successful results

TECHNICAL SKILLS

Programming skills: SQL

Operating Systems: UNIX/Linux/Solaris and Windows

Tools: Service now, OEM, Toad, BMC Remedy, Putty, PPM

Database: Oracle 9i/10g/11g, Aerospike and Couchbase

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA Administrator

Responsibilities:

Maintaining data standards, including adherence to the Data Protection Act
Ensuring that storage and archiving procedures are functioning correctly
Performing scheduled changes in the production databases as per change management process
Ensuring node availability and performing maintenance tasks in Oracle RAC environment for high availability
Resolving lags and ensuring all the DG process are running in Oracle Datagaurd environment
Resolving issues with abended extract/replicat in Oracle Goldengate environment
Acting on alerts/live dashboards to escalate/resolve issues by following SOPs in Oracle (11g) and NO-SQL environments.
Hands-on in Aerospike and Couchbase databases.
Monitor Projector screens for key business metrics deviation and act accordingly to avoid any impact
Perform LTS (live to site) checks for on boarding new systems and databases
Perform scheduled database partition maintenance, ASM disk additions
Responsible for resolving issues at the earliest to maintain minimal impact/outage for the end user
Communication with TDO (Technical duty officer) and SRE (Site Reliability engineer) for incident triaging.
Working with Oracle support to resolve database issues

Confidential

Oracle DBA Administrator

Responsibilities:

Creation of new databases as per application requirement.
Creating, managing and modifying database storage structures like control files, redo log files, archive log files, tablespaces and datafiles as necessary, from information given by application developers
Performing patching for Oracle databases.
Performing script execution and troubleshooting the issues
Testing the backups periodically for consistency and reliability.
Creating and maintaining roles, privileges and profiles of users.
Managing the Data files and the Table spaces
Monitoring, analyzing and rebuilding the indexes
Performance tuning using OEM
Monitoring disks space, CPU usage, memory usage etc. and rectifying the performance related issues for databases which are expected to run with the high availability.
Performing export/import for database restoration.
Performing daily and weekly backups for production Database.
Working with Client via bridge calls to fix the issue

Confidential

Oracle DBA Administrator

Responsibilities:

Creation of new database as per the client requirement
Creating, managing and modifying database storage structures like control files, redo log files, archive log files, tablespaces and datafiles as necessary, from information given by application developers
Creation of users, Security Management through privileges, roles, profiles and auditing of user actions
Managing of Oracle Data guard in physical standby database
Experienced in RAC and ASM Administration in 10g and 11g databases
Finding the root cause and fixing issues experienced in backup job failure
Have performed different levels of RMAN backup and recovery in various databases versions
DB, Schema and table level backup using EXP/EXPDP and IMP/IMPDP
Working with Clients/Oracle support by attending bridge calls