Group Database Manage Resume Profile
Objective
Looking for a Senior Management opportunity in Information Technology Management and/or Enterprise Database Management and Architecture
Strategy Road Map
Enterprise Database Management
Functional Expertise
Business continuity/DR
Global IT Database Design Operations
Salesforce/Onyx
Datacenter Consolidations
Master Data/Metadata Management
Microsoft Dynamics
Public /Private Hybrid Cloud
Data Quality, Security and Encryption
Corporate/Retail Banking
Software Defined Datacenter
Business Intelligence/ Big Data Strategy
Cash Management Systems
Information Security
Datawarehousing/Datamart Design
eCommerce/Supply Chain
Capacity Management
ETL/Data Replication
Concierge/Travel Data
ITIL
PCI/HIPAA compliance
Health Care/Case Management
Professional Summary
- Currently evaluating Big Data/Hadoop/NoSQL technologies for advance analytics.
- Set up the first Database as a Service on Public cloud for International SOS by migrating the corporate development environment to Windows Azure and SQL Azure.
- Set up Disaster recovery from Datacenter in Hatboro to Vienna using EMC Recoverpoint/CE and SRM 5.5 for ERP, Concierge, CRM, Operations and Global Reporting environments.
- Experience implementing Global Datacenters from scratch including setup of hundreds of High availability Application and Database Servers including Microsoft SQL and Oracle RAC clusters, virtualization of the infrastructure using VMWare Esxi 5.5 and VNX 5700 at the backend providing high availability using vSphere vMotion technology, integrating Databases with Tapeless backups solutions using Avamar and replicating the same to offsite Datacenter.
- Experience implementing Enterprise Data Strategy including Enterprise Information Management, Data Quality MDM and Data Governance and Information Life Cycle.
- Experience managing budgets to US 2million
- Experience implementing a Shared services team under CIO's guidance for cost effective IT delivery and service.
- Currently working for International SOS and managing a Global team of DBA's USA/Singapore and India, Data and Business Intelligence architects to deliver projects and support 24x7 Production Environment with Terabytes of Databases. International SOS is leading provider of Medical Assistance and Security services with Global presence through 700 locations in 76 countries with over 10,000 employees worldwide.
- Experience reporting to Department Heads, CIO and CTO's for Strategic Business and long term IT planning. Experience working with a Global team spreading almost all the geographies and cultures. Worked Confidential
- 15 years experience in Enterprise Database Administration, Information Management, Database Architecture, Security and Business Intelligence in Datacenter and Cloud Implementations for large enterprises ranging to multi - billion dollars including Corporate and Retail Banking, Healthcare, Stock Exchange, Supply Chain, Medical and Security Services.
- Implemented very complex and large scale Microsoft technologies based DataWarehouse and Reporting solution and integrating it with SharePoint.
- Design and set up of Hybrid cloud implementation of Travel Data Solution for international SOS. The implementation consists of Database, Application and Webservers in 3 Datacenters in US, France and London. The solution is first Internet based Travel and Security Data Management solution and is one of the most profit making departments for International SOS.
- Worked on PCI/HIPAA security compliance for Databases in Global and regional Datacenters.
- Implemented Confidential Online infrastructure including disaster recovery in 2003-2004. The project consisted of setting up of more than 100 Webservers, SQL and Oracle Database Servers in multiple Data Centers and replicating Data and backups.
- Designed and Implemented, the first internet corporate banking module for ICICI bank in 2002. The environment consisted of a internet facing Webservers with Oracle Database at the backend supported by web application firewall and load balancers.
- Awards
- Received best performer award in year 2010 for Analysis, assisting in Contract Bidding, Design and Implementing High Availability Environment of Database and Application Servers for Multi-Million dollar contract for US Government Department of health 'TRICARE' and integration with WPS and other government agencies using Webservices and ETL.
- Recently worked on complex implementation of Salesforce and integration with 14 critical applications and Data Warehouse. The implementation won Asia-Pacific award for most effective user transition in year 2013. This award is provided by Salesforce to only one client each year.
- Designed and implemented 'Magellan' project, one of the Top 5 CIO award winning Applications in Asia Region in 2007. This Project integrates Call Center, Finance, CRM, and Provider Database in International SOS 26 Offices globally. The Data is distributed on 30 Database Servers throughout the world and involves SQL Transaction and Merge Replication, complex ETL packages, Analysis, Reporting and SharePoint Services based Reporting.
Core Technical Skills
Database Administration
SQL Server 2k/2005/2008/2012 Azure
Oracle 8i,9i,10g,11g
Sybase 10,12
Always On, Clustering, Mirroring, Replication, CDC, Table Partitioning, Auditing, Data Encryption, TDE, SSL, Programming, XML, Performance Tuning, Integration, Data Quality, Reporting and Analysis services
Oracle RAC, Snapshot and Multi-Master Replication, Data Guard, Security, RMAN, Cloning Tuning
Replication, Performance Tuning, Security and Backups
Database Tools
Database Design
Erwin Data Modeler 9.5
Database Backups
Litespeed, Avamar, Netbackup
Database Disaster Recovery
Recoverpoint Cluster Enabler, CA XoSoft
Database Monitoring
SCOM, Patrol, Guardium Active monitoring, Unicentre TNG, Argent, Idera Diagnostic Manager, SQL COP, Toad for SQL
Database Change Management
Embarcadero Change Manager
Database Quality
Informatica 9.1
Master Metadata Management
Informatica Powercenter
Data Scrambling
GS Data Generator
Big Data
Knowledge of Big Data/Hadoop/Yarn
Systems and Network
- EMC CLARiiON and VNX, VMWare ESXi, EMC Site Recovery Manager, Kemp Load Balancers
- Citrix, Sharepoint, Microsoft Biztalk installation and Administration, EMC Recoverpoint
- PKI, SSL, Baracuda Web Application Firewall and Checkpoint Firewall
Programming/Windows/Others
- Windows 2003, 2008 2012, VMWare vSphere, Solaris 10, 11, HP-UX 10
- IIS, Tomcat, Active Directory, DNS
- TSQL/SQL Plus, SSIS, Reporting Service, SQL Loader, Informatica cloud, SQL Cop
- DOS/Power Shell/Unix shell scripting
Project Management
- Project Management and Program Management for Large-scale systems integration
- Business Continuity and Disaster Recovery
- IT/Business Process Re-engineering
- Vendor/Contract Management
- Budgets, Proposal Justification and Cost Analysis
- Done implementation of ITIL Processes like Incident, Problem and Change Management
Professional Experience
Confidential
Job Profile: Group Database Manager Architect
Roles Responsibilities:
- Directly reporting to Group Head for Technical Architecture previously reporting to CIO and leading a Global team of DBA's and Data Architects to Design and support complex distributed 24x7 Databases Environment consisting of about 200 Database Servers globally.
- Work with IT and Business Management to determine future goals and prepare roadmap for Applications and Database architecture for the company.
- Work with Engineering team to evaluate new products, hardware, software's etc.
- Lead Enterprise Information Management, Data Quality, MDM and Data Governance projects.
- Owner of Logical and Physical Database Design, Data Flow diagrams and Data Dictionary.
- Ensure High Availability and Disaster Recovery of the mission critical Data.
- Ensure Security/compliance of all Databases according to industry standards.
- Standardize Master Data management, Capacity Management and Data Quality initiatives.
- Standardize Database Infrastructure by implementing Naming, Programming standards, tools used for Database design, Backups, Disaster Recovery, Security, Monitoring etc.
- Creating management reports/dashboard to provide status reports on Projects/Quality/Performance/Critical issues relating to environment.
- Lead the organization's initiatives in adopting Business Intelligence and Data Warehousing.
- Member of Corporate Change Management committee.
- Review Project Plan/Functional Specs/ High level Design/Detail design/Operations documents.
- Implemented Configuration and Release Management Solutions for Databases.
Confidential
Job Profile: Senior Database Administrator
Roles Responsibilities:
- Support 24x7 application Databases for Confidential . The support included Administration, Design and maintenance of about 100 SQL Servers and 50 Oracle Servers accessed by clients globally.
- Confidential Online VMSU were some of the Major Online Projects. The support extends services to 14 countries including Asia-Pacific and Europe.
- Designed, Implemented Security and Disaster Recovery of Application Databases.
- Installation of SQL Servers, backups, Capacity Planning, Monitoring and Performance Tuning.
Confidential
Job Profile: Assistant Manager
Roles Responsibilities:
- Deputed with Product Technology Group PTG reporting directly to Group Head, responsible for all IT related matters of the Wholesale Banking group of ICICI Bank some of which include, websites aimed for Corporate Banking and Forex transactions, Cash Management System and Check Processing systems.
- Handling a team of 8 people supporting about 150 SQL Server, 75 Oracle Databases and 100 Application Servers including Web Servers, Citrix Metaframe, Middleware Domain Servers
- Designed and implemented Databases for SQL Server 7.0, 2K and Oracle 8i, 9i .
- Set up backups, Disaster Recovery and auditing.
- Setup Monitoring of Database Servers and Web Servers using Unicentre TNG
- Designed Database and programmed various Stored Procedures, Triggers
- Carrying new initiatives to introduce New Technologies in Bank for Automation Monitoring of the Systems and Applications.
Confidential
Job Profile: Systems Officer
Roles Responsibilities:
- Designed and implemented of a in-house built screen based distributed Oracle database system based application developed to keep Finance, Personnel, Sales, Stock, and Marketing etc. information for IPCL all over India.
- Administration Of about 50 Oracle SQL Server databases and the Application
- Installation and Administration of Win-NT servers, AD and the LAN for office
Confidential
Job Profile: Engineer - Systems Integration
Roles Responsibilities
- Deputed onsite at Stock Exchange responsible for maintaining a Trading System developed by CMC for Stock Exchange.
- Database administration of Sybase 10,11 .
- Unix shell scripting for administration tasks.
