Milan Dave

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

Clarks Summit, PA 18411

Ph: 570-***-****

Email: acd8hh@r.postjobfree.com

Expertise:

Over 18 years of success in distributed application architecture; RDBMS development and

administration, relational data modeling, object oriented design and development, user

interface design, and leading projects.

Experience Summary:

Over 18 years of diverse professional experience in Database Administration, Systems

Architecture, Design, Development, Data Modeling, Database Design and Testing of

application software in Client/Server environment.

Extensive coding experience of Stored Procedures, Triggers, Enhancing the SQL Code,

Optimizing and recommending highly scalable code and designing highly scalable server

architecture.

Experience in Monitoring, Trouble shooting and Performance tuning, Capacity planning and

Designs of Secure scalable database servers and n tier client applications in stand alone and

datacenter environments.

Strong Client/Server architecture skills and managing .net applications.

Specialization in design and implementation of High Availability methodologies using FailOver

Clustering, Mirroring, Log shipping, Replication and AlwaysOn Availability Groups and

Stand by environments.

Extensively worked on Windows and UNIX platforms.

Provided Architectural direction and hands on review of code before release of new

applications in production environment and future code releases.

Extensive experience as Senior SQL Server DBA providing on call Production support of over

350 mission critical production SQL server 2000/2005/2008 and 2012 instances and more than

1000 QA/UAT/DEV servers involving both physical and virtual builds.

Exceptional Project management, communication, Documentation and Project leadership

Skills. Self motivated; self managing; able to excel as both team leader and team player;

willingness to mentor; excellent documentation skills; highly effective in communicating with

end users, project team, and executives.

Education:

Master of Science in Engineering, Univ. of New Haven, CT

Clearance: Trusted, TRICARE ADP IT II certified

Certifications: MCDBA (Microsoft Certified Database Administrator)

Environments and Operating Systems:

Operating Systems : Windows 2008 R2 Clusters, Windows 2003 clusters in

Data Center servers and Stand alone, Windows Azure,

Unix Sun Solaris.

Hardware : HP Proliant DL 580 series, IBM, EMC, Sun Sparc

2K/5K/10K/15K, IBM RS6000, HP 9000, Dell

PowerEdge 6650

DBMS : MS SQL Server 2012/2008 R2/2008/2005, SYBASE

12.x/11.x/10.x, Oracle 11g/8i

Languages/Tools : Powershell 2.0, Windows Scripting, VB scripting,

Transact SQL, ISQL, OSQL, SQLCMD, SQL DMO,

RDO, SQR 3.0, C++, Visual Basic 6.0/7.0

Packages : Microsoft Sharepoint 2007/2010, SCCM, SSRS,RedGate,

SQLLitespeed, DBArtisan, ErWin, TDPSQL, EMC

Powerpath, EMC Avamar, BMC Patrol, Digital Guardian,

Optim for Data masking and Archiving, Visio, Crystal

reports, Master Data Management (MDM)

Professional Experience:

Metlife Group Inc., New York, NY July 2000 – Present

Most recent Project Involvement: Oct 2003 Present

Senior Database Administrator/ Information Systems Consultant;

MetLife Investors, Inc., subsidiary of Metlife Financial Services, Newport Beach, CA

http://www.metlifeinvestors.com

Leading provider of variable and fixed annuities and variable life insurance products. Currently the

highest revenue producer of the MetLife family of companies, which together serve approximately nine

million U.S. households and 87 of the Fortune 100 companies.

Lead Database administrator over all SQL Server instances at MetLife Investors (7

•

production instances; 14 QA and development instances). Database instances are

used for production deployment of 16 highly critical applications such as Annuity,

Long Term Care, Cash Control, Transfer Of Assets, CRM, Data warehousing and

Management Reporting.

Defined and managed several projects designed to improve, optimize, and harden and

•

OS migration and SQL migrations of MLI’s production, QA, and development

database environments. Managed activities of other database administrators.

Provided ongoing application analysis and optimization recommendations for four

major application development teams. Mentored SQL developers and database

administrators. Automated the maintenance, backup, and replication of databases

from the production site to the development and failover sites. Automated production

server profiling (capturing 20+ million requests per day) and created analysis tools to

mine the profile data. Enhanced mission critical ETL applications using C#, .NET,

DTS, and VB 6.0. Introduced formalized workflows for various production change

processes.

Designed and created a distributed application workflow agent that executes and

•

monitors mission critical ETL jobs, extranet file transfers, and server maintenance

jobs spanning multiple servers and networks. The agent’s functions include operator

notification of job status and other application events across the enterprise.

Workflows can be defined with file dependencies, job/application event dependencies,

scheduling, execution branching, wait timeout warnings, and run timeout warnings.

All dependencies are tracked through a distributed event log. The agent is written

completely in Transact SQL, leveraging native SQL Server functions for scheduling

and job hosting.

• Planned, reconfigured, redesigned and completed Data Center migration from West Coast to

East coast and Geographic fail-over of database layer using EMC SRDF and web/app layers

with GSS. Improving business continuity by designing and implementing LOCAL

BCVs(business continuity Volumes).

• Designed, configured, deployed More than 25 SQL Instances and 4 Batch processing servers in

clustered environments for datacenter migration.

• Planned, tested and implemented alternative Failover scenario using Log-shipping, TDPSQL

and SQL LiteSpeed tools to achieve RTO of 1 hr.

Developed and maintained Multi dimensional cubes in Prod, DR, QA and Dev

•

environments for Individual Business Policies and activities.

Also, worked on following Project engagements as Senior DBA on Institutional, Individual and

corporate Lines of Business Projects:

• Designed and Implemented Disability Research dataload and Datamart application on SQL 2008

database cluster using Resource-Governor. Achieved required SLAs for recovery using SRDF.

• Involved in Unicode migration of Remedy 7.1 to 7.6. Implemented SQL server replication for

Remedy reporting on sql2008 clustered platform.

• Involved in server build and release of Systems center configuration manager 2012 (SCCM) into

Production on SQL2012 clustered primary and replicated sites.

• Migrated sharepoint 2007 content databases to sharepoint 2010 (on SQL2008 R2) using combination

of db scripts and Quest tool. Designed, configured and implemented production database servers

on windows 2008 R2 on 5 node cluster in datacenter environment. Implemented disaster recovery

using combination of log-shipping and EMC SRDF.

• Maintenance and Production support of 12 Tricare SQL instances of OFAC, E-leeds and 6 other

critical Tricare applications.

• Completed Feasibility studies, design and Implementation of BluePrintSystem software for IT

projects requirements on SQL2012 platform.

• Worked on implementation of Global Compensation platform for Metlife’s US and Japan

operations supporting (more than 10000 users) using SQL2012 and Informatica.

• Involved in Enterprise Architecture re-mapping project to unlock the power of data- access of

from and among various lines of business (LOB) and creation of MetLife Knowledge Management

(KM) portal.

• Provided Production support and enhancements for Vantive ARC and Vantive Mutual Fund

project for MetLife financial services.

• Involved in Architectural redesign of database, presentation and application layers of MetLife

Intranet Environment (MWW) and related applications supported by this site.

• Provided Production support and automated data feeds from other Enteprise applications and

from NASD for highly mission critical Enterprise Licensing and Registration (ELR) application.

The applications maintains the Enterprise licensing and registration and NASD Exam information

for MetLife and its Affiliate agents and their detailed client information. Separated Presentation

and web tier for its web inquiry application for meeting enhanced security guidelines.

• Provided enhancements on Customer Information system for the MetLife Instititutional clients

and Desktop Lifecycle Management (DLM) project.

• Designed and implemented and supported Transactional based replication for reporting of Vantive

problem and change management application from Peoplesoft.

• Supported Enterprise Enrollment system for the Enterprise employees’ access of information and

HR feeds. Improved performance of daily data feeds.

• Involved in design, configuration and migration of legacy data into Horizon (SIEBEL) Data

warehouse that provides Customer Relationship Management ( CRM) solution for Sales Support

and Voluntary Benefits business.

• Designed Database integration and improved availability for MetLife Field agent web portal

(iMetportal) and Metlife Producer Portal by improving data layer access architecture of

datachannel (middleware Java application from netegrity) and by deploying stable Windows

Cluster Hardware solution.

• Single sign-on (SSO) system design and implementation for uniform view to the MetLife customers

in various Lines of Business (LOBs).

• Improved CPU peak usage and reduce database I/O waits by redesigning databases structure and

DTS feeds from a third party vendor Sunopsis (Fujitsu, (Japan)) on MetLife International MetLife

Korea Datacenter Project. Improved performance of highly critical MetLife Korea Annuity

application and improved it availability for data access during business hours.

Role :Information Systems Consultant / Senior Database Administrator,

TRICARE ADP IT II certified DBA

Environment :Windows 2008/2003 advanced and data center servers, Windows 2003

servers, VMWare, MSSQL Server 2012/2008/2005/2000,SSAS 2008/2005, OSQL,SQLCMD, Patrol

3.5x for Windows/Unix/SQL Servers platforms, Ervin, RedGate Tools

HSBC (Formerly Republic National Bank of NY)

Brooklyn, NY. June '98 to July 2000

Involved in Design, Development, Testing, Configuration and Implementation of Loan

•

Origination, Secondary Trade and Servicing Systems.

• Designed and Developed Credit Scoring Engine for Loan Analysis (Pre Approval) and Decision

making process.

Involved in the Development and Implementation of On line Credit Request/Response System

•

for Automatic Ordering of Credit Reports, Automatic Loading of Trade lines and Credit

Scoring Process.

Installed, Configured and Maintained Database Servers Employing Very Large Database

•

Systems (VLDBs) as well as Forms, Reports, Communication Manager Servers and

Transaction Processor Servers for three major Production Sites ( NY, FL, CA) involving MS

SQL Server and Sybase servers. Replicated secondary loan closing database to NY using

replication.

Configured and Monitored and Trouble shoot Communication Server for EDI Transactions.

•

Created and Resolved of EDI tasks related to Transaction Management and Message

•

Maintenance.

Created, Maintained and Enhanced the SQL Code for Loan Origination and Secondary Trade

•

and Servicing Systems.

Created New Attachments, Business Rules, Task Groups and Tasks Definitions related system

•

set up for the Load Loan and Loan Linking enhancement of an existing Loan Origination

System.

System Administration related to loan, forms, reports, tasks and business rule maintenance and

•

operations.

Designed, Implemented and Maintained Transaction Based Microsoft SQL server Replication

•

in a Multiple Publisher/Multiple subscriber scenario between Home and Branch Offices.

Completed thorough Performance Monitoring and tuning related to server configuration, SQL

•

code enhancement and Load balancing for high concurrent User load.

Designed, developed and Implemented an automated feeding process for feeding Quality

•

Management Resource (QRM) data in a combined Sybase Data warehouse servers for the

company’s very critical decision making process and applications.

Designed, Developed and Implemented Backup and Disaster recovery Procedures for

•

Enterprise Servers and VLDBs with Storage Area Network (SANs) Using ARCserverIT

Backup Agent.

Role : Senior Database Administrator / Systems Administrator

Environment : Windows NT 4.0, MSSQL Server 6.5/7.0, IIS 3.0, Distributed Crystal

Reports 5.0/6.0, Visual Basic 5.0, TSQL, ISQL, Forms Designer I 32

Fannie Mae, Washington DC Dec. 97 to June '98

Responsibility included Support, Configure, Install, Trouble shoot the database problems,

develop code, assist the developers on Sybase, MS SQL Server databases. Supported wide

range of database applications company wide primarily on a Production unit. I was involved

in Production support as well as Development and Acceptance support on Sybase, MS Sql

Server systems. The systems maintained on very large databases ( VLDB ), the support and

development was very critical to the business applications. Systems monitored on round the

clock basis.

Credit Loss Management (CLM) system: As a member of CLM production

support team was able to improve the performance and stabilize the

critical processing of CLM suite of systems. The improvements in the

system stabilized the environment and increasing the system availability

time from 11:00 a.m to 8:00 a.m. each day. Due to the team's efforts

Fannie Mae was positioned to roll out a key third party business

initiative.

Recourse Analysis and Processing (RAPS) system: Involved in improving the

reliability and performance of RAPS batch processing. The daily, weekly

and monthly batch processing required time more than available in the

batch window, causing users to lose the system during the day.

Identified performance enhancements, automated manual processes, setup

regular database performance monitoring, and tested and installed one of

the first SUN Ultra 5000s. The result of our support activities was

reduction in the batch processing time by about 100 hours and 300%

improvements in the on line response time.

Event Fault Management(EFM) system: Main task was to recognize and react

to business process interruptions. Worked closely with infrastructure and

applications teams to develop prototypes in advance of developing

production models. Exceeded the challenge by implementing key

enhancements for early problem detection and faster notification to the

correct support group. The efforts resulted in reducing the number and

severity of problems in the environment, minimizing risks to on going

business processes and increasing the reliability of the environment.

Primary Responsibilities and Tasks involves:

Installation, configuration, and maintenance of servers in various

•

environments.

Installation, Configuring the MS SQL Servers, Sybase Servers.

•

Upgrading Sybase 4.9 to Sybase 11 and perform problem determination,

•

isolation and resolution related to Sybase issues.

Performance and tuning of SQL servers and application issues related to

•

migration.

Implement changes to the Sybase servers & MS Sql Servers as per the established procedures.

•

Testing of applications for performance, data integrity and validation

•

issues.

Data Transfers between various servers using BCP

•

Managing Disk space on Unix and NT systems

•

Scripting the Database Consistency Checks ( DBCC ), scheduling the scripts to run daily and

•

weekly basis.

Complete automating on Unix and NT so that the tasks are run with out user monitoring.

•

Assisting developers with code enhancements, indexing the tables properly.

•

Writing the stored procedures, checking the code for efficiency

•

Database monitoring using system tools and third party tools.

•

Setting up the monitoring triggers on NT for SQL Server databases

•

Develop and maintain in house utilities to automate problem

•

determination, change implementation and monitoring activities.

Recommend improvements to bulletproof and enhance the reliability,

•

availability and scalability of existing environment.

Administrative and Production support for various applications in all

•

environments.

Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures,

•

Contingency plans. Testing and Implementing these procedures.

Routine backups and restoration when necessary. Testing the backup and restoration plans.

•

Role : Database Administrator / Systems Administration

Environment : Sun Sparc 2000, 5000, Sun Solaris 2.5, Windows NT 4.0, Sybase 11,

4.9x, MS.SQL Server 6.5,TSQL, ISQL

Marion Environmental Inc., Chattanooga, Tennessee Mar. 96 to Dec. 97

Installation, configuration, and maintenance of Sybase SQL servers and MS Sql Servers.

•

Installation and configuration replication server.

•

Data modeling and design experience using data modeling tools to

•

design the system using Flowcharts, ER Diagrams.

Administrative support for various applications in production

•

rollouts.

Performance monitoring and tuning of Sybase SQL servers and MS Sql Servers.

•

Creation, maintenance, backups and restoration of databases.

•

Creation and maintenance of devices on Sybase SQL server.

•

Creation of logins and user ids and setting up privileges and

•

procedures for protection of data.

Responsibilities included creation of database objects like stored

•

procedures, triggers, tables, indexes, views, rules, defaults etc. and

tools to monitor capacity besides other parameters on the Sybase SQL

server and MS Sql Servers.

Optimizing database objects and streamlining applications.

•

Created many financial reports in SQR 3.0. Developed shell scripts

•

using embedded SQL that built sybase tables from which these reports run

off. Extensively worked on setting up the batch processing.

Role :Database Administrator

Environment :IBM RS 6000, IBM AIX, Windows NT 3.51, Sybase 10/11, MS SQL Server 6.0,TSQL,

ISQL, SQR 3.0

Upjohn Pharmaceuticals, Hamden, CT Jan. 95 to Feb. 96

Responsible for customization of an MRPII package using Sybase 4.9 and

•

Transact SQL. Designed, enhanced, implemented and integrated the

•

Purchasing, Inventory, Supplier, Customer and Sales modules.

•

Involved in extensive interaction with the end users to determine

•

client needs and the design and enhancement team during the

customization of the system

Experience includes installation, maintenance of servers, creation of

•

devices and databases as well as backups and restoration procedures.

Responsible for creation and maintenance of database objects like

•

tables, stored procedures and triggers.

Designed and developed new transactions to resolve discrepancies in

•

the automatic invoice matching process against the Purchase Orders and

Receipts.

•

Development included experience on X windows, RPC, Client Server

•

interaction.

Generated reports using SQR 2.0.

•

Role :Programmer/Analyst, Database Administrator

Environment :HP 9000, HP UX, Sybase 4.9, TSQL, SQR 2.0

Contact this candidate