SUMMARY

• 21+ Yrs. Total as MS SQL Server DBA/ Developer
• 16+ Yrs. MS SQL Server DBA
• 08+ Yrs. SQL Developer for Win/Web/ETL/DTS/SSIS/SSRS/SSAS
• 04+ Yrs. AZURE SQL DBA/ Development - Azure SQL Contributor
• Used models IEEE/ CMM / ISO-9001/ Agile/ Scrum for high quality product development.
• Used TFS/ Serena VM/ Star Team/ MS Source Code Control Version Managers.
• Worked as Physical DBA / Operations DBA using Microsoft SQL Server, Managed 5TB size SAP SQL Databases.
• Worked in CLOUD/ SQL Azure Environment with IaaS/ PaaS / SaaS/ Calculated DTUs/ eDTUs
• Expert in Azure SQL Database/ SQL Data warehouse/ Data Factory/ Data Lake/ DevOps/ Services.
• Moved on-site SQL Server databases to Azure SQL Database Environment, Azure SQL Contributor.
• Used Data Migration Assistant (DMA) for migration to Azure SQL Database, Expert in PoshPAIG for Patching.
• Create and Manage firewall rules on Azure SQL Database Environment, Expert in ola.hallengren Backups.
• Managed & Administrated over 1000s MS SQL Clustering Instances Active/ Passive, Active/ Active/ SAP SQL Server.
• Experience working with SAP/ NoSQL, MongoDB, Exporting/ Importing Data to and from NoSQL Environments.
• Installed/ upgraded SQL 2019/ 17/16/14/12/ R 2/08/05/2000/7/6.5/4 & Applied Service Packs/ TLS 1.2 Security.
• Managed/ Expertise in Always-ON, MS Replications, MS Log shipping, MS Mirroring, Simplement Replication for SAP.
• Managed Database Backups/ Restore for FULL/ Differential/ Incremental for single & Multiple File Groups.
• Managed Database Maintenance Plans: Re-indexing / Reorganize / Update Statistics
• Used Central Management server/IDERA/Foglight/Red Gate/Lite Speed to monitor over 1000s of SQL instances.
• Extensively used MS SQL policy Management to enforce various policies to maintain integrity
• Extensive experience with ROW/ Page level compression methods to for DB performance;
• Expertise with finding solutions to sudden change in baseline and SQL Server Performance.
• Hosted SQL Databases in Local & SAN I/O subsystems using right RAID levels/ Assign LUNs.
• Analyzed and Resolved CPU, Memory, I/O bottlenecks for SQL Server high Performance.
• Maintained SQL Server Baseline Metrics and do preventive actions for consistent DB Performance.
• Identified slow running Queries/ Blockings and do corrective actions to boost SQL performance.
• Worked with 2TB size Databases. Placed DBs in file groups/ Partitions/ drives for High Performance.
• Expertise in SQL Server Profiler/Extended events, Tuning Advisor, BCP, ETL, Data IMPORT/EXPORT.
• Effectively Managed SQL System DB, User DB, DB users, Roles and Schemas and permissions.
• Effectively Managed Database Encryption using Native and EFS encryption methods.
• Expertise in Indexed Views, SQL Functions, Stored Procedure, & Triggers.
• Monitored Disk level and DB level Fragmentations and do corrective actions for high performance.
• Automated Alerting System with e-Mail notification for various SQL Server performance issues.
• Used Dynamic Management Views (DMV) and Functions to analyze various problems.
• Expertise in Administrating SQL Replications in Heterogeneous Environments (ORACLE 10g to MS SQL).
• Do Estimate Database Growth and benchmark Load, I/O subsystem, Network for capacity.
• Do Design various types of Indexes and monitor IO/ CPU intensive SQL using MS Dashboard.
• Expertise in troubleshooting, Problem Solving and tuning methodologies for SQL Server.
• Do Improve user’s performance and experience when they use applications by Database tuning.
• Wrote complex queries & SQL scripts and fast running Stored Procedures.
• Managed long transactions & various Locks and worked with multiple SQL instances.
• Managed, Executed, Debugged, Scheduled SSIS (DTS) Packages.
• Created and Managed MS Reporting Services SSRS, SQL Agent Jobs
• Having Good Architecture & Design skills in using C#, VB, ASP, HTML, .NET. DTS, Web Services

TECHNICAL SKILLS

• MS SQL 2019/17/16/14/12/ 2008 R 2/2005/2000/7/6/4 , SSIS, SSRS Access 2000/97, TSQL, RDBMS, Simplement ReplicationSQL Azure, DTS, OOPS, n-tier, Client/Server, Power Report Server Data Warehouse, VLDB, OLAP, PowerShell, PowerCLI.
• Windows 2012/2008/2003/ NT/XP/98/95, PoshPAIG DOS 4/6, VSS, Star Team, MicroStrategy 9
• Sybase 10/11, Oracle 8/8i, ORA BACKUP & Recovery RMAN, Exchange Server, Share Point Server
• VB 6/5/4/3, C#.NET, ASP.NET, VB.NET ADO.NET, XML Web Service
• Crystal Reports 11/10/9, SQL Server Clustering ASP, XML, HTML, VBScript, JavaScript, IIS 3/5/6
• MTS, COM, COM+, DCOM, ActiveX ODBC, ADO, RDO, DAO, CDO, J2EE
• Unix Shell Script, UNIX, NoSQL, MangoDB UML, ERWIN, ERWIN, Rational Rose, PowerShell

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. SQL Database Administrator/ Azure SQL Contributor.

Responsibilities:

• Azure SQL Contributor, Created Resources on Cloud Azure portal for Azure SQL Database/VMs/ Instance.
• Analyzing and Resolving SQL Databases for SQ Azure Database compatibility, and worked at different pricing Tires.
• Work load analysis carried out on computing DTUs/eDTUs for hosting Databases on SQL Azure.
• Migrating SQL Databases to Azure on IaaS, PaaS, SaaS Platforms using DMA/ SSIS/ BCP/ PacPack tools.
• Migrated moving SQL Databases from on-premise to Azure SQL databases/ VMs.
• Worked and resolved Azure active directory and on-premise windows active directory users and groups.
• Worked with different Azure Subscriptions for DEV/ TEST/ UAT/ PROD Environments, provided recommendations.
• Worked as Senior MS SQL Database Administrator to manage very large volume of Data imports for ACA Processing.
• Managed HA/ AlwaysON, MS Replications, MS Log shipping, MS Mirroring, Always-ON based on Applications.
• Managed Database Backups/ Restore for FULL/ Differential/ Incremental for single & Multiple File Groups.
• Managed & Administrated MS SQL Clustering Instances Active/ Passive, Active/ Active, & ALWAYSON Groups.
• MS SQL Database migrations for SQL 2019/2017/2016/2014/2012/ R 2/2008/2005/2000/7/6. x/4.x
• Managed Database Maintenance Plans - Reindexing / Reorganize / Update Statistics and Tuning SQL Databases.
• Wrote & Reviewed SQL stored procedures and SQL functions for tuning for performance for fast data processing.

Tools: MS SQL 2019/17/16/14/12 2008 R2, SSIS, SSAS, SSRS, SQL AZURE, Red Gate, MySQL 5.x/8.x, EXCEL, MS ACCESS, C#.NET, Visual Studio/ SSMS, PostgresSQL 11/ Power BI/ ETL/ Mediawiki, Power Shell, NoSQL-CosmosDB/ Azure Data Factory

Confidential, Jacksonville, FL

Operations Sr. SQL Database Administrator

Responsibilities:

• Managed & Administrated SQL Server ALWAYSON, MS SQL Clustering Instances Active/ Passive, Active/ Active.
• Worked in SQL Azure Databases, Managed, Backed up/ Restored DBs on Cloud SQL Azure env using ola.hallengren.
• Patched 100s of SQL Servers at the same time in parallel using in PowerShell/ PoshPAIG Patching tools
• Managed SAP SQL Server Databases sizing over 5TB, Managed Simplement Replication tool for SAP SQL DBs.
• Managed over 1000s of SQL Servers of version ranging SQL Server 7/2000/2005/08/ R 2/12/14/16/2017.
• Moved on-site SQL Server databases to Azure SQL Database Environment.
• Work load analysis carried out on computing DTUs/eDTUs for hosting Databases on SQL Azure.
• Migrated SQL Servers to SQL 2017/16/14, Migrated / Deployed SSIS Packages/ T-SQL Scripts.
• Created & Managed SQL Table Partitions, and boundary values to allocate data to each partition.
• Managed Always-ON based on Applications, MS Replications, MS Log shipping, MS Mirroring
• Managed Database Maintenance Plans: Re-indexing / Reorganize / Update Statistics.
• Used PURE Database Restore/ Bare Metal Restore/ Data Domain/ SRM/Avamar Restore for Disaster Recovery.
• Analyzed and Resolved CPU, Memory, I/O bottlenecks for SQL Server high Performance.
• Managed Disaster Recovery (DR)/ Deployment of SQL Scripts/Cubes/ XMLA to TEST/PRODs.

Tools: MS SQL 2017/16/14/12/ 2008 R2/2000/7, SQL Azure, SSIS, SSAS, SSRS, SharePoint 2010/13, Red Gate, Idera, Simplement Replication, PoshPAIG, PowerCLI, Ola.Hallengren, SAP, ServiceNOW

Confidential, Jacksonville, FL

Operations Sr. SQL Database Administrator

Responsibilities:

• Managed & Administrated MS SQL Clustering Instances Active/ Passive, Active/ Active.
• Worked in SQL Azure Databases, Created, Managed, Backed up/ Restored DBs on Cloud SQL Azure env.
• Moved on-site SQL Server databases to Azure SQL Database Environment.
• Used Data Migration Assistant (DMA) for migration to Azure SQL Database.
• Create and Manage firewall rules on Azure SQL Database Environment.
• Work load analysis carried out on computing DTUs/eDTUs for hosting Databases on SQL Azure.
• Migrated SQL Servers to SQL 2017/16/14, Migrated / Deployed SSIS Packages/ T-SQL Scripts.
• Experience working with NoSQL, MongoDB, Exporting/ Importing Data to and from NoSQL Environments.
• Analyzed SSIS packages Variables, Connection Strings centrally to manage and resolve problems.
• Created & Managed SQL Table Partitions, and boundary values to allocate data to each partition.
• Managed MISER Mainframe host data to update SQL Server Database using DATABRIDGE client Tools with BCNotify.
• Managed Always-ON based on Applications, MS Replications, MS Log shipping, MS Mirroring
• Managed Database Backups/ Restore for FULL/ Differential/ Incremental for single & Multiple File Groups.
• Managed Database Maintenance Plans: Re-indexing / Reorganize / Update Statistics
• Extensively used MS SQL policy Management to enforce various policies to maintain integrity
• Extensive experience with ROW/ Page level compression methods to for DB performance;
• Expertise with finding solutions to sudden change in baseline and SQL Server Performance.
• Hosted SQL Databases in Local & SAN I/O subsystems using right RAID levels/ Assign LUNs.
• Analyzed and Resolved CPU, Memory, I/O bottlenecks for SQL Server high Performance.
• Managed Projects/ Databases under TFS Source Control System, Configure and Manage TFS Server.
• Check-in, Checkout source code Objects for delivery for production Releases.

Tools: MS SQL 2017/16/14/12/ 2008 R2, SQL Azure, SSIS, SSAS, SSRS, SharePoint 2010/13, Red Gate, Idera, Foglight, TFS, Mainframe, DataBridge, BCNotify, Power BI Report Server, NoSQL, MangoDB

Confidential, Jacksonville, FL

Enterprise Physical SQL DBA

Responsibilities:

• Worked as Physical DBA / operations DBA, (MS SQL Database Administrator)
• Managed & Administrated over 1000s MS SQL Clustering Instances Active/ Passive, Active/ Active.
• Installed/ upgraded SQL 2014/ 2012/ 2008/ R2/ 2005/ 2000 & Applied Service Packs.
• Managed AlwaysON, MS Replications, MS Log shipping, MS Mirroring
• Managed Database Backups/ Restore for FULL/ Diff/ T-Log for single & Multiple File Groups.
• Managed Database Maintenance Plans - Reindexing / Reorganize / Update Statistics
• Used Central Management server/ IDERA tool to monitor over 1000s of SQL Server instances.
• Extensively used MS SQL policy Management to enforce various policies to maintain integrity
• Extensive experience with ROW/ Page level compression methods to for DB performance;
• Used Central Management server to monitor over 1000s SQL Server instances.
• Managed SQL FILESTREAM component to manage large files and large data sets XML/DOC/PDFs.
• Used DOC xPress tools to document SSIS component and SSIS executables.
• Checked Database for Integrity using DBCC CHECKDB, CHECKALLOC, CHECKCATALOG,
• Applied database scripts as required through Change Control and source control systems;
• Collaborated with security administrators, network administrators to establish and enforce security procedures to ensure data integrity on all database applications, and corporate network environments.
• Used more often SP CONFIGURE procedure to tune the SQL Server for various requirements
• Extensively used MS SQL policy Management to enforce various policies to maintain integrity.
• Managed TFS, CRM, and BizTalk, SharePoint databases in VMWare workstation environments,
• Create and Setup Base Lines and Monitor SQL Server Performance / Productivity.
• Set up SQL Resource Governor and allocated and managed Resources.
• Keep track of over 100 performance counters and tune SQL server based on counter values.
• Participated in SQL Migration Activities for CRM/ BizTalk SQL instances
• Resolved SQL Production problems, Resolved Memory, CPU, and IO issues.

Tools: MS SQL 2014/2012/ 2008 R2,, SSIS, SSAS, SSRS, BizTalk Server 2010, Microsoft Dynamics CRM 2011, MS SharePoint 2010, IDERA, Lite Speed, Red Gate, Toad for SQL Server, TFS, SCOM, DOC xPress.

Confidential, Jacksonville, FL

Sr. SQL DBA

Responsibilities:

• Worked as operations DBA, Managed Replications, Log shipping, Mirroring
• Used IDERA tool to monitor various activities of 100s of SQL Servers.
• Extensive experience with ROW/ Page level compression methods to for DB performance;
• Expertise with finding solutions to sudden change in baseline and SQL Server Performance.
• Used IDERA/ Red Gate/ Lite Speed tools for Various SQL Server tasks to be highly productive.
• Created SQL Database Data/ Log files in different File Groups to hold customer Loan and history data
• Installed & Configured SQL 2005/2008/ 2000 DBs with different RAID levels.
• Deployed SQL Server environments, handled DB performance tuning, analyzed SQL execution, provided backup/recovery strategy and implementation plans.
• Implemented daily operational procedures and alerts to ensure databases are performing efficiently to the optimum performance.
• Effectively used managed DB sizes, CPUs and Network Packets, input and output (I/O) performances.
• Checked Database for Integrity using DBCC CHECKDB, CHECKALLOC, CHECKCATALOG,
• Applied database scripts as required through Change Control and source control systems;
• Collaborated with security administrators, network administrators to establish and enforce security procedures to ensure data integrity on all database applications, and corporate network environments.
• Used more often SP CONFIGURE procedure to tune the SQL Server for various requirements.
• Scheduled SQL Agent Jobs, Alerts, and Notifications to inform Job competing Status.
• Supported in-house and 3rd party databases, performed routine database maintenance as per corporate backup/recovery policies; Created SQL Database Data/ Log files in different File Groups debtors data.
• Provided best archival system to boot best DB performance, Managed Replications, Log shipping.
• Provided helpdesk support to users in SQL client installations and 3rd party DB applications installations;
• Executed Query Plan and re-write the SQL Views/ SP in the way Query Optimizer can execute better.
• Installed & Configured SQL 2005/ 2000 DBs with different RAID levels.

Tools: MS SQL 2008/ R2 /2005/2000, SSIS (DTS), SSRS, SSAS, MS Reporting Services, SQL Replication, C#, ASP.NET, TFS

Confidential, NJ

SQL DBA/ Developer

Responsibilities:

• Logically brought a case into one single row (>3MB row size) for mass import using VB
• Created Complex SQL Stored Procedures to validate & populate data into SQL Tables
• Copy and distribute SQL data to one or more sites, Distributed copies of data on a scheduled basis.
• Did allow multiple users and sites to make changes then merge the data modifications together, potentially identifying and resolving conflicts.
• Did access SQL Server using HTTP/ XPath queries and Language
• Retrieve XML data using the SELECT statement and the FOR XML clause and write XML data
• Created stored procedures, UDF, views for MS Access reporting against the OLTP db.
• Integrated linked table interface to automatically update a secured, linked Access 2000 databases.
• Did Write XML data using OPENXML Row set provider, created complex SQL Stored Procedures to validate & populate data into SQL Tables/Used SQL Query Analyzer and using T-SQL interactively to access and change data, and used BCP utility to insert large numbers of new rows into a table quickly.
• Explored advanced query concepts for query solutions using aggregate functions in the select list
• Worked with Application Team to use SQL data effectively instead of using static data in the application
• Logged and Archived the Messages in MS Access DB/ Used Erwin to model and create SQL Server tables
• Effectively used errors from SQL system table master, dbo.sysmessages.
• Exported/ Imported data between ORACLE/ SQL/ MS ACCESS/ EXCEL using SQL DTS Services.

Tools: MS SQL 2000/7/6.5, ORACLE/ PL SQL VB, XML, Crystal 7, VBA, RDO, ADO, DAO, Crystal RPT 6

Confidential

Developer

Responsibilities:

• Did write Sybase/ SQL Stored Procedures and Triggers to consolidate billing/
• Used Sybase, SQL BCP to import/export data from various database/
• Did participate in code walk-through, reviews of program and code spec/
• Created SQL Stored Procedures, Functions, query, Extensively used left, right, inner, full joins
• Defined functional requirements, created logical & physical data design using S-Designer.
• Did VC++ code to populate data Grid from ESSBASE/ Created SQL Procedures/
• Ensured database integrity and consistency, Diagnosed bottlenecks using SQL Profiler
• Troubleshooting database issues using T-SQL, Wrote complex & lengthy queries & scripts
• Created Crystal Reports using SQL Stored Procedures/ VB for Price analysis Reports.
• Executed T-SQL statement to populate the cursor, Created about 50 complex SQL Stored Procedures.
• Did define SQL integrity constraints/ Did VB Coding for maintaining Chart of Accounts/

Tools: SQL Server 6.5/4.2, Sybase 11, Oracle 7, VB4, PB5, PB4, VC++ 5, MFC 4, PB3, VB3, SQL Server 4.2, Crystal RPT.