SACHIN J PHANSE

ac83rz@r.postjobfree.com 412-***-****/9284

SUMMARY

19+ years of IT experience working at Managerial Position, primary Oracle DBA.

Experience in Holistic server management-supported worldwide DB system with Cross-Application and Cross-Platform, supporting core DBA task as well as development.

Experienced in multi-terabyte databases 10GB to 45 TB size.

Worked with business and end users together, to gather the information and fulfil the project from development to production environment.

Lead offshore teams responsible for 24/7 production support on 471 Oracle and 110 SQL Server (2000 and 2005) database instances for ERP and non- ERP System Databases.

Worked with business and end users together, to gather the information and fulfil the project from development to production environment.

Experience working on Windows servers since versions NT 4.0, 2000/2003/2008/2012/2016.

Expertise in Installation, Configuration, and Creation and Managing Oracle Database for RAC, Streams, Data Guard (ADG), Golden Gate version (12c/11g/10gR2/9iR2), Oracle spatial, including ASM, Audit Vault on Linux /Sun Solaris 10.1, AIX, Windows on Multi-Tiered client-server application.

Expertise in Database Performance tuning - SQLs tuning, Hardware Resources, identifying & solving issues with Advance tuning methods, Customized Script, OEM (13c/12c), AWR, ASH, ADDM reports or SAP tool ‘DB COCKPIT’.

Expertise in Upgrade database from 10.2.0.1 to 10.2.0.4 & 11.2.0.4 from/to 11.2.0.3/4 & 12c Databases (includes ERP ) in RAC and non-RAC environment.

Experience in Server migration including Cross Platform DB Migration from Sun Solaris / AIX to Linux (RHEL-5,6,7) and also experience in migrating single instance to multiple Instances (two – four node RAC).

Experience in cross platform database migration and upgrade from 10g to 11g with Zero down time solution using Golden gate (Solaris to Red Hat Linux). Currently working on 12 c-Goldengate replications.

Experience in Creating MongoDB, performance tuning, security deployment for critical application, debugging server’s related issues and database, configure MongoDB servers.

Experience in client/user authentication mechanisms using Kerberos, LDAP, SCRAM-SHA-1,X.509, MONGODB-CR for MongoDB.

Experience in Migrating database from Oracle to MongoDB.

Experience working on MySQL

Experience in Creating & Managing Partitioning, Cleanup data, resizing, security, managing Users, identify data issues (duplicates) as per business requirement.

Independently Analysis root cause on complex Production issue and Provide long-term solution.

Experience in integrate existing Application with new requirements.

Experience in Data Modeling or remodeling using Oracle Developing tools.

Experience in Capacity Planning, Space Management, and parameter setting for all application Products i.e SAP, Peoplesoft, EBS, Informatica, Pega and customized application with /without OEM (12C/13C).

Expertise in providing solution on gaining Online Space (without Downtime) through online reorg, shrink table etc.

Designed and implemented Disaster Recovery Plan and Backup/Recovery Strategy for 24x7 operation using tools like RMAN including ZDLRA, BRTOOLS (SAP) and DBPUMP.

Experience in configuring Agents, setup backups & recovery: NetApp & EMC systems.

Experience in setting SSO (Single Sign On ) with Kerberos.

Always follows Corporate IT standards, Strategy, Service Level Agreements (SLA) .

Automated the manual processes through Shell Script, Microsoft products (VB,C, C++ etc.)

Experience in generating XML using SQL in Oracle including DBMS_XMLGEN,SQLX.

Experience with scheduling jobs using CISCO Tidal Enterprise, crontab, scheduler etc.

Wrote UNIX / Perl / Python scripts for scheduling jobs and alerts. Coordinated with ORACLE support.

Oracle 9i, 10g, and 11g Certified Professional (OCP), 10g R2: Administering RAC.

Experience working on cloud specially ORACLE Cloud and managing Exadata Machine.

Experience migration databases on Cloud/ORACLE CLOUD, AWS & Azure.

Developed new procedures, methods to streamline the operations.

Knowledge of Income Tax during handling critical databases i.e. IRS data.

SKILLS

Operating Systems: Sun Solaris 10, 9, 8, Linux (RED HAT)7,6,5, AIX, HP UNIX, SCO UNIX, Windows 2000/2003/2008/2012/2016

Hardware: Sun Fire V890, v240, SAN storage 6100, Sun Enterprise 450, 3500, Sun Fire 280R, Ultra Spark 20, 10 and IBM Xeon Processor Power edge 1750, 2850, 4600 server series. 5300-04 (IBM 5L (64bit)), Bald server, LPAR

Database: Oracle 12c (12.1/12.2) 11g (11.2/11.1.0.6), 10g (10.2.0.4), 9i (9.2.0.7), 8i, 8.0, 7.3.4., SQL SERVER 2000/ 2005, Mongo DB, EXCEL, MySQL, ACCESS.

Applications: SAP 3.1/7.0, Peoplesoft Finch & SCM 8.2/8.9, PeopleSoft Tools Version 8.48/8.49, EBS, Web logic 8.1 and BEA App. Server, BEA Web server, ECC6, PI, XI, PORTAL BI, BW, FIN, MDM, PEGA, Hadoop, Oracle spatial.

Tools/Utilities: AWD, ADDM, SQL*Loader, RMAN, Statspack, OEM12c/13c, Toad, SSIS/DTS, ODMA, AutoSys, Tidal Enterprise Scheduler (TES)

Languages: SQL, PL/SQL, iSQL, SQLX, Shell/Perl scripting

Programming: VB6, C, Python.

Cloud: Oracle Cloud, BCBSM Cloud, AWS & Azure

Certification: OCP 9i/10g, Mongo DB from Mongo University.

EXPERIENCE:

CLIENT: BLUE CROSS BLUE SHEELD 10/2013 to 12/2018

BCBSM is Health Insurance nonprofit organization, having holistic Server Management system & complex databases of Oracle, Mongo, DB & SQL Servers. Also having Multiple 4 - node RAC Cluster Environments & Stream. Some of the Database are in TBs (18-40)in size, comprising all environment PRODUCTION, QA, DEV.

Provided the technical expertise for customized and vendor Applications on database management system.

Deployed projects across all environment (DEV, QA, PRODUCTION) including database creation, Preparing Environment (tablespace/partition/user, roles etc.) as per business needs.

Involved in data-Modeling activity for all new Projects and existing projects support. (Including data conversion projects).

Helped developer/Business to re-build structures for enhance project, and build structures for new project: as per business requirement, or to resolve the performance issues for long term solutions.

Generate the data-model from existing structures to help developers/Business for new Business requirement using tools (ErWin).

Provided Technical support & tune the systems i.e Resource, Complex Query including Oracle spatial & XML(SQLX).

Provided Technical support to create/develop Oracle objects i.e. Trigger/Procedure/sequence/DDL, Partitions, tables, index, tablespace etc

Created, Maintained & supported Oracle databases and clients for customized application, Oracle spatial, Hadoop, MDM, Informatica, Cognos, Pega.

Converted /Merged Access / Excel data into Oracle Databases and from Oracle Databases to Mongo DB or vice versa.

Created, Maintained & supported MongoDB, performance tuning, debugging the Server related issues, configuration.

Deployed client/user authentication mechanisms using Kerberos, LDAP, SCRAM-SHA-1, X.509, MONGODB-CR for MongoDB.

Experience in Migrating database from Oracle to MongoDB.

Created, Maintain & supported 2 - 4 node RAC multiple systems as per business requirement.

System migration - Installation upgrade RAC and Non RAC database system.

Cross migration - from ver older than 11.2.0 & 12c.

Applied patches on RAC and Non- RAC Environment.

Created & maintained the users, roles, profiles, triggers, Stored Procedures etc. and also cleanup objects.

Installed 12c,13c including OEM Agent can configure Oracle databases.

Setup Database Backup, scheduling & maintained backup using RMAN, DBPUMP, DD BOOT tool ( EMC App) etc.

Configured Agents & setup of NetApp & EMC systems for backup the database and retained the backups.

Database Refresh from Production to NON -Production DBs through RMAN/DB PUMP.

Analyzed the business practices and requirements and evaluated data models before every deployment.

Monitored DB space & capacity, estimated Growth requirements and Automated.

Independently Analyzed of root cause on issue and Provided long-term solution.

Working experience with Job Scheduler tools: Tidal Enterprise Scheduler (TES), Crontab etc.

Created, Maintained & supported Oracle and GoldenGate (12c) databases.

Experience in setting SSO (single sign on ) with Kerberos.

Supported Data warehouses, OLTP, OLAP, RAC, Streams, (ADG) Active DataGuard, and GoldenGate replication databases.

Environment: 4-node RAC Cluster environment, ASM, Oracle12c/11g/OEM 12c/13c, AIX, Linux-4/5/6/7, Sun Solaris, OLTP, OLAP, Datawarehouse, GoldenGate, Active Data Guard, MySQL-MongoDB, Storage:EMC, NetApp.

Client : Kforce Inc (Head Office) – Direct Contractor, Tampa, FL

07/2013 – 08/2013

Sr. Oracle DBA (HealthCare Project)

Being worldwide company and having combination of PeopleSoft and Non-PeopleSoft database, they have 3- node RAC Cluster Environment with ASM. The Size of database more than 2 TB and around 179 Instance.

Primary work: support Healthcare (ACA Project),in addition also supported other database including 3-node RAC Cluster Environment.

Resolved the migration, performance Issues.

Automated migration process from two different entities, Flat file to Oracle.

Monitor and/or on Request Tune the SQL Queries as per business requirements.

Review & recommend on Platform Database Migration as well as upgrade to 11.2.0.3.6 ver.

Write & Rewrite or Convert the scripts from HP UNIX to Linux i.e Monitoring, alerts, lock information, backup, permission etc using Python,shell scripts etc.

Resolved the Issue with Backup Recovery with RMAN.

Environment: 3-node RAC Cluster environment, ASM, Oracle, SQL queries, HP UNIX, Linux-4/5, OLTP, OLAP, Datawarehouse, GoldenGate, DataGuard. Language for Scripting : Python.

CLIENT: Philips (Respironics (HHS) – Contractor, Murrysville, PA

01/2012 to 08/2012 (Contract Completed)

Lead Oracle SAP DBA

Philips is a worldwide company, which adhere to FDA regulations. The (Respironics (HHS) environment basically consisted of SAP and non-SAP modules. Having SAP R3.1 / ECC6.0 / Netweaver 7 etc. on 10.2.0.1 to 11.2.0.3 and responsible for more than 55 database in sizes were 7.1 to 4.1 Terabytes and having ERP,BW,XI,PI and Portal all SAP Modules as well as Non-SAP Environment on RAC cluster. Philips is having OLTP and OLAP both process. All these constituted of the holistic management system on which I worked.

Primary work: Managing team of 2 DBA/BASIS for ERP kernel.

Coordination with other DBAs and non-technical teams, resolving the issues and educate them if needed.

Built and refreshed environments varying from 40 GB to 7.5 TB in ORACLE SERVERS.

Setup & Configure the OEM for 10g/11g.

Design and build new architecture before upgrade and review existing.

Upgrade SAP Databases from 10.2.0.1 to Oracle 11g (11.2.0.3) along with patching on SPARC 64bit OS

Move the database from single instance to RAC along with upgrade to 11g for Non-SAP environment.

Provided support to end users and developers to tune the SQL.

Provide assistance to BI/BW TEAM for schema redesigning, space, setup alerts.

Applied multiple patches (PSU Bundles) through MO Patch.

Implementation and testing Oracle products Golden Gate, Veridata on Multi-Tiered client-server application.

Used Oracle Golden Gate-Veridata to Identifying & Reporting data discrepancies between database and data.

Configure & test cross platform database migration and upgrade from 10g to 11g with Zero down time solution with Golden gate.

Provided solution Online Space Management through online reorg, shrink table or DATA PUMP etc. and regain the space.

Enabling Security check like COST (secure Transport) and/or like “valid node checking” to restrict direct access to database.

Evaluate, suggest & Resizing Memory parameters (such as SGA/PGA, SHARE POOL etc.) as per business requirements and hardware availability for OLTP and OLAP environment.

Schedule SAP jobs and transports new change for SAP application.

To ensure Security set alerts to secure the parameter file and network files changes.

Prevent audit trail, delete/archiving audit files through Shell scripting & Scheduler.

System monitoring, service level reporting and root cause Analysis -SMD through SOLMAN.

Maintaining Users and Security etc.

Setup, Configure and Produce the Database/Instance/SQL tuning Reports (AWR /ASH / ADDM / DB COCKPIT etc.) And provide the solution on issues.

Monitored process failures, buffer statistics, check locks, updates etc. through DB COCKPIT, AWR Monitored and forecasted database growth and increased the Tablespace size using BRTOOL, DB COCKPIT.

Perform Critical database recovery through RMAN using time base recovery / cancel etc.

Created the test environment for testing different Oracle Products.

Maintain the databases, Create and Rebuilt the indexes, Update the statistics, space management etc. for SAP database and non–SAP DBA.

Involved in DR and evaluate the design and provided suggestions on configuration.

Write shell script for Space management.

Designing/Recommending Database Security Policy and Maintenance golden Images and setup alerts for monitor.

Health check with Monitored process failures through Alert log / DB COCKPIT.

Schedule Backup/Archived the database BRBACKUP/ BRARCHIVE etc. for SAP database and with Tidal Enterprise Scheduler (TES), Crontab etc for non-SAP DB.

Experience in setup database backup on NetApp Storage systems.

Supporting data warehouses, OLTP, OLAP, RAC and GoldenGate replication environment.

Environment: Oracle 10g/11g, ERP Kernel, Linux 4/5, OEM10g, OLTP, OLAP

Tools: DB COCKPIT, BRBACKUP/ BRARCHIVE; Storage : NetApp SAN.

Client : Arcons Technology – Direct Contractor, San Jose, CA

01/2011 to 11/2011 (Contract Completed)

Oracle Database Architecture

The company product Schwab Portfolio Center, Advent Axis and Scottrade Portfolio Director and sub modules

Managed/Led 13 Developers in 3 locations (10 offshore/3 onshore).

Solely responsible for administration.

Planning, designing, developing database architectures for customized Oracle user’s products.

Analyzed, concatenate/mapping and Convert different data TYPE into Oracle database or migrate database as per client/business requirement.

Create/developed/tune the SQLs/Ad-hoc Report as per business requirement.

Developed, managed and testing back-up and recovery plans

Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly.

Working closely with database programmers and web developers.

Managing security policies/standards (i.e.) controlling access permissions and privileges.

Communicating regularly with technical, applications and operational staff to ensure database integrity and security.

Commissioning and installing new applications and customizing existing applications in order to make them fit for purpose.

Scripting

Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata).

Environment: Oracle 9i/10g/11g,MySQLPost OS: Window Servers ver 2003/2008.

CLIENT: Owens Corning - Contractor, Toledo, OH

10/2007 to 11/2009

Lead Oracle SAP/MS SQL DBA

Owens corning is a worldwide building material manufacturing company. The environment basically consisted of SAP and non-SAP modules. The database sizes were in Terabytes. They have over 450 instances of Oracle/SQL Server. Supported holistic server’s management worldwide.

Managing offshore and onsite team of six, coordinating between offshore and onsite DBA’s

Assigning, monitoring, supervising, and providing solutions on issues.

Accomplishing task in relay and/or water fall manner etc.

Administered 210 instances of ORACLE and 110 instances of SQL Server, along with cluster servers (active/passive node).

Handled Critical data like financial data i.e IRS data, finance etc.

Accomplishing Multitasking project like Planning & Upgrade/Migration/Patching, etc w & w/o co-ordinates.

Migrate/merged data between different DBMS/RDMBS databases. MS-sql to Oracle or consolidate data from different database/servers. i.e Migrated Access, Excel data / MS SQL databases to Oracle Database

Designed installation, maintained Data Guard Servers, RAC servers and managed data partitioning.

Involved in architectural design for Cross platform database migration from Sun Solaris to Linux (RHEL-5)

Installed/Managing Oracle Software/Client (9i/10g) along with Grid Control for RAC-non RAC on Sun Solaris, and Linux 5.4 using VMware.

Built, cloned/refreshed, upgraded and tuned databases upto terabyte size.

Monitoring System, Root cause analysis - SMD, through Solution Manager OEM 10G etc.

Monitored backups, database growth and application processes using BRTOOL, DB COCKPIT for SAP and OEM for non-SAP applications.

Optimized complex queries that impacted the database performance.

Installed MS-SQL SERVER 2000 and 2005 on Cluster (active-passive node) and non-Cluster environment.

Performed SQL Server Database Tuning using profiler.

Created, impersonated user and verified user using Active Directory.

Created Link Servers for with in/out of Domain.

Created and managed DTS/SSIS package.

Set alerts, operators and schedule backup/SSIS jobs.

Resolved issues like connectivity, orphan user (SQL Servers), tables etc. and database restorations.

Provided support to Developers & Business to design/create the structure re-modeling using Oracle SQL Data Modeler, ERwin Tools.

Developed Shell scripts such as installation of pre-Oracle setup, hot and cold backup.

Configured Agents & setup database backup on EMC & NetApp Storage systems.

Create and configure package an email message into the appropriate format, locates SMTP Information and delivers the message to the SMTP SERVER.

Additional responsibilities: Income Tax data (IRS ), created documents and processes and supporting data Warehouses, OLTP, OLAP, RAC etc

Environment: Oracle/SQL Server, OLAP, OLTP, SAP, Sun Solaris, Linux (RHEL-5),Window Server NT/2000/2003, VMware-v sphere 4, RAC, ASM, Grid Control, Data Guard, Active Directory, DTS/SSIS. Tools Job Scheduler Tool: Enterprise Batch Scheduler by Tidal Software (known as TES now) & Crontab etc; Storage: NetApp/EMC

EMPLOYER: United Commercial Bank – Direct Contractor, Baroda, India

06/2001 to 11/2006

Lead DBA

UCO bank is one of the oldest commercial banks with over 1700 branches. Solely responsible for handling database in four Western Region branches with turnover of approximately $100 Million.

Converted the entire data into Oracle environment.

Managed/resolved inter-team issues as an onsite DBA.

Helped management & implementation of day to day DBA work for 4 branches i.e ensuring co-ordination & functioning of OS, Network & Application Teams

Installed Oracle software (8, 8i, 9i) and database on UNIX and NT platform.

Migrated data between cross environment i.e DBMS to RDBMS – Flat files/Clipper/Excel/MS Access to Oracle.

Developed Shell scripts for the installation of pre-Oracle setup, hot and cold backup, restoration, and to check the data in the tape drive.

Supported end users, maintained security, monitored memory usage, logs, process failures, network failures and media failures. Managed schemas and indexes.

Created structures like tablespaces, rollback segment, undo management segments etc.

Exported/imported data between various database instances.

Automated Manual process to convert data from Access data into ORACLE Data.

Analyzed data before and after data migration and tuning SQLs using UTLBSTAT and UTLESTAT and STATSPACK reports.

Implemented backup/recovery using RMAN with Catalog.

Created physical standby database using SQL.

Applied security patches, upgraded the database. Analyzed user requirements and managed space for various development projects.

Troubleshooting activities included database connectivity problems, user maintenance, database backup, restored Database on server crash etc.

Deployed applications to the staging and production environment.

Generated statements of work and other custom reports as per EDP and government guideline.

Environment: Oracle7/8i/9i, UNIX, Window Server NT/2000/2003, SQL SERVER 2000.

Education: Master’s in Computer Information Technology.-MSCIS.

Contact this candidate