Oracle Sql Server

Sutanu Das 512-***-**** ******.***@*****.***

Senior DBA/Operations Engineer offer over 10 years of extensive

implementation and production experience in Oracle, Weblogic, Sun

technologies for multiple customer production infrastructures. Expert in

Oracle 11g Databases, Oracle Data Guard, Oracle RAC, J2EE Technologies.

Customer consultative skills, Multi vendor management experience, ITIL Best

Practices implementation. Oracle 10g, 9i, 8i Certified OCP DBA, Sun Solaris

7 Certified System Administrator, BEA Certified Weblogic 7 System

Administrator, and, Sun Microsystems & Purdue Alumni.

Experience

12/2007 - Present Epicor/Activant Solutions

Austin TX

Senior Oracle DBA, IT Operations, Activant IT

MyRole: Serve as Senior Oracle DBA managing corporate Oracle infrastructure

operations hosted in Austin Data Center; Manage 24x7 production operations

and support development organization, and PMO office; Responsible for daily

Oracle management - reactive troubleshooting, root cause analysis, outage

reporting and implementation of proactive best-practices; Team work with

PMO office scoping & driving multiple, complex project implementations &

upgrades from technology standpoint; Support Development & Quality

organization with infrastructure, install-base, design & code review to

ensure Change Management processes in Oracle life cycle, Present senior

management with proactive quarterly recommendations for accomplishments,

project success points and overall Oracle farm performance stability and

outage reductions and long term stability & scalability .

> Reduced production outages by implementing best practices of patch

management, data purge/archival, code optimization

> Lead a team of DBAs to migrate multiple corporate databases &

application from 10g to 11gR2, with post go-live stabilization

> Implemented Oracle DataGuard for Oracle Applications environment as

a part of Disaster Site implementation initiatives

> Presented Oracle Dashboard, configured Capacity Reports & analyzed

performance data using Grid Control

> Implemented multiple new 11g Databases features after accomplishing

upgrade of EBS database from 10g to 11gR2

> Designed migration of single instance to RAC for R12 Ebusiness suite

to support increased user-base after company merger

> Increased availability of development instances by reducing cloning

time by implanting clone automation using Grid/AMP

> Team work with development & PMO organizations scoping multiple

projects: Service Contracts migration, WDN integration

> Optimized backup and recovery processes using new 10g and 11g RMAN

features, compression, optimization

> Manage corporate SQL 2005/2008 databases, install, patch,

maintenance plans, configuration, application integration

> Received multiple awards & recognitions for outstanding work - two

times employee of the quarter, wow awards.

02/2003 - 11/2007 Sun Microsystems Inc

San Francisco, CA

Senior Database Administrator/ Principal Operations Engineer, Sun Managed

Operations, Sun Services

MyRole: Serve as technical lead for multiple Sun Services managed direct

customers, include Customer implementation, 24x7 Production infrastructure

management, database, system builds, upgrades, incident process, change

management, proactive best practices implementation, 24x7 escalation on-

call support, extensive multi-tasking, customer technical relationship

management, customer consulting, service review presentation, overall

customer operations ownership.

. Senior Technical Lead for Sun Managed Services engagement for customer,

Macgregor, a technology solutions company for global investment

community. Patented Real Time Trade Order Management System software

which offers trade on international stocks and equity. Sun Services was

engaged to implement, monitor and manage Macgregor's production IT

infrastructure operations hosting the global Trade Order Management

Systems. The infrastructure is hosted at two geographically isolated

state of the art data centers with Oracle 9i/10g Data Guard Replication,

Weblogic 8 Cluster, Veritas Cluster Server High Availability, Veritas

Foundation Suite 4.1 Volume Management, Sun v490 servers and Sun Storage

3510 arrays. My Duties include:

> Designed a Disaster Recovery Site and High Availability solution for

Macgregor stock-trade application.

> Installed, Configured, Tested Oracle 10g Data Guard Environment

between MA and CA ATT Data Centers.

> Installed, Configured Oracle 10g Grid Control to manage and monitor

the Oracle 10g Data Guard environment

> Migrated customer's single instance database under Veritas Cluster

Server achieving High Availability at Primary Site.

> Performed Oracle Data Guard Switchover and Failover processes to

ensure customer business availability at DR Site.

> Performed Veritas Cluster Server VCS failover testing to ensure OS

High Availability at Primary Site.

> Implemented Oracle Data Guard monitoring using custom scripts,

Sysedge monitoring software integration.

> Executed Proactive performance tuning of Data Guard, Worked with

Oracle Support, Oracle BDE to resolve Oracle bugs.

> Trained junior Tier 2 DBAs for proactive and reactive DBA tasks for

Data Guard / VCS environment.

> Automated customer weekend batch jobs and implement monitoring of

customer batch jobs via scripts.

> Supported customer development team in rolling out major database

code functionality in production ensuring stability.

> Received excellent customer feedback after implementing and

stabilizing customer Data Guard, Weblogic applications.

. Senior DBA/ Operations Engineer providing Oracle 10g RAC DBA support to

customer, International Speedway Corporation (ISC Motorsports), an

industry giant for Motorsports activities, owner of 10 Nascar race

tracks. ISC sought SUN for remote monitoring and management services for

its core environments: ISC Interactive, Online race-car -ticketing

systems, and ERP warehouse. The combined IT infrastructure includes over

50+ Sun servers, Oracle 10g 6 node RAC Clusters, SAN Storage ST 6540s,

Weblogic, and Apache. My duties include:

> Installed, Configured Oracle 10g RAC Cluster for a 6 node multi

instances hybrid cluster.

> Performed Oracle RAC Clusterware Install, Configuration, RAC

Database Creation, Node Administration.

> Implemented Oracle RAC Best practices to ensure RAC Cluster Registry

integrity, voting disk availability.

> Proactively recommended RAC performance tuning aspects to ensure

optimal operation of RAC Infrastructure.

> Resolved complex RAC Proxy operations issues working with Oracle

support services and customer DBAs.

> Cloned production RAC instances to development and QA systems using

RMAN duplication.

> Provided performance reports and analysis of customer RAC

environment, proactive recommendations vs. reactive actions.

> Improved database performance by tuning Oracle optimizer statistics

collection using Oracle DBMS_STATS utilities.

> Applied patches to resolve Oracle RAC process death issues and

Oracle quarterly Cumulative Patch updates

. Oracle 11i ERP Applications Technical Lead / DBA providing migration,

consolidation and operations support for Sun customer, Biotage Inc, a

Global Medicinal Chemistry Manufacturing Company.. Biotage implemented

Oracle EBusiness Suite to simplify the supply-chain and manufacturing

operations and utilize Oracle Financials for corporate finance. Biotage

flex-sourced Oracle, Sun, Veritas, Storage management to Sun Microsystems

to reduce the overall IT costs. Biotage production infrastructure

includes Oracle 11.5.10 Applications, Oracle 10g Discoverer, Oracle 10g

Application Server, Oracle 10g Databases, Solaris 10 Zones, Sun v445

servers with Sun A5200 arrays. My Duties include:

> Oracle ERP technology lead responsible for successful data center

migration of entire Oracle Ebusiness Suite 11i Infrastructure of

Biotage from Oracle Corp on Demand Hosting to Sun Managed

Operations, Sun Services.

> Demonstrated successful technical leadership in performing major

Upgrade of Oracle ERP from Version 11.5.6 to 11.5.10.

> Engineered complex technical upgrade plan, process, and successful

implementation of Oracle 11i 11.5.10 upgrade.

> Installed, Configured Oracle Ebusiness Suite for Multi Node

Architecture, Solaris 10 Containers, Solaris Zones.

> Performed Rapid Clone using RMAN and AutoConfig to refresh

Development systems with Production ERP data.

> Installed patches, product packs, automate applications

administration tasks, maintained snapshots, application libraries.

> Troubleshot Oracle Applications, Apache, Jserver, Concurrent manager

issues for production environment.

> Performance tuned Oracle Applications at multiple layers: AOL

Technology stack, Self Service Web Applications, Database.

> Managed Oracle SR, / iTars, research application bugs, apply

patches, data-fixes to resolve application, user functional issues.

> Performed Oracle 11i System Administration tasks: Manage Concurrent

Managers, Report server, Discoverer 10g Server.

> Validated, documented multiple recovery scenarios for Oracle 11i

Applications and 10g Database using RMAN

. Senior Oracle DBA providing Oracle 10g 9i build, migration and operations

support for Xilinx, a leading provider of programmable logic solutions

in semiconductor industry. Xilinx engaged Sun Services to manage Weblogic

Applications, Oracle 10g Databases with VCS with EMC arrays. My Duties

include:

> Consolidated multiple instances into single physical database to a

new Solaris 10 platform using Solaris zones to reduce IT cost.

> Migrated Oracle 10g Databases from Sun Photo Array to NFS based SAN

array with Veritas VCS Cluster solution

> Upgraded Xilinx database from Oracle 9i to 10g, data validation, and

development support for upgrade activities.

> Troubleshot performance issues of Xilinx part's ordering e-site

using Oracle 10g new utilities: ADDM, AWR, Statspack

> Resolved Weblogic issues, JDBC tuning, Connection Pooling, Weblogic

Cluster management, assisted code promotion tasks.

01/2002 - 02/2003 Sevenspace Inc

Ashburn, VA

Senior Database Administrator, Sevenspace Customer Service Delivery

Organization

Role: Serve as senior Oracle / SQL Server DBA in Customer Production

Operations Service Delivery department; Remote DBA services, customer

implementations, monitoring, proactive management, network operations

center, 24x7 call management of DBA team; Subject matter expert in Oracle

technologies, SQL server support. Duties include:

> Contributed in writing Oracle Database Service Specifications for

Sevenspace Oracle Monitor, Management Services.

> Wrote Oracle 11i ERP Applications Proactive vs. Reactive Service

Specifications for Sevenspace ERP Management Services.

> Senior Oracle DBA's managing Oracle 11i (11.5.6) ERP Applications,

Oracle 9i databases for multiple customers.

> Managed Oracle Applications configurations using AutoConfig,

Performed proactive Application Administration responsibilities

> Performed Oracle 9iAS Application Server upgrade for Oracle 11i

Apps; Deployed Oracle Mobile Applications MSCA suite.

> Analyzed and documented Database and System performance using Oracle

Statspack, ADDM, AWR, Unix scripts, utilities.

> Upgraded multiple customer databases from Oracle 8i to 9i version

demonstrating extensive Oracle upgrade experience.

> Migrated customer Oracle databases from HP-UX to Sun Platform

demonstrating cross platform expertise.

> Installed Veritas Volume manager, Veritas Foundation Suite;

Configured Veritas volumes, changed software raids

> Performed Veritas and Solaris administrative tasks, volume

management, patching, working with Sun and Veritas support.

> SQL Server DBA managing SQL Server Clustered Databases for customer,

Urban Outfitters e-registration website.

> Performed SQL server proactive tasks, scheduling jobs, backups, and

support production code promotions.

> Performed defragmentation of SQL Server database to reduce file

fragmentation and limit database growth.

> Restored and Recover production SQL server database after major RAID

failures.

> Managed 24x7 On-Call rotational support matrix of DBA members; 24x7

On-Call Escalation Support

02/2001 - 1/2002 Nuclio Corporation

Oakbrook, IL

Oracle / SQL Server Database Administrator, Nuclio Operations Department

> Managed Oracle 9i, 8i database of Remedy Ticketing Systems

Application on HP UX and EMC Symmetrix.

> Upgraded Oracle Database from 7 to 8i version; consolidate multiple

databases to single physical database.

> Performed Database and Application Code Migrations and 24x7 on call

support for Production systems.

> Setup and documented backup and recovery procedures using Oracle Hot-

backups with EMC BCV, Clone Technologies.

> Resolved corruption issues in production databases; Worked with

Oracle Support to manage and escalate SR / iTars

> Automated DBA tasks, automate, schedule Database jobs, and wrote

shell scripts and database triggers, export, import.

> Improved performance of Remedy database by reorganizing database and

tune database parameters for optimal operations.

> Optimized SQL code by adding indexes, hints, analyze cost optimizer

plan, support developers.

> Performed Limited SQL Server administration tasks; junior SQL server

administration responsibilities.

03/2000 - 02/2001 IIS Inc

Tempe, AZ

Oracle Applications Database Administrator, IIS Internet Data Center

> Performed Oracle Applications DBA duties to support Oracle 11i

(11.5.1) ERP environment for AZ State Department

> Installed, configured Oracle Applications 11.5.1 in Single Node

systems.

> Installed Oracle application patches, perform application

administration duties using admin utilities.

> Performed Oracle Apache Server administration and Java tasks, Oracle

Applications DBA duties.

> Worked in a team of DBAs to upgrade Oracle Applications from 11.5.1

to 11.5.3 version.

> Upgraded Oracle database from 8.0 to 8i version using oracle

provided upgrade utilities.

> Wrote shell scripts and SQL scripts to manage oracle Hot-backups;

performed recovery tests.

1998 - 2000 Indiana Department Of Transportation

Indianapolis, IN

Oracle DBA, INDOT Systems

> Junior Oracle DBA maintaining development databases for Bridge

Management Systems software for State of Indiana.

> Created database users, roles; manage database user security,

passwords for all INDOT BridgeSystem engineers/users.

> Used Oracle export and import to transfer bridge specification data

from production to development systems.

> Worked with PL/SQL developers to write limited database code to

query bridge data.

> Managed Oracle space, performed Oracle tablespace management tasks,

maintained tables, database objects.

> Implemented Backup strategies of several databases using export

scripts, rotate backups, dump to tapes storage.

> Used SQLLoder to load data from bridge survey sheet text files to

Oracle tables.

Education Master's of Engineering, Purdue University

Certifications Oracle 10g, 9i, 8i Certified OCP Database Administrator

Solaris 7 Certified System Administrator

BEA Weblogic 7 Certified System Administrator.

Contact this candidate