SUMMARY

• About 11 years of experience in IT including Database Design, Development and Administration of Database Management in MS SQL SERVER 2016/2014/2012/2008/2005 on Windows environment.
• Experience in implementing different types of High Availability &disaster recovery technologies like Always on, Clustering, Replication, Log Shipping and Database Mirroring.
• Expertise in Always - On Availability Groups (AAG) and HA/DR Troubleshooting
• Recommend and implement database security policies that are consistent with security guidelines and best practices.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Worked extensively on Clustering and server consolidation.Troubleshooting production issues related to high availability.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in Data Migration between Homogeneous Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).
• Good understanding of Normalization /De-normalization,Normal Form and database design methodology
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and analyzing the execution plan and index management for better Query Optimization.
• Administer MS SQL server by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user account, creation of groups, granting database
• Experience in applying patches and service packs to keep the database at current
• Patch level in different environments of standalone as well in cluster servers.
• Experience in the process of Upgradation/Migration SQL Server and and by upgrading database engine and transferring metadata to new server using In-place upgradation
• Closely monitoring the growth of the databases, as a part of capacity planning.
• Experience in Installing, Configuring IIS (Internet Information Services) on window server 2000/2003/2008/2012
• Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/ locks.
• Maintaining SQL server in a manner to yield un-hindering performance by performing Index Rebuild
• Update Stats, Data file and log file shrinking, Resizing Data file, Log file, and Verifying SQL Server log files for any new entries, which may degrade the performance of databases.
• Evaluated performance and growth of data in SQL server by generating reports through predefined customized scripts weekly basis respectively.
• Scheduling backups using jobs, restoring and taking Adhoc backups using various data tools.
• Documenting Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures In Database Management Prod Guide.
• Deploying a Confidential Azure SQL Database
• Deploying SQL Server databases to Azure virtual machines
• Configuring secure access to Confidential Azure SQL Databases
• Managing SQL Server instances on Azure

TECHNICAL SKILLS

Databases: MS SQL Server 2016,2014, 2012, 2008, MS SQL Server 2005 Database Expertise database administration of MS SQL Server 2016,2014,2012,2008, 2005

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, VMware

Third Party Tools: SQL profiler, SQL Sentry Performance Advisor, Red-Gate SQL Monitor, Idera's SQL diagnostic manager

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Cloud/Azure: Azure Services, PaaS, IaaS, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure

ETL/Data Warehouse Tools: SSIS/DTS, BCP

SSMS: SQL server 2008 R2,2012,2014,2017

Ticketing Tools: ServiceNow

PROFESSIONAL EXPERIENCE

Confidential, Austin,TX

Sr.SQL Server DBA

Responsibilities:

• Perform database installation and configuration, tuning, capacity planning, health checks, backups & recovery and change management
• Creating databases and building servers based on client requirements
• Configured Always On, troubleshooting issues related to Always On and fix them. Perform failovers in Always On for maintenance activities
• Implementing and configuring Central Management Servers to centralize and manage instances of SQL Server 2008 R2 to SQL 2016.
• Supervise code review of scripts and SSIS packages with developers. Advise developers in code optimization.
• Approve and run scripts for Quality Assurance and Production releases.
• Troubleshoots issues with database instances, DR, replication and backups and eliminates root causes
• Provides production database support with specific focus on availability, capacity, performance, security and recoverability.
• Designs, develops and drives global implementation of database standards, tools and procedures throughout the IT organization.
• Designs data storage and management processes for data warehouse projects Plans projects and oversees the tactical aspects of a data warehouse implementation and maintenance.
• Performs complex application environment builds and refreshes, Create and implements disaster recovery procedures.
• Develops project plans for implementing data warehouses.
• Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools, archival/recovery tools and data access
• Coordinating and conducting meetings with several stake holders to ensure the technical debt of the requirements were covered under required business functionalities
• Implementing Data Collector and Data Management Warehouse to collect performance data of all the SQL instances.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Creating stored procedures, views, triggers, user defined functions to apply business rules to the data.
• Working on replication and Change Data Capture.
• Configuring SSRS using configuration manager, created and maintained security roles and created new reports.
• Creating maintenance plans (database and log backups and cleanups).
• Used server scoped DMV’s and database scoped DMV’s to trouble shoot issues.
• Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.

Confidential, Philadelphia, PA

Sr. SQL Server DBA

Responsibilities:

• Responsible for Installation and configuration of SQL Server 2005/2008/2008 R 2/2012/2014/2016.
• Involved in daily monitoring & maintenance of MS SQL Servers in Production and Development.
• Involved in configuration of new SQL Server Instances on Windows servers with appropriate parameters.
• Participated in migration of the databases and managed the location of database files and their sizes.
• Migrated and validated users and logins in the new environment.
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2008/2008R2, 2016 databases.
• Transferred and created maintenance plans, scheduled jobs and SSIS packages.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified, and optimized complex queries for data retrieval and modification
• Created tables, views, indexes, functions and advanced queries using SQL Server Management Studio.
• Generated test data and tested database to meet the functionalities of the deliverables in the project documentation and specifications.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Automated and enhanced daily administrative tasks including space management, database backup and recovery.
• Created Clustered Indexes and Non-clustered Indexes to increase the performance of the database.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, Database maintenance Plans and recovery.
• Configured and maintained transactional, snapshot and merge replications.
• Managed the production and development databases for performance tuning, capacity planning and SQL Server clustering and database security configuration.
• Scheduled and monitored all maintenance activities of SQL Server 2005/2008 including database consistency check, and index defragmentation.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities and also we are monitored the servers and alerted by Foglight PA.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Configured securities and access to production databases in SQL Server 2008, Windows 2008 Server.

Confidential, Redmond, WA

Sr. SQL Server DBA

Responsibilities:

• Installed and configured SQL Servers 2000/2005 and 2008 R2 also Add Migrated SQL servers 2000/2005 to SQL server 2008 R2
• Gather requirements from Lawyers and Clients.
• Manage Log Shipping to a standby by server using DR-Synch. DR-Synch is a Disaster Recovery and has lot of advantages over the inbuilt SQL Server Log Shipping.
• Installed, configured and designed Transactional replication to support payroll systems
• Create Indexes, Stored Procedures, and Functions.
• Create complex reports using Crystal reports with custom parameters when required.
• Create SSIS packages to transfer data from Source Databases to Enterprise Reports.
• Create stored procedures to be run as Regular SQL Server jobs for removing of duplicate data.
• Create stored procedures to generate billing feeds to be sending to clients for Accounting Department.
• Each client has different format for the feed and the challenge is to make sure that data is clean and the feed loads into each client’s system successfully.
• Work on urgent requests from the Lawyers and Clients for custom reports.
• Create jobs Using SQL Server Agent and troubleshoot SQL Server performance related issues.

Confidential

SQL Server DBA

Responsibilities:

• Migration of databases from SQL Server 2000 to SQL Server 2005. Setting up new SQL Servers and configure required users. Restoring and copying production databases.
• Performed Log Shipping and implemented Replication as High Availability techniques.
• Database Mirroring as Disaster Recovery Solution.
• Installation and configuration of MS SQL Server 2005 on New Production and Test Servers with latest Security updates involving Service Packs and Security patches.
• Monitored database status including CPU, Memory, I/O, space and Dead Lock using SQL Server Utilities
• Performed Database Backups for Production, Test and Development Servers and restored backups onto test servers to ensure that we had good backups.
• Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients, etc.
• Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor
• Automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• Creation of logins, users and configuring permissions and assigning roles to users.
• Development of automated notification when SQL Server Backups and scheduled maintenance Jobs
• Upgrade and installation, creating and managing databases, enhanced backup and Restoration plan, monitoring and troubleshooting.
• Designed and implemented comprehensive Backup and Restore Strategy for the point in time recovery. Prepared a document for Disaster Recovery Plan