Highlights:Subject Matter Expert

Skills:DBA, DB Architect, Production Support Manager, Release Manager

Membership:PASS

Certification:MCITP(DBA) MCTS

Honor:Young Software Manager (YSM) TecnoCampus - IBM School of Software Excellence

Sr DBA\DB Architect 01/2011 - current
GroupM, Singapore, Singapore Singapore
Industry: Media
• Global SQL Support over 3000 databases on 350 SQL Servers in production and pre-production environments (SQL Server 2005, 2008 and 2012) • Build/Install Clustered SQL Environments and releases best practices • Build support and implement DW architecture using traditional HW and Fast Track Warehouse • Resolve Performance issues and issue future proof guidelines to avoid it. • Implement, maintain and upgrade the Microsoft MPP offering Parallel Data Ware House (PDW) • Remediate SOX issues and Plan future proof SQL Strategy.
• Global SQL Support over 3000 databases on 350 SQL Servers in production and pre-production environments (SQL Server 2005, 2008 and 2012) • Build/Install Clustered SQL Environments and releases best practices • Build support and implement DW architecture using traditional HW and Fast Track Warehouse • Resolve Performance issues and issue future proof guidelines to avoid it. • Implement, maintain and upgrade the Microsoft MPP offering Parallel Data Ware House (PDW) • Remediate SOX issues and Plan future proof SQL Strategy.--
Sr Global DBA 08/2010 - 08/2011
Credit Suisse Bank, Singapore, Singapore
Industry: Investment Banking
Senior SQL Server DBA / Global Infrastructure DBA Support/ Consultant
Global DBA support for Fixed income Interest Derivative/Market Risk applications Level 3 support/SME for recurring production issues. Design and Implement best practice strategy for DB maintenance including VLDB Developed daily Intelligent index optimization and update stats code for DBA Responsible for Capacity planning, HA/DR design and implementation. Architect of archival strategy, keeping maximum availability with minimum downtime. Minimize Storage, netbackup footprints by DB Partitioning, Filegroups and compression Build Single Click install for DB Rollouts in all pre-prod environments SSAS Administration and On Call assist to Trading community on DB/Risk Cube issues. Enhance responsive and effectiveness of DB by suggesting index improvement based on usage.--
Global MSSQL Lead 08/2009 - 08/2010
Deutsche bank, Singapore, Singapore
Industry: Investment Banking
Senior SQL Server DBA / Global Support SQL Lead/ Consultant
Global Production Support over 3000 databases on 500 SQL Servers in production and pre-production environments (SQL Server 2000, 2005, 2008) Preparing and Implementing Backup Plans using Litespeed, Routine maintenance plans Configurations & ensuring smooth functioning of DB Mirroring, Log shipping and replications Responsible for Database tuning, creation, design, Capacity planning etc Database design using partitioning, Filegroups and recommendation for improvement to developers Used SQL Profiler and performance monitor to access database performance Responsible for SQL Server installation build for new applications Upgraded SQL DB version 2000 to 2005/2008 Supported SQL Server production & pre-production release roll-outs Troubleshoot & fix performance issues along with on call support to Sybase Design and implement index fragment solution with minimizing blocking bottlenecks. Design & development of preprod /integ /development DB refreshes with Production data Pilot the Sun support Model by integrating the alerting mechanism using Tivoli, Foglight--
Database Architect 08/2006 - 09/2006
Agilent INC, Santa Rosa, CA United States
Industry: Manufacturing
Database Architect / Technical Lead / Consultant
Analysis of the current Product Life Cycle Management (PLM) System & supply chain process for different departments/groups in Agilent Technologies, Inc. Capture the reporting requirements of different business groups and evaluate best suitable Product Design supply chain warehouse in SQLServer for Agilent by leveraging existing other 3rd party Data Warehouse (DW) and migrating few existing applications data from SQL 2000 Design the DW architecture SOX compatible & IT supportable.--
Sr MSSQL dBA 12/2006 - 07/2009
JPM Chase Bank, Columbus, OH United States
Industry: Investment Banking
Senior SQL Server & Sybase DBA / Team Lead/ Consultant
Administered SQL DBs for Asset Wealth Management- Private Client/Private Banking applications Designed backup/HA strategy and full proof disaster recovery plans with SRDF, Clustering, DB mirroring, Log shipping & Replication. Implemented light speed backup, stripped backup, parallel backup and object level recovery features Responsible for Database tuning, SQL Profiler tracing, Performance monitor & DTA Implemented best practices on tables, indexes, views and code in order to optimize performance Analyzed bottleneck in Databases and made recommendation for improvement to users Design and migrated all SQL Agent jobs to enterprise schedulers Autosys & Control M Migrated databases from Access/Sybase to SQL Server 2000/2005/2008 Supported SQL Server production & pre-production release roll-outs Design & development of preprod/integ/development DB refreshes with Production data Transformation and Uploading the information from different platforms into SQL Server databases using SSIS/DTS packages Plan & Manage auditing on critical info for SOX purpose. Automated & Developed “SQL Job Monitor” to monitor all jobs that are running on multiple SQL Servers. It sends a page/email to the concerned application support according to the error severity Developed “Auto Queue Manager” to monitor the tickets that users have opened. This program sends a page to the concern application support person according to the application. This automated task replaced the queue manager role whose job is to monitor the tickets and inform the appropriate application support person--
SQL Team Lead 07/2005 - 07/2006
Indian Aiir Force, Delhi, India
Industry: Defence
SQL Server DBA / Team Lead / Consultant
Implementation of an on-line materials management application covering entire logistics functionality relating to Demand Management, Material Transfer, Transportation, Store Procedures etc. Managed team of 23, Responsible for induction, build and appraisal of team members Project planning and execution. Effort estimation, project status reporting, project management reviews and audits. Client interaction – Acceptance Testing approval, negotiating to finalize requirements. Creating policies for taking the backups and recovery procedures Conducted deployments of objects and data through development, testing, pre-production and production environments. Responsible for tuning data, indexes, and queries. Scheduling and Monitoring Batch jobs Automation of batch jobs Optimized SQL in SQL Server for better performance. Data Migration from one database to another Fix of replication issues. Configuration Management. Team management, Resource Management. Performance evaluation of the team. Ensuring proper utilization of human resources Training and Mentoring of team for professional growth. Client interaction for user training, requirements negotiation and status reports.--
Fixed income trading/Global Risk Lead 12/2003 - 06/2005
Merrill Lynch Investment Manager(Blackrock), Morisvillie, PA United States
Industry: Investment Banking
Application Support Debt (Fixed income Trading, Global Risk) / Team Lead / Consultant
Analyze and optimize of the Middle and Back office and Interface with Front Office System Modification/Enhancement in the Existing system Managed team of 9 including 3 onsite and 6 offshore resources. Client Coordination, support and status meetings Attend weekly status meetings with the department leads Project planning and Task Allocation to Team Project estimation Maintain schedules Costing and controlling the quality of product/service Tracking and Mitigating the Risks Analyzing and reporting metrics related to service levels Manage knowledge transfer process Delivery management and Progress reporting Track service delivery Metrics Coordination with offshore team Induction and Team Building SQL Server DBA support for in-house Merrill applications.--
Infrastructure DBA 03/2002 - 11/2003
Goodyear Tyre & Rubber co, Akron, OH United States
Industry: Manufacturing
UNIX Admin / Oracle DBA / Consultant
On call production Unix SA/DBA support for Goodyear Business Management System (GBMS) Point on sale (POS) application infrastructure. GBMS infrastructure Enhancements, Testing & Maintenance Oracle Database Activities Support. Day to day UNIX administration--
SQL Developer 11/2000 - 03/2002
AIG, Newyork, NY United States
Industry: Insurance
Application Support & Development, SQL Developer
Contracts & Claim processing from monthly text feeds Data Conversion (Convert all text data for SQLSERVER tables, Prepare format files) Month End Report Generation (Summary table generation for Month end Reporting) Application SQL Server DBA responsible for Stored procedure, tables, views, triggers, rules, defaults, constraint, jobs and other back-end stuff. Day to day Backup and restoration.--
SQL DBA 01/2000 - 10/2000
BestBuy, Minneapolis, MN United States
Industry: Retail
SQL Server DBA Application Support & Maintenance (ASM)
Production DBA support involved 24*7 Support Database Backup & Restore Handling small performance issues Scheduling and Monitoring Batch jobs Automation of batch jobs Data Migration from different systems to SQLServer User administration and auditing. Optimized SQL in SQL Server for better performance. Technical Documentation regarding all these.--
Application DBA 03/1999 - 01/2000
KLM Airlines, Delhi, India
Industry: airlines
Development DBA SQL Server 6.5
Provided DBA and System administrator duties for development databases Creating policies for taking the backups and recovery procedures. Doing Essential Changes after monitoring the growth of the database. Design User Data types with rules/defaults binding to keep uniformity between objects Table and optimal access strategy design Writing Stored procedures/triggers for reusability, speedy output and security Visual Source Safe Administration, Version control and release management Data Migration/loading from different sources. Performed daily administration, monitoring, and documentation of SQL Servers Database Messages creation, Database Installation Script Creation, Database Task Creation--

Osmania University 01/1992 - 03/1995
Hyderabad, , India
Degree: Bachelor's Degree
Major:Maths
BA Math, App Math, Statistics

Sr MSSQL DBA
Sr DBA\DB Architect MSSQL, DBA, ARchitect, Developer