• Safeguarded and encrypted production databases, masked sensitive data, and minimized locking and deadlocks in Production environments.
• Re-wrote and tuned reporting queries for performance (at time by x50), automated refreshes of several lower environments and managed AG.

• Administered Production database servers 24/7 operations for online e-commerce, ETL and reporting, on premise and Azure environments. Set up and maintained Availability Groups (AG) for HA/DR, and SQL Replication.
• Troubleshot and resolved long running processes, blocking, locking, deadlock & concurrency, tempdb & transaction logs, storage and other resource contentions, applications, I/O, Memory, CPU, disk and network.
• Improved performance of apps and complex report queries and optimized throughput by > 40% via query tuning, proper indexing, server configs and execution plans.

• Designed and implemented the onboarding/ingestion of data from SQL Server databases into Azure Cosmos DB.
• Managed the execution of data extract, data generation, and deployment; diagnosed and resolved failure issues.
• Created improvements in automation and ensured pipeline processes completed within SLA.
• Member of Data Engineering responsible for the data integrity and reliability of ETL pipelines for XBOX.

• Provided 24/7 and subject matter expert support; monitored and resolved server/database issues, optimized queries and plans, indexes, schemas & SQL Server configurations; performed code reviews and assisted in T-SQL.
• Installed, configured, patched, troubleshot, monitored, optimized, set up and maintained HA & DR solutions (Failover Clustered Instance & Always-On Availability Groups), Security, backup/recovery schemes and encryption.
• Defined and automated processes, ETLs, issue tracking, and documented the database environment w/ Dataedo.

• Administered, maintained and supported multiple SQL Server production servers with large databases (60 TB).
• Performed tuning and troubleshooting of database and application server processes, developed and optimized T-SQL stored procedures/ triggers, and SSIS packages.
• Implemented High Availability using Failover Cluster Instance (FCI) and Always-On Availability Group (AG).
• Performed capacity planning, migrations, backups and data recovery, automated administrative and data integrity tasks, created deployment scripts.
• Perform T-SQL Code Review and code releases using Agile Project Development Methodologies, directed 3 junior DBAs , and assisted the Dev team with T-SQL.

• Supervised 3rd party vendors (Blackbaud CRM & SAS) to integrate their applications with in-house databases, applications and business operations.
• Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Set up Disaster Recovery (AG) and SQL Replication to remote sites, and mentored the Dev team on writing T-SQL.

Ops Tech Lead

• Presided the global roll-out of the IBM Infosphere Guardium infrastructure and database on-boarding process, built the architecture and set up Guardium monitoring in the Production/ UAT/ DEV environments.
• Maintained the Guardium incident management, patch management, change and request management.
• Tracked key performance and capacity metrics to ensure the on-going uptime of the infrastructure of the appliances.
• Designed custom reports to use data from application repository along with Guardium data, and facilitated the review and audit for regulatory compliance.
• Performed testing and certification of the software component of Guardium (STAP) for Sybase, Oracle and MSSQL.
• Teamed up closely with Network Provisioning to install the taps/tap Aggregators and connect them to the Collectors.

Sr. DBA/ Data Analyst/ Architect

• Managed multiple instances of production SQL Server 2K-2012, including installation, configuration, patching, replication, indexing, backup/recovery, capacity planning, HA & DR solutions (Failover Cluster Instance, Log Shipping, Database Mirroring).
• Performed tuning of database and application server processes, developed and optimized T-SQL stored procedures and triggers - gains achieved were 50x at times.
• Analyzed technical requirements, designed new data model and developed an application for 'Patent Tracking', for which I was the recipient of the prestigious annual Star Award in 2010.
• Developed scripts to automate database management processes; wrote and maintained technical documentation, defined & enforced database standards, practices and methodologies.
• Monitored database capacity, identified potential data growth, assessed current virtual hardware and software performance and capacity loads, and proposed solutions in a proactive manner.
• Built, deployed and maintained SSRS & SSIS artifacts and designed and generated reports using BIDS.
.

Professional Services Consultant Engineer

• Managed onsite implementation and system integration of Guardium software security of this Linux-based network appliance that safeguards databases, facilitates Audit & Compliance, and addresses regulatory compliance (SOX).
• Provided outstanding customer service during engagements by troubleshooting complex technical situations, and resolving issues, problems and concerns to customers' satisfaction.
• Performed pre- and post- sales technical presentations, support and customer training as needed per engagement.
• Responded to technical components of Request for Proposal (RFP) and Request for Information (RFI).
• Identified, isolated and reported bugs in Guardium software that were fixed by interfacing with QA and Development; proposed few improvements that were implemented.
• Acquired and maintained expert knowledge of Guardium products and implemented solutions for over 50 customers.
• Provided timely and professional customer interaction (verbal, written or Webex) and solicited customer feedback to improve service and respond to customer requests and ideas.
• Created and maintained a knowledge-based system, technical documentations, best practices and methodologies.
• Gained proficiency in MySQL, the RDBMS in this appliance-based technology – and was the internal MySQL DBA.
• Supplanted Technical Support's documentations with knowledge acquired from professional services engagements.

Developer/ DBA/ Analyst

• Developed and supported trading systems for the Futures, Forex, Options, and Equities of a Hedge Fund. Applications included Price Collection, Trading Signal and Order Generation, Slippage Reporting, and P&L reporting.
• Managed a production environment consisting of 30+ databases, and 10 production workstations, with large data load cycles and OLTP-based mission critical trading systems.
• Administered Price Collection operations and oversaw daily operation of batch systems for portfolios totaling $800m.
• Engineered a database and code migration from Informix-SQL/4GL to Sybase using T-SQL, ‘C’ & DB-Library.
• Built UI/UX (PowerBuilder) for a Risk Management System to enable analysis of positions.
• Extensive experience with the following systems: SYBASE (T-SQL, APT-SQL, DB/Library), PowerBuilder, Sybperl, Solaris, Bash & Korn & 'C' Shells, awk & sed.

IT Architect/ Specialist     (Professional Services Consultant)

• Reengineered mainframe insurance apps and converted VSAM files to run on SUN Ultra E6000 (36-nodes SMP under Solaris) with SYBASE 11 and an IBM SP (MPP architecture under AIX) with IBM DB2/PE.
• Engaged appropriate technical resources during the pre-sales process, and performed data modeling, database administration, performed data conversion, data migration, data analysis and data transformation.
• Was a major technical influence in the sale of IBM SP hardware and DB2 Parallel Edition RDBMS to Prudential.
• Provided technical support in sales presentations and sales support, and prepared sales proposals for IBM hardware and software solution systems.