PROFESSIONAL SUMMARY:

• Solution Architect with 11+ years of consecutive Information Technology experience on a wide variety of platforms, hardware, databases and operating systems in multiple industries
• AWS Certified Solution Architect - Associate (AWS CSA), Microsoft Certified Professional (MCP) & Microsoft Certified Solution Associate (MCSA) - SQL Server 2012/2014
• Experience with providing DB solutions on AWS on EC2 vs RDS
• Expertise and specialization in engineering, implementing and supporting applications on Enterprise Level focusing databases & application management tools on Windows/Linux Platforms on premises and also on public cloud
• Strong experience in High Availability such as SQL Server Failover clustering, LogShipping, Mirroring & Always On
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Designed, scripted and integrated automated processes across database management systems to significantly reduce administrative overhead

TECHNICAL SKILLS:

Cloud Technologies: AWS/Azure

Database Technologies: MS-SQL Server 2008,2012,2014,2016

Platforms: MS Windows Server (2016,2012,2008), Unix, Linux

Database Skills: Performance & Tuning, Backup & Recovery, Clustering, Log Shipping, Always On, Replication, Implementing & Supporting High Availability Architecture

Other DB Tools: SQL Reporting Services, Performance Profiler, Microsoft Analysis Services

Scripting Skills: PowerShell, Perl, VBScript, VuGen

Synthetic Monitoring & Management Tools: Idera Diagnostic Manager, Litespeed Backup & Recovery Tool, NetIQ AppManager Suite, Ionix/Smarts, SCOM, Keynote, HP BSM/BPM, Understanding of ITIL, Change Mgmt. & Incident Management Practices, Security, Project Management, IT Continuity management, NAS, SAN, Virtualization, Active Directory, DNS, VMWare, Familiarity with deploying DBs on Cloud Technologies AWS EC2 vs AzureVM (IaaS), RDS vs Azure SQL DB (DBaaS)

EXPERIENCE:

Confidential, New York, NY

Sr. System Engineer

Responsibilities:

• Architect DB Solutions on AWS on EC2 / RDS
• Leading database engineering projects not only from planning phase but to implementation phases including automation, patching, upgrades, consolidation
• Lead virtualization/consolidation project to move existing physical SQL Server infrastructure to Virtual SQL Server platform and successful completed within 18 months
• Utilized index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning on mission critical databases application servers
• Reviewing & auditing current processes and introducing automated process to avoid manual intervention
• Engineered and implemented File System Hygiene Report which help firm to reclaim multiple terabytes of space on storage systems
• Work closely with infrastructure teams (Networking, Unix, Windows, Backup, Compliance) teams, and business units to develop a viable and consistent capacity and recovery solution for all SQL databases
• Performing POC on new or existing tools for database technologies and provide feedback to senior management on pros and cons to integrate any solutions. (For Instance: Cohesity Implementation, Azure vs AWS)

Confidential, New York, NY

Sr. DBA Engineer/ Administrator

Responsibilities:

• Responsible for Databases Support & implementation, operation deployments, advanced configuration, management and administration on all the wealth management database environments (development, staging, production & business continuity)
• Design and support database structures, automate system processes; provide capacity planning, server topology re-engineer and Database security administration
• Performed Database Refreshed, Restore, Backup, Recovery and daily technical support to internal clients
• Utilized index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning on mission critical databases application servers
• Designed & implemented automated scripts to monitor SQL server while integrating with custom monitoring framework using PowerShell/TSQL
• Participated in 24x7 operational on-call rotation schedules for production support.
• Participated in Disaster Recovery planning and testing for infrastructure stability and availability

Confidential, New York, NY

Sr. System Engineer

Responsibilities:

• Managed and Delivered custom monitoring solutions for end users starting business requirements till implementation phase for mission critical applications on heterogeneous distributed systems
• Migrated 100+ application monitoring to new alerting platform in less 5 months
• Designed and re-platformed monitoring layout of central administrative console in 3 weeks for better usability, maintainability and scalability
• Designed, Implemented and Migrated backend database to support monitoring agent growth and increased performance and capacity
• Accomplished application level monitoring by integrating NetIQ WMI managed object with developer’s framework resulted to capture application defects in earlier stages of SDLC
• Delivered and applied ITIL best practices in Service Delivery areas of availability, performance, capacity and IT Continuity Management
• Took Lead role in backend optimization project and rebalanced 900 agents within a week resulting in faster performance and reduce blocking on database servers
• Recommended and implemented many changes to system processes to increase efficiency and decision-making capabilities to management
• Managing event management database, Data Warehouse and Monitoring Portal to provide decision support to management