Oracle Database Implementation Specialist

Senior Oracle DBA and Oracle Developer. Oracle Exadata Database Machine Certified Implementation Specialist, Oracle Autonomous Database Cloud 2021 Certified Specialist, Oracle GoldenGate 12c Certified Implementation Specialist, Oracle Database Administration 2019 Certified Professional OCP and Oracle Database 11g Administrator Certified Associate OCA with more than 10 years of experience as database administrator/developer for production and development environments. Extensive experience in maintenance, security, backup and recovery processes and protocols to protect and retain valuable company data. Proficient in Oracle 10g, 11g, 12c, 18c, 19c and 21c in financial and retail industries. Experience with other RDBMS systems like MySQL, PostgreSQL and SQL Server. Results-oriented engineer with problem-solving and critical thinking skills, as well as meticulous attention to detail and methodical nature. Skilled in tackling problems in unique ways to develop innovative solutions. I am only interested in contract positions on a c2c base.

Work History

2023-01 – To Date

Senior Oracle Database Administrator / Developer

HCL – Dollar General – Nashville TN

● Administration, configuration, and monitoring of Exadata X9M, X9M and X7 machine components, including Cell Server, Infiniband switch, RoCE switch, Cisco switch, PDU and KVM .

● Experience in troubleshooting network and I/O related issues in the Exadata environment.

● Configuring the monitoring cell server thresholds and troubleshooting the cell server, Infiniband, cisco switch and RAC interconnects issues.

● Hands-on experience managing, addition and deletion cell disks, grid disks, ASM disks and all storage features with cellcli commands.

● Optimizing and modifying production and critical databases, as well as diagnosing and determining the core cause of Oracle database on Exadata systems outages.

● Experience in configuring Database Backup and Recovery using RMAN and recovery for databases in TBs.

● Practical knowledge to Data Guard setup, switchover, failover and gap resolution between datacenters in separate cities.

● Experience configuring and building Golden Gate Extracts/replicate for multiple databases.

● Practical experience adjusting Golden Gate to handle restarts, latency, logging, production support, and status reporting.

● Configuring and maintaining OEM grid control, monitoring alerts in a production setting, and taking proactive measures based on business criticality are all included.

● Design testing approaches, complex processes, reporting streams, and assist with the automation of repetitive tasks.

● Performance and capacity review of Production DB environments.

● Migration of on-premise databases to cloud computing, such as AWS and Oracle Cloud Infrastructure (OCI), with methods such as Data Pump, transportable tablespaces, RMAN, duplications from active databases, unplugging, and plugging in PDB databases.

● Use of autonomous data guard technologies, configure disaster recovery databases on Oracle Cloud Infrastructure (OCI) from an on-premise datacenter, adhering to the business company's Recovery Time Objective (RTO) and Recovery Point Objective (RPO) specifications.

● Design and development of PL/SQL procedures to flag suspicious transactions, such as unusually large orders or frequent returns, for manual review.

● Design and development of PL/SQL procedures to integrate with external payment gateways, ensuring secure and seamless transaction processing.

● Development of PL/SQL data extraction scripts for integration with BI tools and reporting dashboards.

● Planned and executed migrations from older SQL Server versions (2008 R2) to 2012, 2014, or 2016.

● Configured high-availability solutions such as Always On Availability Groups and Failover Clusters.

● Managed backups and restoration using SQL Server Management Studio (SSMS) and automated maintenance plans.

● Designed and implemented high availability architectures using Real Application Clusters (RAC) and Active Data Guard on ExaCC to provide continuous database uptime and fault tolerance.

● Migration of large-scale databases to ExaCC with minimal downtime using Oracle Data Pump, Recovery Manager and GoldenGate.

● Plan and execut patching activities for ExaCC environments, including quarterly patch updates for database, grid infrastructure and Exadata storage servers ensuring system stability and compliance.

● Monitored performance using tools like SQL Profiler, Extended Events, and Dynamic Management Views (DMVs).

2022-03 – 2022-10

Senior Oracle Database Administrator

ScotiaGBS S.A.S

Configure, test and support Oracle databases in versions 9i to 19c and additional Oracle technologies as Data Guard, GoldenGate, RAC, Oracle Enterprise Manager, Oracle Autonomous Database, Advance Security, Tuning Pack, Multitenant, Exadata for Scotia Bank in Canada and the US.

●Proactively monitoring the database's health and taking preventive or corrective action as required.

●Ensure DB 7/24 availability global and local Oracle databases.

●Contribute to the creation and maintenance of disaster recovery plans.

●Analyzes and determines database memory requirements, processing power, storage, network connections, and performance optimization.

●Troubleshoot the problems. It includes a quick understanding of the problem and its resolution, restoration of the data, rectify the issue and minimize the damage.

●Developed, updated and organized Oracle databases to handle customer and financial data.

●Continuous review and evaluation of the software, hardware, service delivery, and updates as and when required.

●Actively attends and participates in the professional group meetings. Thus, acquire knowledge of the new and upcoming trends and innovations in the IT field.

●Maintains a data standard and security measures through the implementation of information technology plans, policies, and standards.

●Installing and configuring Oracle GoldenGate oriented to micro services on web console administration.

●Analyze PL/SQL code from developers to provide guidelines in terms of SQL and PL/SQL looking for performance and quality.

●Creation of SQL and PL/SQL scripts to automatize database routine and maintenance tasks.

●Write, test, and improve SQL statements for complex queries being aware of business information requirements.

●Management, monitoring and refreshing Oracle Autonomous Databases on Oracle Cloud Infrastructure.

2017-07 – 2022-02

Senior Oracle Database Administrator

Scotiabank Colpatria

Management of Oracle databases for Scotia Bank Colpatria, installing, supporting, testing and replicating Oracle databases versions 10g to 19c some of them in supercluster machines. Additionally, setting up technologies as Data Guard, GoldenGate, RAC, Oracle Enterprise Manager, Multitenant, Oracle Autonomous Database, Advance Security and Tuning Pack.

●Installed, upgraded, configured and tuned, Oracle databases 10g,11g, 12c, 18c and 19c, SQL Server on systems associated UNIX and Windows environments.

●Leads database upgrade and capacity planning; administers development, staging, testing, and production database environments; and executes plan.

●Analyzes and determines database memory requirements, processing power, storage, network connections, and performance optimization

●Developed, updated and organized Oracle databases to handle customer and financial data.

●Maintained equipment and facilities in optimal condition to support optimal launch and recovery operations.

●Maintained flexible schedule, responded to after-hours, and weekend emergencies.

●Provides support to users and developers.

●Conducts database performance tuning, query optimization, index tuning, tables restructuring, and storage optimization.

●Supports disaster recovery efforts at remote sites.

●Evaluates and implements new technology stack releases and patches for databases.

●Performs upgrades and cloning of application databases.

●Performs data replication as needed.

●Provides guidance to junior staff members.

●Hands-on experience setting up Oracle Golden Gate versions 12c and 19c implementing projects like table’s logical replication and migration projects for bank core databases between super cluster systems and Linux cluster systems.

●Replication with Golden Gate on one way and bidirectional with data replication conflict detection.

●Experience administrating Oracle databases for ongoing Siebel CRM applications.

●Patching and upgrading software and firmware of the database server’s supercluster and Exadata database machine.

●Provide and implement performance tuning recommendations for databases with special resources on Exadata systems.

●Check and advise improvement on PL/SQL code and coach developers giving feedback for optimization in run time and resources based on the knowledge of how an Oracle database processes any kind of statements.

●Develop PL/SQL code to automatize repetitive tasks on the database and collect specific scheduled metrics for special reports.

●Write, test, and improve SQL statements for complex queries being aware of business information requirements.

●Creation, configuration, monitoring and backing up of Oracle and Aurora RDS on AWS and Oracle on Amazon EC2, also experience with NoSQL DynamoDB.

●Migration from on premise databases to Cloud computing such as AWS and Oracle Cloud infrastructure with methods Data Pump, transportable tablespaces, RMAN, duplications from active databases, unplug and plug in pluggable databases, and more.

●Install, monitor and maintain PostgreSQL software database engine, implement monitoring and alerting with versions PostgreSQL 9.6,10,11,12.

●Experience in upgrading, patching, and migration databases between PostgreSQL and Oracle database systems.

●Installation, configuration and management of MySQL versions 5.7 and 8.0.

●Optimization of SQL queries in MySQL 5.7 and 8.0.

●Management and maintenance of MySQL versions 5.7 and 8.0 keeping control of new releases, performance, security and availability of database.

2015-01 - 2017-07

Oracle Database Administrator

Banco AvVillas

Provide 24/7 support to Oracle, MS SQL Server and Netezza databases for AV Villas bank in production and non-production environments, and other Oracle solutions as RAC, Advance Security and Tuning Pack. Also management of Weblogic and WAS application servers supporting PeopleSoft.

●Installs, configures, and maintains enterprise database environments.

●Conducts research and make recommendations on database products, services, and standards in support of procurement and development efforts.

●Performance review and database tuning.

●Plans and coordinates data migrations between systems.

●Establishes appropriate end-user database access control levels

●Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.

●Created and implemented database designs and data models.

●Planned and implemented security measures to safeguard vital business data.

●Encrypted sensitive information within the database and implemented Encryption keys on relational database management systems by using Oracle transparent data encryption (TDE).

●Use TDE either in individual data columns or entire tablespaces. Controlling access to database exports or recovery manager backups.

●Ciphering (encrypt) data on tables and reducing the data exposed to unauthorized users who are not available to read data in specific columns with Oracle Data Redaction feature.

●Deployment of applications on AWS.

●Management of Non SQL database like Dynamo on AWS.

●Set up of AWS services like S3, Cognito and API gateway.

●Migration of on-premise Oracle database to the Oracle Cloud.

2012-06 - 2015-01

Software Developer

Imagine Technologies

●Developed shared central authentication system in PHP and JAVA languages for intranet applications.

●Development of SQL DML and DDL to access the database and update, delete and insert information.

●Evaluated project requirements and specifications and developed software applications that surpassed client expectations.

●Walked clients and internal staff through troubleshooting steps to resolve common software issues.

●Built, tested and deployed scalable, highly available and modular software products.

●Translated technical concepts and information into terms all parties could easily comprehend.

●Consulted with engineering team members to determine system loads and develop improvement plans.

●Collaborated on all stages of systems development lifecycle, from requirements gathering to production releases.

Education

2008-01 - 2014-11

Bachelor of Science with a Major in Systems Engineering

Universidad Minuto De Dios - Bogotá DC - Colombia

2015-01 - 2015-12

Associate of Applied Science: Database Management

Fundación De Egresados De La Universidad Distrital - Bogotá DC - Colombia

2016-06 - 2016-10

Associate of Applied Science: Administering Microsoft SQL Server 2014

Intelligent Training Bogota DC - Colombiatá

Oracle Certifications

2023-05

2022-10

2022-02

2021-12

2018-07

2024-11

Oracle Exadata Database Machine X9M Certified Implementation Specialist

Oracle GoldenGate 12c Certified Implementation Specialist

Oracle Autonomous Database Cloud 2021 Certified Specialist

Oracle Database Administration 2019 Certified Professional

Oracle Database Associate 11g Administrator Certified Associate

Introduction to Programming with Python

Professional References

2024-11

2022-10

2022-02

Abdel Delgado - Lead DBA – HCL

*****.*@*******.*** - +1 (321) 616 - 9265

Gang Liu - DBA Manager – Scotiabank - ****.***@**********.*** - +1-647-***-****

Alejandro Cespedes - Country Manager delivery - Scotiabank Colpatria - *********.********@*******************.*** - +57-313-*******

William Quitian

Senior Oracle DBA / Oracle Developer

Contact

******@*****.***

Skills

Oracle database administrator 12c and 19c

Excellent – 10 yrs – 5 yrs

Oracle database administrator 18c and 21c

Very Good – 5 yrs – 2 yrs

Oracle database administrator 10g and 11g

Very Good – 10 yrs – 10 yrs

Tuning and performance database

Excellent – 10 yrs

Oracle RMAN

Excellent – 10 yrs

Oracle Data Guard

Very Good – 8 yrs

Oracle GoldenGate

Good – 5 yrs

Oracle Cloud Control

Excellent – 6 yrs

Oracle RAC

Very Good – 10 yrs

SQL – PL/SQL

Good – 8yrs

Unix and Linux OS

Average – 12 yrs

Toad for Oracle

Very Good – 10 yrs

Contact this candidate