Database Administrator Oracle
Resume:
ALLWIN ALEXANDER
Database Administrator (ORACLE)
+91-828******* *********@*****.*** https://www.linkedin.com/in/allwin- alexander-802036b1
Mumbai
SUMMARY
Motivated and result oriented Oracle database administrator with 5+ years of experience in developing and maintaining database across multiple domains like Healthcare, Banking and Retail. Also, skilled in troubleshooting and Performance Tuning and have expertise across various database versions.
EXPERIENCE
05/2023 - Present
Mumbai, India
Consultant – Oracle Core DBA
Versetal Cloud RMM Solutions Pvt Ltd
05/2022 - 05/2023
Mumbai, India
Oracle Core DBA
Tata Consultancy Services
03/2021 - 05/2022
Kochi, India
Oracle DBA
Datamate Infosolutions Pvt Ltd.
09/2016 - 09/2018
Mumbai, India
System/Database Administrator
L.C.Manek Hospital
EDUCATION
2018 - 2019 Masters in Computer Applications
University of Mumbai
2013 - 2016 Bachelor of Science in Information Technology University of Mumbai
2011 - 2013 Higher Secondary School
Maharashtra State Board
2010 - 2011 Secondary School
Maharashtra State Board
CERTIFICATION
Oracle DBA Certification
Tech Mahindra (Year 2016)
SQL Fundamentals Certification
Udemy
AWS Certified Solutions Architect Associate
SAA-C03
Udemy
E q
TECHNICAL SKILLS
Oracle Database
Database Installation, Creation, Upgrade and Migration (Oracle 11g,12c,18c,19c,etc). Troubleshooting database issues, errors and bugs.
Good understanding of Oracle Database Architecture. Good understanding of CRSCTL and SRVCTL commands.
Good understanding on Real Application Cluster (RAC) databases. Installation and configuration of RAC. Add/Remove Nodes on RAC. Implemented ASM and NON-ASM databases.
Database Maintenance and Performance Tuning
Daily monitoring of database parameters.
Generating AWR reports, ADDM reports diagnosing the problems. Space management for smooth running of database.
Implementing patches and bug fix.
Execute table and Index statistics.
Indulge in querying tuning for faster retrieval of data. Indulge in creating new indexes and rebuilding the old ones as well as monthly purging of tables. Managing tablespaces and ASM disk spaces.
Database Security
Managing users and profiles.
Enhanced system security by implementing Transparent Data Encryption (TDE). Implemented Database Vaulting.
Backup, Recovery and Disaster Recovery
Database Cloning/Duplicate using RMAN.
Implemented RMAN backups (Incremental and Differential). Knowledge in Flashback Technologies & Hands-on experience with Expdp/Impdp. Hands-on experience in Point in time recovery using RMAN. Hands-on experience in Recover a loss of all online redo log files using RMAN. Hands-on experience in Table Recovery using RMAN Backup. Implementing and managing physical and Logical standby database for disaster recovery purpose. Creating Standby database for Production environment. Performing monthly DR drill activity.
ADDITIONAL SKILLS
Oracle Cloud Infrastructure (OCI) Tools like TOAD, SQL DEVELOPER, OEM.
Operating Systems : RHEL, ORACLE
LINUX, WINDOWS.
Coding Skills : Shell scripting, SQL,
PL/SQL, ASP.NET with C#, C++, JAVA
Oracle APEX installation Oracle Golden Gate
PostgreSQL - Database
Administrator (IN PROGRESS)
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Contact this candidate