SUMMARY:

• Microsoft Certified Professional with over 12+ years of experience as Microsoft SQL server database administrator in Very large databases (VLDB) and highly transactional servers and production support in SQL Server environments.
• Experience in different types of backups, restoration of the database and also using SQL Server agent to schedule jobs and Maintenance Plans and set Database Mail settings for notifications or alerts.
• Extensive experience in implementing High availability solutions like Replication (Snapshot, Transactional and Merge), Log shipping, clustering and mirroring on physical and virtual machines.
• Experience in conducting Performance Tuning, Query Optimization and Client/Server Connectivity, Database health Check, Indexing and Updating Statistics.
• Experience working with ETL Tools such as creating and migrating SSIS/SSRS packages from 2008 instances to 2012 instances.
• Extensively used the native tools like Index Tuning Wizard or Database Engine Tuning advisor, SQL Profiler, Performance Monitor, Activity Monitor, Event viewer for performance analysis and fix any performance related issues, ensuring optimum performance.
• Expertise in installing, configuring, planning, testing MS SQL Server 2016, 2014, 2012, 2008R2, 2008,2005 and associated database tools, updating with latest service packs, hot fixes and security patches.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing and Reporting Services (SSRS).
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

TECHNICAL SKILLS:

Technologies Frameworks: HTML, CSS, JavaScript, ASP.NET, Agile Methodology

Databases: MS SQL Server 2014/2012/2008/2005/2000

Languages: SQL, C#, Java(Basics)

MS Office Tools MS - Word: MS-Word, MS-Excel, Power Point, MS Access, VISIO, MS-Publisher, MS-Outlook.

Operating System: Windows, Linux

SQL Server Tools: SQL Server Data Tools BI, BIDS, Extended events, SQL Server Profiler, Visual Studio 2010/2012, DTS, Replication and Always ON

Tools Used: Redgate, Idera/SQLSafe, Lite Speed, SCOM, ServiceNow, JIRA, Remedy Ticketing System.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, California

Senior sql DBA

Roles and Responsibilities:

• Served as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management.
• Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance multiple SQL server environments.
• Interface with source data from MSSQL, MySQL, Oracle, Access, and SQL Server DB's into SQL Server 2008 R2.
• Design and implement SQL Server code changes to support new business needs.
• Performed CapacityPlanning, Data Modeling and Logical/Physicaldatabasedesign.
• Designed and implemented backup plans as per the data- retention policy outlined in the Business Requirement Document.
• Created and Manage Automation of Maintenance jobs and proactively monitoring the system health of servers.
• Verifying Index Fragmentation and performing re-org and rebuild as per %
• Develop and review SQL scripts, stored procedures to automate daily task and make sure scripts provide the standard needs.
• Installed and configure SQL server 2005/2008/2008 R2/2012/2014 on standalone machine as well as on Cluster environment.
• Designed and built database maintenance routines, including backups, integrity checks, and index maintenance.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
• Worked on mirroring for synchronization of databases for SQL Server High Availability.
• Troubleshoot database status, performance, Replication, Log-shipping, Always On Availability as well as various errors on production, development and UAT servers.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers& maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Used Remedy ticketing tool in Resolving database related incidents and requests, resolving incidents within defined SLA's and respond to database related alerts escalations.
• Working experience on Windows and Cloud SQL Server Azure
• Experience in RDBMS database creation, performance tuning, optimization, backup and recovery in SQL Server 2008/2008R2, SQL Server 2012, SQL Server 2014
• Administering, Managing, Developing and configuring SQL Server database design, upgrades, migration, capacity planning, performance tuning, backup and recovery and managing clusters of SQL servers
• Created Logins and Users as per client's policy and requirements and assigned roles as needed according to the project plan.
• Experience with Indexes, index management, integrity checks, configuration, and SQL Server patching.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Performance Data Collector and Transparent Data Encryption (TDE).
• Provided 24x7 production supports for SQL Server databases on Clustered Servers to achieve maximum performance and uptime in production environment.
• Created and managed databases, schema objects such as tables, views, indexes, procedures, triggers and database constraints to meet business requirements and policies and maintained referential integrity.
• SQL server patching and database integrity checks.
• Experience in implementing the new features of MS SQL Server 2008R2/2008 such as Policy Based Management, Backup Compression and Transparent Data Encryption (TDE).
• Create SQL Server logins, database users, assign permissions, move security between servers and implement data encryption.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Created Database Objects like tables, views, indexes, partition tables etc.
• Set up SQL Server configuration settings to resolve various resource allocation & memory issues for databases and setup ideal memory, min/max server options.
• Attended weekly and monthly meetings with other DBA, Project Manager, Development Team and Test Team regarding current project status, future projects, project deadline.
• Setting up High availability DR solutions over Azure, SQL Server Patching on 2005, 2008, 2008R2, 2012, 2014.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Expertise in creating databases, users, tables, macros, views, stored procedures, functions, joins and hash indexes in Teradata database.
• Set up backup and recovery plans, also had a proper documentation platform making sure data is secured at all levels.
• Participated in Disaster prevention and Recovery Strategies and supported High availability features like Snapshot Replication, Clustering (Active/Passive) .

Confidential, Woonsocket, RI

Senior sql DBA

Roles and Responsibilities:

• A 24/7 production SQL Server DBA responsible for all production, development and QA SQL servers, both clustered and stand alone.
• Involved in Data center migration.
• Experienced in configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.
• Verifying Index Fragmentation and performing re-org and rebuild as per %
• Expert in System Analysis and Design, Development, Support MS SQL Servers ( ) in Production, Development and Testing in Clustered and Standalone Server Environment.
• Expert in installing MS SQL SERVER 2016, 2014, 2012, 2008r2, 2008, 2005, 2000 updating with the hot fix and service packs.
• Standardize processes within the data department including creating documentations for installations, migrations, upgrades, backups, restores, index maintenance.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Responsible for Query optimization and Performance tuning.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle and Teradata. Created and configured OLAP cubes using SQL Server 2008 analysis services
• Schedule jobs to automate different tasks such as monitoring database health, disk space, job alerts, index monitoring, stats monitoring
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers& maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Migrated databases from SQL Server 2008R2 to 2012
• Installed, configured and maintaining SQL databases on Windows cluster.
• Ensure disaster recovery and business continuity for all database related infrastructure components.
• Performed database tuning and performance monitoring, performed general technical troubleshooting and give consultation to development teams.
• Scheduled Full, Differential and Transactional log backups for the user created and system databases in the production environment using Quest Lite Speed tool.
• Used Quest Lite speed to implement Log shipping at the remote site for production databases.
• Reorg/Rebuilding the indexes at regular intervals for better performance
• Designed and implemented partition scheme and sliding window job
• Created transactional Replication, configuration and monitoring the replication between two sites, generated scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
• Identify deadlock, blocking scenarios and Perform Reindexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Setting up and configuring Database Mirroring in SQL Server 2012.
• Used Encryption for Security of SQL Scripts for protection against unauthorized access of various codes like stored procedures, views and user defined functions.
• Developed SSIS packages to load data from heterogeneous databases.
• Troubleshooting SSIS packages and SSRS reports issues
• Monitored the use of disk space usage, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Interact with All teams like Business Analyst, Development Team, Testing team, Configuration Management Team and Project Management.

Confidential, San Francisco, California

Sql server DBA

Roles and Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Maintaining jobs for data messaging from development server to test server for generating daily reports.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• Verifying Index Fragmentation and performing re-org and rebuild as per %
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages.
• Constructed OLTP and OLAP Databases.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Confidential

Sql server DBA

Roles and Responsibilities:

• As a member of Database team, extensively worked on Database Administration activities.
• Migrated multiple financially significant applications from SQL Server 2000 to SQL Server 2005.
• Involved in Database Administration activities like Installation, Configuration, Backup, Security, Replication, and Data Migrations across all the servers.
• Created Logins, Roles, Schemas and other Security related activities for various groups accessing the systems.
• Created all the required Databases and objects like Tables, Indexes, and Constraints and maintain source control versions.
• Implemented Full, Bulk-Logged and Simple recovery models according to requirements.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Responsible for monitoring and making recommendations for performance improvement in databases by proactively involving in index (Defrag, Rebuild, Alter), DBCC maintenance jobs, file group modifications.
• Involved in writing various DB Objects like User defined functions, instead of triggers, Usage of Indexes for accomplishing various tasks.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Used SQL Server Profiler to determine deadlocks and identify possible causes.
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis.
• Involved in Table partitioning to improve I/O access.
• Created technical specifications, test plans and test data to support ETL processes.
• Created stored procedures to use as the datasets for the Report Design.

Confidential, New Jersey

Sql server DBA

Roles and Responsibilities:

• A 24/7 production SQL Server DBA responsible for all production, development and QA SQL servers, both clustered and stand alone.
• Involved in Data center migration.
• Migrated databases from SQL Server 2008R2 to 2012
• Installed, configured and maintaining SQL databases on Windows cluster.
• Ensure disaster recovery and business continuity for all database related infrastructure components.
• Performed database tuning and performance monitoring, performed general technical troubleshooting and give consultation to development teams.
• Scheduled Full, Differential and Transactional log backups for the user created and system databases in the production environment using Quest Lite Speed tool.
• Used Quest Lite speed to implement Log shipping at the remote site for production databases.
• Created transactional Replication, configuration and monitoring the replication between two sites, generated scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
• Identify deadlock, blocking scenarios and Perform Reindexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Setting up and configuring Database Mirroring in SQL Server 2012.
• Used Encryption for Security of SQL Scripts for protection against unauthorized access of various codes like stored procedures, views and user defined functions.
• Developed SSIS packages to load data from heterogeneous databases.
• Troubleshooting SSIS packages and SSRS reports issues
• Monitored the use of disk space usage, memory and connections.
• Installed and configured Quest Performance Analysis to monitor the SQL servers.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Involved in developing a number of Stored procedures, UDF's, Triggers and Views using SQL Server 2012
• Creation and monitoring of all SQL tasks (DTS packages) and scheduled daily jobs using Agent Scheduler both through Enterprise Manager and code in Visual Basic. Includes implementation of necessary batch processes for periodic updates.
• Provide support to application Users and Developers.

Confidential, Ohio

Sql server DBA

Roles and Responsibilities:

• Experience on backup, configuring, Managing and Monitoring of all SQL servers
• Automation of SQL Server activities including scheduled and maintained routine Jobs,
• Alerts and Maintenance Plans.
• Monitoring sql server jobs like backup, database space, log space etc.
• Strong Experience in Backup, Recovery strategy and Database Refreshes
• Experience in Database administration activities for DB security (creating users, logins and assigning permissions to them)
• Good experience on database migration.
• Experience in finding Root cause for all type of incidents to fix the issue permanently
• Have experience in finding and clearing blockings
• Having hands on experience in Database Mirroring and ensuring high availability to the
• Database by testing the failover.
• Good exposure in configuring and troubleshooting Log shipping and Replication
• Have good working knowledge on ALWAYS ON
• Extensively involved in Performance tuning.
• Good experience in using DBCC, DMV's and Extended Stored procedures.
• Have experience in upgrading SQL Server 2005 to SQL Server 2008/2008 R2/2012
• Have good experience in applying Service Packs and Hot fixes on SQL Servers.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• In-depth understanding of security and backup procedures to ensure database integrity.
• Speaking with clients/application & development teams regarding issues and keeping track of the issue till resolution.
• Create and Configure SQL Server 2012 as Always On servers, Maintaining High Availability, DR.