SUMMARY:

• Over 15+ years of IT experience as Lead, Architect, Admin, Developer and Automation Expert designing, architecting, deploying and maintaining systems/databases hosted on Physical, Virtual, Hybrid & Cloud environments.
• Designed Custom Transactional Replication for SQL to handle bulk transactions between OLTP and OLAP environments to transfer high volume data without queuing mechanism. (2 TB a day).
• Specialized in designing cost effective solutions.
• Good exposure working with Health Care, Gaming, Mining, Telecom, Insurance, Banking, Finance, Logistics, Ecommerce & Internet domains.
• Developed and deployed in - house ChatOps process using Slack & Errbot and designed custom tasks in Python & PowerShell.
• Designed, developed & Implemented IoT devices for toll gates and truck tracking ELD Devices.
• Specialized in setting up Azure RM Templates for automating server builds dynamically.
• Automating flat files import/export from SFTP SQL using C#, CMD Shell, TSQL & PowerShell by applying business rules to raw data.
• Designed and developed custom DevOps process for TFS build and deployments to prod and non-prod environments for .Net and database environments.
• Automated .Net code deployments to Azure environment.
• Configured Centralized SQL 2016 SSRS Server to host reports for multiple ASP & MVC applications with secured authentication.
• Optimized and enhanced CRM pages and reduced page load time up to 90% using advanced JavaScript techniques and Pagination.
• Building 2 Node multi subnet Windows & SQL Cluster from scratch using Win 2016, SQL 2016 SP1 CU6 for AlwaysOn set up.
• Upgraded TFS Server from 2005 => 2015 without any issues.
• Developed and maintained dynamic data upload from CRM application to database from both ASP and database sides.
• Migrated SQL Server(s) from SQL 2008 SP2 => 2016 SP1 successfully.
• Designed and configured Centralized Database Maintenance and Monitoring for different versions of Prod and Non-Prod Database servers from scratch with Graphical Email & Text Alerts.
• Installing and configuring Splunk for centralized log management and analysis for multiple servers.
• Optimized long running queries to access big data sets from hours to secs using Advanced TSQL.
• Over 15+ years of IT experience architecting & SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2017,2016,2014, 2012, R2, 2008, 2005 and 2000 in Production, QAReporting, Staging, UAT, Development, Replication and Clustered Server Environments.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2016/2014/2012/ R2/08.
• Hands on experience developing console and web applications using C#, ASP.Net, HTML, JQuery, JavaScript etc.,
• Experience in upgrading SQL Server from version 2005 to 2008/R 2/2012/2014/2016.
• Have good experience with partitioned schemas, partitioned tables and indexes, creating file groups using SQL Server 2008/2012/2014/2016.
• Good experience with implementing DR solution, High Availability of database servers using Database Mirroring, Replication and Log Shipping.
• Experience in Data Migration Management and Maintaining Large Data Sets.
• Designed and built 2 node multi-subnet cluster from scratch and implemented SQL 2016 Always On for OLTP databases.
• Hands on experience working with High Volume Databases which sizes > 10 TB.
• Hands on experiences creating, deploying and debugging console & web applications using .net technologies.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
• Good experience with Hyper-V and System Center Virtual Machine Manager (SCVMM) tool for managing Virtual Server Infrastructure.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
• Installed, configured Slack with Hubot for ChatOps and team communication and customization of DevOps.
• Exposed virtual machines and cloud services in the VNets to the internet using Azure External Load Balancer.
• Good experience in implementing Identity and Access Management (IAM) technology areas with a focus on Azure Active Directory and how it interacts with traditional on premise Active Directory and Cloud Architectures using Microsoft Graph & Graph API.
• In depth knowledge of Configuration of SSO for Web and On-premises and SaaS applications with Azure AD and Azure Application proxies, ADFS 3.0, Ping Identity, ADFS on Windows 2016, Azure AD Connect, Azure RMS, MS Intune, Health Connectors, EMS, Conditional Access, MFA and RBAC (Role Based Access Control) for organizations.
• Deployed Azure IaaS virtual machines and cloud services (PaaS role instances) into secure VNets and subnets.
• Designed and configured Azure virtual networks (VNets), subnets, Azure network settings, DHCP, address blocks, DNS settings, security policies and routing.
• Good working experience with PowerShell 3.0 and higher in windows server 2008/R2/2012/2016 environments.
• Upgraded multiple SQL Server(s) from SQL 2008 SP2 => 2016 SP1 CU6 without any issues and improved performance.
• Designed and implemented in house DevOps solutions for continuous development, deployment and testing life cycle to cloud and non-cloud servers.
• Hands on experience with Active Directory for user creation and maintenance.
• Working with different tools like SolarWinds & Splunk for Log Management and troubleshooting.
• Using Splunk tools to automate deployments.
• Working with multiple technical teams, architects, security team, managers and business users, reviewed And documented workloads, system dependencies and business requirements. Mapped workloads to the capabilities of Microsoft Azure for public, private and hybrid clouds.
• Experience with installing and configuring SSL certificates on web servers and enabled secure (https) transactions.
• Hands on experience with designing, architecting and configuring database environments in SQL Azure & Amazon Web Services (AWS).
• Extensive experience in writing Distributed Queries between SQL Servers by creating linked servers.
• Experience with handling data migration between different database environments like SQL MySQL / Oracle SQL / SQL Azure.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional n basis of business specification.
• Good exposure writing TSQL queries, Stored Procs, Triggers, Functions, Constraints, Indexes, Performance Tuning, Capacity Planning, PowerShell scripts for monitoring.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.

PROFESSIONAL STRENGTHS:

Principal Architect | Cloud | DevOps | DBA | AI | ML | IoT | Automation Expert LinkedIn | Twitter | Blog

TECHNICAL SKILLS:

Operating Systems: Linux, Windows 2000/2003/2008/2012/2016/2019 Server, Windows 95/98/XP/NT/7/10

Languages: T-SQL, PL/SQL, C#, ASP .Net, JQuery, MVC .Net, CSS, VB Script, XSQL, Java Script, Node.js, Edge.js, Vue.js, Require.js, Discord.js, PowerShell, Python, CMD Shell, HTML etc.

Data Visualization: MS Reporting Services, D3.js, FlowChart.js

Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2010, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Database Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), Splunk, FogLight, RedGate, SolarWinds, Active Directory, Active Server Roles, CA Service Desk, IT Service Catalog, Avamar, Team Track, VMWare, Connect wise, SQL Safe, Remedy, SSDT, HP Overview, Docker, Visual Studio Code etc.

RDBMS: MS SQL Server 2005/2008/R 2/2012/2014/2016/2017 , MySQL, Oracle, PostgreSQL, MongoDb, DynamoDb

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard, FTP, SFTP, PowerShell, Batch Files

Database Modeling & Other Tools: Quest Litespeed, Quest SQL Spotlight, Redgate SQL Compare, SQL Trace, SCOM 2012

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Principal Architect | DBA | Cloud

Responsibilities:

• Responsible for migrating SQL 2008 /R2 versions to SQL 2012/2016 with proper planning and documentation in place.
• Extensive usage of PowerShell for monitoring, administering and securing SQL servers.
• Writing Stored Procs, Views, Triggers, Functions etc., based on business requirement.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity.
• Deployed Azure IaaS virtual machines and cloud services (PaaS role instances) into secure VNets and subnets.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Excellent knowledge on On-premises Active directory & Cloud’s Azure AD, Azure AD Domain Services. Azure Subscriptions-Azure AD association, Setting up Multi-Factor Authentication (MFA or 2FA).
• Exposed virtual machines and cloud services in the VNets to the internet using Azure External Load Balancer.
• Configured Database mail, linked servers in SQL server 2012.
• Hands on experience working with Azure Data Factory, Analytics & other PaaS models.
• Programmatically accessing Azure AD through Graph API, versions of Graph API, Azure AD Endpoints, Azure AD OAuth 2.0 Best Practices, error handling, Authorization Code as well as Client Credential Grant flows and OpenID Connect usage & Azure ACLs.
• Automated database and .net deployments to database and web servers using multiple languages like C#, PowerShell, CMD Shell, Python and TSQL.
• Extensive experience working on developing Microsoft Reporting Services.
• Upgraded Biztalk Server from 2006 to 2016 using side by side migration and minimized downtime.
• Upgraded TFS Server from version 2005 to 2015 without loosing any user data or permissions.
• Using Splunk for centralize log management monitoring and alerting.
• Created, configured centralised Log management for multiple applications and database servers.
• Working with TFS to maintain source code and changes.
• Developing SSIS packages to migrate data from OLTP to OLAP servers.
• Good Working Knowledge of using SSIS & SSRS.
• Created and configured AWS services like S3, EC2, EBS, RDS, IAM etc.,
• Good working experience working with SSIS for ETL requirements and built custom solutions for using data sources like SFTP and other which old versions of SSIS don’t support.
• Created desktop applications for automating application tasks using C# and Visual Studio.
• Extensive experience with SQL query tuning and optimization.
• Working with SQLSentry PlanExplorer for checking query plans and optimizations.
• Architected and implemented in house DevOps solutions for continuous development and deployment life cycle.
• Developing Python scripts for automated delivering of encrypted messages via secure channel to a server in non-trusted domain.
• Created monitoring scripts to alert for blocking, dead locks, sql agent job failures, backups etc.,
• Setting up monitoring for CPU, DB Free Space, Log Space, IO and tuning the performance of databases.
• Maintaining databases as per SOX standards and generating different kinds of SOX reports for auditors.

Environment: SQL Server 2017/ 2016/2014/2012/ 2008/R2/2008/2005, Windows 2019/2016/2008/2012 server, Windows Server 2008(x64), BIDS 2005/2008/R2, SSDT 2012, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, TSQL, Stored Proc’s, SOX, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, PowerShell, BizTalk, Azure Logic Apps, SQL Sentry, Docker, ASP .Net, MVC .Net, CSS, CMD Shell, TFS, ODBC, FTP, SFTP, WFSC, Azure, AWS etc.

Confidential, Concord, CA

Sr Database Architect | Admin

Responsibilities:

• Responsible for migrating SQL 2005 / 08 /R2 versions to SQL 2012 with proper planning and documentation in place.
• Installed, configured Slack with Hubot for ChatOps and team communication and customization of DevOps.
• Implementing new features of SQL 2012 like Always on, Column Stored Indexes & Contained Databases in newly migrated servers.
• Working closely with Development & Application teams to guide with best practices on writing tsql queries.
• Writing Powershell scripts to make enhancements to existing functionality.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2012.
• Extensive experience working on developing Microsoft Reporting Services.
• Installing, Configuring and maintaining Lite Speed for SQL Servers for backups & Restores.
• Developing SSIS packages to migrate data from OLTP to OLAP servers.
• Good Knowledge of using SSIS & SSRS.
• Created monitoring scripts to alert for blocking, dead locks, sql agent job failures, backups etc.,
• Working with SCOM to monitor server across all the domains.
• Maintaining databases as per SOX standards and generating different kinds of SOX reports for auditors.

Environment: SQL Server 2012/2008/R2/2008/2005, Windows 2008 server, Windows Server 2008(x64), Windows Cluster Server, BIDS 2005/2008/R2, SSDT 2012, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, Remedy, Lite Speed, TSQL, Stored Proc’s, SOX, Triggers, UDF’s, Constraints, DTS, BCP,Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, SAN, PowerShell, Active Directory, ODBC etc.

Confidential, Denver, CO

Sr Operations DBA | Lead

Responsibilities:

• Responsible for supporting > 350 SQL instances which include SQL 2000 / 05 / 08 / R2 & 2012.
• Monitoring of database size and disk space in Production, Staging & Development environments
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centres. Patch applications.
• Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with
• Microsoft Operations Manager and backup teams.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2005.
• Installed and configured Quest monitoring tools like SpotLight & FogLight.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
• Good working knowledge of using SSRS (SQL Server Reporting Services).
• Performed Production support and on Call duties.
• Executed Change management scripts on weekly basis.
• Documented up gradation procedures from MySQL to SQL Server and Oracle to SQL Server.
• Created monitoring scripts to alert for production issues.
• Migrated Databases from MySQL, Oracle to SQL Server 2005.

Environment: SQL Server 2012/2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2000, BIDS 2005/2008, SQL Server Management Studio, Query Analyser, SQL Profiler, Performance Monitor, SSIS, SSRS, CA Service Desk, IT Service Catalog, SOX, Avamar, TSQL, Stored Proc’s, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Quest SpotLight, FogLight etc.

Confidential, Atlanta, GA

Senior Lead DBA | Architect

Responsibilities:

• Management of SQL Servers, databases, storage management for databases sizing from 250 GB to 5 TB.
• Responsible for Database Administration and Performance Optimization.
• Data Migration from legacy to master tables using DTS-import and Export wizard.
• Trouble shooting Problems by using SQL server profiler.
• Administering and maintaining Clustered databases on 2 Node (Active/Passive) cluster.
• Updating with latest service packs and security patches.
• Experience working with TFS to make changes to code.
• Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.
• Created indexed views using T-SQL to increase the query performance.
• Develop Backup & Restore scripts for SQL Server as needed.
• Created reports using SQL Server Reporting services.
• Has done DBCC checks to ensure the physical consistency of the database and objects.
• Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primary production servers and Standby.

Environment: SQL Server 2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2003, SQL Server Management Studio, Query Analyser, SQL Profiler, Performance Monitor, SSIS, Team Track.

Confidential

SQL Server DBA

Responsibilities:

• Creating and maintaining various databases for Production, Development and Testing using SQL Server 2005.
• Installing SQL Server 2005 / 08 on the server and client machines, providing connections and managing databases.
• Planning and scheduling backups and developing recovery procedures.
• Migration of data across different databases and different servers.
• Creating procedures, functions, and triggers, handling database performance and tuning.
• SQL Server Installation, patch application, migration of databases.
• Creation of new databases, planning the location of data, index, and Transaction log files on disks.
• Setting up backups for the databases.
• Providing support to the Application developers on the application databases.
• Handled 24/7 Production Issues.

Environment: SQL Server 2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2003, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS.

Confidential

SQL Server DBA

Responsibilities:

• Installation, configuration and maintenance of the MS SQL Server 2000.
• Migration of SQL server 6.5 to 7 and from SQL server 7 to 2000.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Migrated oracle8i data into SQL Server 2000.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Complete automating on NT so that the tasks are run without user monitoring.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000/2005/2008 , Windows Server 2003(x64), Windows Cluster Server, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, HP Over View.