Senior Oracle DBA

Nasi Asapova email: *******@*****.***

** ***** ** *****: 917-***-****

Chatham NJ

07928

TECHNICAL SUMMARY:

HARDWARE: 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), MS SQL (2014, 2012, 2008, 2005, 2000), DB2 (8, 9), INFORMIX (7, 8)

TOOLS: ORACLE GRID CONTROL, ORACLE ENTERPRISE MANAGER (OEM), QUEST

(SPOTLIGHT, TOAD, BENCHMARK FACTORY), ERWIN, HP OPENVIEW, ETL (SSIS),

EMBARCADERO (Rapid SQ, DBARTISAN), PRECISE

REPLICATION: Oracle - DATAGUARD, GOLDEN GATE, DB2- HADR Q replication.

CLUSTERING: RAC, RAC one node

LANGUAGES: SQPLPUS, PL/SQL, C, SHELL

Technical SKILLS:

DBA and Database Infrastructure Engineer/Architect, Service Oriented Architecture (SOA), ETL (Dealing withData in in multiple formats, in different locations, from a variety of sources

Providing quality and integrity of available data for ease of access and analysis)

AWS Migration

EXPERIENCE:

THERAP SERVCIES LLC

Database Solutions Architect/Senior DBA Feb 2016 – Jun 14, 2017

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

Updatable views and db links.

GTECH

Senior Oracle DBA (Consulting ) Jan 2015– Feb 2016

Build Disaster recovery Site for RAC ONE Oracle with DATAGUARD On standalone.

Provides Day to Day Support of the existing Enterprise wide Oracle Environment.

Introduced Monitoring tools in order to proactively resolve issues.

Installed and configured Oracle Advanced Security Features: Oracle Database Vault with Transparent Data Encryption

Upgraded Oracle 11gR2 to Oracle 12c Pluggable Database (PDB) in Multitenant Architecture using Transportable Tablespace (TTS) method

BNY CONVERGEX LLP, New York Sept 2007 – Nov 2014

Vice President, DBA/Architect

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

Organized a 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.

Support Developer teams and End Users in developing,, troubleshooting, and tuning queries and applications.

Implemented Table Partitioning for MS SQLSERVER 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.

BLOOMBERG LP, New York April 2003 – Sept 2007

Trading Systems Database Systems Group, R&D – Senior Oracle DBA/Architect

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 database and applications..

Database Engineering Team, Database Systems Group, R&D – Senior Oracle DBA

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.

Peoples Bank, Bridgeport, Connecticut July 2002 – Apr 2003

Information Technology Department – Lead Oracle Database Administrator

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 HA project 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.

Merrill Lynch & Co., Inc. August 1998- Dec 2001

Enterprise Oracle Database Administrator, Technology Infrastructure Services - Vice President, DBA

Global Database Support Group (3/1999 – 2/2001)

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

Application Infrastructure Group (8/1998-3/1999)

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 Merrill Lynch as a Liaison to Oracle Corporation.

Implemented multi-master replication for geographically distributed Oracle database.

CBS News Corporation February 1998 - August 1998

Senior Technical Architect, DBA, New Media Division

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 www.cbsnow.com 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.

Oracle Corporation Mar 1997 - Feb 1998

Senior Consultant, DBA - NY Metro Area Consulting Unit

DBA and Web Server Administrator – CBS NEWS CORPORATION

Built instances of Oracle databases and web servers (test, benchmark and production)

for CBS Personal News web site: www.cbsnow.com

DBA, CHASE MANHATTAN BANK, New York

Migrated Oracle 6 to Oracle 7 on VAX VMS platform.

DBA, CANON USA, New York

Supported Production In 8 node OPS environment; implemented Oracle Alert Messaging.

DBA, WERNER MUSIC, New York

Implemented symmetric replication for distributed Data bases (7.3 in NY – 7.16 in LA)

Societe Generale Securities Corporation, N.Y. June 1994 - March 1997

Applications Manager, DBA, Systems Development Department

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.

Production Manager, DBA, Systems Development Department

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.

SAI (Securities Applications Inc.), N.Y. Nov. 1993 - May 1994

Senior Software Engineer, Software Development Department

For security application produced front-end GUI (JAM/JAYCC) interface

Implemented Source Code Control (SCCS)

AT&T, Consultant (PARAGON CONSULTING Employee), New Jersey May 1992 - Oct 1993

General Ledger Software Department

Ported Financial Information Tracking System from Mainframe to Pyramid S7080.

CCS (Consumer Communications Systems) Department

Implemented several releases of the WCC (Why Customers Call)

Citibank, N.A., Assistant Manager, Systems & Technology April 1985 – Dec. 1991

Systems Programmer Analyst, Branch Automation Department

Developed a general purpose Monitoring utility, implemented as a continuous background process using inter -process communication, message queues and shared memory.

Implemented utility to format transaction reports from Mainframe (IBM) files for Unix Platform (NCR).

Developed a Security Subsystem, which allowed the system administrator to create different application roles functions and grant them to designated persons.

RELATED OTHER EXPERICENCE Jun 2015 – Nov 21015

HSBC, Senior Compliance Officer, Data Governance Department (contract)

Streamlined and performed a number of Data Reconciliation Processes between the source extract files and the Compliance Database.

EDUCATION

M.S. Physics/Mathematics, Tbilisi State University, Republic of Georgia.

Certificate Yeshiva University, Computer Training Institute, New York

MANGEMENT SKILLS:

Managed throughout 20+ years of IT Career, Teams of Production DBA’s and Developers.

Experienced in All phases of project management, Track record of Delivering successful Projects On time and within the budget.

Facilitated weekly department manager meetings and participate in project reviews. Conduct quarterly one-on-one meetings to review performance and goals. Initiate, foster, and support a positive, effective working relationship between Business Units and IT technical support personnel. Provide input to Engineering Projects and participate in design reviews.

Manage Technical Services budgets for both headcount and operating expenses.

Ensure processes are aligned to support Enterprise Wide Business Continuity Policies.

NASI ASAPOVA Page

Contact this candidate