MERY MORENO

**** *. ******* *** ****: 813-***-****

Tampa, Florida 33614 Email: adgrjl@r.postjobfree.com

Summary

IT professional with over 18 years of demonstrated ability in developing and implementing database systems. Span of technical experience includes database design, development, implementation, testing and support. Recognized for deep and broad knowledge of multiple database platforms and being able to gap design to desired business outcomes. Analytical and detail-oriented problem solver with a strong work ethic who is able to plan, organize and prioritize complex database systems and multiple job requirements. Fully bilingual in English and Spanish.

Technical Skills

Databases/Operating Systems/Languages:

Oracle 10.x/11x, 12c, 18c, 19c Oracle Designer/Developer 2000, SQLPLUS, PL/SQL, Teradata, SQL SERVER 7.x, 2000,2005,2008,2012,2014 AlwaysON Windows Cluster (High Availability). (V2R2/V2R3), Teradata Utilites, BTEQ, Teradata Manager, WINDDI, Queryman, ASF2, Netbackup, TSO/ISPF, JCL Utilities, Fileaid DB2, DB2 Utilities, QMF, CICS, VSAM COBOL, SQL Server 7.x/2000/Access, ROCHADE, Datacom, Unix (VI/Korn Shell) TSO, HTML/HGML, Window (2003/20082012/NT/XP), and Diverse Network Topologies.

Software/ Network/Hardware:

Hummingbird Connectivity, MS Office/Access, CASE tools (Erwin, Systems

Architect and Visio), Infoman, TCP/IP, FTP, Telnet, Internet (IE),

Intel Desktop HW, Lotus Notes, Outlook, Power Builder, MS Project, IBM

3090/4341/3033 Mainframe, PCS/SUN SPARC Station, Teradata V2R3 (5250), HP9000,

ICL 2900, and VAX.AIX, Linux

Professional Experience

BLOOMIN BRANDS Inc, Tampa, FL June 2014 – Present

Oracle & Azure Database Administrator

Bloomin Brands INC, a restaurant industry. It has recognized nationally for its community support, outstanding customer support, a national leader in arts and corporate philanthropy. As Bloomin Brands Inc growing, the Oracle DBA team is tasked to meet the growing demands and exploring newer, more efficient and reliable methods to ensure database reliability, availability, performance and cost efficiency. As part of this team, I am primarily tasked with updating Database Backup and recovery strategies, in addition to being closely involved with the new Development initiatives database patches, Production/QA/Development support, Performance tuning, and all aspects of database administration.

Major Activities undertaken

Managing Azure SQL & Azure SQL Data Warehouse databases.

Building, Managing and Monitoring Azure Failover Groups

Create Azure VMs for Linux and Windows environments.

Build Automate jobs to scale up and scale down Azure Databases & Build VMS servers for Online Order Systems.

Work closely with MS & business to migrate databases and application to Azure

Upgrading databases from 8i to 11g, 11g to 12c and 12c to 18c & 19c

Scripting, enhancing and scheduling EXPDP and RMAN backups.

General database health, monitoring data segments allocation & possible space contention issues

Applying periodical CPU’s and PSU’ to the Clusterware, ASM and RDBMS

Working with Oracle Support to resolve bugs and patch databases, creating and following up with Tars etc.

Deployment of QA’d code from Development to Acceptance and Acceptance to Production for SQL Server and Oracle.

Refreshing Development and QA databases with Production data using Transportable Tablespaces on Oracle and Impor/Export on SQL Server.

Performance tuning Production, Development and Acceptance databases, assisting developers with Queries and PL/SQL, T-SQL code,SQL Trace & Explain Plans

Providing and testing performance enhancements using partitioned tables for large data volumes

Monitoring the database growth, sizes, alerts and system logs to provide minimal downtime.

Managing SQL Server databases

Building, Managing, Monitoring Windows Cluster SQL Databases 2014-2016

LAKELAND REGIONAL MEDICAL CENTER, Lakeland, FL Nov 2003 – May 2014

A Non Profit Health Care Organization

Oracle/SQL Server/CACHE/DB2 Database Administrator

Recruited as a DB2, Oracle, and SQL Server, CACHE DBA to support a number of projects(Patient Admissions, Account Payable, Financial Ledger, Invision, Care Enhancement, Risk Management, Lawson, and etc)

Support multiple project team databases and applications, managed tables, load/unload data, SQL tuning, performance tuning, back up and recovery, Migrate data to a different platforms and new releases.

Set up and administer data base middleware interface structures, security and standards for passing application data from system to system via network and interface engine software

Install, implement and maintain data base management systems, e.g. CACHE DB2, Oracle, SQL Server, SQL Maximize the value, quality, and usability of corporate information through the standardization of database configuration, accessibility procedures, and maintenance. Promote data consistency and standardization

Monitor the availability and reliability of database-related procedures, processes, and services.

Identify and resolve key problems with database structures, including: Create and modify physical storage structures (i.e. tablespaces, tables, indices, partitions, clusters, snapshots, rollback segments, temporary storage structures, clusters, and data files.) Size physical storage structures to minimize database fragmentation and chaining. Perform status reporting to I.S. and user management.

VERIZON/FORMELY GTE, Tampa, Florida July 1997 – October 2003

(A Multi-national telecommunication organization with $60+ billion in annual

revenues.)

VERIZON WIRELESS, Tampa, Florida August 2001 - November 2003

Teradata/DB2/Oracle Database Administrator - Data Warehouse

Recruited as a DB2 DBA Oracle, and Teradata to support a number of projects

(UDM Data Warehouse, ECRC, Onstar, PowerPlay, etc)

Supported multiple project team databases and applications, managed tables, load/unload data, SQL tuning, performance tuning, back up and recovery, production support, created privileges for users, and data conversation.

Specifically, as a Teradata DBA, worked on migrating an Oracle Enterprise Warehouse system to 2TB Teradata running 5250 using Teradata Utilities (Fastload, Multiload, etc.), continue providing day to day DBA support: provide support to developers, database performance and tuning, security issues, trouble shooting, implementing various systems into production, providing 7x24 support, define and implement backup/restore strategy (using Mainframe, ASF2, and Netbackup).

As an Oracle DBA, supported an on-line order entry system using Oracle 8.x.

As a DB2 DBA supported the IIM system. The development was done on DB2 using Cobol II, Fileaid, SPUF1, QMF, VSM and DB2 Utilities.

Developed database system requirements, design, testing, and system specification documentation; performing under pressure and within time constraints.

Created logical and physical data models (ERD), using CASE tool technology for project teams. Including the creation and maintenance of DDL, and tables.

Function as Liaison between NCR/Teradata Vendor and third party software vendor for the database.

Implement standards to ensure that all application designs and code are produced with proper integrity, security and performance. Participate in design reviews to reassess that the code to ensure adherence to business need.

VERIZON DATA SERVICES, Tampa, Florida August 2000 - August 2001

Junior DB2/Oracle Database Administrator - Enterprise Database Home Room

Responsible for the support and the development of multiple DB2 and Oracle databases to implement new and existing systems within Verizon. Ordering, payroll, and billing projects supported include RPA, BAT, ECRC, IIM, RCA, ONSTAR, SDW, etc).

Supported multiple project team databases and applications, managed tables, load/unload data, SQL tuning, performance tuning, back up and recovery, created privileges for users, production support, and data conversation.

Developed database system requirements, test cases/scenarios, high-level design, and system specification documentation; performing under pressure and within time constraints.

Provide technical support to application development teams.

Evaluate releases of Oracle and its tools, and third party products to ensure that the site is running appropriately.

Created logical and physical data models (ERD), using CASE tool technology for project teams. Including the creation and maintenance of DDL, and tables.

Enforce and maintained database constrains to ensure integrity of the database.

Troubleshoot issues regarding database application and developmenttools.

Develop and enhance policies and procedures on how the current billing systems will be utilized in Oracle.

GTE DATA SERVICES, Tampa, Florida May 1998 - August 2000

Junior DB2 Database Administrator - Computer Infrastructure & Standards (CIS)

Responsible for the support and the development of multiple DB2 applications

within GTE. Payroll, and billing projects supported include IIM, BAT, and AAIS.

Monitored of the groups databases for the successful completion of production jobs processed.

Created logical and physical data models (ERD), using CASE tool technology for project teams. Including the creation and maintenance of DDL, and tables.

Created and maintained MS Access databases and utilized Oracle as a power user and end user.

Collaborated with senior database administrators in resolving all database or SQL issues.

Generated management time reports utilizing MS Excel via the import of raw data from multiple DBMS. Utilized DB2/MS Access to store the data. Utilized CA-DQRY for access of data stored in CA-DATACOM.

GTE DATA SERVICES (Ajilon), Tampa, Florida January 1998 - May 1998

Project Administrator - Architecture and Planning Organization

Responsible for the development and maintenance of project plans department wide.

Administered development, and maintenance documentation and production to ensure consistency quality and efficiency.

Monitored system changes and analyzed the impact on existing documentation.

Utilized MS Project, TOS/ISPF and HTML TRANSIT to document system plans.

Education

UNIVERSITY OF SOUTH FLORIDA, Tampa, Florida

Master Degree in Computer Sciences, On going

UNIVERSITY OF SOUTH FLORIDA, Tampa, Florida

Bachelor of Science degree in Business Administration, Graduation: 1997

HILLSBOROUGH COMMUNITY COLLEGE, Tampa, Florida Graduation: 1995

Coursework towards degree in Computer Information Systems

Training

Verizon, Lakeland Regional Medical Center & BloominBrands Inc Database Training:

Oracle Data Administration, Oracle Backup and Recovery, Oracle Performance

Tuning, Introduction to SQL using Oracle, DB2/SQL Queries using QMF,

Fundamentals of SQL, PL/SQL Programming Using Oracle, Teradata V2R3/4 Database

Administration, DB2 Data Administration, DB2 Tuning & Performance, SQL Server 7, & 2000 Data Administration, SQL Server Backup & Recovery. Unix, Shell Script. Microsoft SQL Server 2012 & 2014 Database Administration, and Performance & Tuning. Oracle 12c Features.

Contact this candidate