SUMMARY:

• Have an expertise in building multi - tier enterprise system architecture for global heavy distributed systems with millions of Internet users per day with the greatest performance
• (a few hundred milliseconds per request).
• Have knowledge to prevent any database loaded with high volume capacity from crashing and bad performance.
• Expertize in Data Architecture, Data Modeling, Database Design for globally distributed multi-tier environment.
• Implemented multiple performance improvements and decreased company expenses.
• Had multiple assignments (after databases with high volume were crashed) to increase their performance, scalability, resilience.
• Have a key strength in efficient design and integration of big volume (tens of TB) distributed data sources with ability to operate on multiple platforms and operating systems
• (Windows, Mac OS X, Unix, LINUX (Red Hat, Ubuntu), Mainframe (z/OS, z/VM).
• Providing support of Oracle Databases 12c/11g/10g on Unix/Linux, Windows OS.
• Utilizing different OS Systems: Red Hat Linux, Ubuntu Linux, Oracle Linux 6, 7, z/OS, z/VM, Windows.
• Installation and configuration of Oracle 10g, 11g, 12c on LINUX and Windows environment.
• Installed Oracle 12c Databases with Clusterware on Flex Clusters (leaf and hub nodes).
• Upgrading databases (10g R2 to 11g, 11gR2 to 12cR1).
• Experience with Oracle GRID architecture (Oracle Clusterware, ASM), and Real Application Clusters (RAC).
• Installation, configuration, upgrade and performance tuning of Oracle RAC databases.
• Experiencing on ASM Storage and Clusterware technologies.
• Performing Oracle Databases backup and recovery by RMAN and Oracle EM features.
• Tuning databases, PL/SQL tuning using explain plan, hints, SQL profiling to optimize the SQL statements, utilizing Confidential tuning features.
• Planned and implemented high availability solutions for primary DB on RAC using Standby Database and Oracle Data Guard for Oracle DB 12c, 11g on RAC.
• Using and supporting Oracle data guard for physical standby databases.
• Installing, configuring Oracle Golden Gate (ETL, Propagator, and Data Integration system), troubleshooting Confidential issues.
• Moving and combining large volumes of transactional data from different Oracle and non-Oracle databases by Golden Gates with minimal impact to on-line systems.
• Implemented Oracle Real Application Clusters (RAC) for an OLTP applications with high transaction volume.
• Making logical and physical database design.
• Managing of schema objects.
• Creating and partitioning indexes and tables.
• Implemented DB patches, performance tuning, script development.
• Performed DB Cloning, installation, troubleshooted issues/errors/alerts/incidents.
• Supporting replication with snapshots, Materialized Views and Streams.
• Experience in using Confidential, and Data Migrations using Data Pump export/import.
• Configuring DB Links for users located remotely.
• Utilizing Oracle Database features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Understanding about Exadata specified features: Smart Scan, HCC Hybrid Columnar Compression, Smart Flash Cache, OIRM, Storage Index.
• Installation, configuration, support as DBA for nonSQL MongoDB (versions 2.4/3.4) databases.
• Configuring Mongo Replication Sets and data auto-sharding.
• Performing Mongo performance tuning and day-to-day routines.
• Performing backup and restore of database by Mongodump and Mongorestore.
• Manage Teradata Databases, monitor the system performance and make tuning changes.
• For Teradata Database recommended most cost effective design and architecture solutions.
• Utilizing and configuring Oracle Golden Gates system for replication of big volume Teradata.
• Experience in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Configure Exadata to meet security requirements.
• Prepared capacity planning, and documentation.
• Implementing PL/SQL queries, stored procedures, triggers, functions, packagesUNIX Shell Scripting.

TECHNICAL SKILLS:

OS: z/OS, z/VM, UNIX, LINUX (Red Hat 3, 4, 5, Oracle, Ubuntu)Windows, Mac OS X, Oracle Virtual Machines (VM)

DATABASES: Oracle 10g, 11g, 12c; DB2 V9, V10, Teradata, UDB;

MongoDB (NoSQL, Big Data); MySQL; MS Access; MS Excel:

DB Management: Oracle Enterprise Manager Confidential 10g,11g,12c GRID control RAC

Tuning and Monitoring: RAC 11gR1/R2, RAC 12c, Data Guard 10g/11g, DB CloningStandby Databases, RMAN 10g/11g/12c, TKPROFEXPLAIN PLAN, STATSPACK, AWR, ADDMPlatinum Detector, DB2 Omegamon, DB2-PM

DB Tools and Utilities: Oracle Enterprise Manager ( Confidential )Database Configuration Assistant (DBCA)Database Update Assistant (DBUA)Oracle Universal Installer (OUI)SQL*Loader (SQLLDR), Recovery Manager (RMAN), Data PumpLog Miner, Golden Gate, Putty, WinSCP, ASMCA, Netmgr, NETCAMongoDB Replication Set; MongoDB Data ShardingMongodump, Mongorestore, Hadoop IBM Load Utilities, BMC Utilities, IBM Propagator, RC UpdateDB2 Connect, Work Load Manager (WLM), QMF, SPUFIDB2 Data Sharing

DB Modeling Tools: Erwin, Bpwin, CASE, MS Visio

DB Languages: SQL, Native, PL/SQL, SQL*Plus

Other Languages: XML, HTML, UNIX Shells, Ruby, Python, Easytrieve+, SAS, SPSSCobol II, PL/1, CICS, JCL

Development Tools: SQL Developer, MySQL, Intertest, Xpediter

Testing Tools: Proterm, JMeter

Other Packages: FTP, TCP/IP, MQ Series, WebSphere, VSAM, Endevor, File AidMVS Utilities, CICSPLEX, MQ Sharing

Methodologies: SDLC, Agile (SCRUM), Waterfall

Application Suites: Adobe Acrobat, MS Office, Project

EXPERIENCE:

Confidential, Newtown, PA

Consultant Oracle Data Base Architect / Oracle Database Admin

Responsibilities:

• Installing Oracle Virtual Machines (VM Box).
• Installing Oracle GRID (Clusterware and ASM) for Flex Clusters consist leaf and hub nodes.
• Configuring Automatic Storage Management (ASM) on LINUX RHEL (Red Hat).
• Setting up Public, VIP, SCAN, and Private IP addresses utilizing DNS for hub nodes.
• Installing Oracle RAC 12cR1 for multiple instances.
• Installing Oracle Enterprise Manager ( Confidential ) and Agent for Oracle RAC GRID Control.
• Creating tables and indexes (using Erwin), views, users, roles, privileges, sequences, synonyms, packages.
• Tuning new databases using SQL profiling and Confidential tuning features for the best performance.
• Making Physical Standby database on RAC - ASM and Clusterware architecture.
• Setting recovery and back up processes by Confidential .
• Made day-to-day database jobs and processes schedule by Confidential .

Environment: ORACLE, Erwin, SQL*Plus, Confidential 12c, Red Hat Linux, RAC, Data Guard, ASM, PL/SQL, RMAN, Confidential GRID.

Confidential, Paramus, NJ

Consultant / Oracle Data Base Architect / Oracle Database Admin

Responsibilities:

• Installed, configured and maintained Oracle 12c, 11g, and 10g Databases.
• Installed and configured Confidential Grid Control architecture.
• Installed and configured Oracle Golden Gate system.
• Oracle Database gets Customer Profile data from DB2 database by Oracle Golden Gate system.
• Upgrading Oracle Golden Gate from 11g to 12c in RAC environment.
• Implement Golden Gate HA solutions using Oracle Clusterware functionality.
• Oracle 11g, 12c GRID Architecture uses three clusters of four servers each: for Storage Servers with Automatic Storage Management (ASM) and Clusterware, Database Servers with Real Application Clusters (RAC), Application Servers.
• Control of the Oracle RAC Environment administer by Oracle Enterprise Manager Grid Control.
• The described above system is operational 24 by 7.
• The system provides high reliability, scalability, resilience, and performance.
• Establishing standards, policies and procedures for Golden Gate replication administration.
• Managing, troubleshooting and resolving Oracle databases, RAC and applications issues.
• Installing Confidential Grid Control to monitor all databases.
• Implemented views, procedures, functions, packages, triggers.
• Implemented scripts and reports using SQL, PL/SQL.
• Designed and implemented Oracle Real Application Clusters (RAC) with AMS Storage and Clusterware for an OLTP applications with high transaction volume.
• Established best practices and best procedures for database administration.
• Responsible for SDLC support to include migration of all custom application changes through test to production instances.
• Manage Standby Database (Data Guard), make setup and configure DB links.
• Implemented multiple instances on RAC environments for high volume database and implemented Data Guard on RAC environment with another RAC Standby Database.
• Monitored, managed multiple instances of RAC databases using Confidential Grid Control.
• Implemented Database backup and recovery by RMAN, Confidential .
• Enabling and analyzing trace files.
• Performing DB monitoring and performance tuning.
• Defining and setting database backup and recovery procedures.
• Performed and tuned Oracle databases using AWR, Confidential Grid Control, and tkprof.
• Tuning the database using statspack and monitoring it by utilizing custom scripts, Confidential features.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics for non ASM databases.
• Experienced in Tuning SQL statements using Explain Plan, SQL profiling, hints, SQL Trace, TKPROF and STATSPACK.
• Performing Shell Scripts for managing day-to-day activities and automation of database backup.
• Using tables and indexes partitions to improve the query performance and manageability.
• Installed SQL and PL/SQL Packages, triggers.
• Performed database multiple volume and stress tests and tuning.
• Mapping Teradata DB tables across Oracle Databases for transmission across servers.
• Investigating session locks, performance issues, monitoring Database sizing.
• Resolving session blocking and locking instance issues.
• Periodically check Database top session usage: top consumers, top activity, physical I/O.
• Checking frequency of log switch.
• Assisted CPS team for optimizing of stored procedures.
• Worked on projects for Origin Package Delivery OPLD and International Data Movement OPSYS.
• Installed and configured MongoDB as a pilot system on Linux Redhat OS.
• Converted OPLD system 36 RDBMS tables to noSQL MongoDB to one document oriented JSON format document.
• Loaded 10 millions rows from original tables for pilot test.
• Presented to upper management performance, scalability, easy maintenance, resilience advantages of pilot version of MongoDB (NoSQL, Big Data).
• Checking and resolving alert log errors. Investigated and resolved failed, broken, chain stalled DBMS jobs.
• Detecting and resolving lock objects. Checking sessions using rollback segments.
• Checking chaining and migrated rows.
• Participated in SDLC project for In-Transit Intercept System utilizing MQ Series for Mainframe - Linux interface (LINUX, ORACLE, PL/SQL DB2, Erwin, Detector, MQ Series, XML,).
• Made Logical Design of new Oracle Data Base for ITI System.
• Getting and analyzing DB statistics. Checking and improving DB start up time.
• Checking frequently pinned objects.
• Analyzing frequency of objects reloaded in memory and re-sizing memory.
• Finding and fixing if needed invalid objects in Oracle Database.
• Providing Database size analysis.
• Finding and removing not used indexes.

Environment: ORACLE, MongoDB, Teradata, SQL*Plus, Confidential 11g/12c, Red Hat Linux 4.x, RAC, Data Guard, Golden Gate, ASM, PL/SQL, RMAN, Confidential GRID.

Confidential, Franklin Lakes, NJ

Consultant / Database Architect

Responsibilities:

• Utilizing Oracle 11g Grid Infrastructure, Clusterware, ASM, RAC, Active Data Guard on RAC environment.
• Architecture, planning, designing, developing, deploying and supporting Oracle 11gR2 CRS, ASM, and RAC environment.
• Installation, configuration Oracle Grid Infrastructure (ASM and Clusterware), Voting Disk, OCR.
• Database software troubleshooting, handling common issues that arise during integration of the whole database: bugs, network issues, configuration files issues, OCR and Voting Disk issues.
• Worked with customer for different RAC related issues such as hang check, split brainRAC recovery, ASM, OCR corruptions, Voting disk loss.
• Backup and Recovery issues related loss of OCR, Voting Disk and Oracle Clusterware, also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Upgrading 11gR1 RAC database to 11gR2 RAC database.
• Made design and Implementation of new Database “Prescriber Load and Specialty Codes” for new strategic client.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Setting up High Availability Oracle Golden Gate Confidential systems on Oracle 11gR2 RAC environments: Oracle Exadata X3 Full Rack.
• Installation, configuration, support as DBA MongoDB (NoSQL, Big Data ) databases.
• Configuring Mongo Replication Sets and auto data sharding.
• Performing Mongo performance tuning and day-to-day routines.
• Performing backup and restore of database by Mongodump and Mongorestore.
• Manage Teradata Databases, monitor the system performance and make tuning changes.
• For Teradata Database recommended most cost effective design and architecture solutions.
• Utilizing and configuring Oracle Golden Gates system for replication of big volume Teradata.
• Was supporting production and development Databases Shoe-Box System, Lag System, Brand-Generic & Marketing Analysis System.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Environment: IBM z/OS, Oracle 11gR1/11gR2, MongoDB 2.4/3,4, RHEL AS 5, SQL * Plus, Confidential, Erwin Data Modeler, Teradata, Exadata X3, Confidential, Erwin.

Confidential, NY, NY

Data Base Architect - Consultant

Responsibilities:

• Participated in logical and physical design, development of Forensic Identification Database for identification of missing victims 9/11/2001 at World Trade Center. System utilized multi-platform Data Bases.
• Implemented ETL procedures to provide data exchange between multi-tier environments.
• System allowed direct access to database for OCME and Health Department professionals.
• It produced special on-line request forms used by medical employees.

Confidential, Newark, NJ

Data Base Architect - Consultant

Responsibilities:

• Implemented logical and physical design with star schema elements for new Repository Assessment data warehouse. It was used DW modeling for demand planning, forecasting, marketing management tasks. Evaluated of ETL tools, responsible for proper documentation and presentation materials.
• Analyzed the user requirements and designed views using STAR schema for improving performance of Data Marts.
• Implemented OLAP - dynamic multidimensional analysis of intelligent data. Wrote Data Mining components: association, factor analysis, clustering, classification, prediction - trend. Integrated metadata of Repository DW. Made data scope definition and collection of business requirements.
• Built the unix - mainframe OS Data Base Warehouse. Implemented Object Oriented design.
• Designed, developed multiple HTML on-line forms connected via WebSphere to mainframe.