SUMMARY:

• Over 8 years of IT experience in Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance and Performance Tuning, Backup/Restore and disaster recovery experience in SQL Server 2016/2014/2012/2008 R 2/2008/2005.
• Having hands on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors and functions to meet business requirements.
• Experience in implementing SQL Server Security and object permission like maintaining creation of users, configuring permissions database authentication modes and assigning roles of users.
• Expertise in implementing different types of high availability and disaster recovery mechanism like replication models, log shipping, database mirroring, always on and clustering.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing.
• Worked on Clustering and server consolidation, troubleshooting production issues and raising high availability.
• Proficient in SQL Server Replication, Always on, Backup/Recovery, Disaster recovery and Capacity planning.
• Worked on SQL Server 2012 migration from SQL Server .
• Sound knowledge on stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
• Expert in tuning database by choosing indexes and using tools Database engine tuning advisor, SQL Profiler.
• Expertness in trouble shooting database issues like space issues, deadlocks, performance and blocking.
• Experienced in SQL Server tools like Enterprise Manager and SQL Query Analyzer.
• Experienced in allocating system storage and planning future storage requirements for the database system.
• In - depth experience on Microsoft Azure.
• Experienced in Monitoring and optimizing the performance of the database.
• Dynamic problem solving ability, team player, detail-oriented, and quick learner. Strong analytical and interpersonal skills, strong work ethic and effective at meeting project objectives and deadlines in fast-paced environments.
• Installation, Upgrade, Configuration and Migration of My SQL Server in clustered and non-clustered production environments.

PROFESSIONAL EXPERIENCE:

Confidential, Houston,TX

SQL DBA

Responsibilities:

• Installation, Upgrade, Configuration and Migration of MSSQL Server in clustered and non clustered production environments.
• Setting up the Transactional Replication in between SQL Server databases.
• Modifying the database structure, as necessary, from information given by application developers.
• Planning for backup and recovery of database information.
• Planed and created, configured, managed AlwaysOn Availability Groups on sql server 2014 and sql 2016.
• Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer Database Engine Tuning Advisor.
• Created reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Worked on Integration services for the purpose of Transforming data from the cubes and storing it in to the data in to the SQL Server tables.
• Involved in SQL Server Reporting Services (2008 SSRS) maintenance.
• Created maintenance plans and jobs to achieve maximum performance.
• Expertise in Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Responsible for data migration from Excel, to Microsoft SQL as well as Extracting, Transforming and Loading of data using Microsoft SQL Server SSIS.
• Worked on SQL Server 2012 migration from SQL Server 2008.
• To ensure recoverability of the Data Warehouse with minimal loss of information which includes extensive testing of the backup and recovery processes and taking backups full and incremental as needed.
• Worked on installation, configuration, support, maintenance and backup of SQL Server databases and IIS Web Server.
• Administrated and implemented the new SQL Server 2012 mechanisms like data compressions, online indexing.
• Developed and documented backups, recovery strategies, disaster recovery mechanism and participated disaster recovery drills for various environments. Successfully implemented Log shipping for DR solutions.
• Proactively managed Microsoft SQL Server instances at the corporate office by developing Microsoft SQL scripts for creation and upgrade of databases, maintenance plans, user logins, automation of network and server monitoring with exception reporting via Database Mail notifications, and a SQL Server failover system.
• Worked on SQL Server 2016 migration from SQL Server 2014.
• Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.
• Involved in development of database including creating new databases, converting old databases to new databases, modification of existing databases, creating reports to meet business needs.
• Hand on experience in troubleshooting of all databases related issues.

Environment: SQL Server 2016,SQL Server 2014, SQL Server 2008, 2012 SQL, Server 2005 Enterprise

Confidential, Houston, TX.

SQL DBA

Responsibilities:

• Installation, Upgrade, Configuration and Migration of My SQL Server in clustered and non-clustered production environments.
• Performed backup using backup compression and Data compression in MSSQL Server 2008R2 on clustered environment.
• Involved in scheduling the reports to run on daily and weekly basis in Report Manager.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
• Worked with Capacity planning tools, checked CPU and memory utilization, disk contention, transactions per second etc.
• Administrated and managed the SQL Server 2012, 2008R2, 2005 production and Non-production servers.
• Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
• Migrated SQL Server 2005 databases to SQL Server 2008R2 databases including DTS to SSIS packages.
• Implemented high availability on the various servers using Replication, Log-Shipping and Mirroring.
• Implemented and tested the point in time recovery of the production databases.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources like SQL Server using SSIS.
• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Deployed and used Microsoft Azure on test and development scenarios.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created necessary templates for various requirements gathering and documentation.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored Log shipping and Transactional Replication and trouble shooting of errors.

Environment: Windows 2000/2003, SQL Server 2005 and 2008R2, Windows Enterprise Server 2003, SSRS Microsoft Reporting Services.

Confidential

Junior SQL DBA

Responsibilities:

• Responsible for data migration from Excel, Flat file, Sybase, Transforming and Loading of data using Microsoft SQL Server SSIS and DTS.
• Prepared, maintained and modified SQL server installation and configuration documents.
• Database Administrator, Database Programming.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Recovering the databases from backup in disasters.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Rebuilding the indexes at regular intervals for better performance.
• Involved with development team and developed functions, procedures and packages performed Logical Backups by Export and Import utilities.
• Handled numerous change management requests on production servers.
• Configured SQL Server settings using configuration manager.
• Worked on log shipping for synchronization of database.
• Involved in creating functions to provide custom functionality as per the requirements.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, T-SQL, Enterprise Manager, SQL Query Analyzer, SQL Profiler.