Alf Baez

*** *** ****** ***** ****, New York, NY 10001

US Citizen, MBI OPM, NYPD Cleared

929-***-****

acf8ru@r.postjobfree.com

High Volume IT Infrastructure and Application Management

Sr Database Technologies and Data Architect, Technical Lead/Manager

Summary

. Over 15 years of experience in information systems, including defining

the roadmaps, budget, staff, infrastructure and facilities, and

overseeing the implementation of plans for increasing growth, and

ensuring high performance/availability for maximizing business continuity

for organizations with local and global presence

. Highly experienced in leading and managing diverse multi-cultural teams

of 25+ people in stressful 24/7 environments, prioritizing deliverables,

and optimizing resource utilization across projects to accomplish

targeted goals and assure that Service Level Agreements (SLA) are

fulfilled

. Strong experience in Migration VLDB (very large database systems, up to

35Tbs) Oracle 10g/11g/12c to LOZ (zLinux systems) using migration tools

such Oracle Golden Gate, with proven contingency rollback plans as fail-

back safe procedures, pulling delta data from target system such as LOZ

back to source system and reconciling the differences.

. Highly experienced with hands on DBA/Architect in capacity planning,

implementation and management of critical mixed environments configured

with active-active, active-standby options implementing Oracle's Advance

technologies DataGuard, 9i/10g/11g Real Application Cluster (RAC),

Automatic Storage Manager (ASM), GoldenGate, Exadata v2, RMAN with Split

mirror backups and Oracle WebLogic (10/11/12c) OEM 11g/12c;

. Highly experienced in managing environment with IBM DB2, MS-SQL Sever,

Oracle Times-Ten, MySQL and NoSQL open source projects PostgreSQL

(8/9.2), Greenplum DCA 4.0 full-rack, Cassandra, Hadoop, MongoDB

. Highly experienced in Application assessment, capacity planning,

performance tuning, response time improvement and identification of

bottlenecks at different levels of infrastructure (front-end, middleware,

back-end, network, bandwidth connectivity, storage growth, CPU, Memory,

and maintenance of datacenters).

. Highly experienced in designing architecture, planning and deploying RAC

with Transparent Application Failover (TAF) environments along with Cache

Fusion and Flashback technologies for high availability and zero

downtime.

. Experienced in modeling and designing online transaction processing

(OLTP), data decision support (DDS), warehouses (DW) database systems,

and extract/transform/load (ETL) processes. Along with creating, and

maintaining Database Objects, including application and user

schemas/roles/privileges, partitions, packages, stored procedures,

functions, triggers, database links, snapshots, tables, constraints,

clusters, views, indices, sequences, and synonyms.

. Highly experienced in software development life cycle (SDLC)

methodologies and procedures.

. Experienced in integration of external financial data systems such

Broadridge, MarkIT, Reuters, and Bloomberg.

. Experienced in designing appropriate database models, constructs and

feeds for multiple processes such as real-time pricing information,

holdings, trade details, performance data, and other market data.

. Experienced in maintaining vendor and client relationships and

attracting/retaining talent.

. Experienced on Script Programming using Korn and bash shell, Perl, Awk,

ps, sed, grep, and archiving tools like tar, gunzip, gzip, backup,

auditing both external auditing and internal auditing, experience on

various UNIX and Linux platforms like Redhat, SuSe, AIX, and Solaris

Technical Skills

RDBMS/Apps: Oracle 8i/9i/10g/11g, Oracle TimesTen (11g R2), SQL Server,

PostgreSQL 8/9, Greenplum DCA 4, Oracle 9iAS/10gAS, Oracle Grid Control,

Grid Infrastructure, WebLogic 10/11, Oracle EBS (11i/12i), EnterpriseDB

(Advance server and plus), DB2, My SQL, NoSQL open source projects

Cassandra, Hadoop, MongoDB, and Greenplum.

Tools: Oracle SQL Developer, Oracle Discoverer DS, OEM 11g/12c, RMAN,

STACKPACK, Erwin, Toad, MS-Visio Crystal Reports, SQL*Loader, JDeveloper;

Secure CRT, TOAD, Putty; Informatica, DataJunction. Oracle Apps 11i/12i, MS

Project, GoldenGate, Exadata, SharePlex, IBM BDW 8.2, Spectrum, PgAdmin,

PgCluster TOAD for PostgreSQL 8/9, PgPool, SlonyI, Bucardo

Programming Languages: SQL, PL/SQL, T-SQL, Shell Scripts, PERL, PHP, Java,

JavaScript, C, C++, Ruby on Rails

Operating Systems: UNIX (Sun Solaris x-10.x, IBM AIX 5.x -7.x, HP-UX 11i

v3), Linux (Red Hat 5.x-6.x, SuSe), MS Server, MS Windows NT Server, MS-

Exchange Server

Storage/Mainframe Vendors: 3PAR, EMC, Hitachi, IBM Subsystems, IBM Banking

Data Warehouse, IBM System z (zEC12, z196), EMC

Experience:

Federal Agency Confidential (via Oracle ACS), Washington D.C

03/2013 - Present

Sr. Technical Lead Architect DB Technologies

Sr. Technical Lead Architect DB Technologies and Adviser for the Affordable

Care Act (ACA) project, ACA is a United States federal statute signed into

law by President Barack Obama on March 23, 2010

. Sr. Technical Lead with hands on and executive advisor for the several

project state holders and C level, responsible for the design,

implementation, and capacity planning of database systems for the ACA

project utilizing Oracle's newest and advance technologies for both RAC

and non-RAC environments, single node RAC, and oracle restart, RMAN, ASM,

Grid Infrastructure (GI), OEM 12c, GoldenGate, and WebLogic 12c.

. Sr. Technical Lead responsible for the implementation of RMAN with Split

mirror backups for several multi-terabyte database systems, this required

the implementation of Grid Infrastructure, single node RAC environments,

oracle restart, and Oracle ASM interacting with Veritas and Netbackups

environment

. Sr. Technical Lead responsible for day to day activities and overall

architecture of database infrastructure environment: capacity planning,

configuration and integration of several database and components to be

managed with Oracle OEM 11g/12c

. Sr. Technical Lead responsible for day-to-day advance support for the

High Availability Environments: multi-node RAC and DR (Disaster

Recovery) Site systems utilizing Oracle's physical and Logical Standby

Databases (Data Guard) strategies.

. Lead Implementation project on High Availability solutions with Oracle

10g and 11g utilizing Oracle's physical and Logical Standby Databases

(Data Guard) strategies and Oracle's GoldenGate

. Responsible for the built of several databases in ACA's QA & DEV

environments via cloning using Oracle RMAN duplicate utility features.

Perform several logical database refresh using Datapump and

Transportable Tablespaces tools for development and testing database.

. Responsible for identifying regressed SQL statement and suggesting

appropriate solutions using SQL Tuning Advisor.

. Responsible for the planning and assessment of VLDBs in the several

TBs, Backups and migration using BCVs mirroring technique and storage

technologies

. Tech Lead for the Migration Oracle 11g/12c to LOZ (zLinux systems)

Environment: OLTP and DSS system databases sized from 100Gs up to over 35

TBs running on 10gR2, 11gR2, Solaris 9/10, Red Hat 5/6; EMC Clariion,

Veritas, Unisys, Greenplum DCA 4.0 full-rack, Oracle AMS, Oracle RAC, Grid

Infrastructure, WebLogic 12c, IBM System z (zEC12, z196), Unisys Storage

management.

New York Confidential Financial Law Enforcement (via URimagination) New

York, NY 09/2012 - 03/2013

Sr. DB Architect Principal and Technical Lead Consultant

A DB Architect Principal Technical Lead Consultant and Adviser for the

DBA/Developers in-house personnel

. DB Lead Architect Consultant responsible for the design and

implementation of 10gR2 to 11gR2 migration for all corporate databases

for both RAC and non-RAC environments.

. Managed day to day activities and overall architecture of the entire

database infrastructure environment: capacity planning, configuration and

integration of several database and components to be managed with

. Conducted Database and SQL Performance Tuning in oracle RAC

environment using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and

ADDM reports.

. Responsible oracle databases running on Windows / UNIX (HP-US, Sun

Solaris, - IBM AIX 5L) /Linux (RedHat)

. Lead Implementation project on High Availability solutions with Oracle

10g to 11g migration, Physical and Logical Standby Databases (Data

Guard)

. Built QA & DEV environments via cloning using Oracle RMAN duplicate

utility features. Perform several logical database refresh using

Datapump and Transportable Tablespaces tools for development and

testing database.

. Responsible for identifying regressed SQL statement and suggesting

appropriate solutions using SQL Tuning Advisor.

. Responsible for advising developers how to code optimal SQL and

PL/SQL.

. Responsible for performance tuning of PL/SQL with the help of Oracle

tools set.

Environment: OLTP and DSS system DBs sized from 150Gs up to 50 TBs running

on 10gR2, 11gR2, Windows, Solaris 9/10, Red Hat; EMC Clariion

Sumitomo Mitsui Banking Corporation (SBMC)

(via URimagination, Vyvoa Consulting, LLP), NYC, NY

6/2012 - 09/2012

Sr. DB Architect Principal Technical Lead

A DB Architect Principal Technical Lead for the Oracle Enterprise Manager

12c Implementation Project.

. Managed day to day activities and overall architecture of the entire

database infrastructure environment: capacity planning, configuration and

integration of several database and components to be managed with OEM

12c: vendors products and technologies: Oracle 9i/10g/11g, GoldenGate, MS-

SQL Sever (2005/2008/2010), Oracle Times-Ten, NoSQL open source projects

Greenplum, WebLogic (10/11/12c) OEM 11g/12c

. Assist SMBC with installation, configuration and testing of OEM 12c

. Leverage existing licensed OEM Management Packs where applicable, for

monitoring and configuration management

. Work with SMBC resources to configure HA for the OEM environment

. Create notification rules specific to SMBC requirements with the correct

response SLAs

. Matter expert with the following activities related to your Oracle

Enterprise Manager 12c (OEM 12c) implementation program:

. Review business and technical requirements for the OEM 12c solution.

. Assisted with the design OEM 12c architecture and deployment plan.

. Assisted in validating and preparing your server for installation.

. Assisted with the install and configuration of SOA/WLS BI/Reports

Publishing Server Management pack.

. Assisted with the design for Oracle Provisioning and Patch Automation

Pack Oracle Configuration Management Pack.

. Assisted with the install and configuration of base monitoring for web

center portal and enterprise content.

Environment: OLTP and DSS system DBs sized from 150Gs up to 50 TBs running

on 10gR2, 11gR2, PostgreSQL, Greenplum DCA 4.0 full-rack, EnterpriseDB,

Oracle Exadata x2/3, Solaris 9/10, Red Hat; EMC Clariion X3 M80, Hitachi

AMS, 500, 2100, 2300, Cisco, Greenplum

Bank of America Merrill Lynch (via URimagination), NYC, NY

12/2006 - 05/2012

Sr. DB Manager Principal Consultant/Sr. Lead Architect DBA

Global Wealth and Investment Management (GWIM)

As Senior Principal Technical Lead/DBA, I actively participated in

DB/middleware/application tuning, performance capacity assessments and

implementation of recommended enhancements for BoA's Online Brokerage, a

web-based transactional system generating over $100 million in annual

revenues. As a result of our improvements, BoA's application moved from

300th position to the top 25 for response time and top 10 for availability

on industry benchmark charts, and the global cash deposit rate increased by

80%.

. Managed and led geographically and culturally diverse team (7 database

administrators, 9 developers and several other support engineers based in

London, Bangalore, Romania, Istanbul)

. Coordinated efforts between in-house and outsourced teams, data center

managers (New Jersey, Chicago, Santa Clara) and major vendors (Oracle,

Sun, several other hosting providers such as Savvis, SunGuard)

. Tracked projects with MS Project and provided status reporting to

management; implemented process and policy changes to enforce proper

application change control.

. Led regular global team and stakeholder meetings to discuss and

prioritize necessary enhancements to database environment and resolve

issues such as security and proper use of database accounts and data by

implementing separation of duties.

. Technical Lead for a big-data project team for the migration of several

databases from Oracle OLTPs/DWHs to Greenplum DCAs

. Trained team members on available vendor support resources and conducted

knowledge sharing sessions as well

. Responsible for the development, deployment and ongoing operational

management of the database environment (applications and hardware

infrastructure) underlying BoA's online brokerage website.

. Led the conversion and integration of online brokerage systems with the

two largest clearing platforms in the industry (Merrill Lynch and NFS).

. Managed day to day activities and overall architecture of the entire

database infrastructure environment: capacity planning, configuration and

management of several database vendors products and technologies: Oracle

9i/10g/11g, GoldenGate, Exadata v2, PostgreSQL 9.1, MS-SQL Sever

(2005/2008/2010), DB2, Oracle Times-Ten, MySQL, NoSQL open source

projects Cassandra, Hadoop, MongoDB, Greenplum 4.0, WebLogic (10/11/12c)

OEM 11g/12c, eBS 11i

. Supported bank accounts conversion and merger for BoA and Merrill Lynch.

. Designed and implemented 9i to 10gR2 and 11gR2 migration for all

corporate databases for both RAC and non-RAC environments.

. Designed and implemented the migration of several database applications

cross platform from Sun 10 to Linux using GoldenGate

. Implemented and managed Oracle Advanced Replication, Advanced Security,

Label Security, Database Vault, Partitioning, Compression, Encryption

with Oracle Transparent Data Encryption (TDE)

. Led Exadata v2 project planning, implementation, migration, and tuning of

several databases and application along with GoldenGate production,

disaster recover (DR), and quality assurance (QA) - to be used for

mission critical applications.

. Led RAC project of 2 nodes, 3 databases with ASM and DataGuard; Oracle

10gR 2, on Solaris 10; responsible for all major dbs synchronizations

across the globe implementations using GoldenGate technologies, Veridata,

and Director.

. Led the migration of several application/databases off oracle to

PostgreSQL 9.1, single instances and replicated environments, and using

third party open source tools: PgAdmin, SlonyI, Bucardo, PgCluster,

PgPool, DBEnterprise

. Coordinated with SAs to ensure that most up-to-date Oracles CPUs were

installed on all database systems and necessary O.S patch updates were

successfully tested and deployed.

. Designed and modeled several DSS/reporting systems for Data warehouses to

off-load and improve performance on the transactional relational database

management systems (RDBMS). Also collaborated with the Greenplum Data

Computing Appliance team migrating several big data extracts from Oracle

DWHs to Greenplum.

. Integrated market data from external providers (Morningstar, Lipper,

Reuters, S&P) and brokerage and clearinghouses (National Financial

Services).

. Provide detailed documentation of DBA procedures/operations, including a

DBA run book focused primarily on DBA routine functions for proactively

maintaining the corporate databases.

. Performed and automated any dba tasks using shell scripting for korn,

bash, Perl, Awk, sed, ps, and many more uinx/linux like utilities such

tar, gunzip, gzip, backup

Environment: OLTP and DWHs/DSSs system DBs sized from 150Gs and over 20 TBs

running on Oracle 9iR2, 10gR2, 11gR2, PostgreSQL 8/9, Greenplum 4.0 Full-

Rack, EnterpriseDB, Oracle10gAS, Oracle Exadata 2, MS-SQL Server 2005/2008,

Solaris 9/10, PH-UX, Linux Novell SuSe and Red Hat; 3PAR InServ T800, EMC

Clariion X3 M80, Hitachi AMS, 500, 2100, 2300

Health & Hospitals Corporation of New York, NYC, NY

11/2003 - 12/2006

Lead Oracle DBA/Coordinating Manager

. Implemented, maintained and enhanced MISYS Data warehouse, a major

VLDB/WH mainly used for DSS and scientific research

. Led deployment of the MISYS Data warehouse project for HHC at Coney

Island Hospital, including partitioning implementation, performance

tuning and maintenance.

. Implemented major database technologies including Oracle SQL Server,

Oracle Applications Server, Oracle Discoverer Admin and End Users.

. Developed and administered customized reports using Oracle Discoverer and

Oracle Discoverer Administrator.

. Provided detailed documentation for all installations and database

processes.

Environment: OLTPs, DDS, and WH DB systems sized up 5.7 TBs running on

Oracle 9iR2/10gR2, SQL Server 2000, Oracle9iAS, Oracle Discoverer End User

& Administrator, AIX 5.2, Linux, and Teradata

GlobalTron Corporation (DBA Phone1), Miami, FL

07/2002 - 10/2003

Oracle DBA

. Designed, created and administered Oracle databases (production,

development and testing environments).

. Worked with local and remote DBAs to synchronize database objects and

implement backup strategies.

. Developed custom reports, interfaces, and applications using Crystal

Reports.

. Monitored and maintained SQL Server production environment.

. Administered security; created user accounts and managed roles,

privileges and profiles.

Environment: OLTPs and DSS/WH system DBs combine sized up to 1.5 TBs

running on Oracle 8i, SQLSERVER 7.0/2000, Solaris, DB2 UBC, z/OZ, AIX

Net Import & Export Inc., Miami, FL

01/2000 - 06/2002

Oracle DBA

. Assisted senior DBAs in creating/maintaining Oracle databases

. Created and modified new and existing SQL code, including PL/SQL

packages.

. Created stored procedures, views and transactions linked to custom user

interfaces.

. Performed capacity planning

. Resolved Oracle related errors/issues on an on-going basis.

. Planned, implemented and monitored backup and recovery strategies for

production databases using RMAN.

. Administered company's Microsoft network.

. Maintained the company's CRM database.

Environment: OLTP DBs running on Oracle 8i, SQLServer7, InterAction 3.22,

Sun Solaris, Windows NT 4.0, NetApp

Computer Technical Systems, Miami, FL 11/1998

- 12/1999

Technical Support

. Developed and supported desktop MS Access databases for in-house and

external client use.

. Installed, implemented, and integrated accounting software systems.

. Assisted in the installation, configuration and support of Microsoft

networks and mixed environments.

. Provided technical support via phone.

Environment: MS-Office Suite 97, MS-Access, MS-Windows NT, Unix Solaris

5.8/8, and SQL Server, Oracle

Education:

. B.S in Computer Science, Bogota Colombia, Santo Thomas University, 1999

. M.I.S in Computerized Office Systems Specialist, Information Management

Systems Analyst, Hi-Tech Business School Miami, FL 2000

Certification:

. Oracle Certified Expert, Oracle Real Application 11g and Grid

Infrastructure

. Oracle Exadata 11g Certified Implementation Specialist

. Oracle Certified Professional 9i-11g

. Oracle Certified Implementation RAC Specialist

. Oracle Certified Partner Network Certified Specialist

Training:

. Oracle: Exadata v2/x2 Implementation and Administration; Oracle Apps 11i

Implementation of all modules within the E-Business suite, Discoverer

Administration, Discoverer for End Users, Database Administration,

Database Performance Tuning, Database Backup & Recovery, Oracle Grid

Control, JDeveloper9i

. Microsoft: MS SQL Server MS Visio; MS Excel advance data loads, DTS

Warehouse and Data conversion

. Computer Associates: Erwin v4.1, Toad, Crystal Reports.

. Operating Systems: Sun Solaris, IBM AIX 5.X, HP-UX 11i, Red Hat,

SuSe/Novell MS Server, MS Windows NT Server

. Other: Secure CRT, TOAD, Putty; DataJunction, PostgreSQL, GoldenGate,

SharePlex, Veritas Cluster Ware

Work Status: US Citizen

Clearances:

Federal MBI Office of Personnel Management, active

New York Police Department active

Spoken Languages:

English, Spanish, Italian

Basic understanding and able to communicate in Portuguese

[pic]

Contact this candidate