SUMMARY:

• Highly successful Technical Specialist with extensive IT SDLC experience focused on leading and managing strategic and complex programs/projects
• EXADATA X4 - 2/X8-2: EXADATA CELL SERVER, INFINITBAND, ILOM, PDU, CELLCLI, DCLI, HCC, SMART SCAN, SMART FLSH CACHE, STORAGE INDEX, RAC, RMAN, ASM, ACFS, ASR, OEDA, PATCHING/UPGRADE, IORM and support Platinum Team for EXADATA patching
• 11gR2/12c/19c RAC Architecture, Installation, Failover and configure using ASM, SCAN, IP, SERVICE, VIP, Interconnect, ACFS, OCR and Voting disk
• Architecture, Installation, Administration of Data Guard 11gR2/19c (EXADATA and NON-EXADATA)
• Support ZFS storage for RMAN backup and Golden Gate Replication
• Architecture, Setup and Administration Golden Gate 11/19 (Classic/ Integrated) replications using ACFS and NAS/ZFS
• Installation, Configuration of OEM13c/Agent/Discovery/Monitoring of EXADATA/ZFS
• Architecture, Installation, Configuration and Upgrade Oracle 8/9.2/10gR2/11gR2/12c/19c.3 on Linux, HP UNIX, Sun Solaris, AIX and NT/2000 platforms for OLTP, DSS and Hybrid databases
• Experience software development technologies including Oracle, MS-SQL Servers, SYBASE, MYSQL PL/SQL, SQL, ETL, Unix, Linux, Windows and full SDLC application development methodologies.
• Security administration, GUARDIUM use for PCI/SOX compliance and Auditing
• Database Support for Hadoop Big Data, AWS, Aurora PostgreSQL, Flyway DB/Bamboo, JIRA, Oracle Application Server, SAP, People soft, Siebel and Web Sphere
• Installation configuration and setup of Oracle Unbreakable Linux and Red hat Linux
• Installation, configure and administration of SQL Server 2005/8/14
• Installation, configure and administration of Sybase ASE 12/15
• Installation, configure and administration of MYSQL 5.x
• Managed projects include application development, business requirements, systems specification, systems integration, Quality Assurance testing, User Acceptance Testing, Business Readiness Testing, systems performance and architecture, software delivery and implementation services, business and process improvements, business change management, software release management and vendor selection, vendor management, systems and managed operations, and Methods and Procedures.

TECHNICAL SKILLS:

OS: HP UNIX, Solaris, Linux (Red Hat/Unbreakable/SUSE), AIX, VMware & Windows

RDBMS: Oracle 7.3/8/9i/10g/11gR2/12c/19c, SQL Server 2002/5/8/14, SYBASE ASE 12/15 and MYSQL 5.x

Tools: Grid control, RMAN, EMC SRDF, Golden Gate, PL/SQL, LDAP, AWR, T-SQL, INFORMATICA 5/6, Web logic, TOAD, PVCS, Visio, Win Runner, Erwin, Apache/Web sphere, JIRA, Confluence, Nagios, SolarWinds and Flyway database

Job Scheduler: AUTOSYS (CA), Control M (BMC), Tivoli Job Scheduler (IBM)

PL/SQL programming: Unix SHELL Scripts, Perl, XML, AWK, JAVA

Oracle data warehouse: with terabyte database, ETL Process/tool, Real-time Data Transfer, Data loading, DB monitoring, Performance tuning, Partitioning, DB Cloning

Oracle Certified DBA: OCA/OCP 10gR2/11g, RAC/ASM 11g expert

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. ORACLE DBA

Responsibilities:

• Create OEDA for EXADATA X4-2/X8-2 RAC (Eight/Quarter Rack) for platinum Team to install Oracle 2 node RAC database (11gR2/19c)
• Setup DR (using Data Guard) for EXADATA and NON-EXADATA databases 11gR2/19c
• DR and Application testing using Active Data Guard and Snapshot Standby database with Flashback Technology
• Install and Administration of OEM13c/Agent/EXADATA/ZFS monitoring
• Installation of Integrated/Classic Golden Gate for Container and NON-container database (Extract/Pump/Replicate) using ZFS/ACFS (using Flex ASM)
• Encryption: setup network encryption, tablespace encryption and RMAN backup encryption
• RMAN backup and restore of database using ZFS storage/OEM13c
• Evaluate and apply Oracle Database/Grid/CELL/IB Software patches or upgrades
• Monitoring and administration Cell desk, grid disk, Cell Flash cache, Flash disks, CellSrv, RS, MS (cellcli, dcli)
• Manage software release planning including user requirements development and prioritization, development estimates, system specification, and 24x7 support.

Confidential, NY

Sr. ORACLE DBA

Responsibilities:

• Installed, architecture, configured and maintained Oracle 11gR2 Real Application Cluster (RAC) on Unbreakable Linux 6 using SCAN, Services IP, VIP, Interconnect and ASM
• Architecture, design, migration and configuration Single instance database and Data Guard 11gR2 using ASM, Data Guard Broker and Grid control
• Configuration and administration of ASM Disk Groups, add/drop disks and rebalance operation
• Apply patches/patch set in production databases and upgrade the databases (ORACLE/MySQL/MSSQL)
• MySQL/MSSQL - Installation, configuration, administration and Replication/mirror. Database creation, User Management, backup/recovery, Tuning and production support
• Managed program activities including work pipeline, project staffing, project reviews, project financials (revenue, margins, and profitability), resource utilization, customer relationship, program status reporting, solution architecture support, services estimation and pricing, work order development, and change management.
• Supervise all aspects of the assigned team including day-to-day supervision, performance evaluation, and assignment to IT Projects and/or Production Support functions, On-call responsibilities on a rotation basis to cover 7/24 DBA support

Confidential, NY

Sr. ORACLE DBA

Responsibilities:

• Architecture, design, migration and configuration Single instance database and Data Guard 10gR2/11gR2 using ASM, Data Guard Broker and Grid control
• Support Oracle Active/Passive setup using VCS, Clone the Oracle Home, database and Upgrade the database
• Perform database recoveries using either Oracle backup and recovery tools (RMAN, Data Pump, Export/Import or Veritas NetBackup)
• Apply patches/patch set in production databases as well as clustered databases
• Capacity planning for database growth, CPU and memory and Database/Memory/OS tuning and SQL tuning
• Install and admiration ASM like add/drop ASM disks and monitor rebalance operation
• Collaborate with the Software Maintenance Organization to conduct knowledge transfer sessions and hand-off the software from development/delivery to Application Support
• Assignment to IT Projects and/or Production Support functions and supervise all aspects of the assigned team including day-to-day supervision, performance evaluation and 24x7 DBA support

Confidential, NY

Lead Oracle DBA

Responsibilities:

• Installed, Architect, Configured, Documentation and Maintained Enterprise Manager/Grid control 11gR2 (RAC and Non-RAC)
• Setup and Tuning of Stream, Snapshot, RAC, non-RAC database, ASM, Services, assists in the evaluation, recommendation and standardization/Best practice of new database technology and services within the database environment and day-to-day trouble shooting
• Upgrades, apply patches, provides troubleshooting support and according to the SLA and provided 24x7 on call support for production databases as well as clustered databases
• Open SR for Hardware/Software vendors support teams to escalate problems and work with them
• Maintenance of database objects like rebuilding indexes, add/drop/split partitions and refresh materialized view
• RAC specific tuning parameter: ITL (INDEX) and Sequence (CACHE and NOORDER)
• Supervise all aspects of the assigned team including day-to-day supervision, performance evaluation, and assignment to IT Projects and/or Production Support functions, On-call responsibilities on a rotation basis to cover 7/24 DBA support

Confidential, NJ

Lead Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 10gR2 Real Application Cluster (RAC) on Red Hat 5 Linux (2 nodes) for high transactional production environment
• Clone the Oracle Home, database and Upgrade the database
• Making Changes to database schema as per requirements of System Design, Creating Table spaces, Tables, Synonyms, Indexes, Materialize view and Partition etc for DSS & OLTP databases
• Guided development teams in data transformation and mapping from various sources to data warehouse databases.
• Golden Gate replication (Installation, configuration, monitor and troubleshoot) and SIPERIAN (Master Data Management) support
• Using GUARANTEE FLASHBACK DATABASE test, the application release and rollback
• Assists the managers and Database Architect with on-going solution improvements and technology strategy enhancements that drive lower cost, faster delivery, and greater reliability.
• Leads and participates in the development of database standards/best practices/documentation/monitoring script for the organization
• Delivers quality root cause analysis (RCA) and timely follow through on corrective action plans, documentation and communication with managers
• Modify and setup IP, VIP, Interconnect, Setup backup for OCR/Voting disk for RAC

Confidential, Jersey City

Sr. ORACLE DBA

Responsibilities:

• Worked with application team to design and implement data warehouse databases including OLTP, ETL process, DSS applications.
• Support for Fix Income, Equities and Prime Brokerage production/Development databases
• Stream setup, troubleshooting and monitoring for 9i and 10g databases
• Installed and Configured Automatic Storage Management (ASM)
• Clone Oracle Home, ASM Home and duplicate database using RMAN
• Move db server (SAN and Server) to new location using Data Guard 10gR2 and ASM
• POC of Active Data Guard 11g for Disaster recovery setup
• Participates in on-call (SQL Server), overnight off-hour production problem resolution activities.
• Developed and maintained a set of UNIX shell scripts/tools and set up in Oracle cron job for daily Oracle database administration tasks including DB monitoring, RMAN backup, automatic startup/shutdown, DB reports, logs purging, table space monitoring.

Confidential, NY

Sr. ORACLE DBA

Responsibilities:

• ORACLE 10gR2 RAC HA Testing, Troubleshoot and documentation
• Tune RMAN script for backup in RAC environment and setup Net Backup for Tape backup
• Installation, configuration and implement Grid control OMS server and Agent
• Tuning, backup, ETL, Security, Partitioning, logical/physical layout and administration of Data warehouse database (20 TB)
• Installation, configuration and implement Data Guard 10gR2
• Setup and administration of bi-direction streams
• Installation, setup, monitor, upgrade, troubleshoot and Supported Golden Gate (9.0) replication for RAC environment
• Configure Matrices, Rules, Alerts and Reports using Grid Control
• Installation, configure and administration of SQL Server 7/2000
• Supported PCI complain audit project and GUARDIUM tools for monitor Network
• EXADATA V1 HP Server (ProLiant DL 180) Full and Half RACK setup - EXADATA Hybrid column compression, Smart scanning, Smart Flash cache, Storage Index, RMAN, ASM and DBRM.

Confidential, NY

Sr. ORACLE DBA

Responsibilities:

• Installed, configured and maintained Oracle 10gR2 Real Application Cluster (RAC) on HP-UNIX (2 nodes) and Linux (2 nodes) for OLTP & DSS production environment
• Modify and setup IP, VIP, Interconnect, Setup backup for OCR and Voting disk for RAC
• Set up and maintained oracle disaster recovery site using Data Guard 10gR2. Develop and implement RMAN backup using VERITAS NETBACKUP
• Created and maintained different database entities included table spaces, data files; redo log files, rollback segments and renaming/relocating of data files on servers.
• Installed and configured 10gR2 Enterprise Manager Grid Control. Create a auto partition script to maintain the Add, Spilt and Drop partition for DSS & OLTP
• Convert 32-bit word size to 64-bit word size for Oracle database on Linux. Setup, administration and maintenance of Schema level Stream. Design, Administrate and tuning XML database
• Developed and maintained a set of UNIX shell scripts/tools and set up in Oracle cron job for daily Oracle database administration tasks including DB monitoring, RMAN backup, automatic startup/shutdown, DB reports, logs purging, table space monitoring.