SHABBIR BHINDARWALA

USA Citizen, Email:adboyk@r.postjobfree.com

Looking for Oracle DBA position in NewYorkCity, JerseyCity, NJ

PROFESSIONAL SUMMARY

●Wide-ranging experience in Database Administration(14+years in Citigroup) supporting mission critical applications in Oracle 18c, 12cRac, 11gRac,10gRac 9iRac, 8iOps, 7.x on Unix/Linux/Windows. Senior Application Programmer working with SQL, PL/SQL, Unix Shell Scripting, Oracle Forms and Reports.

●Able to work very well independently or as part of a team environment, full understanding of the Full Life Cycle, able to actively participate in meetings and make critical decisions, as well as work under tight deadlines and under pressure.

●Experience in Large 30+ Tb Databases.

●Strong experience in Unix/Linux shell scripts, awk, sed, sar, iostat, netstat

●Also worked on MSSqlServer Database, SqlServer Replication, LogShipping

●Used Oracle OS watcher to monitor Unix i/o, cpu, memory, top process, network, interconnect for RAC

●Used Enterprise Manager, SqlDeveloper, DBArtisan, Toad, SQL Navigator

●Worked on ASM, Dataguard, Physical/Logical Standby, DataPump, Export/ Import, SQL*Loader

●Golden Gate, Advanced Replication, Streams, Materialized Views, Advance Queue, Distributed Transaction

●Partitioning, Parallel Query, Rebuilding Tables/Indexes

●RMAN, Hotbackup, Flashback, Crontab, AutoSys, Iwatch

●PL/SQL, Packages, Stored Procedures, Functions and Database Triggers

●Installed and monitored Listener, Names Server, dbsnmp agent.

●Worked on Security Administration, Roles, Profiles, Grants, Synonyms.

●Experience in Developer/2000 (Forms 4.5, Reports 2.5), Pro*C, PL/SQL and SQL*Forms 3.0, SQL*DBA, SQL*Loader, Dynamic SQL using DBMS_SQL, Report Writer 1.1

●Worked on Process Modeling and ER modeling, and prepared system requirement specification documents

●Worked on a wide variety of business applications including ERP, Banking, Sales, Material Management in Finance, Insurance, Manufacturing and Trading Industries.

TECHNICAL SKILLS:

Software: Oracle 18c, 12cRac, 11gRac, 10gRac, 9iRac, 8i /7.x / 6.0, Golden Gate Personal Oracle7.3, MSSqlServer, Dev/2000 (Forms 4.5, Reports 2.5),SQL*Menu 5.0, Oracle Graphics 2.5, Pro*C, SQL*Forms 3.0, Report Writer 1.1, SQL*Plus 3.2, PL/SQL 2.0, SQL*Loader, SQL*DBA, UNIX, C, Cobol, FoxPro 2.0, dBase III Plus, Lotus, VP-Planner.

Tools: Enterprise Mgr, Grid Control, ASM, RMAN, DataPump, Toad, Streams, AutoSys, Iwatch.

OS/Hardware: Linux RedHat, Aix, Sun Solaris, HP Unix, Novell-NetWare, SCO Unix Sys, Windows NT 4.0,

MS DOS on Compaq Proliant 4500, HCL Mini Horizon II, Windows 95, MS Windows 3.11, MS DOS on IBM compatible AT&T, Pentium

EDUCATION

· Honors Diploma in Systems Management, NIIT, Bombay, India, 1991

· Bachelor degree in Commerce, Bombay University, India, 1988

PROFESSIONAL EXPERIENCE:

Mizuho Japanese Bank JerseyCity(NewPort) NJ Dec 2018 – Till Date

Sr. Oracle Database Administrator

Project: Flexcube, others

Working on multiple mission critical projects. Dataguard, ASM Storage, Migration 12c to 18c.

Responsibilities:

●Active DataGuard setup.

●Configure, implement ASM, RMAN.

●Monitor, maintain and tuning of Oracle 12c, 18c RAC Databases.

●Working with Application team on various application sql tuning and releases.

●Disaster Recovery Testing.

●Developing and implementing shell scripts.

JPMorganChase JerseyCity(NewPort) NJ Oct 2017 – Jul 2018

Sr. Oracle Database Administrator

Project: GTI

Worked on multiple mission critical projects. ASM Storage Migration projects for more than 300 Servers. Projects to move ocr and voting disk from non asm to asm. Projects to move manual standby to DataGuard.

Responsibilities:

●Migration of ASM Storage on Oracle 12cRAC, 11gRAC 20+Tb Databases.

●Configure, implement ASM, RMAN, DataGuard.

●Using OEM, shell scripts to monitor and maintain Databases.

●Database tuning and working with Application team on various application sql tuning and releases.

●Migration of 15TB Database from one datacenter to another.

●Setting and maintaining Oracle Goldengate on Aix

●Cob Testing for Disaster Recovery.

●Developing and implementing shell scripts.

Citigroup JerseyCity(NewPort) NJ Feb 2010 – Sep 2017

Sr. Oracle Database Administrator

Project: CitiDirect, CAS, Mart, BE, Teamtrack

Worked on multiple mission critical projects. CitiDirect, CAS, Mart, BE are all global banking projects with thousands of users accessing from 100s of countries globally round the clock. Teamtrack is an internal Issue tracking system. All these projects are 24 by 7 with contingency site (standby database).

Responsibilities:

●Migration of 15TB Database on Oracle 9.2.0.8 on Sun Solaris 10 to Oracle 10.2.0.4 on AIX 6.1

●Migration of 30TB Database on Oracle 10.2.0.4 on AIX 6.1 to Oracle 11.2.0.4 on AIX 7.1

●Migration of 9i client on all application servers to 10g client

●Upgrade Databases from 11gRac to 12cRac.

●Database and Sql Tuning.

●Install, configure, implement ASM, RMAN, DataGuard

●Using OEM to monitor and maintain Databases.

●Install, configure, implement Oracle Goldengate on Solaris and Aix

●Purging of Payment application data

●Working with Application team on various application releases.

●Cob Testing for Disaster Recovery.

●Developing and implementing shell scripts and pl/sqls to compare goldengate replication regular and lob data, schema structures.

●Install, configure, implement MSSqlServer Standby Database using Log Shipping.

●SqlServer Migration from SqlServer5 to SqlServer8.

●Configure and implement SqlServer Master to Master Replication.

AXA Financial Inc. JerseyCity(NewPort) NJ Mar 2009 – Feb 2010

Oracle Database Administrator

Project: Enterprise Infrastructure Services

AXA Financial Inc. is a leading financial protection company and a premier provider of life insurance, annuity, and investment products and services. It is a part of the global AXA Group, a worldwide leader in financial protection strategies and wealth management. AXA Group’s operations are geographically diverse, with major operations in Europe, North America, and the Asia/Pacific region. It has been helping clients for 150 years.

Responsibilities Included:

●Database administration of Oracle 11gRAC, 10gRAC on Linux

●Creating, maintaining ASM Group.

●Working on Oracle Clusterware in 11g RAC

●Creating, maintaining databases.

●Tuning, troubleshooting databases.

●Maintain/worked on database files, Export files, Rman files.

●Using OEM to monitor and maintain Databases.

●Stabilizing backup, monitoring, and operating environments.

●Setting up scripts and proactive maintenance to ensure smooth production operations.

Fxall - Foreign Exchange Alliance NewYork NY Apr 2007 – Mar 2009

Oracle Database Administrator

Project: Enterprise Infrastructure Services

FxAll is the leading provider of automated trading and workflow solutions for foreign exchange and treasury products. FXall has offices in New York, Boston, London, Singapore, Tokyo and Sydney works with more than 700 clients from around the world. Through its network of global liquidity providers, it offers liquidity in some 300 major and minor currency pairs, and their trading and research services are available in more than 60 countries worldwide.

Responsibilities Included:

●Installing, Upgrading, Patching Oracle 10gRAC, 9iRAC, 8i software on Linux.

●Creating, maintaining, tuning, troubleshooting databases.

●Maintain/work database files, Export files, Rman files on OCFS

●Database migrations to Linux/RAC for Reporting Databases.

●Create procedures for DataGuard database & BCVs that supports key COB initiatives.

●Working on Materialized Views, Parallel Query, DataPump, Advance Queues, Distributed Transaction

●Using Oracle OS watcher, Swingbench.

●Migration from Oracle RAC 10.2.0.1 to 10.2.0.4.

●Working on GridControl, ASM, Oracle Clusterware in 11g RAC

●Supporting Fxall teams to improve stability, availability, rollout of Fxall applications.

●Participating in security engineering of the FXall trading platform.

●Stabilizing backup, monitoring, and operating environments.

●Setting up scripts and proactive maintenance to ensure smooth production operations.

●DST Oracle patch rollout, Partitioning

Lehman Brothers JerseyCity(NewPort) NJ Jul 2006 – Apr 2007

Oracle Database Administrator

Project: Enterprise Architecture Services

Enterprise Architecture Services includes 72 projects. I was managing around 20 projects, providing 24*7 support to global users accessing round the clock.

Responsibilities:

●Installing, Upgrading, Patching Oracle 10g, 9i, 8i software.

●Creating, maintaining, tuning, troubleshooting databases.

●Configuring Veritas Clusters, Oracle service group, listener, file system for failover.

●Meeting with users to plan for growth, performance and high availability of databases.

●Managing and Distributing Load on Unix Server for more than 7 instances on each Host.

●Working on Unix Shell, Autosys.

●Planning and assigning work to Junior DBAs.

●Helping and training junior DBAs and Application programmers.

Citigroup New York NY Feb 1999 – Jun 2006

Oracle Database Administrator

Project: CitiDirect - GECD (Citigroup Global Electronic Customer Delivery)

CitiDirect is a global online banking project with thousands of user accessing from 100s of countries globally round the clock. This project is 24 by 6 with contingency site (standby database).Worked as a contractor from April 1999 till Nov 2003 on this project, then joined Citigroup as full-time employee in Nov 2003.

Responsibilities:

●Providing 24x6 Production Support to Client. Used Transparent Application Failover TAF to fail over to surviving node, when one of the nodes fails and used Standby database for Disaster recovery

●Working on Oracle 9i (RAC), 8i(OPS), 734 Database, Application Server

●Creating, maintaining 4+Terabyte size Oracle using RAW Devices on Unix - Solaris5.8-64bit, HP-UX11

●Administrating, Configuring, Tuning, Load balancing Terabyte Real Application Clusters

●Instance monitoring & Tuning using v$ dynamic views, Glance, top, sar, vmstat

●Meeting with users to plan for growth, performance and high availability of databases.

●Creating, maintaining, and monitoring Standby Database (contingency site). Splitting Standby database to create Production Images for QA testing using BCV

●Developing scripts to monitor instance’s locks, long running queries, listener, free space, extents growth, etc

●Performing large Terabyte size database Backup including Physical backup through Hotbackup/ColdBackup of Oracle database on Raw Devices using dd & compress and Logical backup using multiple streams Export / Import

●Working on RMAN, Standby database.

●Installing and monitoring Listener, Names Server, dbsnmp agent

●Performing testing on Database Cache to improve the 3-tier environment, also worked on OEM, OMS

●Partitioned Large Tables by range as well as by list

●Design and development of Daily Schema Change Monitoring program across all Databases

●Weekly maintenance of rebuilding Tables/Indexes into different Tablespace using info from Statspack

●SQL Tuning using Materialized Views, Parallel Query, tkprof

●Security Administration including creating & maintaining XA Ids having application related permission, READ Id having only enquiry permissions using Roles, Profiles for Dev, QA and Prod Environments

●Designing, Developing, Implementing and Maintaining Schema Migration Generator and Equalizer, in PL/SQL (OracleChange, Quest, Patrol, etc - ALL were too slow for 600+ Objects Schema) to create DDL for all objects including tables, constraints, view/proc, static data migration from 5-DEV to 3-QC to 2-UAT to Production Environments

●Developing Unix shell scripts using awk, sed, tr, etc to automate a wide range of tasks including administration, backup, monitor, troubleshoot database issues, execute background and batch process round the clock

●Creating, maintaining and monitoring Replication

●Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes

●Planning and assigning work to junior DBAs.

Environment: Oracle Server 10g, 9iRAC, 8iOPS, 7.3.4, Enterprise Manager 9.2, Embarcadero DBArtisan 5.4, SQL*Plus 9.2, PL/SQL 9.2, on Solaris5.8-64bit, HP-UX11, Windows 95, Windows2000

Insyst Business Solution. _ Sep 1995 – Jan 1999

Project Leader, Senior Oracle developer

Project: Orion - INSYST'S ERP PRODUCT

Insyst is a software development company. Its products include Orion - an ERP product.

This project involved conversion and upgrading the 160+ forms and 300+ reports on-line programs from SQL*Forms 3.0 to SQL*Forms 4.5 and Report Writer 1.1 to Reports 2.5. as well as additions of new Forms and Reports..

Responsibilities:

●Designed and Developed online screens in SQL*Forms 4.5 based on the original SQL*Forms 3.0, and added features using Oracle Graphics 2.5

●Developed UNIX shell scripts to automate and execute background and batch process

●Developed database tables, indexes, views, packages, database triggers, stored procedures

●Performed Database administration, instance creation, tuning and maintenance

●Perform Hotbackup, Coldbackup, Export, Import

●Prepared test plan, conduct unit testing, module testing, integration testing and volume testing of the system. Testing of Forms and Reports for GUI Standards, Consistency, Security Issues and Memory problems

●Developed automation tools for faster documentation using AWK scripts

Environment: Oracle 7.x, Developer/2000 - Forms 4.5, Reports 2.5, Oracle Graphics 2.5, Pro*C, SQL*Forms 3.0,

SQL*Plus 3.2, PL/SQL 2.0, on Windows 95, MS DOS, vt100 terminals, SCO UNIX.

Dubai Wire FZE -Dubai, UAE. _ Dec 1993 – Aug 1995

System Analyst, Designer, Senior Oracle/dBase/Lotus Developer

Client had various small modules developed in COBOL, dBase and Lotus. These modules were not integrated. A new system was developed in Oracle 6 to enhance and integrate all the old modules. The new system was developed using SQL*Forms 3.0, Report Writer 1.1, SQL*Menu 5.0 on Oracle 6. The system consisted of 100+ Forms, 200+ Reports. The system generates several reports.

Responsibilities:

●Reengineering the existing system. Did extensive user interaction to understand the user needs and translating it into system requirement specification.

●Prepared Process Modeling and Entity Relationship modeling.

●Analysis, Design, and Development in SQL* Forms, Report Writer, PL/SQL.

●Creating tables, primary key, foreign key constraints other constraints, synonym, view.

●Created and maintained tablespaces, rollback segments, users, roles, etc. for supporting the backend applications.

●Used SQL*Loader and Import/Export to load and transfer data from Cobol, dBase and Lotus to Oracle.

●Developed UNIX shell scripts to automate and execute batch process.

●Worked on 100+ online forms using Oracle 6.0, PL/SQL and SQL*Forms 3.0.

●Developed 200+ Tabular, matrix and Master-detail formats reports using Report Writer including use of user exits.

●Migrated Oracle database from Novell NetWare 3.11 to Sco UNIX.

Environment: Oracle 6, SQL*Forms 3.0, Report Writer 1.1, SQL*Menu 5.0, SQL*Plus 3.2, PL/SQL 1.0, Cobol, dBase, Lotus on Windows 3.11, MS DOS, vt100 terminals, SCO UNIX, Novell NetWare.

Trilogy Software Pvt. Ltd. Apr 1991 – Nov 1993

System Analyst, Designer / Oracle/FoxPro/dBase/Lotus Programmer

Responsibilities:

●Interaction with senior management, detailed study to analyze the information needs and limitations in the current manual system.

●Preparation and presentation of requirement specifications and functional specifications.

●Designing and Development of the system. Creating tables, primary key, foreign key constraints, other constraints, synonym, view. Uploading data from Cobol, DBase & Lotus.

●Development of complex reports that involve combinations of Tabular, matrix and Master-detail formats.

●Team coordination and Technical support to the team members.

●Client Presentations, Implementation and User Training.

Environment: Oracle 6, Forms 3.0, Report Writer 1.1, SQL* Plus 3.1, PL/SQL 1.0 on SCO UNIX, MS DOS,

FoxPro 2.0 on Novell NetWare 3.11

Received following Awards

●Best student in System Management NIIT

●CitiDirect Release 4.4 Citigroup

●Upgrade of CitiDirect Project to Oracle 9i Citigroup

●Database, Application migrations FxAll

Training

●Oracle 11g – RAC Workshop Oracle University

●Oracle 10g – Administration II Oracle University

●Oracle 9i RAC Citigroup, New York

●IBM WebSphere Citigroup, New York

●Programming Logic and Cobol Semester I NIIT, India.

●Analysis, Design and Implementation Semester II NIIT, India.

●dBase III Plus and VP Planner Semester II NIIT, India.

●UNIX and C Semester III NIIT, India.

Contact this candidate