Engineer Oracle

Luis Saldana

Oracle and SQL Server Engineer with 10+ years of experience

*** ***

3155

HIGHLIGHTS

Primary Skills:

•

• Database Administration: MS SQL Sever 20016/14,2008R2, Oracle 12c/11gR2

• OS: Window Server 2016,UNIX(Linux, Sun-Solaris, HP-UX, AIX),Virtual Box.

• Cloud Service: Oracle/AWS.

• Backup and Restore Linux file System.

• Backup and Restore MySQL Database.

EDUCATIONAL QUALIFICATION

INTELLIPAAT IT Technical School for AWS and Unix Scripting completion on 06/15/18.

•

• AVTECH Institute of Technology completion on 07/14/2012.

• Majored in Sun UNIX System Administration and UNIX Project. Certificate of Completion

on 07/14/2012.

• Oracle University Oracle Distributed Database Implementation certifies of completion on

April 21, 2011. Oracle Advanced Replication certifies of completion on May 05, 2010.

Oracle Backup and Recovery certifies of completion on August 25, 2010.

• SYBASE System and Database Administration certifies of completion on April 20, 2009.

• Learning Tree International Microsoft SQL Server 2009R2 certifies of completion on January

15, 2009.

COMMVAULT Technical School for Oracle and SQ Server Backup and Recovery certifies of

•

completion on 12/27/08.

• Borough of Manhattan Community College Majored Oracle Database Design and Engineering.

Certificate of Completion 03/23/2007.

TRAININGS/ CERTIFICATION

Certified System Administrator on December 27, 2007.

•

Certified System Engineer on January 3, 2008.

•

Certified System Support on January 3, 2008.

•

• Microsoft SQL Server 2009R2 certifies of completion on January 15, 2009.

• Sun UNIX System Administration and UNIX project. Certificate of Completion on 07/14/2012.

• Oracle University Oracle Distributed Database Implementation certifies of completion on April 21,

2011.

• Oracle Advanced Replication certifies of completion on May 05, 2010.

Luis Saldana 1

• Oracle Backup and Recovery certifies of completion on August 25, 2010.

PROJECT EXPERIENCE

Synechron June 2018

to Present

Client : Wells Fargo

Role: Database Administrator.

Responsibilities:

• Database migration, monitoring and troubleshooting databases scripts for following

environment from Source Machine DEV, SIT, PROD1 and Prod2 to target Machine Oracle

12c RAC Exadata.

• Capacity planning, SQL analysis, schema revisions, security administration and user account

maintenance.

• Migrate database server based EDM Team that meets user requirements.

• Create, modify and test various SQL queries, stored procedures and views for obtaining data

from diverse source systems and platforms.

• Modified the database development and production standards for Microsoft enterprise

databases.

• Deploy database change scripts provided by EDM Teams.

• Document the logical and physical components of operational databases and their

functionality.

• Understand table indexing and query strategies, database objects maintenance and

performance issues.

• Analyses database migration problems as assigned and provide solutions to address EDM

Team needs.

• Setup Meeting for Database Migration Project.

Environment: Oracle 12c, SQL Sever 2016, OLTP.

Philips Company /Teleperformance Jan 2017 to May 2018

Role: Databases Technical Support

Responsibilities:

• Provided day to day productions database (Oracle 10g/9i) operational supports for IBM clients like ATB

Financial and Alberta Oil & Gas companies.

• Performed enterprise database (Oracle 10GR2) and applications server (Web Logic 10.3) software

installations, configurations, upgrading patches, database management and administrations under various

operating systems (Linux, Sun Solaris 5.10/Windows 2005).

• Created user profiles, groups, roles and scripted for easy database administration.

• Approved all productions database designs and schema changes.

Luis Saldana 2

• Controlled all migrations (Oracle 8i and SQL Server 2000 to Oracle 10R2) of the database schema

objects and ensure the data availabilities.

• Performed daily backup & recovery system (RMAN) and VERITAS.

• Setup databases performance monitoring system tools (OEM 10g Grid Control)

• Monitored database performance tuning and others diagnostic activities.

• Provided On-Call (24/7) technical supports when needed.

Environment: Oracle 11G, SQL Sever 2016 and AW

COMMVAULT System 4/3/06

– 10/10/16

Role: Database Engineer (Level 3 Support) /UNIX Group

Responsibilities:

Data management, administration and modeling for SQL Server 2016 Window.

•

• Document all observations and work performed in a clear and detailed format, with timely

status updates / follow-ups to customers and management as required.

• Reproduce /confirm customer issues or product defects, and submit to engineering for

immediate or future consideration (as appropriate).

• Articulate and communicate technical concepts and issue solutions to customers in regards to

the Installation of Red Hat 7.1 version on Oracle Virtual servers.

• Support customers in the installation of COMM VAULT software for File System IDA for the

following systems, Linux, Sun-Solaris, HP-UX, AIX, MAC and Windows Servers.

• Manage the installation of COMM VAULT SOFTWARE Oracle IDA and SAP IDA for the

following Oracle database on Linux, Sun-Solaris, HP-UX, AIX, OS-390 & Windows).

• Oracle Database Administration for 12c, 11g and 10g.

• Assist the customer in the setup of Oracle (RAC) Application Clusters databases, backups

online and recovery.

• Provided On-Call (24/7) technical supports when needed.

Environment: SQL Sever 2016/2014, OLAP, OLTP and Oracle 12c.

Luis Saldana 3

Luis Saldana 4

Contact this candidate