Innovations technological

Thanks,

Jinal Shah

1125 US Highway 22, Ste 1

Bridgewater, NJ 08807

Tel: 908-429-8008 x 347

Cell: 908-875-9179

Fax: 908-429-8005

Email: Jinal.Shah@cyberThink.com

**********************************************

Sr. Oracle DBA

SUMMARY OF QUALIFICATIONS:

·         Fourteen+ years of IT experience in various industries that support Service, Production & Information Technology Sector.

·         Ten+ years of experience as Oracle DBA, Database Management - Backup & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management, and managing data dictionary objects.

·         Extensive experience in installations of Oracle Software, Configuration for database and day to day routine works for database administration, System User administration, Index organization, Cluster creation. V$Views checking for daily performance Tuning of database.

·         Experience with Installation of SQL Server 2k or 2k5 or 2k8 in cluster and non-cluster environment as per company policy and maintaining documents for configuration.

·         Temporary Tablespace management. Rollback segment creation and assignment of Rollback segment to procedure or transaction.

·         Hands-on experience in RDBMS (Oracle 8, 9, 10g, MS Access, MS SQL Server 6.5/7.0/2000, 2005, 2008).

·         Experience working with Oracle Enterprise Manager (OEM)

·         Experience migrating data from Data Migration from SQL Server2005 to Oracle10g.

·         Write Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.

·         Fine-Tuned and optimized SQL queries and performed code debugging using TOAD, SQL Profiler.

·         Experience in UNIX, Linux Shell Scripting.

·         Worked on Database size up to 4TB.

CERTIFICATION:

·         Oracle8 Certified Professional (OCP) Certificate from Oracle Corporation: Database Administration, Backup and Recovery, Network Administration.

·         Oracle8 DBA Certificate from Brain Bench.

·         Master Diploma in Software Engineering

Technical Skills:

Database Administration:             Oracle (versions 7.3, 8.0, 8i, 9i, 10g, 11g), Microsoft Access, SQL Server 2k, 2k5, 2k8.

Software:                                            Developer 2000 (2.1) (Oracle Forms 3.0, 4.5, 5.0, Reports 1.1, 2.5, 3.0), Pro*C 1.5, 2.2, Visual Basic 5.0.

SAP:                                                       SAP R/3 Basis Administration, SAP R/3 V 4.x, 3.x, MySAP.com, BW.

Languages:                                         C, C++, SQL, PL/SQL, Basic, and COBOL.

Networks:                                           TCP/IP, Ethernet, MS Windows NT.

PROFESSIONAL EXPERIENCE:

Aug '11 – Present                                                                                                                                             Citi Group

Sr. Oracle DBA                                                                                                                                Warren, NJ

Responsibilities:

• Installation of Oracle on Standalone and Cluster environment with DMA.  User Creation, Role & Profile Assignment in DMA with workflow in Linux and AIX environment.
• Database backup & Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import. Create Backup workflow in DMA.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Work on Disaster Recovery Project (high availability) and successfully configured Oracle and SQL production database.
• Create Patching workflow for DMA and apply on standalone and cluster environment. 
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level.
• Install DMA services on servers and configure with DMA environment for creating new workflow and installed HP workflows for Database automation. 
• DBA support on 24X7 environment, Supporting Central Administration Service Desk for Database related issue and work on Ticket to resolve the identified issues.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization.  Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job.

Environment:    Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003.

Aug '08 – Present                                                                                                                                             SPX Corporation

Sr. Oracle & SQL DBA                                                                                                                     Charlotte, NC

Responsibilities:

• Installation of Oracle and SQL Server software with cluster (RAC) and non-cluster environment. Configuration of Database, User Creation, Role & Profile Assignment in SAP and Non-SAP environment.
• Database backup & Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Work on Disaster Recovery Project (high availability) and successfully configured Oracle and SQL production database.
• Perform Daily check for all SAP System with Global SOLMAN and working with BRTOOLs for database maintenance. (Daily checks Using Tcodes ST04, DB02, DB13, DB12, SM20, SM21, SM35, BD87, SM37, ST22 etc.) And perform Oracle and SQL database according to company policy.
• DBA support on 24X7 environment, Supporting Central Administration Service Desk for Database related issue and work on Ticket to resolve the identified issues.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization.  Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level.
• Working with Database Refresh, Migration from Oracle 7 to 9i and Datacenter Move from one location to another. 
• Domain migration for Database servers. 
• Hands on work experience with 11g new features like High availability, RMAN archive log management for streams and data guard, optimize undo backup, Data Pump to use for compression and encryption of backup, transportable partitions, Manageability with memory_target parameter for auto memory management, auto SQL turning, and more.
• Knowledge of 11g new features of ASM like SYSASM role, Fast Disk Resync.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job.

Environment:    Oracle 9i, 10g, 11g, SQL Server 2k, 2k5, 2k8, SAP NW, SAP R/3, BI, XI, Vertex, Oracle Apps, Linux, IBM Unix, SUSE, HP-Unix, Windows Server 2003.