SUMMARY

• Data Architect, DBA and Database Infrastructure Engineer/ Service Oriented Architecture (SOA),
• ETL (Dealing with Data in the multiple formats, in different locations, from a variety of sources, Providing quality and integrity of available data for ease of access and analysis)
• AWS (CLOUD Migration) - Implemented strategy for the company’s oracle DW migration strategy, in conjunction with application teams, using AWS Database Migration Service, spearheaded actual migration to Amazon RDS (Red Shift).

TECHNICAL SKILLS

• AWS, CISCO, HP, SUN, IBM (AIX), EGENERA, HP 9000/800, NCR 3B2, Pyramid 7000
• OS LINUX (RED HAT 5 & 6), UNIX (SUN /SOLARIS, SCO, NCR, HP) WINDOWS,
• DATABASES ORACLE (12c, 11g, 10g, 9i, 8i, 7x), REDSHIFT(AWS), POSTGRES, MSSQL), DB2 (8, 9), INFORMIX (10)
• TOOLS ORACLE GRID CONTROL, ORACLE ENTERPRISE MANAGER (OEM), QUEST,
• SPOTLIGHT, TOAD, BENCHMARK FACTORY), ERWIN, HP OPENVIEW, SSMS, ETL (SSIS), SSAS, SSRS
• EMBARCADERO (Rapid SQ, DBARTISAN), PRECISE
• REPLICATION Oracle - DATAGUARD, GOLDEN GATE, DB2 Q replication. MS SQL Log shipping
• CLUSTERING RAC, RAC one node (Oracle), always on (MS SQL), HADR (DB2)
• LANGUAGES SQPLPUS (SQL), PL/SQL, C, SHELL scripting, T-SQL
• ORACLE APPPLIANCE AVDF (12c)

PROFESSIONAL EXPERIENCE

Confidential

Consulting

Responsibilities:

• On premise database Migration to AWS Redshift.
• implemented MISMO compliant customer centric model.
• Provided solution for synching of on premise MS SQL database with AWS Postgressvia native replication
• Established Enterprise KPI definitions based on meetings with the Business owners. Established process and
• Methods for getting data into Database.
• Leading efforts to replace the existing third party software that synchronizes HUB DB with all Databases across the enterprise In the real time utilizing SSIS.
• Reverse Engineered existing Hybrid (OLTP&Historical) Database in order to forward engineer a DW. (MSSQL)

Confidential

Database Solutions Architect/Senior

Responsibilities:

• As a hands on DBA, migrated Oracle 11gR2 to Oracle 12c Pluggable Database (PDB) in Multitenant Architecture using Transportable Table space (TTS) method.
• In order to comply with Auditing requirements Installed and configured Oracle Advanced Security Features: Oracle Database Vault and AVDF (Oracle Audit Appliance 12.2 ).
• For the Multitenant Architecture 12C database, Utilizing Erwin data modeling tool reverse engineered current production database.
• Based on a review and understanding of the current database model, performed an elaborate data modeling process and created models to separate a Historical DW (denormalized in order to speed up queries) and the Daily Activities Databases ( in the 3NF normal form), resulting in 2 databases being separated,
• Applications changes/enhancements being reflected in the updatable views, accessible from both databases via the
• Build Disaster recovery Site for RAC ONE Oracle with DATAGUARD on standalone.
• Introduced Monitoring tools in order to proactively resolve issues.
• Installed and configured Oracle Advanced Security Features: Oracle Database Vault with Transparent Data Encryption

Confidential, New York

Vice President, DBA/Architect

Responsibilities:

• Managed Deploying and Implementing Oracle Technology for the entire Enterprise.
• Implemented POC of 11G Oracle RAC, and benchmarked performance vs single node of current Production.
• For all new versions of Software Created deployment documents and Oversee deployment to production.
• Organized Web Seminars for Production DBAs in Oracle TimesTen technology.
• Architect data layer For Security Master and Implemented preproduction Systems in the Lab and QA environment. Optimized for Performance.
• Implemented HA and DR solutions based on Oracle Technology of Data Guard.
• Organizeda Benchmark of switchover and the failover for production databases.
• Implemented several POC together with Oracle Solutions Architecture team to evaluate Oracle Grid Control as an integrated single point of monitoring and administration tool for the Enterprise.
• Created and enforced implementation of Backup/Restore/Recover Policies and procedures based on Oracle RMAN Technology.
• Providing a third level support for production systems.
• Migrated Oracle DW to SSQLSERVER.
• Build SQLSERVER databases for a new Fixed Income Applications. Utilized SSMS, SSIS and SSRS for Management and application needs.
• Support Developer teams and End Users in developing,, troubleshooting, and tuning queries and applications as well as writing
• Implemented Table Partitioning for MSSQLSERVER VLDB database.
• In SQL Server environment Streamlined the Backup/Restore and the Latest upgrades to the multi version production environment.
• Implemented Log Shipping for MS SQL databases to DR Site. In order to mitigate growing usage of disk,
• Migrated number of databases to the larger disk volumes
• Supported Oracle/MSSQL Production environments as a member of 24/7 rotation team.
• Performed End to End Performance Tuning for databases and worked with development teams on tuning applications for Oracle/MSSQL environments
• Worked closely on business requirements utilizing data integration (SSIS), analytics (SSAS), and business intelligence (SSRS) MS tools.

Confidential, New York

Senior Oracle DBA/Architect

Responsibilities:

• Designed and Implemented DW Relational Model from non relational legacy database based on user requirements. Created Models using Erwin and produced DDL in choice of RDBMS (Oracle or DB2).
• Developed methodology and process for data cleaning and loading.
• Determined Storage requirements. Benchmarked performance using Quests’ Benchmark Factory.
• Served as a “GOTO” source for the Critical, High visibility problems for ORACLE/SQLSERVER and DB2 and Informix database and applications..
• Implemented Oracle 10G Logical and Physical DATAGUARD utilizing Grid Control.
• Established Enterprise Wide DB monitoring practices for multi platform Database Environment.
• Implemented and fully documented RMAN backup/restore solution Production Databases
• Established and managed Hiring Process for DBA team.
• Implemented HA and Scalable Solution and Benchmarked System and DB performance in different data replication scenarios (SRDF vs. DATAGUARD) utilizing EMS Disks and VERITAS Clusters.
• Participated in preparing HA Systems and networking components test plan. Outlined HA test procedures to exercise all single points of hardware failure.
• Developed and documented procedures for installation, operations, backup/restore, monitoring and troubleshooting of RAC Implementation.
• Utilizing QUEST Benchmark Factory, Developed Industry Standard testing scenarios and applications for use against RAC configuration, and other possible HA configurations.
• Planned, installed, and configured Oracle DB and RAC software on the four RAC project machines. This configuration was modified at least 2 times to reflect the 2 major configurations that were being tested.
• Supported Oracle/DB2/Informix Production environments as a member of 24/7 rotation team.
• Performed End to End Performance Tuning for databases and worked with development teams on tuning applications for Oracle/DB2/Informix environments.

Confidential

Lead Oracle Database Administrator

Responsibilities:

• Planned and implemented a number of HA solutions for online bank credit card applications. This Solution was based on the business requirements for HA including clustered fail over for active/active nodes, distributing databases or replication and standby database.
• Led and created the strategy for implementing the new enterprise data warehouse.
• Migrated distributed database, ensuring data integrity while ensuring transaction coordination, data replication and data synchronization.
• Using DB-TUNER (EMC version of Precise software) implemented capacity planning for the new production database for 3rd party deployment software (RADIA).
• Managed and created set of policies and procedures for Oracle databases such as change management, disaster recovery, source control, etc.
• Documented and enforced usage of Best-Practices standards for creating and implementing Oracle databases for clustered and standalone environments. (Veritas clustering, EMC Disk).
• Using ERWIN, implemented a new database model to support applications and business intelligence data modeling for Enterprise.
• Implemented HAproject that converted production from a single node to 2 node clustered environment for Oracle 8i & 9i databases utilizing Veritas Clustering software on Solaris 8 (Sun 6800)
• Installed 9i, upgrading existing production environment to 9i and built standby database.

Confidential

Enterprise Oracle Database Administrator, Technology Infrastructure Services

Responsibilities:

• Ensured high performance and scalability for Oracle 8i databases.
• Built logical and physical models of very large data warehouse using ERwin, based on gathered data for supporting business intelligence.
• Implemented and tested fail-over solution for Clustered Nodes using VERITAS software.
• Participated in efforts to establish proper coding standards in order to produce optimal performance.
• Interfaced with end users as well as application programmers while deploying the applications implemented on databases.
• Mentored junior database administrators while reinforcing standards for building and monitoring databases.
• Planned and implemented disaster recovery strategy.
• Implemented standby instances as part of a disaster recovery strategy.
• Installed, configured and tested RMAN for backup/restore part of the disaster recovery strategy with LEGATO backup software. Implemented database duplication using RMAN Utility.
• Installed and configured Oracle database for Documentum.
• Performed installation and configuration of software for a number of Oracle 8i databases according to the global database standards.

Enterprise Database Architect DBA, Enterprise Technology Services - Architect, DBA

Confidential

Responsibilities:

• Implemented VLDB ( of Terabyte size) Oracle Data Warehouse for a DB2 Legacy database.
• Established enterprise wide standards for building, monitoring and backup solutions for the VLDB (full life cycle).
• Reinforced proper methodology for such processes as QA, Change Management and Technical Documentation.
• Handled all contacts with the 3rd party vendor regarding technical/logistical issues.
• Benchmarked the Oracle VLDB performance for the third party securities application software (FTI).
• Determined and researched High Availability and Disaster Recovery requirements (OPS, Standby, Hot Spare).
• Benchmarked performance of 10.x Oracle Financials versus 11i.x Financials.
• Presented seminar on middleware distributed computing.
• Organized series of seminars covering data warehousing, time series & data cartridges, ORDBMS and object technology in 8i for Confidential as a Liaison to Oracle Corporation.
• Implemented multi-master replication for geographically distributed Oracle database.

Confidential

Senior Technical Architect, DBA, New Media Division

Responsibilities:

• Designed, built and maintained the infrastructure for CBS website, selecting appropriate new technologies for building scalable high performance databases.
• Used Designer 2000 to create and maintain data model for production database.
• Installed and upgraded software on database and web servers.
• Monitored system and database performance for confidential website to anticipate increasing resource requirements.
• Determined scalability of databases and web servers for the projected number of simultaneous website hits.
• Implemented hot standby database for the production database as a part of a disaster recovery plan.
• Installed and prepared OPS solution for 24X7 availability.

Confidential, N.Y

Applications Manager, DBA, Systems Development Department

Responsibilities:

• Set up performance objectives for staff.
• Established training and coaching procedures for each staff member to ensure knowledge transfer, adequate training and personal development goals.
• Performed semi annual and annual performance evaluation.
• Managed development of a project in International Locations (Paris, France) for clearing securities trades.
• Managed brokerage applications for Fixed Income Securities (Trade Upload, Accounting and P&L)
• Managed implementation of new third party software brokerage applications.
• Managed deployment of software in multiple international sites.
• Designed and maintained data model for Oracle database using ERWIN.
• Developed and maintained project plans, schedule and budget.
• Delegated tasks and tracked progress report on projects.
• Handled user requirements/interfaces.
• Communicated project progress to relevant parties.
• Handled vendor contacts and deployment of third party software such as Bloomberg or Reuters.
• Monitored and updated inventory of hardware/software.
• Organized central depository of documentation explaining production procedures.
• Implemented disaster/recovery plan for existing production.
• Managed SWIFT (OS2/Merva) Messaging and DAVIDGE (Real Time Trade Entry) systems.
• Managed full system backups and exports, maintenance of users and available resources
• Performed benchmarks and database/application tuning.
• For security application produced front-end GUI (JAM/JAYCC) interface
• Implemented Source Code Control (SCCS)
• Ported Financial Information Tracking System from Mainframe to Pyramid S7080.
• CCS (Consumer Communications Systems) Department
• Implemented several releases of the WCC (Why Customers Call)