SUMMARY

• Over 20 years of experience in teh Information Technology as a Solution and Database Infrastructure Architect at Datacenter and Cloud.
• 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 wif architects, engineering, client managers, project managers, applications and infrastructure ream to plan, implement and coordinate changes.
• Manage teh technical deliverables for projects to high quality standards.
• Over 15+ years of experience in Database Administration. (SQL Server and Sybase)
• Defining scope of architecting and managing infrastructure projects (Datacenters, HA, DR and Cloud).
• Worked as an architect of infrastructure design of Development, Production, Disaster recovery and High Availability.
• Thorough knowledge on SQL Server Architecture.
• EPIC Clarity ETL and Database installation, maintenance, troubleshooting and performance optimization.
• Experienced on handling various data sources, data scrubbing and loading using SQL DTS, SSIS.
• Skilled in SQL Server 2014/2012/2008R2/2008/2005/2000/7/6.5 & Windows NT/2000/XP/2003/2008/2012.
• Responsible for teh overall design of teh infrastructure and mapping teh business requirements to systems/technical requirements.
• Solution Architecting, Consulting for Infrastructure/Data base towards HA, DR and CLOUD - AWS /Azure.
• Subject Matter Expert in 2-3 Technology domains and broad understanding of other associated Technology domains.
• Perform teh role of Lead Infrastructure/Database Architect for cloud such as IAAS, PAAS and SAAS.
• Adhering to SLAs Design of IT Infrastructuresolutionsbased on requirements from teh business making use of existing IT capabilities and services in teh company.
• Identify, understand, negotiate and document business requirements wif various groups, which include Business, Application and other teams.
• Alignment of Business requirements wif 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 andSolutionBlueprints. Provide value add in optimizing Technology for Business in order to reduce Cost of IT.
• Build good relation wif teh customer architecture team by proactively engaging wif both customer and Wipro internal team and propose innovative ideas.
• Keep a tap on teh current market trends by conducting thorough research and engage in discussion wif Wipro internal Architecture team and vendors. Create Architecture Artifacts, which includes.
• Reference ArchitecturesHigh Level and Low Level DesignTarget 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 teh team ofSolutionArchitectsthat includes TechnicalArchitects/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.
• Customer-facing engagements for sales or solutions or technical discovering and analyzing needs tan designing solutions to match their vision.
• Ensure alignment and compliance wif Global EA standards and TechnologiesStrengths
• Managed a team of employees, consultant and clients or vendor partnerships.
• Strong leadership and training experience
• Excellent analytical and problem solving skills
• Solid experience in customer service and sales support
• Capacity planning and Disaster recovery.
• Project planning skills and good verbal and written communication skills

PROFESSIONAL EXPERIENCE

Confidential, GA

Lead Solution & Database Architect

Responsibilities:

• Provided architectural leadership for infrastructure and database solutions that enable teh following:
• High Availability/ Disaster Recovery
• Data Center Virtualization - Has architected and migrated few application to Cloud - AWS/Azure and Rackspace
• Cloud Efficiencies and cost savings presentation at C and D level
• Alignment/Acceleration to teh roadmap of next-generation infrastructure
• Reduction of risk and production incidents
• Improvements in organizational execution
• SQL Server Consolidations of servers or Data centers and Migration to Cloud
• Assessments of applications (For IAAS, PAAS or SAAS) and their consolidation (Database consolidation).
• Designing of SQL Server Services wifin Private Clouds
• Leveraging teh latest hardware and software technologies wif TRUE up Licensing
• Architecting and implementation of Best Practices and standards

Confidential

Lead Database Solution Architect

Responsibilities:

• Manage Database Projects, SLA and escalation wif customer.
• Worked on Architect infrastructure for SQL Server.
• Worked on Clinical \Financial applications issues and upgrades to cloud.
• Worked wif Vendor and teh relationship for upgrades and migration
• Worked on Architect infrastructure for SQL Server.
• Worked on Clinical \Financial applications issues and upgrades
• Worked wif Vendor and teh relationship for upgrades and migration
• Created DW environment and worked wif developers for reports and analysis (Epic and Clarity)
• Managing other health care applications (Epic, Lawson, All scripts, GE etc.), databases and their Vendors.

Confidential, FL

Database Consultant\Architect

Responsibilities:

• Worked on Architecting new infrastructure and migration plan (Servers + Storage +Databases).
• Worked on Clinical \Financial applications issues and upgrades at teh time of Migration
• Procurement order and narrowing server requirements (VM’s and database consolidation)
• Actively involved in teh architecture of database in term of new implementation or performance.
• Creation of documentation and process as per SOX Policies and procedures.
• Worked wif Vendor and teh relationship for upgrades and migration
• Managing and Migrating DW environment from legacy to new environment
• Worked wif developers for reports and analysis (Cerner- clinical and other applications)
• Managing other health care applications (Siemens, All scripts and GE etc.), databases and their Vendors.

Confidential

Database Consultant\Architect

Responsibilities:

• Planned and architecting wif different GE entities for Cloud migrations wif PRESENTATION to management.
• Defining and budgeting teh requirements of procurement, licensing and efforts.
• Reviewing applications (Web/APP and Databases) its process for architecting teh new infrastructure in cloud.
• Procurement order and narrowing server requirements (VM’s, Cloud (IAAS, PAAS, SAAS) and database consolidation)
• Actively involved in teh architecture of database in term of new implementation in cloud.
• Actively involved in teh design of applications wif vendors and migration towards azure cloud.
• Migration of applications to cloud and defining HA and DR strategies.
• Implemented Always On, Database Mirroring, and Replications for reporting and log shipping for DR.
• Effectively managing Backup strategy, capacity planning and disaster recovery.
• Define process of migration for applications towards cloud.
• Monitoring performances through SQL Server or third party tools, Query optimization and other resources in cloud.

Confidential

Database Consultant\Architect

Responsibilities:

• Responsible for teh overall design of teh infrastructure and mapping teh business requirements to systems/technical requirements.
• Solution Architecting, Consulting for Infrastructure/Data base towards HA and DR.
• Subject Matter Expert for SQL Server and broad understanding of other associated Technology domains.
• SQL Server Consolidations of servers\Multiple Data centers; Designing of SQL Server Services wifin Private Clouds while leveraging teh latest hardware and software technologies wif TRUE up Licensing
• Customer-facing engagements, discovering and analyzing customer needs tan designing solutions to match teh vision.
• Primary technologies are Microsoft SQL Server, Relational Design Concepts, .NET, Windows, Servers, SAN, VMware, Hyper V and networking.
• Alignment of Business requirements wif 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 andSolutionBlueprints. Provide value add in optimizing Technology for Business in order to reduce Cost of IT.
• Build good relation wif teh customer architecture team by proactively engaging wif both customer and Wipro internal team and propose innovative ideas.
• Monitoring performances through SQL Server or third party tools, Query optimization and other resources.
• Worked wif securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.

Confidential

Lead Database Consultant

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 wifin Private Clouds while leveraging teh latest hardware and software technologies wif TRUE up Licensing
• Customer-facing engagements, discovering and analyzing customer needs tan designing solutions to match teh 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 teh systems performance for multiple EPIC Clarity non-production and production environments.
• Suggesting teh 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 teh 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 wif securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.

Confidential

Sr. Database Consultant\Architect

Responsibilities:

• Planning and architecting of new infrastructure for migration.
• Managing VLDB (20+ TB) database wif 10,000 transactions per minute.
• Actively involved in Sorian Financial/Clinical Application and its performance tuning
• Working wif 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 teh 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 teh architecture of database in term of new implementation or performance.
• Creating and effectively managing capacity planning and disaster recovery testing.
• Worked wif securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.

Confidential

Database Consultant\Architect

Responsibilities:

• Planning and architecting of new infrastructure for legacy servers.
• Procurement order and narrowing server requirements (VM’s and database consolidation)
• Actively involved in teh architecture of database in term of new implementation or performance.
• Creation of documentation and process as per SOX Policies and procedures.
• Actively involved in teh architecture of database in term of new implementation or performance.
• Effectively managing capacity planning and disaster recovery testing (quarterly).
• Monitoring performances through SQL Server or third party tools, Query optimization and other resources.
• Worked wif securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.
• Worked wif SCOM 2007 for performance, alerts and capacity planning.

Confidential

Database Team Lead\Architect

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 teh 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 teh transition.
• Actively involved in teh architecture of database in term of new implementation or performance.
• Worked on DR wif 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.
• Developed, managing and testing disaster recovery and backup strategies.
• 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.
• Worked wif SCOM 2007 for performance, alerts and capacity planning.
• Working wif Backup and Recovery, database migration, indexing schemas and implementation, query optimization and stored procedures development, server clustering, and database partitioning
• Monitoring performance for DW Environment and its maintenance.
• Developed, managing (capacity planning) and testing disaster recovery and backup strategies.
• Daily archiving process of Data warehouse and working wif architect of warehouse.
• Maintenance of Database on regular basis, which includes automation process.
• Creating architecture of database in term of new implementation or performance.
• Working wif database migration, indexing schemas and implementation, query optimization and stored procedures development, server clustering, and database partitioning
• Providing service restoration and performance tuning for SQL 2000, 2005 and 2008 production legacy systems
• Managing and creating fail over through mirroring on other applications.

TECHNICAL SKILLS:

Operating Systems: Microsoft Win XP, Win2k, NT4, Terminal Server, Linux &Novell Netware operating systems.

Hardware: IBM Net Infinity Servers, Dell, and HP & COMPAQ Servers.

Database: MS SQL Server 2016, 2012, 2008 R2, 2008, 2005, 2000, 7.0 and 6.5, Access 2000/XP & Sybase System 10

Data warehouse Tools: OLAP, SSRS, SSIS and SQL Data Transformation services (DTS)

System & Network monitoring: HP Open View, Bind view, Empirix monitoring tool

Reporting tools: Brio, Crystal Reports, Microsoft Reporting Server.

SQL server Tools: SQL profiler, Meta Data services, Data Junction ETL tool, Microsoft Reporting Server

Software & Application tools: Mercury interactive Load Runner 6.5, Radview Web load 4.5, Internet Information Server (IIS) 5.0&4.0 & Microsoft Front Page 2000, Visual InterDev 6.0, Visual Source Safe 6.0, MS Office, ActiveX, VB Scripts.

Mail servers: Microsoft Exchange Server 5.0.

SQL Server Tools: Litespeed2005, Entegra, Embarcadero & other Third party tools.