SUMMARY

• A Microsoft Certified Professional with around 13 years of IT Experience which includes focused experience in Database Administration, Development & Support of MSSQL 2017/2016/2014/2012/2008 across various Client Server/mission critical Environments.
• Migrating On - Prem SQL servers to Azure Databases both Managed Instances and SQL Databases as per Requirement.
• In place & Side-by-side Migration experience from SQL Server 2005à2008à2012à2014à2016 using Upgrade Wizard and Upgrade Advisor in both Clustered and Non-Clustered Environments.
• Implemented Always-ON in Multi-Subnet platforms and troubleshoot issues involved while configuring.
• Experience in migration of Databases from SQL Server 2005/2008 to SQL Server 2012/ 2014/2016/2017 and troubleshooting migration issues on both 32-bit and 64-bit Environments.
• Experience in migrating SSIS packages to Azure Data Factory.
• Automated SQL Installations along with pre and post configurations using PowerShell cmdlets.
• Hands-On Experience in writing & debugging Stored Procedures, Triggers, functions and Troubleshooting Code Issues in T-SQL.
• Experience in using new features such as Query Store, Temporal Tables, Stretch Database, Enhanced In-Memory OLTP etc., in SQL 2014/SQL2016.
• Creating and maintaining SSIS Packages for huge data transfers and various ETL activities.
• Installation, Configuration & Administration of SSRS 2012/ 2014/2016/2017 , SSIS, SSAS, Legacy Components, and Feature packs.
• Generated Enterprise reports using linked reports, sub reports, charts and filters in SQL server reporting services and Power BI.
• Experience in Working with Production 24/7 and Development and UAT Environments.
• Experience in Database Backup & Restore methodologies using Maintenance Plans, SQL Lite-speed and various 3rd party tools.
• Experience in Performance& Query Tuning using SQL Profiler, Perf-Mon, Extended Events, PSSDIAG’s, SPOTLIGHT, Deadlock Analyzer and various DBCC and DMV utilities.
• Configuring Replication (Merge, Transactional & Snapshot) to replicate data to regional and remote servers and troubleshooting Replication issues.
• Experienced in implementing and supporting High Availability solutions like Clustering, Database mirroring, Log shipping and Replication.
• Experience in Working with Windows 2000 Advance and Enterprise Server 2003/2008/2012/2016. Co-ordination of Service Packs, Hot-fixes with Windows Infrastructure Team.
• Experience in assisting Applications & teams across Remote and Local geographical locations as part of Support.
• Excellent Analytical, Interpersonal and Communication Skills.

TECHNICAL SKILLS

SQL Server Tools: DMA, SQL Extended Events, SSIS.

Database: MS-SQL Server 2000/ 20 .

Programming Languages: T-SQL, PL/SQL, PowerShell, C, C++, C#

.NetWeb Technologies: VB Script, HTML, DHTML, XML, ADO.NET.

Operating System: Windows NT, 2000 Advanced Server/ Enterprise Server 2003,Win XP Prof/Standard, Win 98, HP UNIX 10.xReporting Tools: SSRS 2005/2008/2012 , Crystal Reports, BIDS and Impromptu

ETL Tools: InformaticaOffice Suite / Tools MS Office (Word, Excel, Power Point, Access 97/200

DB Design Tools: ERSTUDIO (ERWIN 3.1/4.0)

Miscellaneous: CommVault Simpana, Dell Spotlight, SQL Lite-speed, NetApp, EMCSAN, RedGate DLM Automation, Visual Studio 2013

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Azure SQL DBA

Responsibilities:

• Maintenance and Administration of SQL Server 2008R2/SQL2012/ SQL2014/SQL 2016/SQL2017 across different environments like Development, Acceptance and Production.
• Successfully Migrated/Upgraded SQL Server 2000/2005/2012 to SQL Server 2014/2016/2017 on Development, Acceptance, Production Environments for various mission critical applications.
• Migrated On-premises databases to Microsoft Azure cloud services.
• Creating Assessments using Database Migration Assistant (DMA) and identify any issues for successful migration of Databases to Azure
• Configured and maintained multi-subnet Always-ON on SQL Server 2014/2016.
• Configure and maintain merge replication and verify data consistency between shore and ships.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, DBCC verification and Re-indexing, update Statistics as part of PerfTuning efforts using PowerShell.
• Develop PowerShell Scripts to remotely monitor, maintain and configure SQL servers across domain.
• Monitoring database status including CPU, Memory, I/O, Space and track baseline data using Dell Spot-light and SQL Management Data Warehouse (MDW).
• Query Level Tuning by reading Query plans and identify resource contentions and fine-tune them for optimal performance.
• Maintaining Data consistency using various High Availability solutions like Database Mirroring, Clustering, Log shipping and Replication.
• Created linked Servers and enable distributed queries to run across Oracle, ADSI and other OLEDB data sources.
• Monitoring backup & Restore Jobs using SQL Lite-speed, CommVault Simpana and device methodologies for disaster recovery for production SQL Server databases.
• Change Control Migrations for Code and Database deployments, across all environments adhering to SOX rules and regulations.
• Configured Database encryption technologies including Always-Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking by creating certificates, symmetric and asymmetric keys to secure confidential Data.
• Experience with handling various Data Corruption issues.
• Identifying potential applications and decision making to implement Delayed Durability, Data compression, Column-store Indexes and In-Memory OLTP.
• Develop SSIS Packages and catalogs for extracting, cleaning, transforming and loading data into data warehouse (SSAS).
• Choosing and Configuring SAN RAID levels suitable for Data, Log and Temp DB’s.
• Performed Security Administration by creating Logins, Users, granting permissions through roles, managing Schemas and automate them using PowerShell for remote deployment throughout the Enterprise.
• Monitoring SQL server performance using Extended Events and profiler to find performance, dead locks and blockings.
• Created jobs, alerts to monitor activity logs and error logs to capture and fix any possible errors.
• Automated and enhanced daily administrative tasks including space management, ping status, Replication, mirroring performance, database backup and recovery.
• Rollout Service packs, Hot-fixes, Patches across environments on a needy basis and coordinate with Server Operations Team.
• Documentation of reoccurring production issue troubleshooting procedures.
• Provide On-call support for high critical servers.

Environment: MS SQL Server 2008/ 2012/ 2014/2016/2017 , T-SQL, Active Directories (ADSI), SQL-LightSpeed, CommVault Simpana, Erwin, Visio, SPOTLIGHT, DB-Artisan, T-SQL, SSIS, SSAS.

Confidential, Chantilly, VA

SQL DBA

Responsibilities:

• Involved in Installation, Configuration, Upgrades and Administration of SQL Server 2008/2012 across different environments like Test, PPE, PROD and DR.
• Implemented Security which included creating Logins, Users, granting permissions to users and debugging permission Issues.
• Installation of various SQL server components which includes SSRS, SSIS and SSAS as per the requirements.
• Configured Transactional Replication Types between Primary Server and Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Created server and application monitors and alerts, blocking-chain and deadlock monitors, automated performance report generation and distribution with Database Mail.
• Configured and Maintained Database Mirroring for Disaster recovery in high safety Mode.
• Configured MS SQL Server 2008 in-built log shipping from primary server to standby server for report generation.
• Implemented Policy-based Management by configuring facets, conditions and policies to adhere company security policies.
• Involved in creating databases, various DB Objects like Tables, Procs, UDF’s, Triggers and migrate them across various change control environments.
• DB Programming using T-SQL in developing stored procedures for generating various Reports using SQL Server reporting services (SSRS 2008/2012).
• Windows server administrative tasks like performance monitoring at server level, testing and applying security patches.
• Querying data stored in SQL server 2008 Databases using LINQ, Grouping sets and Merge operator.
• Applying monthly Security Patches, Hot-fixes, QFE’s on all environments.
• Examine and Deploy bugs in PPE, Sand box and Production that were approved by Test team.
• Created linked Servers and enable distributed queries to run across different environments.
• Involved in extensive 24/7 production support.

Environment: - SQL Server 2005/2008, SSIS/DTS, OLAP, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ER-Studio, Erwin, Upgrade Advisor, DTS Designer Tools, Windows Performance Monitor, Access, Windows 2000 Advanced Server/win 2003/2008 Server.

Confidential, Chantilly, VA

SQL DBA

Responsibilities:

• Generated Scripts to automate server administration by using SQL Server Power-Shell in SQL Server 2008.
• Involved in creating databases, various DB Objects like Tables, Procs, UDF’s, Triggers and migrate them across various change control environments.
• Storing data in a database using SQLCLR and access the data using ADO.NET.
• Configuring Active Directory Security Groups and add users to the groups and provide permissions to groups on Databases.
• Create alerts, notifications, and emails for system errors, insufficient resources, fatal database errors and hardware errors.
• Monitored database performance on tables using Index tuning Wizard.
• Created Linked Servers across various data sources including SQL Servers, Oracle.
• Mapped data between SQL Data types and .net CLR Data types.
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup, archival software, media, hardware, and offsite storage.
• Rebuilt indexes to reduce fragmentation using DBCC DB Re-index, Index defrag, Alter Index.
• Extensively worked on Report coding to behave according to the front-end CRM Application.
• Upgrade DTS Packages to SSIS Packages.
• Monitoring Blockings and proactively monitor Deadlocks and resolve them by setting up trace flags - T1204, -T1205, -T1222.
• Monitor connections, locks and performance of SQL server.
• Transformation of data (Millions of records) to Data warehouse (SSAS) using SQL server Integration Services (SSIS).
• Worked with SQL Server Profiler, PSSDIAGs and other monitoring tools to generate traces and trouble shoot issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2000/2005 backend.

Environment: MS SQL Server 2008/2005/2000 , oracle 9i/ 10g, Visual Studio 2005/BIDS Windows 2000/2003, IIS 5.0, T-SQL, Active Directories (ADSI), SQL-Litespeed, Visio, SPOTLIGHT, DB-Artisan, T-SQL, VBScript, JavaScript, DTS/SSIS, SSRS 2000/2005.

Confidential, Herndon, VA

Database Administrator

Responsibilities:

• Maintain the databases
• Implement database maintenance procedures: hourly/daily/weekly backup schedule.
• Review and modify database structures, stored procedures, views, triggers, user-defined functions.
• Enhance performance by reviewing disk configuration and storage allocation.
• Schedule and monitor all maintenance activities of SQL Server including database consistency checking, and index de-fragmentation.