PROFESSIONAL SUMMARY:

• Over 8 years of Experience in SQL Server Database Administrator on creating, maintaining database objects, managing MS SQL in development, testing, and production environments. Proficient with performance monitoring, troubleshooting, security, database migration, high availability, and DR solutions.
• Experienced in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions.
• Designed and implemented Tables, Views, Store Procedure, Functions and PowerShell.
• Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tools such as Service now and Jira.
• AdministerSQLServer security by enforcing security policy, creating user logins with appropriate roles, monitoring user accounts, creating groups, and granting minimum required privileges to users and roles.
• Hands on experience in using Native tools such as SQL Server Profiler andDatabaseTuning Advisor.
• Hands - on experience in resolving locks, deadlocks, handling Isolation levels and performance issues such as CPU, I/O, Memory bottlenecks.
• Experienced in regularly patching, security updates, hotfixes, and version releases to ensure architecture stability.
• Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.
• Documented procedures in runbooks.
• Experienced in implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG.
• Strong experience on understanding and creating the server level and database level roles as per business requirement.
• Experience in Configured and Scheduled SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets and Transparent Data Encryption (TDE).
• Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.
• Strong experience on designed and implemented the backup and disaster recovery strategies as per RPO and RTO values.
• Experience on configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk.
• Proficient in designing and creating database objects in MS SQL and MySQL environments.
• Hands on experience in Azure SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Azure SQL Managed Instance, Azure Virtual Network, Azure Virtual Machine, Azure Storage, Azure Data Lakes Store, Azure Key Vault and Azure Data Factory, Designed, coded and implemented pipelines.
• Highly motivated and enthusiast learning new technologies; good communication skill as well as good teamwork spirit and skill.

TECHNICAL SKILLS:

Databases: SQL Server

Azure Cloud: Azure SQL Server, Azure SQL Database, Azure SQL Managed Instance, Azure SQL Data Warehouse, Data Lake Store, Azure Data Factory, Azure Virtual Networks, Azure Virtual Machine and Azure Storage

BI Tools: SQL Server Management Studio, SSIS, SQL Profiler, SQL Server Agent, SQL Server Data Tools, Power BI, Extended Events, Query Store, DMV and DMF.

Source Code Control: Microsoft Visual Studio Team Foundation (TFS), Git/GitHub and DevOps.

Project Management: JIRA and Team Foundation Server (TFS).

Language: SQL, T-SQL, DAX, Visual Basic .Net, C#, Python

Data Modeling and Tools: E-R Modeling and Dimensional Modeling, ERWIN and VisioMicrosoft Office Applications Office 365

Operating Systems: Windows Server 2016/2012/2008/2003, Windows 10/11

PROFESSIONAL EXPERIENCE:

Confidential

SQL DBA Administrator

Responsibilities:

• Installed, configured, administered and secured production and non-production servers (clustered and non-clustered).
• Upgraded SQL server 2012 to SQL Server 2017.
• Experience in implementing windows clusters across multiple availability zones and Implemented SQL Server 2016 Always On availability group.
• Experience in setting up database transactional replication for reporting server, Using Backup and restore methods.
• SQL server encryption and decryption (TDE).
• Expert in Database refresh from prod. to lower environment as per the business requirements. Automated quarterly/monthly database refresh.
• Managed and involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs.
• Managed and Implemented Ola Hallengren's Industries best SQL server maintenance plan and created schedule for all environments.
• ManagedSQL server Logins, Database users & rolesand involved in Daily User Maintenance.
• CreatedDatabase Maintenance jobsto perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Monitor databasegrowthactivities & Troubleshoot Transaction Log Issue.
• Provided weekly status information on all projects to Project Manager.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Logical and Physical design of database for projects on basis of user requirements using ERWIN
• Reported on a weekly basis to the project manager.
• Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.
• Worked withPerformance Tuning/Query tuning,execution plans, trace flags and SQL Profiler
• Installation ofService packsto all environments.
• Used log shipping for synchronization of databases.
• Designed and developed ETL process using SSISto load data from various sources like MS Access and SQL Server 2014, Oracle database,
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server SSIS.
• Designed and created database objects in MS SQL and MySQL environments
• Experience in migrating SQL Server 2012 and 2014 to SQL Server 2017 with AlwaysOn Availability
• Worked on BCP for data uploading module and create SSIS packages for data transfer & transform across locations and multiple data sources as per requirement.
• Performing DB backups, DB refresh, DB restores, clean-up, statistics update
• Installed and configured MS SQL Servers in Virtual Environments using VMWARE.
• Analyze the Execution plans and recommend/implement a better execution plan.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Environment: Windows R2, SQL Server, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, DataEdo, ERWIN, Azure cloud.

Confidential

SQL Server Database Administrator

Responsibilities:

• Installed and configured various editions and versions of SQL Server in standalone, and clustered nodes
• Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2008, 2008 R2 & 2012.
• Applied service packs, hotfixes and cumulative updates
• Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2012 and 2014
• Created and maintained logins, Users, Roles and managed security of the database.
• Taking Full, Differential and Transactional log backups and setting automated jobs.
• Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
• Performed data Extracting, Transforming and Loading (ETL) from different data sources.
• Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance
• Created triggers, views and stored procedures,
• Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.
• Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures
• Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping and Failover Clustering.
• Scheduled reports using SSRS to generate daily, weekly, Monthly, Quarterly reports.
• Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.
• Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.
• Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).
• Experience in using third party tool such as Red Gate compare tools, Network backup tools.
• Network Installation configuration and Security

Environment: Windows R2, SQL Server, IDERA SQL diagnostic Manager, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.

Confidential

SQL DBA

Responsibilities:

• Installed and configured SQL server 2008 and 2008/R2.
• Installed and configured window server 2003 and 2008
• Created and updated databases, tables, stored procedures, triggers, functions, and views.
• Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments.
• Prepared documentation for disaster recovery plan.
• Involved in installing failover clustering on multiple nodes.
• Implemented database mirroring and log shipping
• Planned backup strategies, scheduled backups, and performed restore operations.
• Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.
• Worked on creating, reorganizing, and rebuilding indexes.
• Worked on database space management, performance monitoring, and alert management.
• Planned the location of files and increased the size and number of files.
• Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.
• Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks.
• Transferred data between several servers using BCP and DTS.
• Generated reports extensively using SSRS.
• Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.

Environment: Windows R2, SQL Server R2, SQL Server 2012 SSMS, Profiler, Extended Events, Perfmon, RAID