SACHIN J PHANSE

adal7q@r.postjobfree.com / 732-***-****

SUMMARY :

19+ years of IT experience working at Sr. level position primary Oracle/MS-SQL DBA.

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

Lead offshore teams and handled holistic Server Management system & complex databases.

Worked on various Structured Oracle, MS-SQL and semi-Structured Database (MongoDB ) for OLTP,OLAP & Data Warehouse Databases.

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

Experience in analyzing the data and generate Adhoc-Reports as per customer requirement

i.e. member, provider, revenue management, HIPAA, claims etc.

Expertise in handling projects for Customized applications, Hadoop, Informatica, MDM, PEGA including Peoplesoft/ORACLE - HCM,FSCM,SAP MODULES.

Experience in handling projects such as building systems, database version upgradation, server migration, cross platform server migrations for RAC and non RAC environment, MS-SQL servers/Database migrations, Design -development system project and Hadoop projects.

Experience in installation of Binaries, OEM12c/13c, Clients, GoldenGate, and Streams for all Environments: Production to Development.

Experience in working on Ticketing (P1-P2) including Production Database.

Involved in Designing Hadoop system including Structure Design, Mapping,Data injection, Transformation.

Design and create strategies for projects (New and existing environments) including Cloud specially ORACLE & AWS Cloud as IaaS, PaaS and managing Exadata Machines.

Provided Zero- Downtime Solutions using Golden-Gate (Solaris to Red Hat Linux).

Expertise in Cross-Platform database migrations from Solaris/AIX/Linux to Linux (Exadata)

Expertise in migrating databases from on Prem to Cloud (AWS, Oracle).

Experience in Data Migration for various sources into Oracle/ MS SQL DB, semi structural Database/Hadoop. Such as staging, Transformation, migration using ETL tools or SSIS packages, Map Reducer/ RDD.

Expertise in Database Performance tuning - SQLs tuning, Hardware Resources, identifying & solving issues with Advance tuning methods, Customized Script, tools such as OEM (13c/12c), using reports AWR,ASH,ADDM for Oracle and Profiler for MS-SQL Databases.

Experience in working on Oracle Products such as RAC, Streams, Data Guard (ADG), Golden Gate, Oracle spatial, including ASM on Linux /Sun Solaris 10.1, AIX, Windows on Multi-Tiered client-server application.

Experienced in multi-terabyte databases 10GB to 45 TB size handing and supported big database environment supported, 450+ Oracle and 320+ MSSQL Server database instances for ERP and non- ERP System Databases.

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 for new projects, remodeling for project such as eliminating redundancy, sharing existing data for new projects etc.

Handled projects such as Capacity Planning, Space Management, parameter setting, data sharing, data transparency, and eliminating redundancy

Designed and implemented Disaster Recovery Plan and Backup/Recovery Strategy for 24x7

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

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

Experience working on software development tool i.e. JIRA.

Experience working on Oracle Licenses.

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:

Exadata, 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

Databases

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,2008R2,2012,2014,2016 Mongo DB, EXCEL, MySQL, ACCESS.

Applications

SAP 3.1/7.0, Peoplesoft FSCM, HCM,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 Ecosystem- Kafka, pig-map Reducer, Oozie – Apache,zookeeper, Oracle spatial. Big Data

ManagerTools/Utilities

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

Reporting Tool

SSRS, Crystal Reports 8.5/XI, Business Object

Languages

SQL, PL/SQL,T-SQL, SQLX, Shell/Perl scripting

Programming

VB6,C,Python, R

Cloud

Oracle Cloud, BCBSM Cloud, AWS & Azure

Software Development Tool

JIRA, MS PROJECT

Certification :

oMongo DB from Mongo University.

oCert Prep – Project Management Professional (PMP)

oHadoop - Eco System and components (In Process)

oApache Spark Essential Training: Big Data Engineering

oBig Data Foundations: Techniques and Concepts

oAdvanced SQL for Data Scientists

oSQL: Data Reporting and Analysis

oPython: Advanced Design Patterns

oProgramming Foundations: Algorithms

oCert Prep: AWS Certified Solutions Architect – Associate

oMachine Language (Python & R)

oMongoDB for DBAs

oOracle Certified Professional 10G (OCP)

oOracle Certified Professional 9i (OCP)

oOracle Certified Associate 9i (OCA)

oOracle 9i: Real Application Cluster (RAC) R2 Ed2

oOracle 9i: Data Guard Administration

oCertification of Achievement ORACLE 9i DBA

EXPERIENCE:

CLIENT: BLUE CROSS BLUE SHIELD, Detroit, MI 10/2013 to Till date

Sr. Oracle DBA

BCBSM is Health Insurance nonprofit organization, having holistic Server Management system & complex databases of Oracle, Mongo,DB2 & MS SQL Servers and having customer Applications, Peoplesoft / Oracle - HCM, PSCM – modules, MDM, Informatics, EDW and Also having Multiple 4 - node RAC Cluster Environments & Stream. Some of the Database are in TBs (18-45) in size, comprising all environment PRODUCTION, QA, DEV.

Provided the technical expertise for customized and vendor Applications on database management system to Business Customer,Product owners, Solution Architects, Consulting Engineer and IT Security-Team.

Created Maintained standards & supported Oracle databases and clients for customized application, Oracle spatial, Hadoop, MDM, Informatica, Cognos, Pega and Peoplesoft /ORACLE - HCM,FSCM.

Create guidelines from new databases as per Business requirement. (Database creation, Preparing Environment (tablespace/partition/user, roles etc.) as per business needs.

Setup high-availability and disaster-recovery solution such as AlwaysOn, log shipping, SSIS, SSRS, up with SQL Server 2016 and other version.

Setup Alerts, scheduling Jobs through Maintenance, Monitoring Jobs

Experiencing in building Databases, SSIS Packages, Linkes, Users and resolved issues including performance, integration, connections, Services, Users issues.

Analyzing the data and generating Adhoc-Reports using SSRS/T-SQL as per customer requirement. i.e. member, provider, revenue management, HIPAA, claims etc.

Data Migration for various sources into Oracle/ MS SQL DB(SSRS), semi structural Database.

Analyzing data/ structure, provide solution for data sharing or eliminating redundancy

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

Handled the projects such as migrations, Archiving, new implementations on new servers or existing databases including data conversion projects.

Mongo DB: Setup and Maintain MongoDB Environment for replication, create document/DB Backup and Recover strategies, version update strategies and documentation.

Designed / redesigned data structure for new/existing ORACLE/ MS SQL- MongoDB databases.

Created data model for various form of data, identified data sources for new projects from existing data.

Involved in reducing gaps between various teams members to implement new projects.

Worked on projects such as Capacity Planning, Space Management, parameter setting, data sharing, data transparency, and eliminating redundancy

Designed and implemented Disaster Recovery Plan and Backup/Recovery Strategy for 24x7

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

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

Converted /Merged MS_SQL/Access / Excel data/ into Oracle Databases and from Oracle Databases to Mongo DB or vice versa using ETL tools & SSIS packages.

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

Created document, strategy for System, Cross DB migration – Installation, upgradation RAC and Non RAC database system, Cross migration - from ver older than 11.2.0 & 12c.

Designed Documented and implemented hands on for setup of Grid, OEM12c/13c, databases, Migration to Exadata and support those databases including users, roles, profiles, triggers, Stored Procedures and also cleanup objects.

Worked on various migrations such as Cross migration, OS Version ( including Upgrades ), Database version and Cloud migration from on prem.

Created standardized documentation & procedures for setup Database Backup, refreshing scheduling & maintained backup using RMAN, DBPUMP, DD BOOT tool ( EMC App) & Configuration Agents & setup of NetApp & EMC systems for backup the database and retained the backups.

Involved in designed HoopEco system: design Structure for new data transformation, Security Setup.

Hand on experience using Hadoop Pig-map Reducer/Apache – Spark for processing Big Data from various sources – DB2,ORACLE, MONGODB and, scheduling job through Oozie .

Monitored DB space & capacity, estimated Growth requirements.

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

Provide solution for replication: converted DB from Streams to GoldenGate(ver 12c)

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

Tracked Project - related issues using software development tool i.e. JIRA

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 (SPARC 64bit OS ), 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.

Worldwide company having combination of PeopleSoft (HR/HCM,FIN) 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.

Provided standard documentation and procedure for database migrations to Exadata(Linux).

Migrated Solaris database to Exadata (Linux )

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 Solaris to Linux(RHEL) 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, 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 adheres 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.5 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 SOLARIS 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 DB from 10g to 11g with Zero down time solution with Golden gate and resolved the issues etc.

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, OS – SOLARIS SPARC 64bit OS

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

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

01/2011 to 11/2011 (Contract Completed)

Lead DBA/Developer

The company product Schwab Portfolio Center, Advent Axis and Scottrade Portfolio Director and sub modules. Software supports MS-SQL, Oracle, MySql.

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, MS-SQL, MySql. OS: Window Servers ver 2003/2008.

CLIENT: Owens Corning - Contractor, Toledo, OH

10/2007 to 11/2009

Lead Oracle SAP & PeopleSoft/MS SQL DBA

Owens corning is a worldwide building material manufacturing company. The environment basically consisted of SAP and non-SAP modules (PeopleSoft HCM,SCM,etc). 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, PeopleSoft- FSCM,HCM, SCM, 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