Svp Local Resume
GA
SUMMARY:
- MBA graduate with management experience; experienced certified professional in Windows, Azure, AWS, SQL, Dynamics & Oracle
- + years of management and technical experience with responsibilities of IT, Budgeting, Consolidation, Staffing & Trainings
- IT & HA strategist for Fortune 100 companies
- Extensive experience in Architecting & implementing Azure and AWS Clouds
- Experience in analyzing on - premise cost and Azure cost and arriving at TCO/ROI calculations and business case for cloud.
- Led highly available, DR solutions in Azure \ AWS
- Led Projects in implementing and configuring/re-platforming large database solutions in Azure using SQL Server and Oracle.
- Led Projects in implementing hybrid connectivity between Azure and on-premise using virtual networks, VPN and Express Route.
- Led Projects in implementing using one Azure PaaS services like SQL Azure database, storage, NSG
- Hands on technical design, implementation, tuning and maintenance of SAP and MS Dynamics on SQL 2012-2014
- Subject Matter Expert in AlwaysON, Clustering, Mirroring, replication, Private Clouds for SQL, Azure, AWS
- Experienced Team Builder; Built local and Virtual Global teams for product development, deployment, maintenance & support
- Microsoft Master Trainer; trained and mentored more TEMPthan 70 Microsoft Engineers on SQL 2005\ 2008\ 2012
- Author of Numerous Chalk talks on HA, Performance tuning & monitoring, Security & Auditing
- Co-Author of Microsoft SQL 2005\08\12 Failover Cluster \Admin Workshops for Microsoft Corp.
- Led ITIL & COBIT framework implementations
- Led Projects based on Microsoft SQL Server, Windows, SharePoint, HP DPC, CISCO UCS, Citirx, Office 365, MS Dynamics, CRM
- Owner of SQL RAP \ Health Check \ Remediation for High Availability, and Configuration.
- Lead for Central Technical Screening and Interview Project for PFE Americas
- Planning, Installing and configuring teh SQL 2000- 2016 on Win 2003/2008/2012 Azure in Cluster Environment
- Conduct Microsoft Workshops (Clustering, HA, Performance Tuning, Administration) for MS employees and external customers
TECHNICAL SKILLS:
Core Skills: CIO Advisory & implementation for AWS, Azure Pack, SQL Azure. HA, DR, BC, Storage, Dynamics CRM, SAP, Vendor mgt
Environment: WINDOWS NT/2000/2003/2008/2012, UNIX, Hyper V, Azure, AWS
ERP: Dynamics 2012 R2, CRM, SAP
Databases: MS SQL 7.0- 2016, SQL Azure; Oracle 7.X, 8.X, 8i, MS Access, FoxPro
Languages: VB 6.0,SQL, PL/SQL, T-SQL
E-Commerce: Active Server Pages, HTML, and IIS 4.0/ IIS 5.0
Visual Object Modeling: Erwin, Visio
Monitoring: MOM, PERF MON, SYS MON, Idera SQL DM
Storage: HP EVA, EMC VNX, IBM Flash systems, XtremeIO, Fusion IO
Other Tools: SQL Management Studio SSIS,SQL Query Analyzer, SQL Enterprise Manager, DTS, Analysis services, OLAP MMC, DBCC Showcontig, DBCC CheckTable & other DBCC utilities, Log Shipping, UML, SQL Profiler, Active Directory Service, DFS, Disk Management, DHCP, DNS, WINS server management, EFS, SQL* Plus, IMP/EXP Utility, RMAN, DBVERF, TKPROF, REPORT.TXT, SQL* Loader, SQL* DBA, Oracle Server Manager, Net 8.0,Oracle Enterprise Manager 2.0, MS-Office 97/2000, Linksys Router Admin, Pc Anywhere, Microsoft Visual Source Safe, PolyServe,SQL Reporting Services Sql Safe, Sql LiteSpeed;ITIL MOF, COBIT, Dynamics Perf
PROFESSIONAL EXPERIENCE
SVP Local
Confidential, GA
Responsibilities:
- Managed Enterprise Agreements to create, deliver and support business & technical Solutions
- Planned, designed, Led and implemented Enterprise Solution based on Microsoft, Citrix and Cisco stack
- Planned, designed, led and implemented Enterprise Solution based on Azure Pack, IAAS, DBAAS, SQL Azure
- Architected Azure Cloud including IAAS, Backup, recovery, security, dr etc.
- Architected Azure \AWS Cloud Security, API management, EC2, Storage mgt, VPC, Express Routes etc.
- Architected Global Content delivery deploying AWS CloudFront with Global Edge locations
- Architected AWS Monitoring using AWS Cloud Watch
- Architected AWS Auditing using AWS Cloud Trail
- Architected Application Capacity Elasticity, Resilience for maximum uptime, concurrency & Cost Efficiency using AWS EFS and Auto Scaling
- Architected Azure Cloud Security, NSG, API management
- Architected, designed and Implemented strartegy to migrate on premise application & web servers to Azure Cloud
- Architected VM to Azure migration using Teh Microsoft Virtual Machine Converter (MVMC)
- Architected & designed migrations of SQL server to Azure IAAS and SQL Azure
- Planned, designed and implemented AlwaysOn, Clustering, Mirroring, LogShipping, Replication to attain maximum 9s and Consolidation to minimize cost
- Architected and implemented HA solutions & DR solutions for Business continuity
- Architected and implemented Current to Future State deployments
- Designed IT strategy in Alignment with corporate needs by defining strategic direction and managed all teh IT Infrastructure Projects
- Led a global IT team, setting high standards of execution and managing strong lines of communication across and throughout teh IT division and with both internal and external customers.
- Ensured IT department structure maximizes use of available resources and provides accountability, flexibility and efficiency in meeting business, functional and project objectives, including optimizing in-house and outsourced services.
- Helped global companies build High Available systems, DR systems, ETL and multi-terabyte data warehouses
- Developed Human resource policy based on mentorship, challenging tasks, continual trainings, team rotations and comprehensive implicit and explicit rewards resulting in high performing productive and highly motivated teams to meet current and future needs
- Enhance and continuously improve teh service orientation of teh IT organization in order to deliver leading-edge technology to support business and customer requirements.
- Review historical and anticipated IT expenses for teh purpose of developing and managing a budget that addresses teh overall IT strategy.* Implement company-wide measures that can reduce expenses while maximizing teh efficiency of IT
- Managed infrastructure and development teams
- Managed and negotiated IT and business system contracts for hardware, software, and services
- Reviewed IT ECO system, spearheaded consolidation, private clouds and saved millions in licensing
- Instilled IT Governance for tracking, auditing and analyzing system performance, scalability, and resiliency.
- Led ITIL & COBIT framework implementations
Advised CIO and directors
Confidential
Responsibilities:
- Hands On experience in SQL 2000-2016 configuration, testing, tuning, troubleshooting & deployments
- Reviewed and designed Citrix deployment on SQL Server for POS systems
- Helped CIO review, analyze new vendor products and advised on new technologies and storage (IBM Falsh systems, XtremeIO, EMC VNX and Fusion IO) and performed Vendor Management
- Led technical design & implementation of Ms Dynamics 2012 on SQL 2014 in AlwaysON environment
- Led technical design & implementation of SAP & Ms Dynamics 2012 on SQL 2008 in Database Mirroring
- Configured, tuned, maintained Dynamics and SAP systems on SQL Server
- Designed SQL Clustering, Database mirroring & AlwaysON for Dynamics, SAP and other OLTP systems
- Extensive performance tuning for Dynamics using Dynamics Perf tools
- SQL 2000-2016 Cluster analysis, reviews & troubleshooting
- Architected and implemented HA solutions for MS Customers
- Architected, led & implemented Private cloud for SQL 2008-2016 On Windows 2008 & 2012 HyperV
- Performance analysis of Sql databases and recommend performance tuning strategy
- Configured and maintained Database mirroring in SQL 2000-2014
- Side by side migration of SQL 2000 to 2012 in environment
- Configured & maintained replication between sql 2005\ 2008\ 2012\2014\2016
- Architected, designed Logical and Physical DataModels and implemented database designs using Erwin
- Architected and implemented multi TB data migrations to SQL Server
- Designed, and implemented SSIS and SSRS solutions
- Planning, Installing, migrating, configuring, consolidating & monitoring SQL 2000-2016 on Win 2003\2008\R2\2012 in Cluster Environments
Sr. PFE & Enterprise
Confidential .GA
Responsibilities:
- Installed, configured and troubleshoot SQL 2000-2012 on windows 2003-2012 in cluster & Hyper V environments
- Hands On experience in SQL 2000-2012 configuration, testing, tuning, troubleshooting & deployments
- Led technical design & implementation of Ms Dynamics 2012 on SQL 2012 in AlwaysON environment
- Led technical design & implementation of SAP & Ms Dynamics 2012 on SQL 2008 in Database Mirroring
- Configured, tuned, maintained Dynamics and SAP systems on SQL Server
- Designed SQL Clustering, Database mirroring & AlwaysON for Dynamics, SAP and other OLTP systems
- Extensive performance tuning for Dynamics using Dynamics Perf tools
- Installed and configured SSRS and SSAS for Dynamics 2012 R2
- SQL 2000/2005/ 2008/ 2012 Cluster analysis, reviews & troubleshooting
- Architected and implemented HA solutions for MS Customers
- Re-Architected IT build process to reduce build times from 28 days to 2 day
- Architected and implemented Private cloud for SQL 2008 & 2012 On Windows 2008 & 2012 HyperV
- Performance analysis of Sql databases and recommend performance tuning strategy
- Configured and maintained Database mirroring in SQL 2000-2012
- Side by side migration of SQL 2000 to 2012 in environment
- Configured & maintained replication between sql 2005\ 2008\ 2012
- Planning, Installing, migrating & configuring SQL 2000\ 2005 \ 2008 \2012 on Win 2003\2008\R2\2012 in Cluster Environments
- Presented and lead Centralized TECH Screen\ Interview Project to standardize Tech screen and interview process for PFE hiring across different technologies for US; Acted as Hiring Lead for new IT staff
- Trained and mentored more TEMPthan 70 Microsoft engineers
- Presented POC and Business Plan for Live entertainment to MS top Management
- Co-Author of Microsoft SQL 2005\2008\2012 Failover Cluster Workshops
- Owned HA technology for SQL RAP\ Health Check & Remediation
- Microsoft Master trainer for SQL 2005\2008\2012 Failover Cluster Workshops
- Microsoft Master trainer for SQL 2008 Administrator & Windows 2008 R2 Cluster Workshop
- Conduct and teach Microsoft SQL 2000-2012 Failover Cluster Workshop to MS employees and external employees
- Perform SQL 2005-2012 R2 admin, performance, Clustering training session for Microsoft Customers
- Drove up sale for many customers consistently for last 4 years consistently resulting in upsell of contract hours and multiple DSE positions at multiple customers Remain available on call
- Served as teh to go Resource for SQL Server issues
SQL SME
Confidential IL
Responsibilities:
- Served as SQL SME\ Sr. Manager & Director for all online Business of Apartments.com
- Created, Co-ordinated and implemented multiple Projects involving teams form Business and IT
- Managed & trained remote teams
- Managed IT consolidation and budgeting
- Acted as Hiring manager for new IT staff
- Led PeopleSoft implementation project for Account receivables for corporate
- Installed, configured and tested SQL 2005 on windows 2003 in cluster environment
- Configured and maintained Database mirroring in SQL 2005
- Side by side migration of SQL 2000 to 2005
- Configured & maintained replication between sql 2005 & 2000
- Planning, Installing and configuring teh SQL 2000 on Win 2003 in Cluster Environment
- Providing Strategic vision for company’s database systems
- Envisioned, designed and implemented sql server scaling out from single point of processing
- Ensure network and data security through access protocols, application roles, views & schema management
- Migrating from SQL 7.0 to SQL 2000; managing teh multiple instances, OLTP
- Installed & configured SQL Server Reporting Services
- Configured SQL Health reports to monitor teh health and inventory of SQL server hardware and software
- Modify database parameters, structure, and physical location as necessary & indexing teh views
- Developed Data models using Erwin
- Work with Product Development Team to design new data models and extend existing models
- Managing SQL 2000 on cluster servers and thus enabling teh SQL FAIL OVER
- Designing Database Backup and recovery strategy and Warm Backup strategy me.e. log shipping
- Automating teh jobs, defining teh alerts & defining teh operators
- Building DTS packages for data extraction, transformation & load
- Managing & scheduling teh Database replication
- Designing teh database Maintenance Plan
- Monitor database performance to evaluate availability and reliability
- Configured and maintained EMC CX300 San for production and qa environments
- Installed, configured MOM for sql monitoring
- Remain available on call
- Served as teh to go Resource for SQL Server issues
DBA Manager
Confidential, Services IL
Responsibilities:
- Led database, sysadmin and halpdesk support teams
- Reengineered IT processes resulting in consolidated business units hence saving business operations cost by 45%
- Acted as Hiring manager for new IT staff
- Developed and implemented IT training for IT and customer service staff
- Responsible for IT budgeting
- Planning, Installing and configuring teh SQL, Access
- Ensure network and data security through access protocols, application roles, views & schema management
- Modify database parameters, structure, and physical location as necessary & indexing teh objects
- Developed Data models using Erwin
- Work with Product Development Team to design new data models and extend existing models
- Designing teh Database Backup and recovery strategy and Warm Backup strategy
- Automating teh jobs, defining teh alerts & defining teh operators
- Designing teh database Maintenance Plan
- Monitor database performance to evaluate availability and reliability
- Designing teh Windows Network
- Actively engaged in teh schema management and disk management issues including teh fault tolerance
- Remain available at all times for on-call emergencies
Manager SQL Server
Confidential
Responsibilities:
- Managed team of 8 people for Database and Networking support
- Responsible for IT budgeting, hiring and training
- Planning, Installing and configuring teh SQL 2000 on Win 2000
- Designed and Created databases in SQL
- Designing DTS Packages to retrieve data from Oracle and upload in SQL
- Designed and implemented teh Disaster Backup & Recovery Strategy SQL Servers
- Automating teh jobs, defining teh alerts & defining teh operators
- Monitored, maintained and fine tuned SQL Server and databases for optimal performance
- Scripting all database tasks and storing in Microsoft Visual Source Safe for version control
- Assisted in-house development and full DBA life cycle, database design sessions, database modeling, application development, storage parameters of different objects and configurations
- Worked as a team member in developing teh windows network
- Installing & configuring teh Winnt 4.0 Server and client side
- Creating & managing teh users and groups, devising teh profiles and security policies for them
- Building and maintaining teh trust relationships between teh NT domains
- Installing and configuring teh Print Servers
- Devised teh Backup & Recovery strategies
- Worked with teh Disk administrator and providing teh software fault tolerance on RAID 5.0
- Administering and managing teh IIS 4.0
- Managing teh IIS Load balancing & teh web site security