| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate William
Quitian
Senior Oracle DBA, Oracle Exadata Database Machine Certified
Senior Oracle DBA
Implementation Specialist, Oracle Autonomous Database Cloud Street Address
Certified Specialist, Oracle Golden Gate Street Address c Certified Implementation Contact
Specialist, Oracle Database Administration 2019 Certified Professional OCP
and Oracle Database 11g Administrator Certified Associate OCA with more E-mail
than 9 years of experience as database administrator for production and EMAIL AVAILABLE
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 Skills
in financial and retail industries. Experience with other RDBMS systems like
MySQL, PostgreSQL and SQL Server. Results-oriented engineer with problem- Oracle database
solving and critical thinking skills, as well as meticulous attention to detail and administrator 19c
methodical nature. Skilled in tackling problems in unique ways to develop
innovative solutions. I am only interested in contract positions on a c2c base. Excellent
Tuning and performance
Work History database
Excellent
Oracle RMAN
2023-01 To Senior Oracle Database Administrator
Date
HCL Dollar General Nashville TN Excellent
Administration, configuration, and monitoring of Exadata
X9M, X9M and X7 machine components, including Cell Oracle Data Guard
Server, Infiniband switch, RoCE switch , Cisco switch , PDU ,
KVM . Very Good
Experience in troubleshooting network and I/O related
Oracle Golden Gate
issues in the Exadata environment.
Configuring the monitoring cell server thresholds and
Good
troubleshooting the cell server , Infiniband , cisco switch ,
RAC interconnects issues . Oracle Cloud Control
Hands-on experience managing, addition and deletion
cell disks, grid disks, ASM disks and all storage features with Excellent
cellcli commands.
Optimizing and modifying production and critical Oracle RAC
databases, as well as diagnosing and determining the core
cause of Oracle database on Exadata systems outages. Very Good
Experience in configuring Database Backup and
Recovery using RMAN and recovery for databases in TBs . Unix and Linux OS
Practical knowledge to Data Guard setup , switchover ,
failover and gap resolution between datacenters in Average
separate cities.
Experience configuring and building Golden Gate Software
Extracts/replicate for multiple databases.
Practical experience adjusting Golden Gate to handle Toad for Oracle
restarts, latency, logging, production support, and status
reporting. Very Good
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 DataPump, 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.
2022-03 Senior Oracle Database Administrator
2022-10
ScotiaGBS S.A.S
Configure, test and support Oracle databases in versions 9i
to 19c and additional Oracle technologies as Dataguard,
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 Golden Gate 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 Senior Oracle Database Administrator
2022-02
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 Dataguard, Goldengate, RAC, Oracle Enterprise
Manager, Multitenant, Oracle Autonomous Database,
Advance Security, 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 DataPump, 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 - Oracle Database Administrator
2017-07
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 - Software Developer
2015-01
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 - Bachelor of Science with a Major in Systems
2014-11
Engineering
Universidad Minuto De Dios - Bogot DC
2015-01 - Associate of Applied Science: Database
2015-12
Management
Fundaci n De Egresados De La Universidad Distrital -
Bogot DC
2016-06 - Associate of Applied Science: Administering
2016-10
Microsoft SQL Server 2014
Intelligent Training Colombia - Bogot
Certifications
2023-05 Oracle Exadata Database Certified Implementation Specialist
2022-10 Oracle Golden Gate 12c Certified Implementation Specialist
2022-02 Oracle Autonomous Database Cloud 2021 Certified Specialist
2021-12 Oracle Database Administration 2019 Certified Professional
2018-07 Oracle Database Associate 11g
Professional References
2022-10 Gang Liu - DBA Manager Scotiabank -
EMAIL AVAILABLE - PHONE NUMBER AVAILABLE
Alejandro Cespedes - Country Manager delivery - Scotiabank
Colpatria - EMAIL AVAILABLE -
2022-02 PHONE NUMBER AVAILABLE
Juan Carlos Fuquen - Manager DBA - AV Villas Bank -
EMAIL AVAILABLE - PHONE NUMBER AVAILABLE
2017-07
.
|
