Architect Cloud

VISHWAJIT KUMAR

Cell: 312-***-****

***********@***.***

http://www.linkedin.com/in/vishwajit77

Summary

Twenty years of professional experience in Infrastructure, Virtualization, Cloud (Azure, AWS, Google and Third Party) and Databases (SQL Servers and Sybase). Most of years performed as Infrastructure\Database Architect dedicated to the upgrades, migrations, consolidation, infrastructure design-development, maintenance, and performance of databases and datacenters. Good experience with healthcare, financial and educational applications. Have consolidated, planned and migrated eight Datacenters and cloud Projects (Application and Databases).

PROFESSIONAL EXPERIENCE

Over 20 years of experience in the Information Technology as a Solution and Infrastructure Architect at Datacenter and Clouds (approx. 5 Years).

Have Migrated 10 PETA Byte of databases to Cloud (Azure Specifically) using third party replication tool. Server assessment was major issue and resolved successfully.

Provided thought leadership for cloud, Datacenter, Distributed and technical solutions for multiple channel.

Architect solutions for massively scalable and resilient systems, build shared IT service centers for Cloud operations.

Collaborate with architects, engineering, client managers, project managers, applications and infrastructure ream to plan, implement and coordinate changes.

Manage the technical deliverables for projects to high quality standards.

Over 17+ years of experience in Database Administration on multisite, public and private Clouds.

Defining scope of architecting and managing infrastructure projects (Datacenters, HA, DR and Clouds).

Worked as an architect of infrastructure design of Development, Production, Disaster recovery and High Availability.

Solution Architecting, Consulting for Infrastructure/Data base towards HA, DR and CLOUD – AWS /Azure.

Data Center Virtualization – Have designed and migrated few applications to Cloud –AWS/Azure and Rackspace with Hybrid Cloud.

Subject Matter Expert in 2-3 Technology domains and broad understanding of other associated Technology domains.

Perform the role of Lead Infrastructure/Database Architect for cloud such as IAAS, PAAS and SAAS.

Adhering to SLAs Design of IT Infrastructure solutions based on requirements from the business making use of existing IT capabilities and services in the company.

Identify, understand, negotiate and document business requirements with various groups, which include Business, Application and other teams.

Alignment of Business requirements with Technology wherever needed for deriving better Business results. Required to clearly understand, articulate and document existing "as-is" systems & design and define strategy for "to-be" design.

Define Target Architecture, Technology Roadmap and Solution Blueprints. Provide value add in optimizing Technology for Business in order to reduce Cost of IT.

Build good relation with the customer architecture team by proactively engaging with both customer and Wipro internal team and propose innovative ideas.

Keep a tap on the current market trends by conducting thorough research and engage in discussion with Wipro internal Architecture team and vendors. Create Architecture Artifacts, which includes.

Reference Architectures High Level and Low Level Design Target architecture, Technology roadmap and Architecture Vision. Build reusable components that can be used by Architecture team, this could include Design patterns, Reference Architectures and templates.

Lead the team of Solution Architects that includes Technical Architects/SMEs in different infrastructure domains and drive Architecture.

Actively involved in new transitioning or presentation of scope and planning at C level from database prospective.

STRENGTHS

Managing team of Architects, Consultants and clients or vendor partnerships.

Cloud Efficiencies and cost savings presentation at C and D levels with real time scenarios.

Excellent analytical and problem solving skills

Highly organized, structured and process oriented.

Good experience in customer service and sales support – Pre Sales

Good experience with Capacity planning and Disaster recovery.

Project planning skills and good verbal and written communication skills

Automated scripts and strong knowledge of system tables and DMVs. CLOUD STRENGTHS

Deep knowledge and master of cloud platforms (Azure primary, AWS, Rackspace, Google and others).

Hands on and familiar with Cloud Monitoring tools (such as CloudWatch, AppDynamics, Splunk, ELK, Application monitoring, etc.).

Containers and Orchestration: Docker, AWS ECS, and Kubernetes.

Configuration Management (ex. Chef, Puppet, Ansible).

Continuous Integration (ex. Jenkins).

Database Migration strategy for cloud (SQL Server, Oracle, Data Warehouse and NoSQL or Hadoop)

Awareness of open source tools and technologies

March 2020 – November 2020

Clear wave Inc. – (Lead Database Architect - Managing BAU\Solutions\Planning, Atlanta, GA) Responsibilities:

Manage Cloud and SQL Server Upgrade/Migration projects, SLA and escalation with 500+ customers.

Worked with Application team for understanding of Architecture and layout.

Build new platform and migrated existing database architecture to cloud

Build HA/DR for Database and BAU maintenance plan for every night.

Stream line security and database infrastructure intake from product and application team.

Worked with Business line for building Data Warehouse layout in cloud.

Configure replication from servers to another server for reporting.

Have started working on Sybase System 10 and SQL Server 4.21a until today’s latest versions.

Worked on Devops, CI/CD of database development and deployments.

Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)

Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO) March 2017 – February 2020

Donyati LLC – (Mgr. Database BAU\Solutions\Architect \Planning, Atlanta, GA) Responsibilities:

Manage Cloud and SQL Server Upgrade/Migration projects, SLA and escalation with customers.

Working on Database technology for more than 20 years.

Have started working on Sybase System 10 and SQL Server 4.21a until today’s latest versions.

Managed\Design and tuned 25 TB of single Database (OLTP) environment with heavy transactions.

Building Data Warehouse on premises or in Azure with real-time replication through Attunity tool.

Managed Development team and has converted logical Database design to physical layout.

Worked in Agile Framework of database development, implementation and business requirement.

Defining the process of cloud enablement for modernizing the existing infrastructure.

Manage Healthcare applications and CRM, SAP applications.

Designed infrastructure for SQL Server or other critical applications of HIPAA, PHI and PCI.

Worked on Clinical \Financial applications issues and upgrades to cloud.

Worked on Devops, CI/CD of database development and deployments.

Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)

Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)

Perform DBA Activities at Business solution, Functional, Application or Development.

Installation and implementation of best practice of SQL Servers and their instances (in cost effective way or consolidation).

Configure SQL Server monitoring utilities to minimize false alarms

Hands on third party tools such as Idera diagnostics manager, Red Gate, Fog Light, SCOM, Solar winds etc.

Decision on new systems are brought in-house, choose in design as logical\physical or to use encryption, Always On, clustering, log shipping, mirroring, kind or replication, Windows Azure, or other technologies.

Maintaining HA through Clustering, SQL Server Mirroring, Always On or Disk Replication at SAN Level (SRDF).

Deploy database change scripts provided by third party vendors or development team.

Performance tuning of Scripts, process or debugging the issues and working with developers

Defining Security for new or existing application at SQL Server or ADFS level (SOX, HIPAA, PCI or PHI)

When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes

Finding DMV queries to answer questions about server-level performance

Using tools like sp_WhoIsActive, Perfmon and other to diagnose server reliability and performance issues

Tuning T-SQL queries to improve performance optimization through Execution plans.

Troubleshooting hardware using tools like Dell Open Manager, HP System Insight Manager, and UCS Blade Diagnostics (VMWare and Hyper-V – Microsoft)

Managing other health care applications (Epic, Lawson, All scripts, GE etc.), databases and their Vendors.

Worked with securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.

Implemented HL7 Database connectivity sub system to connect database system

Implemented SOX Policies on financial database as per standard. October 2013 – March 2017

Wipro Ltd. (Lead Solution & Database Architect, Atlanta, GA) Projects Managed at Wipro:

Quest Diagnostics – Lead Cloud Solution Architect

(Managed Team of DBA’s, Admin and Engineer’s)

Working with stakeholders and Application owners on assessments of applications.

Defining the process of cloud enablement for modernizing the existing infrastructure.

Manage Projects, SLA and escalation with customers.

Designed infrastructure for SQL Server or other critical applications of HIPAA, PHI and PCI.

Worked on Clinical \Financial applications issues and upgrades to cloud.

Worked with Vendor and the relationship for upgrades and migration

Worked on Application assessments

Catholic Health – Lead Database and Cloud Solution Architect

Worked on Architect infrastructure for SQL Server.

Created\ Presented Presentation on infrastructure and planning with OCIO.

Assessment of applications for Migration to private and public cloud

Worked on Clinical \Financial applications issues and upgrades

Worked with Vendor and the relationship for upgrades and migration

Created DW environment and worked with developers for reports and analysis (Epic and Clarity)

Managing other health care applications (Epic, Lawson, All scripts, GE etc.), databases and their Vendors.

Levis – Lead Database and Cloud Solution Architect HIBU – Lead Database and Cloud Solution Architect

FOTL (Fruit of the Loom) – Lead Database and Cloud Solution Architect

Created\ Presented Presentation on infrastructure and planning with OCIO.

Worked with different team on solutions and scopes definition.

Worked with Vendor and the relationship for upgrades and migration

Successfully transitioned to off shore team and supported until go live.

Created Documentation for transition and follow up with customer. Mattel – Cloud and database Solution Architect

Worked on Architect infrastructure for SQL Server.

Assessment of applications for Migration to private and public cloud

Worked with different team issues and upgrades of datacenters

Worked with Vendor and the relationship for upgrades and migration of database and infrastructure

Axis Insurance – Transition and Cloud, Database and Support Architect

Worked on Transition and new Architect infrastructure for SQL Server.

Worked on migration plan for datacenter and upgrade of SharePoint and other applications.

Worked with different team for building solutions and completed successfully.

Worked on process implementations, defining SLA and security definition March 2013 - October 2013

Health Management Associates, Inc. (Lead Database Architect \Consultant, Naples, FL - Contract) Responsibilities:

Technical Consulting, Project Management, Infrastructure/Data Architect, High Availability and Disaster Recovery Architect.

SQL Server Consolidations of servers\Multiple Data centers; Designing of SQL Server Services within Private Clouds while leveraging the latest hardware and software technologies with TRUE up Licensing

Customer-facing engagements, discovering and analyzing customer needs then designing solutions to match the vision.

Primary technologies are Microsoft SQL Server, Relational Design Concepts, .NET, Windows, Servers, SAN, VMware, Hyper V and networking.

Planning and architecting of new infrastructure design, migration and upgrade to SQL Server 2012.

Assessments of applications and Consolidation of databases environments (Database consolidation).

Managing other health care applications (Epic, Lawson, Medhost etc.), databases and their Vendors.

Responsible for administration, modification, and maintenance of ETL’s for EPIC Clarity and Business Intelligence

Monitor, support and improve the systems performance for multiple EPIC Clarity non- production and production environments.

Suggesting the path towards best practice and performance and future prospects as per growth.

Resolving bottle necks of SQL Server in related to CPU, I/O and Memory.

Actively involved in the architecture of database in term of new implementation or performance.

Creating and effectively managing capacity planning and disaster recovery testing.

Monitoring performances through SQL Server or third party tools, Query optimization and other resources.

Worked with securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.

Implemented HL7 Database connectivity sub system to connect database system

Implemented SOX Policies on financial database as per standard. April 2012 – March 2013

Fresenius Medical Care (Sr. Database Consultant\Architect, Boston, MA - Contract) Responsibilities:

Planning and architecting of new infrastructure for migration.

Managing VLDB (20+ TB) database with 10,000 transactions per minute.

Actively involved in Sorian Financial/Clinical Application and its performance tuning

Working with Siemens and their developers on upgrade and issues

Consolidation of databases and environments requirements (VM’s and database consolidation)

Managing other health care applications, databases and their Vendors

Managing OLAP environment for reporting and Analytics (SSRS and SSAS)

Reviewing SharePoint Databases and performing database optimization.

Suggesting the path towards best practice and performance.

Suggesting and making some changes in Database maintenance for better performance.

Resolving bottle necks of SQL Server in related to CPU, I/O and Memory.

Maintenance of Database on regular basis, which includes automation process.

Actively involved in the architecture of database in term of new implementation or performance.

Creating and effectively managing capacity planning and disaster recovery testing.

Monitoring performances through SQL Server or third party tools, Query optimization and other resources.

Worked with securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.

Implemented HL7 Database connectivity sub system to connect database system

Implemented SOX Policies on financial database as per standard. November 2010 – April 2012

Accenture (Lead Database Consultant\Architect, USA - Contract) Accenture clients were:

Stanford Hospital and Clinics – Database\ Architect Team Lead Responsibilities:

Planning and architecting of new datacenter (infrastructure) for move of 240+ application databases.

Procurement order and narrowing server requirements (VM’s and database consolidation)

Management of requirement from UCS and software licenses.

Created process for data center move and standardization

Migration of OLAP Environment including SSRS and SSAS.

Managing other health care applications (Epic, Lawson, Imaging and other), databases and their Vendors

Monitor, support and improve the systems performance for multiple EPIC 2012 Clarity non- production and production environments

Epic upgrades and updates to production and non-production environments

Managing Team of SQL DBA (8) for the transition.

Actively involved in the architecture of database in term of new implementation or performance.

Worked on DR with Application SLA’s and assigned Metal Chart.

Maintenance of servers and databases on regular basis, which includes automation process.

Creating and managing capacity planning and disaster recovery.

Providing service restoration and performance tuning for SQL 2000, 2005 and 2008(R2) production legacy systems

Managing and creating fail over through mirroring in disaster recovery.

Monitoring performance for DW Environment and its maintenance.

Maintenance of Database on regular basis, which includes automation process. March 2010 – October 2010

Dow Jones MaerketWatch (SQL Server Consultant, Minneapolis, MN - Contract) Responsibilities:

Maintenance of Database on regular basis, which includes automation process.

Creating architecture of database in term of new implementation or performance.

Effectively managing capacity planning and disaster recovery.

Working with Backup and Recovery, database migration, indexing schemas and implementation, query optimization

Working on stored procedures with development team

Providing service restoration and performance tuning for SQL 2000, 2005 and 2008 production legacy systems

Managing and creating fail over through mirroring.

Worked with SCOM 2007 for performance, alerts and capacity planning.

Maintenance of servers and databases on regular basis, which includes automation process.

Creating and managing capacity planning and disaster recovery.

Providing service restoration and performance tuning for SQL 2000, 2005 and 2008(R2) production legacy systems

Managing and creating fail over through mirroring in disaster recovery. October 2009 – March 2010

Headstrong - Agilent Technologies Inc. (SQL Server Consultant, Santa Clara, CA-- Contract) November 2007 – October 2009

SYNCADA- US Bancorp (Sr. SQL Server DBA, Minneapolis, MN) May 2007 – November 2007

Chicago Public School (Sr. SQL Server DBA -Lead, Chicago, IL) June 2006 – May 2007

Federal Home Loan Bank of Chicago (Sr. SQL Server DBA, Chicago, IL) October 2005- April 2006

Caterpillar Inc. (Sr. SQL Server DBA, Peoria, IL- Contract) September1999 – August 2005

Heartland Information Systems- Nuance (Database Administrator, Toledo, Ohio) November 1997 – September1999

NIIT Ltd. (System Engineer -Internship, New Delhi, India) TRAINING/CERTIFICATIONS:

• Bachelor Degree in Arts from YCMOU

• Diploma on Computer Hardware /Network Technology from National Institute of Information Technology (NIIT).

• Solution Architect Cloud Certification (Azure and AWS)

• Microsoft Certified Systems Administrator (MCSA)

• Microsoft Certified Database Administrator (MCDBA)

Contact this candidate