Rupesh Mehta Email & Phone Number

Working on providing AWS solution including data modeling, designing and architecture efforts for enterprise data warehouse applications supporting the Federal Health Exchange, VLER, AHLTA-T, CDR, iEHR. Working closely with business owners, end users, BI developers, and database administrators to devise conceptual, logical and physical data models, data flows, and data dictionaries. Responsible for installing Oracle clusterware 11.1.0.6 and then patch it to 11.1.0.7.4 on HP-Itanium with Veritas… Show more Working on providing AWS solution including data modeling, designing and architecture efforts for enterprise data warehouse applications supporting the Federal Health Exchange, VLER, AHLTA-T, CDR, iEHR. Working closely with business owners, end users, BI developers, and database administrators to devise conceptual, logical and physical data models, data flows, and data dictionaries. Responsible for installing Oracle clusterware 11.1.0.6 and then patch it to 11.1.0.7.4 on HP-Itanium with Veritas cluster file system and Installation of 11.2.0.2 on Solaris x86 – 64 bit on VMWare.Hardening the database environment by following the DOD guidelines for applying the related STIGS.Upgrade from Oracle 11gR2 to 12c.Convert the exiting non-RAC database to 11g RAC.Add another node to the single node 10g RAC to make it 2 node RAC on HP-Itanium with 11gCRS. Make sure that the best practices are followed while converting non-RAC database to RAC database and prepare extensive document for the installation instructions.Successfully migrated non-RAC databases to RAC. Set up backup and recovery procedure using RMAN and set up Standby database using Data Guard Show less

Managed all activities related to the administration of the data environments. • Responsible for administration and supporting Oracle 9i, 10g and 11g databases. Worked on creation of new Oracle instances for 10g and 11g RAC and non-RAC. Creation of Physical standby using DataGuard. Cloning of Oracle binaries. Hot and Cold cloning of 11g databases using RMAN. Creation of duplicate databases using RMAN from 4 node RAC to 2 node RAC. Resizing redo logs, RMAN backups and other DBA duties… Show more Managed all activities related to the administration of the data environments. • Responsible for administration and supporting Oracle 9i, 10g and 11g databases. Worked on creation of new Oracle instances for 10g and 11g RAC and non-RAC. Creation of Physical standby using DataGuard. Cloning of Oracle binaries. Hot and Cold cloning of 11g databases using RMAN. Creation of duplicate databases using RMAN from 4 node RAC to 2 node RAC. Resizing redo logs, RMAN backups and other DBA duties. Monitoring and trouble shooting of databases. Performance tunning.Database adminstration of Sybase, Sybase replication server, Replication from Sybase to Oracle using DCO. Show less

Worked as a database team lead in Fannie Mae. The responsibilities include DBA duties for the dev and test. Performance and fine tuning of SQL queries, procedures and triggers. doing analysis, creation of technical design documents, Database design and creating ERD diagrams using ERStudio, database development including creation of tables, procedures, triggers and others database objects. Server side java development using spring.

Was responsible for Database Design, Development and Administration which includes using Modelling tools, deriving data standards, maintaining data dictionary, writing stored procedures to cater to the requirement of various users and groups, fine tuning of SQL queries, fine tuning of SQL server parameters, writing triggers on Sybase 11.5 ASE . Using CIS for transparency to users and Interoprability. Tasks performed as DBA and developer are: Manage disk storage, grant permissions to Sybase… Show more Was responsible for Database Design, Development and Administration which includes using Modelling tools, deriving data standards, maintaining data dictionary, writing stored procedures to cater to the requirement of various users and groups, fine tuning of SQL queries, fine tuning of SQL server parameters, writing triggers on Sybase 11.5 ASE . Using CIS for transparency to users and Interoprability. Tasks performed as DBA and developer are: Manage disk storage, grant permissions to Sybase users, transfer bulk data using BCP utility; create, modify, drop, lock server login accounts. Fine-tune Sybase server by changing configurable system parameters; create devices, user databases; grant ownership. Create segments; define threshold procedures. Migration from 10.x to 11.x, database design, defining rules, defaults, primary key. Following are some of the projects I worked on.- Syslogs parsed by the java application and then loaded into Oracle database through SQL Loader. - Migration from Syabse 11.9 to Oracle 8.1.6 Show less

Responsible for development of Integrated accounting and financial system on SYBASE RDBMS with FOXPRO front. Job included Database Administration, system study, design/development and managing the team of developers.

Timex Watches Factory in NOIDA, UP, INDIA.