SUMMARY:

• Over 16 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 experienced in Oracle Cloud Services, public and private for federal (DBaaS, SaaS, DaaS, PaaS, IaaS), Oracle and PostgreSQL on AWS (RDS; Redshift) projects. Capacity, planning, and implementation of many of the SOA components: BPEL, Human Workflow, Business Rules, Mediator, Oracle Service Bus, Oracle JCA, Oracle Cloud Adapters, Oracle Enterprise Scheduler, Oracle BAM, Oracle A, Oracle MFT along with Oracle Fusion Middleware
• Highly experienced with hands on Data Architect in capacity planning, implementation and management of critical mixed environments configured for HA/Replication with active-active(GoldenGate multi-master), active-standby options implementing Oracle’s Advance technologies DataGuard, 9i-12c Real Application Cluster (RAC), with Multitenant Option: Container and Pluggable databases (12c CDB and PDB), Automatic Storage Manager (ASM), GoldenGate with encryption TDE TSE, Golden Gate Veridata, Exadata v2, RMAN with Split mirror backups and WebLogic (10g-12c) OEM 10g-12c
• Strong experience in designing, capacity planning and implementing Big Data, Cloud (private and secure), and VLDB (very large database systems, well over 50Tbs) using Oracle 12c, Exadata, PostgreSQL, Greenplum DCAs, and migration tools such Oracle Golden Gate, Attunity to support several Anti-Money Laundering (AML BSA) and Counter Terrorism applications and systems to support decision making officials and their agencies in real-time with support of their Patriot Officer and BAM+
• Strong experience in Migration VLDB (very large database systems, over 96TBs) Oracle 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 planning and implementing GoldenGate 12c Transactional Data Capture with WLS (Weblogic Server) Java Messaging Service (JMS/Java Adapter) and VAM message capture components
• Highly experienced in managing environment with IBM DB2, MS-SQL Sever, Oracle Times-Ten, MySQL and NoSQL PostgreSQL (8/9.2), Greenplum 4.3 with DCA V1 V2 V3 full-rack, Cassandra, Hadoop Spark, Scala, 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)
• 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 Agile Scrum and UML (CA ERWin) modeling schemas, database procedures supporting enterprise application such as Curam which is globally recognized within the government federal agencies in several countries.
• Experienced integration of external financial data systems such Broadridge, MarkIT, Reuters, and Bloomberg

TECHNICAL SKILLS:

RDBMS/Apps: Oracle Cloud Service SOA modules and components: BPEL, Human Workflow, Business Rules, Mediator, Oracle Service Bus, Oracle JCA, Oracle Cloud Adapters, Oracle B2B-Health Level 7, Oracle Enterprise Scheduler, Oracle BAM, Oracle API Manager Cloud Services, Oracle MFT, Oracle 8i/9i/10g/11g, Oracle TimesTen(in memory db) (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, 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:

Confidential, DC

Sr. Data Architect, Implementation Specialist

Responsibilities:

• Sr Data Architect responsible for planning and implementing Oracle OEM 13c and the integration of several modules, plug-ins, and customs scripts to monitor the entire enterprise; Storage, Database, OS level metrics and so on, Admin groups: Dev, QA, Production, setup and customize several alert and rules to go out a certain time to email inboxes and phones sms to responsible individuals.
• Sr Data Architect responsible for designing the architecture for many of APEX, SOA mobile Applications and deployment in Tablets and mobile phones and responsible for planning and implementation and administration of source code control and standards utilizing Oracle Portal’s CMS and guidance of other team members in their development and testing efforts.
• Lead architect responsible for the planning, implementation and management of several components of the SOA suite in HA/Clustered environment. This included installing, configuring WLS domains, load balancing, performance tuning, deploying, troubleshooting and maintaining of WebLogic servers along with the monitoring for performance for short and long terms capacity planning.
• Assisted in the Migration of data in and out to DBs running in Greenplum 4.x on DCAs v2 and v3 leading task such as: Planning and implementation of upgrade for the DCAs from V2 to V3; planned and implemented upgrade of GreenPlum databases from 4.x to 4.3.5.
• Supporting a global multi-master replication environment implanting encryption AES256 on data at rest and in motion
• Lead for PostgreSQL Greenplum assessing, planning, and implementation big data projects. With direct hands on as technical lead responsible for planning and implementation of PostgreSQL GreenPlum installations, creating databases on demand for the application teams and others such as Dev, QAs, EUT.
• Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several databases and managing users, and creating secure connections.
• Supporting assessment, design and implementation of replication tools such Oracle Golden Gate, Attunity to support several Anti-Money Laundering (AML) and Counter Terrorism applications and systems to support decision making officials and their agencies to the minute and or real-time.
• Sr. Technical Lead, for the Oracle Cloud Integration project which included the capacity, planning, an implementation of many of the SOA modules and components (BPEL, Human Workflow, Business Rules, Mediator, Oracle Service Bus, Oracle JCA, Oracle Cloud Adapters, Oracle B2B-Health Level 7, Oracle Enterprise Scheduler, Oracle BAM, Oracle API Manager Cloud Services, Oracle MFT)
• Providing lead development and architectural guidance for all in-house teams as well through knowledge sharing

Confidential, MN

Sr. Data Architect, Implementation Specialist

Responsibilities:

• Sr. Technical Lead, for the Oracle Cloud Integration project which included the capacity, planning, an implementation of many of the SOA modules, providing lead development and architectural guidance for all in-house teams as well.
• Sr. Technical Lead, providing assistance to the development, architecture, and release teams, providing architectural design recommendations, driving standards and naming conventions as per Agency’s requirements for effective Greenplum transition to production operations.
• Planned and implemented Oracle CMS to in corporate internal CMS administrative program accounting transactions and responsible for administration of source code control and standards utilizing DEC CMS and guidance of other team members in their development and testing efforts.
• Designed and implemented data migration and replication strategies to maintain several mix databases environments to Greenplum using Attunity replicate for Pivotal.
• Responsible with hands on day-to-day PostgreSQL db operations such as planning and implementation of PostgreSQL GreenPlum installations, creating databases on demand for the application teams and others such as Dev, QAs, EUT.
• Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several databases and managing users, and creating secure connections, as well.
• As part of the Big data project, managed and admin Greenplum (PostgreSQL) databases (Masters/Segments) using open source and Pivotal/Greenplum utilities such as PgAdmin III and using cli (command line interface) such as pgstart pgstop, pgssh, etc.
• Sr. Technical Lead, designed, planned, and implemented Oracle’s GoldenGate in several configurations such as unidirectional, bi-directional (Active-Active), and cascade. Along with Oracle’s Veridata to monitor and detect conflict and perform resolution, to migrate and replicate several 100s of databases in heterogeneous environments to Oracle Exadata 12c with Container and Pluggable (CDB/PDB) options part of the State’s Confidential, MNSure, SSIS, and Curam, project initiatives among others.
• Implemented Nagios for over systems monitoring. Also tune minimum OS (Linux RedHat/SuSe) kernel parameters for better overall performance. mplemented GoldenGate with Transparent Data Encryption (DTE), and Tablespace Encryption (TSE) and other advanced data security technologies and production.
• Implemented Oracle Golden Gate’s Director middleware to manage and monitor the entire replication environment.
• 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 Confidential project utilizing Oracle’s newest and advance technologies for both RAC and non-RAC environments, single node RAC, and oracle restart, RMAN, ASM, Oracle DB 12c with Multitenant options CDB and PDB, Grid Infrastructure (GI), OEM 12c, GoldenGate 12c, and WebLogic 12c.
• Sr. Technical Lead responsible for day to day activities and overall architecture of database infrastructure environment: capacity planning, 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 11g and 12c-utilizing Oracle’s physical and Logical Standby Databases (Data Guard) strategies and Oracle’s GoldenGate bi-directional (Active-Active) configuration and using Veridata to monitor conflict and perform resolution and Oracle Golden Gate’s Director middleware to manage then entire replication environment.
• Sr. Technical Lead with hands on planned and implemented the Java CapTrans-TDC project using GoldenGate 12c: Transactional Data Capture WLS (Weblogic Server) Java Messaging Service (JMS/Java Adapter) VAM message capture
• DB Lead Architect Consultant responsible for the design and implementation of 11gR2 to 12c migration for all corporate databases for both RAC and non-RAC environments.

Confidential, Washington, DC

Sr. Technical Lead Architect

Responsibilities:

• Sr. Technical Lead and Data Architect 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 Confidential 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 and Data Architect responsible for designing the architecture for many of APEX, SOA mobile Application to be deployed in Tablets and mobile phones.
• 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, 11g, and 12c-utilizing Oracle’s physical and Logical Standby Databases (Data Guard) strategies and Oracle’s GoldenGate bi-directional (Active-Active) configuration and using Veridata to monitor conflict and perform resolution and Oracle Golden Gate’s Director middleware to manage then entire replication environment.
• Sr. Technical Lead with hands on planned and implemented the Java CapTrans-TDC project using GoldenGate 12c: Transactional Data Capture WLS (Weblogic Server) Java Messaging Service (JMS/Java Adapter) VAM message capture
• Responsible for the built of several databases in Confidential ’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
• Assisted various teams on the Migration Oracle 11g/12c to LOZ (zLinux systems)
• Assisted the Lead Greenplum 4.0 Implementation for full racks with DCA v1.
• Assisted the Lead designed and implementation of High Availability, Backup/Restore, and Disaster Recovery of the Greenplum environments.
• Lead Designing and implementing databases for OLPT and data warehouse (start schemas with big fact tables and dimensions)
• Managed day-to-day db operations such creating and managing users, and secure connections.
• As part of the Big data project, managed and admin Greenplum (PostgreSQL) databases (Masters/Segments) using open source and Pivotal/Greenplum utilities such as PgAdmin III and using cli (command line interface) such as pgstart pgstop, pgssh, etc;
• Implemented Nagios for over systems monitoring. Also tune minimum sys/os(Linux RedHat/SuSe) kernel parameters for better overall performance.
• Responsible for all documentation procedures of daily operations for the organization’s DBA run book, which integrated into the corporate’s infrastructure run book with detailed instruction on how to procedure and how to contact key staff members, Technical lead, vendors, managers, executives, etc.

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.

Confidential, New York, NY

Sr. DB Architect Principal and Technical Lead Consultant

Responsibilities:

• 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

Confidential, NYC, NY

Sr. DB Architect Principal Technical Lead

Responsibilities:

• 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: vendor’s products and technologies: Oracle 9i/10g/11g, GoldenGate bi-directional (Active-Active), 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

Confidential, NYC, NY

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

Responsibilities:

• 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
• Data Architect responsible for the planning and implementation of their AML BSA Patriot Officer and BAM+ applications and post-implementation support
• 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 ( Confidential and Confidential ).
• 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 Confidential .
• 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 and active-active configuration, Veridata, and Director.
• Led the migration of several applications/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