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.
• 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.
• 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 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 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
• 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

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

Operating Systems: UNIX Sun Solaris, IBM AIX 5.X, HP-UX 11i v3 , Linux Red Hat, SuSe , MS Server,

MS Windows NT Server, MS-Exchange Server

Storage Vendors: 3PAR, EMC, Hitachi, IBM Subsystems, IBM Banking Data Warehouse

Experience:

Confidential

Lead Oracle DBA

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.
• Tech Lead for the Migration Oracle 11g/12c to LOZ zLinux systems

Environment: OLTP and DSS system databases sized from 50Gs up to over 50 TBs running on 9i, 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.

Confidential

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

Confidential

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

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

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 , Oracle Times-Ten, MySQL, NoSQL open source projects Cassandra, Hadoop, MongoDB, Greenplum 4.0, WebLogic 10/11/12c OEM 11g/12c
• 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.
• 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.
• 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.
• 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
• 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

Lead Oracle DBA/Coordinating Manager

• Led deployment of the MISYS Data warehouse project for HHC at Coney Island Hospital, including partitioning implementation, performance tuning and maintenance.
• Implemented, maintained and enhanced MISYS Data warehouse, a major VLDB/WH mainly used for DSS and scientific research
• 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

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

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

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