SUMMARY

• 8 years of Professional experience as SQL SERVER Database Administration and Production Servers maintenance.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Implemented side by side and Inplace Migration of MS SQL server /2008R2 and applied Patches and Service packs to update different versions of MS SQL server.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments and creating linked servers between SQL servers 2000/2005/2008 R2/2014 environments.
• Hands on experience with SQL Server 2012 Always On High Availability Groups.
• Expertise on new feature ALWAYSON in SQL 2012 for HA, DR and Reporting access for faster, easier and better safety of data.
• Proficient in SQL Server 2008 new features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, DatabaseSnapshot, DDL triggers, Try - Catch blocks, Online Indexing, Online Restoring, DMV’s, DMF’s, Mail Setup, Jobs, Alerts and Database Tuning Advisor.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Experience in implementing and setting up Disaster Recovery and High availability solutions like different Replication Models, Log Shipping, Clustering (Active-Active and Active Passive) and Database Mirroring on physical and virtual machines.
• Gathering data requirements and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of Microsoft SQL Server Databases is my primary responsibility.
• Experience in Import, Export, Backup, Database Monitoring tools and Application support.
• Good working knowledge in Logshipping, Mirroring, Replication, Clustering and AlwaysON.
• Experience in planning and implementing the Disaster Recovery (DR) strategies as per the client requirements
• Experience in configuring & Administering 3rd party monitoring tools SolarWinds, Spotlight.
• Basic exp with PowerShell scripts to automate day to day activities.
• Ability to work effectively in a very independent environment, balancing multiple priorities and keeping stakeholders apprised of status and issues
• Strong interpersonal skills, with the ability to interact with technical, non-technical easily and effectively, support, and business staff at all levels
• Experience with onshore/offshore business models and sourcing concepts

TECHNICAL SKILLS

Databases: SQL SERVER 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019

Operating System: Windows Server 2019\2016\2012\2008\2003.

Scripting Languages: PowerShell

Monitoring Tools: SolarWinds, Spotlight.

PROFESSIONAL EXPERIENCE

Confidential, Florham Park, NJ

SQL Server DBA

Responsibilities:

• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creating new Databases and Migrated SQL Server 2012 databases to SQL server 2014 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Created Linked servers for distributed queries.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Responsible for providing 24 * 7 critical production support, development and clustered servers.
• Created DDL triggers for auditing any DDL change in SQL 2008R2.
• Determined hardware and software requirements for SQL Server version 2012 and 2014. Determined the SQL 2014 installation options. Tested the installation of SQL 2014 server.
• Worked on multiple projects on building reports using SQL Server 2005 reporting services (SSRS), Business Objects Crystal Reports. Support and debug asp.net applications using Data tools.
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Performance Analysis and Spotlight.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active Directory Group.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Installed SQL Server 2014 Cluster and configured Always On availability group set up on Windows Server 2012 in Development production environments.
• Performed Backup and recovery Automation of Backups using maintenance plans.

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• Pro-active monitoring of Database related activities, Installations, applying SQL Security Patches, Version Upgrades.
• Work closely with clients to detect problems and provide resolution to improve optimization and efficiency.
• Automation of day to day activities using the PowerShell scripts.
• Development of automated daily, weekly, and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Configuring SQL monitoring with SolarWinds, Spotlight.
• Implementation and maintenance of Log shipping, mirroring and Transactional replication, clustering and AlwaysON.
• Database Performance Tuning - Understanding and recommendation based on SQL.
• Upgrade \ Migrate databases to newer versions of SQL server.
• Designed and Implemented DR strategies as per the client requirement.
• Independently managing Production and Development database support.
• Troubleshooting issues with SSIS and SSRS.
• Implementing SQL Security best practices.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured edition of SQL Server
• Successfully migrated from SQL Server 2005,2008 to SQL Server 2014,2016 on Development and Testing Environment.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments.
• Creating logins and roles with the appropriate permissions.
• Responsible for resolving blocking and locking issues.
• Successfully implemented database mirroring between Primary server and Mirror Server.
• Implemented log shipping in standby mode to support DR servers.
• Provided 24 X 7 dedicated supports for SQL Server production server
• Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.

Confidential

SQL Server DBA

Responsibilities:

• Supported 200+ servers in which around 70 production servers with a total of more than 3000 databases.
• Good understanding in incident management.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, and Database complete backup).
• Created and scheduled scripts for Database growth Monitoring, Disk Space Monitoring, Check Blockings on the server and SQL Server Performance snapshot application which gives the CPU and Memory utilizations, Long running jobs and processes information of a selected server
• Attend to user calls using Remedy call tracking system, resolve problems over the phone or email
• Escalate support requests to next level of internal support upon approach of established resolution targets
• Escalate application issues/bugs to the development team and provide resolutions
• Experience in Database mirroring, Log Shipping and Snapshot\Transactional Replication
• Scheduling and Troubleshooting of SSIS packages and Jobs
• User administration in SSRS and SSAS
• Troubleshooting and scheduling of SSIS packages.
• Troubleshooting problems with reports in SSRS.
• Hands-on experience with SQL Server installations and patching
• Basic knowledge in troubleshooting Clustering issues.
• Performance Tuning of Database by using query plans, profiler and DTA.

Confidential

SQL Server DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008R2, 2012, and 2014in development, test, and production environments
• Monitored SQL Server activities/issues (such as CPU utilization, Memory utilization and IO utilization, disk space issues, blocking, deadlock, fragmentation, Identifying indexing issues, managing indexes, growth patterns, etc. ) and optimized performance using Execution plan, PerfMon, Profiler, Database Tuning Advisor, DMVs and DMFs
• Implemented Backup strategy for production and development environments and managed Backup to different media such as Local Drive, Network Drive/Backup Server, Tape Media, and Restored databases
• Setup and configured Database Mail and configured notifications and alerts
• Performed regular backups, restores, and databases
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification, cleaning history, deleting old files, index, and fragmentation management
• Installed, Configured, and Maintained Fail-Over Clustering using SQL Server 2012
• Setup, configured, monitored, troubleshoot, and maintained Log Shipping, and Transactional Replication
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server.
• Created user accounts and managed database object permissions
• Regularly inspected SQL Server Logs, SQL Server Agent Error Logs, and Windows Event Viewer for Information, errors, and warnings
• Using Third-Party Monitoring tools SolarWinds and Erwin also, we use Ticketing system Remedy
• Involved in resolving deadlock issues and performance issues and the Health Check process for the database
• Responsible for Database support, and troubleshooting application issues daily basis
• Monitoring of database size and disk space in Production, Staging & Development environments
• Developed and Managed reports in SSRS (SQL Server Reporting Services) including managing securities