Database Administrator - Oracle DBA

Location:

Posted:

February 14, 2018

Resume:

PROFESSIONAL SUMMARY

Senior Database Administrator with more than 10 years of experience as DBA with several RDBMS engines like Oracle (10 years), PostgreSQL (7 years), SQL Server (5 years) and MySQL (5 years). Oracle 11g/12c Certified Professional DBA OCP, Oracle 11g Certified Master DBA OCM, Oracle 11g RAC Administrator Certified Expert OCE and Oracle 11g Managing Oracle on Linux Certified Expert OCE with extensive experience in Real Application Cluster (RAC) and standalone development, test and production environments under Unix and Linux.

Extensive experience in Installation and configuration of Oracle Databases, Patching and Upgrading to New Releases, RAC configuration and administration, Migration, Exporting and Importing Data and Metadata (Oracle Data Pump), Backup and Recovery (RMAN), Performance Tuning, Table Partitioning, Maintenance Tasks and Support to Incidents. Experience installing, configuring, implementing and managing Oracle GoldenGate 12c on UNIX and Linux and also troubleshooting on different issues related with EXTRACT, REPLICAT, DATA PUMP and TRAIL processes. Proven experience in Financial, Government and Telecom industries. Team worker, autonomous, organized, proactive and dynamic professional with abilities to establish priorities of tasks and to delegate in an effective way.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Transact SQL, HTML, PHP and JavaScript.

Databases: Oracle RDBMS 8i/9i/10g/11g/12c, DB2, SQL*Server 2008/2012/2014, PostgreSQL 9 and MySQL 4/5.

Database Utilities: Export and Import utilities, Backup and Recovery (RMAN), Real Application cluster (RAC), Oracle Data Guard, Oracle Enterprise Manager 9i/10g/11g, Oracle Enterprise Express 12c and 13c, Automatic Storage Management (ASM), Audit Vault, Oracle Optimizer and Oracle Grid Cloud Control 10g and 11g, Oracle Grid Cloud Control 12c and 13c, SQL*Loader, Oracle Statspack, Oracle Application Server 10g and ADDM, Oracle Virtual Machine OVM 3.1 and 3.2, Oracle Solaris Super Cluster, AWR and ASH, PGAdmin, MySQL Workbench and MySQL Admin.

O/S: UNIX- LINUX: Solaris, AIX, HP-UX, Oracle Linux 5, 6 and 7, Mac OS X, Ubuntu, Fedora, Suse, Centos, Red Hat, Windows 7, 8 and 10 and Windows Server 2003, 2008 and 2012.

PROFESSIONAL EXPERIENCE

Asesoftware - May 2016 – Dec 2017

Senior Oracle DBA – Bogota, Colombia

End-Client: Davivienda Bank, BBVA Bank and TransUnion (Financial)

Responsibilities:

Management and experience with complex infrastructure and large database environments.

Installation, configuration, upgrades/rollback, maintenance, backup, restore, monitoring and performance tuning experience with Oracle RDBMS versions 10g, 11g and 12c, MySQL 5.4, 5.5, 5.6 and 5.7 and PostgreSQL 9, and tools including: SQL Developer, TOAD, ASM, Tuning Pack, Cloud Control 13c, Oracle Grid, Database Cluster RAC 11g and 12c, GoldenGate 12c, PGAdmin, MySQL Workbench and MySQL Admin.

Creation, maintenance and management of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures for Development, Testing and Production’s environments.

Impact analysis of any changes made to the database objects or structure and database’s capacity planning..

Monitor and support for local and remote Oracle databases.

Configuration of thresholds, metrics and alarms for tablespaces, disks and memory.

Management and administration of Filesystem, Logs and traces.

Troubleshooting issues related with Oracle databases, applications and development tools, and support for incidents, services required and troubleshooting for different fails of security.

Creation, configuration and management of profiles and templates to control access to the databases and its objects; and creation and administration of users, roles, privileges and profiles to control access permissions and privileges of users and/or applications.

Verification and implementation of executions plans on Oracle databases 11g and 12c; and tuning queries, DML statements, data loads, extractions and servers in production environments.

Creation and configuration of RMAN shell scripts to recover datafiles, tablespaces, pfile and control files and implementation of back up policies to tape for production, and test environments.

Installation and management of Grid Infrastructure and Automatic Storage Management (ASM) 10g, 11g and 12c, troubleshooting on different issues on datafile, tablespaces, and password file drop and add disks to diskgroups, rebalancing and lost disks.

User, objects local and remote applications on cloud security administration through Active Directory/LDAP and Identity Manager on multiples Oracle databases 11g and 12c and servers as windows UNIX and Linux

Solve data corruption issues on datafiles, tablespaces and database blocks.

Management of cluster services, HAS, CRS, ASM and SCAN.

Design, implementation and management of Oracle Data warehouse for financial institutions.

Experience with MySQL 5.7 components including MyISAM, InnoDB storage, Management Server, NDB and cluster Infrastructure.

Use of Data Guard to synchronize standby databases, Data Guard broker administration and flash back recovery.

Configuration, administration and support of Oracle GoldenGate 12c replication for financial production environment using REPLICAT, EXTRACT, Data Pump and Manager Processes.

Extensive experience with Oracle Exadata 12c (Half Rack and Full Rack) using OEDA, Smart Scan (cell offload), Flash Cache, Exadata Hybrid Columnar Compression (EHCC), IO Resource Manager, storage Index, LIBCELL, cellcli, dcli, infinibant network and ILOM.

Resolve issues for lost archives or gaps on standby.

Cloning of databases for storage or transportable tablespaces.

Use of Data Pump, Export and Import (Oracle) and mysqldump and mysqlimport (MySQL) to export/import data and rebuild indexes after migrations.

Installation, administration and maintenance of production databases SQL Server 2008 R2, 2012 and 2014 on VMWare 10 and Azure.

Security management creating users and granting access according to application roles and creation of Linked Servers to SQL Servers and other databases such as Oracle, MySQL, PostgreSQL, etc.

Configuration of SQL Server Cluster and failover on SQL Server 2012.

Design and implementation of back up and restore strategies for time to time recovery.

Setup of High-Availability as part of the disaster recovery strategy for the databases considering Failover Clustering, Database Mirroring, Log Shipping and Replication.

Day by day troubleshooting solving several issues and monitoring SQL Server Error Logs and checking alerts.

Documenting major changes to SQL Servers, apply Service Packs and database capacity planning.

Extensive experience in migrations using techniques like duplicate, cloning (storage), transportables tablespaces, Data Guard rolling upgrade, Golden Gate export/import and DATAPUMP, RMAN scripts, DBUA and CATUPGRD.sql. and in several scenarios including: Oracle RDBMS 10.2.0.5 to 11.2.0.4 from Solaris v.10 to Solaris v.11, Oracle RDBMS 11.2.0.4 to 12.2.0.1 from Solaris v.10 to Solaris v.11, Oracle RDBMS 10.2.0.5 to 11.2.0.4 from AIX v.6 to AIX v.7.1 and Oracle RDBMS 11.2.0.4 to PostgreSQL v.9 from Oracle Linux v.6 to Centos v.6.

Provide technical support to application development teams.

Tools/Environment: Oracle RDBMS versions 10g, 11g and 12c, MySQL 5.4, 5.5, 5.6 and 5.7, DB2 version 9.7, Linux Red Hat versions 5, 6 and 7, Oracle Linux Version 6 and 7, Solaris versions 10 and 11, AIX versions 6 and 7, Data Guard 11g and 12c, Data Guard Broker, ASM Automatics Storage Management 10g, 11g and 12c, SQL Developer, TOAD, Tuning Pack, Cloud Control 13, Grid Infrastructure and Cluster RAC 10g, 11g and 12c, PGAdmin, Exadata 12c, MySQL Workbench, MySQL Admin, SQL Server Management Studio, SQL Server 2008 R2 / 2012 / 2014, VMWare and Azure.

Data Tools - Dec 2015 – May 2016

Senior Oracle DBA – Bogota, Colombia

End-Client: SIM, Migration Colombia (Government)

Responsibilities:

Installation, configuration and upgrades (patches apply and rollback) experience with Oracle RDBMS versions 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4, 12.1.0 and 12.2.0 and tools including: TOAD, ASM, Cloud Control 12, Oracle Grid, Database Cluster RAC 11g and 12c, PGAdmin.

Creation and administration of users, roles, privileges and profiles to control access permissions and privileges of users and/or applications.

Configuration and implementation of AUDIT security on oracle databases for each transaction.

Use of RMAN scripts for backup, restore and recovery and export/import to move data between 10g, 11g and 12c in production, test and development environment.

Installation and configuration of Oracle RAC 11g and 12c.

Addition of new nodes on 2 clusters 11g and 12c.

Database migration from 10 to 11g and 12c using cloning for storage, tablespaces transportable and duplicate database using RMAN.

Use of Cloud Control to monitor and support several components including: Grid Infrastructure, RDBMS, ASM, Listener, SCAN, RAC, queries, tablespaces and datafiles.

Generation and maintenance of database documentation and reports on good practices and status of all databases environments.

Configuration single and RAC databases in archivelog mode

7x24 Support and troubleshooting.

Installation and configuration of Oracle Data Guard 11.2.0.4 and Data Broker on Oracle Linux 7.

Tuning of DML’s statements on Oracle RDBMS 10g, 11g and 12c.

Installation, configuration, backup and recovery and application of Service Packs, HotFixes and upgrades of SQL Server 2008 R2 and 2012 using Upgrade Advisor.

Monitoring of error logs for failed logins and notification to the audit team when necessary.

Troubleshooting of SQL Server day by day issues related with disk, I/O, CPU and memory.

Monitoring log shipping and mirroring using customized store procedures.

Replication of databases using GoldenGate between Oracle, SQL Server and MySQL.

Extensive experience in migrations using techniques like duplicate, cloning (storage), transportables tablespaces, Data Guard rolling upgrade, Golden Gate export/import and DATAPUMP, RMAN scripts, DBUA and CATUPGRD.sql. and in several scenarios including: Oracle RDBMS 11.2.0.4 to PostgreSQL v.9 from Oracle Linux v.6 to Centos v.6, PostgreSQL v.9 to Oracle RDBMS 11.2.0.4 from Windows 2008 to Oracle Linux v6.

Tools/Environment: Oracle RDBMS 10g, 11g and 12c, Oracle RAC 10g, 11g and 12c, Oracle Linux 6 and 7, Solaris 10 and 11, Oracle Data Guard physical 11g and 12c, Data Guard Broker, Oracle ASM 10g, 11g and 12c, TOAD, Cloud Control 12, Exadata 12c, Grid Infrastructure, PGAdmin, SQL Server 2008 R2 and 2012.

Colvatel - Apr 2015 - Dec 2015

Senior Oracle DBA – Bogota, Colombia

End-Client: Minminas (Government)

Responsibilities:

Installation, configuration, upgrade/rollback, maintenance, backup and restore, monitoring and performance database tuning experience of Oracle RDBMS versions 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4, 12.1.0 and 12.2.0 and tools including: TOAD, ASM, Cloud Control 12, Oracle Grid, Database Cluster RAC 11g and 12c, MySQL Workbench and MySQL Admin.

Archive log mode’s configuration.

Implementation of backup (hot/cold), restore and recovery policies using RMAN, export/import and Data Pump.

Configuration and implementation of standby and test databases.

Implementation of database security and audit features.

Table space management, database analysis report, database purging and data corruption troubleshooting.

Configuration and management of database access to Oracle and non-Oracle applications accesing the databases.

Database health monitoring and Log monitoring in scheduled manner.

Administration Oracle GoldenGate 12c for telecom industries.

GoldenGate configuration and upgrades.

Application different security patches PSU November on GI 10G, GI 11G and oracle database 11.2.0.3, 11.2.0.4.

Installation, configuration and administration SQL Server 2008 R2 and 2012 and Reporting Services on Windows 2008.

Maintenance and support of regarding logs, users, tables, packages and functions.

Review and monitor system and instance resources to ensure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention).

Implement, maintain, and test backup and recovery strategies and performance tuning on tables, indexes, tables and procedures on SQL Server 2008 R2 and 2012.

Extensive experience in migrations using techniques like duplicate, cloning (storage), transportables tablespaces, Data Guard rolling upgrade, Golden Gate export/import and DATAPUMP, RMAN scripts, DBUA and CATUPGRD.sql. and in several scenarios including: Oracle RDBMS 11.2.0.4 to PostgreSQL v.9 from Oracle Linux v.6 to Centos v.6, Oracle RDBMS 11.2.0.4 to 12.2.0.1 from Solaris v.10 to v.11, Oracle RDBMS 10.2.0.5 to 11.2.0.4 from Windows 2012 to Oracle Linux v.6.

Tools/Environment: Centos 6 and 7, Suse Server 12, Oracle Linux 6 and 7, Red Hat 5 and 6, Windows Server 2008 and 2012, Solaris 10 and 11, Oracle RDBMS 10.2.0.4(2 databases), 10.2.0.5(3 databases), 11.2.0.2(4 databases), 11.2.0.3(4 databases), 11.2.0.4 (5 databases), GI 11.2.0.3 and 11.2.0.4, Cluster 11.2.0.3 (2 RAC), Cluster 11.2.0.4 (3 RAC), Veritas 6, Virtualization OVM 3.1 and VMWARE 10, MySQL Workbench, MySQL Admin, SQL Server 2008 R2 and 2012

Getronics - Aug 2014 - Mar 2015

Senior Oracle DBA – Bogota, Colombia

End-Client: ETB (Telecom)

Responsibilities:

Installation, configuration and upgrades (patches apply and rollback) experience with Oracle RDBMS versions 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4 and 12.1.0 and MySQL 5.4 and 5.5 using tools like: TOAD, ASM, Cloud Control 12.1.0.5, Oracle Grid Infrastructure 11.2.0.4 and 12.1, Database Cluster RAC 11.2.0.3, and 11.2.0.4 and 12.1.0 and SuperCluster 12c with 30 nodes on Solaris 10 and 11, PGAdmin, MySQL Workbench and MySQL Admin.

Solved issues data corruption in datafiles, controlfile, tablespaces, on databases 10.2.0.5, 11.2.0.4 and 12.1.0

Configuring the Database in Archive log mode and take backups incremental, full backup and hot backup for different database 10g, 11g, 12c in the following environments TEST, DEVELOPMENT, PRODUCTION using RMAN script and export/import data pump.

Restore and recover tablespaces, datafiles, large databases on different test, develop and production environments and after different disaster scenarios.

Take Export/Import Data structure, remap tablespaces, data ONLY, table exist action, and remap schema.

Monitoring threshold, targets, alarms on GI, ASM, LISTENER, CLUSTER SERVICES, CRS, DATABASES, and processes related with CLIENTS applications, temporary segments usage, checking for DB links that are inaccessible and finding invalid objects and fixing them

Installation, configuration and admon cloud control 12.1.0.5, Solved incidents, petitions and user requirements using service manager(HP) tool.

Admon storage, datafile, blocks, extends and Database health monitoring and Log monitoring in scheduled manner, Quarterly Database log purging activity

Application different security patches PSU on GI 10G, GI 11G, 12c and oracle database 11.2.0.3, 11.2.0.4.

Administration Oracle GoldenGate 11g and 12C under Oracle Exadata.

Upgrading and migration data using Oracle GoldenGate on databases.

Admon and troubleshooting database cluster on virtualization OVM 3.1 and VMWARE 10

Verify all instances are up & working and look into new alert log entries and checking for any errors, Check table space usage and checking if there is enough disk space for the data files to grow

Checking session locks and monitoring overall Database health & performance

Identifying tables with chained rows & rectifying them and monitoring users and transactions.

Escalating issues and providing feedback and suggestions

Identify and solve different DBA issues including data fragmentation, blocked transactions, user’s access, tablespaces’ use and objects and constraints.

Look for security policy violations and look in SQL *Net logs for errors, validate archive all alert logs and revision of trace files.

Check redo log optimal size based on transactional activities and analyze tables and indexes for better performance, identifying non-system tables with no primary key and identifying non-system tables with excessive indexes causing performance issues.

Check invalid/unusable indexes and index usage and prepare comprehensive monthly review and reports.

Create project specific objects in test and production environments according to user-creation and security policies.

Identify and optimize queries causing bottlenecks.

Job scheduling and monitoring.

Administration of Oracle Data Guard 11g on Oracle Linux 6.

Extensive experience in migrations using techniques like duplicate, cloning (storage), transportables tablespaces, Data Guard rolling upgrade, Golden Gate export/import and DATAPUMP, RMAN scripts, DBUA and CATUPGRD.sql. and in several scenarios including: Oracle RDBMS 10.2.0.5 to 11.2.0.4 from Windows 2012 to Oracle Linux v.6, Oracle RDBMS 11.2.0.4 to 12.2.0.1 from Solaris v.10 to v.11, Oracle RDBMS 11.2.0.4 to PostgreSQL v.9 from Windows 2008 to Centos v.6, Oracle RDBMS 10.2.0.5 to 11.2.0.4 from AIX v.6 to v.7.

Tools/Environment: Oracle RDBMS 10.2.0.3, 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4 and 12.1.0, Oracle Grid Infrastructure 11.2.0.3, 11.2.0.4 and 12.1, Oracle RAC 11.2.0.3, 11.2.0.4 and 12.1, MySQL 5.4 and 5.5, Oracle Virtualization OVM 3.1, AIX 6.1. and 7.1, Red Hat 5, 6 and 7, Oracle Linux 6 and 7, Windows Server 2008 and 2012, Solaris 10 and 11, Networker 8.1, VMWARE 9, PGAdmin, MySQL Workbench and MySQL Admin.

Imcolmedica - Sep 2012 – Aug 2014

Oracle DBA – Bogota, Colombia

Responsibilities:

Management of storage, datafiles, data blocks, extends and Database health monitoring and Log monitoring in scheduled manner, Quarterly Database log purging activity.

Application of different security PSU, CPU and SPU patches on Grid Infrastructure Oracle 10g, 11g and Oracle RDBMS 11.2.0.2, 11.2.0.3 and 11.2.0.4 and MySQL 5.4, 5.5 using PGAdmin, MySQL Workbench and MySQL Admin.

Collection of statistics for tables, index, on all databases 10g and 11g.

Maintaining all databases required for development, testing, training and production usage.

Maximizing uptime of databases, share resources used amongst applications.

Administrates all database objects, including tables, views, indexes, stored procedures, functions, packages, sequences and clusters.

Enforces and maintains database constraints to ensure integrity of the database.

Installation and configuration of DBMS server software and related products.

Upgrading and patching/hot-fixing of DBMS server software and related products.

Assists with impact analysis of any changes made to the database objects.

Migrate database to another server between 10g to 11g.

Evaluate DBMS features and DBMS related products.

Ensure that the site is running the most appropriate products and ensure that any new product usage or release upgrade takes place with minimal impact.

Establish and maintain sound backup and recovery policies and procedures.

Database design and implementation.

Implementing HA Solution (Replication, Clustering, Mirroring and Log Shipping).

Implement and maintain database security (create and maintain logins, users and roles, assign privileges).

Performance tuning and health monitoring on DBMS, OS and application.

Setting Up Server Level, Database Level and Operating System Alerts.

Implementation of robust maintenance plan including tasks like Index Defragmentation, Statistics Update, DBCC, among others.

Setup and maintain documentation and standards.

Perform reviews on the design and code frequently to ensure the standards are being adhered to Plan growth and changes (capacity planning).

Troubleshooting on DBMS and Operating System performance issues.

Troubleshooting and give consultation to applications development teams.

Documentation of any implementation and changes (database changes, reference data changes and application UI changes etc).

Provide a strategic database direction for the organization.

Management of ASM, Tablespaces, Datafiles, OEM, Cluster 10g and 11g.

Installation, configuration and management of data guard physical 11.2.0.3, Cluster 2 Nodes primary and single standby synchronic.

Resolve issues for archives lost or gaps on standby, configuration and management of data guard broker.

Use of different technical features as flash recovery area for flash back and rebuild data guard in case of disaster.

Desing, configuration and administration of SQL Server 2008 R2 and Reporting Services and back up ad restore of SQL Server databases using SQL Management Studio.

Support to development teams tuning application queries.

Monitoring and performance tuning of physical server level and database level and use of Profiler to solve locks related issues and tune transactions.

Tools/Environment: Red Hat 5 and 6, AIX 6, Centos 6, Solaris 10, Windows 2003 and 2008, Cluster 10.2.0.5(3), Cluster 11g(5), ASM 10g, ASM 11g, GI 11g, RDBMS 10.2.0.5 and 11.2.0.2, Data Guard physical 2 nodes primary and single standby 11.2.0.2, OEM 11g and Grid Control 11g, PGAdmin, MySQL Workbench, MySQL Admin 4 and 5, SQL Developer, SQL Server 2008 R2 and SQL Management Studio.

Bolsa de Valores de Colombia - Aug 2011 – Aug 2012

Oracle DBA – Bogota, Colombia

Responsibilities:

Scheduling jobs and monitoring its execution.

Database design discussion, feedback and reviews.

Upgrading and patching/hot-fixing of RDBMS server software and related products.

Build, monitor and continuously develop a high performance database infrastructure.

Implement and continuously refine operational processes to ensure a stable, robust and highly efficient environment.

Check of redo logs optimal size based on transactional activities and analyze tables and indexes for better performance, identifying non-system tables with no primary key and identifying non-system tables with excessive indexes causing performance issues.

Database objects management (tables, indexes, views, etc.) in test and production environments.

Security management (create and maintain users and roles, assign privileges).

Query optimization.

Configuration of different politicies using audit on large financial 10g and 11g databases.

Installation, configuration and support of Cluster RAC 11.2.0.3, SCAN, ASM, IP PUBLICS, IP PRIVATES, IP VIRTUALS, Oracle listener, tnsnames file, sessions, locks, Index, CRS and LISTENER_SCAN.

Purge and maintenance logs, alerts, binaries ORACLE_HOME, GRID_HOME, filesystem on Unix and Linux S.O.

Implemetation of cold backups and hot backups for production and development environments.

Restore and recover different backups on production and test environment in case of disaster.

Monitoring targets ASM, CRS, Oracle listener, filesystem, ALARMS, TRESHOLDS, NETWORKING using grid control 11.

Migration data between different UNIX servers and Oracle RDBMS 10g and 11g.

Support of data warehouse, tables, index, partitionings for banking application.

Administration and solved Data Guard issues 11.2.0.3, solve gaps, redos, archives, corruptions datafiles.

Generation and use of statistics AWR, ASH, ADDM and reports snapshop in general Oracle RDBMS 11g.

Recommend and implement different tasks to improve the efficiency and effectiveness of the organization's change management and configuration management processes and systems.

Experience cloning Oracle RDBMS 10.2.0.5 and 11.2.0.3 on test environment.

Delete RAC node 11.2.0.3 on production envinronment.

Tools/Environment: Red Hat 5 and 6, AIX 6.1, Windows Server 2003 and 2008, Centos 6, HP-UX 11, VMWARE 9, GI 10G AND 11G, Oracle RDBMS 10.2.0.5(10) and 11.2.0.3(50), CLUSTER 11.2.0.3(5).

Dumian Medical SAS - Jun 2009 – Jul 2011

Oracle DBA – Cucuta, Colombia

Responsibilities:

Installation, configuration, upgrades and support for Oracle RDBMS 10g / 11g Grid Infrastructure 11g, 12c, single and cluster and MySQL 5.4 for test, development and production environments.

Installation and configuration of Cluster 11.2.0, ASM, Listener, tnsnames, port, scan for 2 nodes and addition of new node for cluster 11g.

Monitoring targets, thresholds, alarms, networking, ASM, disk, filesystem, logs, Redos.

Database design, creation, implementation and maintenance of all database objects including views, tables, index, procedures, functions, packages.

Use RMAN shell scripts for back up/restore/recovery automation using for crontab on Unix and Linux.

Maintainance of archived data on tape.

Generation of statistics on tables, index and large databases.

Verification of AWR, ASH, ADDM.

Use of audit feature on Oracle 11g, for sessions, user, DML, DDL and different transactions from clients.

Approve and troubleshooting for all production schema changes.

Allocating system storage and planning future storage requirements for the database system.

Modifying the database structure, as necessary according to all needs from the development team.

Administration of all connections and access to all database’s objects for all users/schemas/clients/applications.

Data migration between differents Oracle RDBMS versions including 10g and 11g.

Implementation good practices for performance on Oracle RDBMS 10g and 11g.

Create reports about database documentation, including data standards, procedures and definitions for the data dictionary (metadata).

Performance of the capacity planning required to create and maintain the databases.

Administration and monitoring replication Oracle Data Guard 11.2, including data guard broker, archives, redos and online logs.

Configure archive log mode on databases production environment and stablish politics of synchronization.

Tools/Environment: Red Hat 4, 5 and 6, Windows 2003 and 2008, Centos 5, Ubuntu Server 9, Suse Server 9, oracle RDBMS 10.2.0.4(4), 11.2.0(10), GI 11.2.0 and cluster RAC 11.2.0 (3), MySQL Admin 4 and 5 and SQLDeveloper.

Droguifarma - May 2005 – May 2009

Oracle DBA - Cucuta, Colombia

Responsibilities:

Installation, configuration and administration of Oracle RDBMS 10.2.0 including maintenance of all database objects including indexes, tables, views, triggers, procedures, packages, functions and sequences.

Application of patches, rollbacks, upgrades and migrations on several production, test and development environments.

Monitoring of Oracle background processes, grid infrastructure 10g, tablespaces, datafiles, memory structures (SGA, PGA) and listener using Oracle Enterprise Management 10.

Trobleshooting performance, security, access and datafiles corruption issues, tuning SQL statements and capacity planning for production environments.

Use of RMAN scripts for database backup, restore and recovery.

Analisys of alert logs, trace files and data usage on tablespaces (water mark) and maintenance of filesystems.

Tools/Environment: Red Hat Linux 4, Windows 2003, Centos 4 and Oracle RDBMS 10.2.0.

EDUCATION/CERTIFICATIONS

Oracle Database 12c Administrator Certified Professional OCP 2014.

Oracle Database 11g Administrator Certified Associate OCA 2013.

Oracle Database 11g Administrator Certified Professional OCP 2013.

Oracle Database 11g Certified Master OCM 2013.

Oracle Database 11g Managing Oracle on Linux Certified Expert OCE 2013.

Oracle Database 11g Real Application Cluster RAC Administrator OCE 2013.

Bachelor Degree in Computer Science. 2007

NAME:Nelson Puentes

DATE: 1/15/2018

POSITION: Senior Oracle DBA

SKILLS INVENTORY

Years of Experience

Last Year Used

Self Rating

Oracle RDBMS 8i

2005

Oracle RDBMS 9i

2006

Oracle RDBMS 10g

2017

4.5

Oracle RDBMS 11g

2017

4.5

Oracle RDBMS 12c

2017

Oracle Application Server

2013

Enterprise Oracle Grid

2017

4.5

Oracle Real Application Clusters (RAC)

2017

4.5

Oracle Clustering

2017

4.5

ASM

2017

4.5

MySQL 4/5

2016

PostgreSQL 9

2016

Oracle Data Guard

2017

Unix Shell Scripting

2017

Linux Shell Scripting

2017

Unix

2017

Linux

2017

Oracle GoldenGate

2015

Oracle Database Performance

2017

AWR

2017

ASH

2017

SQL

2017

PL/SQL

2014

SQL Loader

2013

Oracle Designer

2013

Oracle Developer Suite: Forms 11g / Reports 11g

2012

ODBC Drivers

2011

Self Rating Criteria: 1. No Experience. 2. Limited Exposure. 3. Working Knowledge. 4. Skiled. 5. Expert.

Contact this candidate