Results-driven Oracle Database Administrator adept at enhancing database performance, ensuring high availability, and proficiently managing data recovery and backup processes. Skilled in Oracle RAC, Data Guard, Golden Gate, and Performance Tuning to efficiently complete tasks with precision. Possess strong problem-solving abilities, effective communication skills, and capacity for critical thinking to excel in fast-paced environments.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Oracle Database and Infrastructure Administrator
Pemex Procurement International
Houston, TX
03.2022 - 12.2024
Managed multiple databases across different environments like development, testing and production.
Provided 24x7 on-call support for critical incidents related to databases.
Worked closely with application developers to ensure proper design of applications and database structures.
Upgraded the databases from older versions to newer ones while ensuring minimal downtime.
Installed and configured Oracle Database software, components, and tools.
Designed high availability solutions for mission-critical databases using clustering technologies (RAC).
Created and maintained database objects such as tables, indexes, views, triggers, stored procedures.
Monitored database performance and tuned accordingly.
Created program backups and information recovery systems.
Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
Tested new database features before introducing them into production environment.
Developed and ran autonomous database backups.
Performed backup and recovery operations using RMAN utility.
Implemented data replication solutions like GoldenGate or DataGuard.
Scheduled jobs for maintenance activities like index rebuilding.
Developed and implemented security initiatives to protect important company data.
Provided technical assistance to users in resolving database related issues.
Deployed patches and upgrades on existing installations as per best practices guidelines.
Managed user accounts and support systems within complex Oracle database and cloud systems.
Created and altered database storage structures to meet user needs.
Configured Oracle Enterprise Manager for monitoring the health of databases on multiple nodes.
Managed databases including MS SQL Server and Oracle Database 12c Enterprise Edition.
Configured and maintained enterprise databases such as Oracle, SQL Server, and DB2.
Developed complex Oracle PL and SQL packages, procedures, functions and triggers to support application development.
Database Administrator
NETLINKS Ltd
08.2019 - 08.2021
Managed multiple databases across different environments like development, testing and production.
Provided 24x7 on-call support for critical incidents related to databases.
Worked closely with application developers to ensure proper design of applications and database structures.
Upgraded the databases from older versions to newer ones while ensuring minimal downtime.
Installed and configured Oracle Database software, components, and tools.
Designed high availability solutions for mission-critical databases using clustering technologies (RAC).
Created and maintained database objects such as tables, indexes, views, triggers, stored procedures.
Monitored database performance and tuned accordingly.
Created program backups and information recovery systems.
Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
Tested new database features before introducing them into production environment.
Developed and ran autonomous database backups.
Performed backup and recovery operations using RMAN utility.
Implemented data replication solutions like GoldenGate or DataGuard.
Scheduled jobs for maintenance activities like index rebuilding.
Developed and implemented security initiatives to protect important company data.
Provided technical assistance to users in resolving database related issues.
Deployed patches and upgrades on existing installations as per best practices guidelines.
Managed user accounts and support systems within complex Oracle database and cloud systems.
Created and altered database storage structures to meet user needs.
Configured Oracle Enterprise Manager for monitoring the health of databases on multiple nodes.
Managed databases including MS SQL Server and Oracle Database 12c Enterprise Edition.
Configured and maintained enterprise databases such as Oracle, SQL Server, and DB2.
Developed complex Oracle PL and SQL packages, procedures, functions and triggers to support application development.
Database Administrator
YRMPT
09.2018 - 07.2019
Monitored database performance and tuned accordingly.
Created program backups and information recovery systems.
Deployed patches and upgrades on existing installations as per best practices guidelines.
Managed user accounts and support systems within complex Oracle database and cloud systems.
Provided technical assistance to users in resolving database related issues.
Created and altered database storage structures to meet user needs.
Maintained working knowledge of programming languages and technical documentation.
Devised reports and visualizations to present requested data in sleek format.
Installed and configured Oracle Database software, components, and tools.
Education
Bachelor of Computer Science -
Reva University
Banglore ,India
08-2018
Skills
Database cloning
Database migration
Shell scripting
Patch management
Database troubleshooting
Oracle database administration
High availability solutions
Oracle exadata management
Data guard implementation
Performance tuning
Oracle cloud services
Storage management
Oracle RAC configuration
Disaster recovery planning
Database security management
Real application testing
Network configuration
GoldenGate implementation
Oracle enterprise manager
Oracle ASM management
Backup and recovery
Linux administration
PL and SQL development
Incident management
Certification
Oracle Certified Associate (OCA)
Azure Data Engineering
Az 900
Oracle Advance database administration
PowerBi reporting
Computer Programming Languages (Python, PHP,Java, C#.NET, ASP.NET)