SUMMARY

• Microsoft SQL DBA with 12 plus years of diverse experience in database design and systems development with proven expertise in database administration, design, development, implementation and infrastructure implementation and support. Well versed in supporting broad scale mission - critical database systems including configuring high availability, scalability, performance, and disaster recovery.

TECHNICAL SKILLS

• Installation/Configuration
• SQL Server Migration
• On-premises to Azure\AWS migration
• Clustering
• Database Optimization
• High Availability
• Disaster Recovery\DR exercise
• Database Modeling
• Automation, Implementation & Testing
• Deployment of SSIS and SSRS packages
• Migration (DMA & map toolkit tool)
• Performance Monitoring
• Backup and Restore
• Unix\Linux\PowerShell

PROFESSIONAL EXPERIENCE

Confidential

Azure SQL DBA\Developer

Responsibilities:

• Monitoring and troubleshooting all scheduled Jobs, Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach-technical guidance, task assignment and tracking.
• Experienced in providing analysis on High availability/Disaster recovery & scalability.
• Worked with Azure migration team and implemented including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).
• Worked as Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, resource groups.
• Worked with multiple applications vendors for troubleshooting applications backend SQL server and CosmomDB.
• Developed ad hoc SQL statements & complex store procedures per user request and develop SSRS report.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Performed code reviews with application developers regarding database security and performance.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Worked with various versions in Tableau, Tableau Server, Tableau Public, and Reader & Online.
• Worked on Data analysis and technical requirement gathering and review.
• Worked on migration documentation and DR exercise run book.
• Migrated SQL servers from on prm prem to Azure environments.
• Worked on database encryption TDE and SQL Auditing, Resource Governor, Policy Based Management (PBM), data and Network Encryption using certificates
• Involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory SSIS.
• Used actively database migration assistant ( DMA ) and map toolkit tools for assessment
• Supported large scale thousands of databases within the Shared Hosting Environment and Windows Development Production Environment applications backend SQL server,Oracle and DB2 databases.
• Installed, configured, administered SQL Server 2019,2017,2016,2014,2012 on production and development environments.
• Regularly monitoring and updating the production and lower environment resource utilization threshold of CPU, Disk I/O, memory related bottlenecks and carried out similar other tasks.,
• Installed, maintained & monitored production SQL servers and making sure they are up-to-date with latest rollup hotfix and service packs.
• Installed and configured windows server failover clustering and configured Always-ON for High availability, (DR) disaster recovery solutions and Distributed Availability groups . .
• Worked on documentation, worked on run-book for DR-exercises.
• Configured distributed availability group and geo-clustering.
• Worked on production\test deployments\releases using PowerShell every two weeks .
• Designed and Implemented log shipping, mirroring, replication from primary site to the secondary site to support mission critical applications and offload queries.
• Migrated multiple databases\SSIS packages\SSRS reports\SSAS cubes between different SQL versions 2014\2012\2008R2 in both in In-place and Side-by-Side migration methods.
• Moved several existing production databases, jobs, packages, reports, linked server, logins and other computer objects to new versions of SQL server.
• Worked closely with application team, development team and infrastructure team for planning and Implementation of the migration and for new application equirements\releases.
• Worked on performance tuning, optimization of stored procedures and queries.
• Automated database refresh from production to test using custom scripts.
• Set up linked servers between SQL servers, DB2 and oracle data sources.
• Supported VMware and SharePoint backend databases.
• Worked with Offshore team coordinating migration project activities to meet the project deadlines.
• Developed and deployed SSIS packages and SSRS Reports.
• Managed windows and SQL database users\groups accounts using Active Directory.
• Handling day to day support tickets and development and production issues and worked with offshore teams.
• 24 X 7 Production on Call Support.

Environment: SQL Server 2017\2016\2014/2012, Azure Cloud, Windows server, Backup Utility(netbackup), Quest spotlight, SQL Litespeed, Idera technologies Like SQL secure,solarwind,TFS, AWS,S3 VMware, SharePoint, PowerShell, Redshift, Master Data Services (MDS),Extended Events.

Confidential

SQL DBA

Responsibilities:

• Install, configure and administer MS SQL server 2012 and 2014
• Worked capacity planning and migrated hundreds of instances and databases to SQL 2016\2017.
• Configure and administer Availability Groups for high availability/ Always On of multiple databases
• Successfully Installed, configured and administer a traditional SQL Server failover Cluster with 2 nodes
• Created and administered various jobs to handle different tasks and to monitor resources on various servers and to email the necessary information when threshold was reached.
• Apply SQL Server patches ; Service Packs, Hot-fixes, and Cumulative Updates as required and created documentation for tracking
• Implement Database optimization such as performance tuning and improvement using Dynamic management views and functions and others
• Design, Develop and implement SQL server reporting service that extracts data and present in the user friendly formats.
• Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Ensured systems availability and managed critical incidents, troubleshoot issues to full resolution and provide detailed updates to management
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Experience in deploying on prem SQL Databases in AZURE.
• Security Patching on the Azure IAAS VMs through the Shavlik Patching Tool.
• Monitoring the Azure clusters health Pre and Post deployments.
• Intensively analyzed the existing system in regard to the database administration and produced an inception report which describes the existing situation, pros and cones, and future intervention and plan of action(short, midterm and long-term)
• Created linked servers to perform distributed queries and data transfer
• Establish a modality to collect the information and documentation of the existing system
• Develop procedures/protocols on database planning and implementation, database security aspects, database auditing, backup and restore modality
• Review the current procedure of backup and restoration, and introduced the differential back up into the system and periodic restoration of backups\Applied SQL Server best practices
• Provide support for critical databases that are on Azure and Hyper-V
• Worked with database developers team for database design, data modeling and normalization
• Assisted developers in the process of Extract, Transform, Load ( ETL ) in data warehouse
• Run DBCC commands to check the database consistency and shrink the databases
• Monitored and troubleshoot server performance, database activities and clients’ applications
• Participated in enhancing end users’ understanding of database systems by conducting pre-implementation trainings/workshops and different events
• Manage Very Large databases (VLDBs) of 1TB and more using Table Partitioning, Backup and data Compression and Multiple file-groups
• Responsible for Designing and implementing the backup strategy required as per the requirement on production and development environments

Environment: Windows Server 2008/2012 R2, MS SQL Server 2012/2014, Azure Cloud, T-SQL, SQL Profiler, System/Performance Monitor, Activity Monitor, ETL, Quest SpotLight, ERWin, PowerShell, SSRS, SSIS, SSAS, Azure, Hyper-V, Data Warehousing, TFS, IIS, High Availability/AlwaysOn, Ticketing softwares, Visual Studio, SharePoint and Others.

Confidential

SQL DBA

Responsibilities:

• Designed and implemented multiple high availability technology SQL server 2012\14\16\17 clustering,Always-ON, Log shipping Mirroring between multiple sites on both development and Production environment sizes over Terabyte.
• I have successfully Migrated thousands of databases from SQL Server databases, SSIS packages, SSRS reports, Multiple database along all database objects like stored procedures, logins (orphaned users and after migration worked with application owner to redirect \ point their application to the new migrated server or using alias on the connection string.
• Assist design with development and implementation of SQL server into the Shared Hosting Environment and Windows Development and production Environment.
• Assist with the development of Disaster Recovery plan for SQL server Environments.
• Attend technical meetings with various components to discuss database releases, upgrades, changes & deployments.
• Created automated process to notify the management on the status of system resources.
• Pal take in bi-monthly working meetings with user community to discuss upcoming SQL server releases\changes within the environment.
• Used remedy and servicenow ticketing systems to track and resolve incidents in a timely manner.
• Implement and support Quest spotlight application server.
• Perform daily system health of the SQL server (space, CPU utilization, memory).
• Monitored the overall activity I/O of the SQL server through Quest spotlight and managed through capacity manager.
• Check the SQL server error logs for any errors that may occurred overnight.
• Write multiple stored procedures to improve the server performance.

Confidential

SQL DBA/Developer

Responsibilities:

• Installation and configuration of Windows Server 2008, 2012 R2 including the set-up of Active Directory, Domain Controller, DNS and DHCP servers and Windows failover cluster
• Installation, configuration and administration of SQL Server 2008, 2008 R2, 2012
• Administering the MS SQL Server security in relation to users, logins, groups, Principle of Least Privilege (PLP), Securable, Permission, Roles and Authentication Modes as a part of Security Policies
• Creating and managing databases, schema objects such as tables, views, indexes, procedures, triggers and database constraints to meet business requirements and policies and maintained referential Integrity.
• Implementing a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) on production and test environments and provided support 24x7
• Timely taken backup, differential backup and transaction log backup for all production and test systems
• Upgraded SQL Server for high volume processing databases on a clustered environment.
• Managing critical databases on Amazon Web Services (AWS)
• Worked on migrating and managing database systems on Oracle VM VirtualBox and VMware Implementing SQL server high availability solutions/tools like Log shipping, Mirroring and Replication as well carefully scheduled maintenance plan to minimize downtime.
• Install and configure a traditional SQL Server failover Cluster with two nodes
• Managing the use of disk space, memory and connections/network.
• Running DBCC consistency checks and analyzing stack traces, if generated, fixing data corruption on application databases
• Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks
• Installed and configured SQL Server Reporting Services in a team
• Create and deploy different reports for different business purpose in a team
• Proposed various high availability options to maintain the high availability of SQL server on various environments