SUMMARY:

• Over 8+ years of Experience in SQL Server DBA, System Analysis, Development and Support of Microsoft SQL Server development, test and production environments. Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, credentials.
• Experience in installation, maintenance, and migration of different versions of SQL Servers in both OLTP and OLAP lower regions and Production environments.
• Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, using performance monitor/profiler for resolving deadlocks.
• Experience in working with VLDB databases up to 20TB, Managing Backups, Disk & Drive Space issues, managing indexes.
• Experience in Performance monitoring using Idera SQL Diagnostic Manager.
• Experience in using DMV and dynamic management functions (DMF) for finding out long running queries.
• Experience using Resource Governor and Policy Based Management system for maintenance.
• Experience in Day - to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning as well as researching, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands, Database Engine Tuning Advisor.
• Experience in Windows PowerShell Scripting and also in Agile/Scrum Methodologies.
• Experience in Data Modeling, Star Schema, FACT and Dimensional tables and Operational Data Store.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in Clustered Servers to achieve maximum performance and uptime in production environment.
• Experience in Configuration, Implementation and Maintenance for Disaster Recovery Solutions Using Log Shipping, Failover Clustering, Database Mirroring & AlwaysOn Availability Groups in SQL Server.
• Working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
• Upgrading/Migrating SQL Server to higher versions, 2005, 2008, 2012, 2014, 2016 and applying service packs and cumulative fixes.
• Experience in Performance Tuning (System level/Database Level/Query Level) and optimization.
• Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption to secure data at rest and document the process.
• Experience in implementing AlwaysOn Clustering and Mirroring on physical and virtual machines.
• Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012.
• Monitoring SQL Server Error Logs, Disk Space growth, Clustering Environment.
• Working experience in SDLC in developing an application, with Installation, design architecture, data flow, Maintenance and Operations of a system.
• Thorough understanding of blocking/lock issues, TempDB Optimization, File group management.
• Conducted RCA for database incidents and problems.
• Taking backups using tools like Lite Speed.
• Excellent T-SQL skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions.
• Played a key role in business requirements analysis, physical and logical Data modeling, application developments, testing, training, production support and Project review with client.
• Thorough knowledge on SAN environments, RAID levels, VMware Environments.
• Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, Lite Speed, SQL sentry etc.
• Exposure to multiple database platforms like Oracle, MySQL and Mongo DB.
• Experience in working with huge databases, troubleshooting issues and documenting the causes.
• Versatile team player and a quick learner with strong written, oral and inter-personal communication skills.
• Possessing strong analytical skills, an excellent team player with good leadership qualities and strong oral and written communication skills.

TECHNICAL SKILLS:

Database Tools: SSMS, BIDS, DTA, SQL Profiler, DTS, DTSRUN, MS Visio, Import & Export (DTS), DTSX Change, SSRS, SSAS, SSIS, Erwin, Lite Speed, Crystal Reports 10.0, Share Point, SQL CMD

RDBMS: MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, SYBASE, MYSQL, Oracle

Web Tools: Internet information Server (IIS), FTP, TCP/IP, SMTP, LAN, MS-Outlook Express

Programming Languages: T-SQL. PL/SQL, Unix, C#, ASP.Net

Operating Systems: Windows Vista, UNIX

Utility Tool: MS Office, MS Project, Visual Source Safe 6.0 (SCOM), Visio 2007, Perfmon, Backup Utility

Virtualization: VMware VSphere Client

PROFESSIONAL EXPERIENCE:

Sr. SQL Server DBA

Confidential, Dallas, TX

Responsibilities:

• Principal responsibility is to troubleshoot and fine-tune out SQL environment.
• Supported SQL 2016/ 2014/2012/2008 /2005 databases in clustering environment (A/P & A/A) including database mirroring/Log shipping on critical large-scale databases.
• Analyzed long running slow queries and tune the same by creating appropriate indexes, removing duplicate code and creating calculated columns to optimize application and system performance.
• Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory, CPU and I/O issues.
• Maintained production and development databases in some non-stop heavy transactional and reporting environments.
• Migrated SQL upper versions like 2012 & 2014 by using side by side upgrade process.
• Deploying SSIS packages in production environment.
• Maintained the data, database backups and restoration, backup strategies, scheduled backups.
• Refreshed development, UAT, Training and Testing Databases with latest production Data upon testing team's request.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the project.
• Implemented and tested Database Backup to a Data duplexing device and confirm RPO and RTO to implement retention of backup and storage.
• Served as a part of DBA team which was involved in the maintenance of the SQL Server databases for the Production as well as the development environments.
• Implemented the New SQL Server mechanisms like data compressions, online indexing and Contained Databases.
• Implemented and maintained AlwaysOn Availability Group in SQL 2012/2014.
• Set up the Virtual machines through VMware software in development & Production Environment.
• Created Database Maintenance Plan for the better Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Developed partitioned views and tables for the purpose of security and fast upload.
• Installed SQL Server 2014/2012/2008 R2 on Windows Clustered and standalone environments with latest service packs. Configured and deployed SSRS reports.

Environment: SQL Server 2008/2008R 2/2012/2014/2016, Windows 2008, Windows 2008 R2, Oracle DB, VMware, Clustered, Active Directory, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Profiler, Tuning Advisor, SQL, PL/SQL.

Sr. SQL Server DBA

Confidential, Houston, TX

Responsibilities:

• Involved in migration from MS SQL Server 2012 and SQL Server 2014.
• Involved in documentation and implemented a disaster recovery system.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Experienced in Security Issues such as creation and granting permissions on various Objects. Assign permission to users, roles, and object.
• Analyzed long running slow queries and tuned the same to optimize applications and system performance and Performed DBCC Checks.
• Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), SQL Profiler and index Tuning Wizards.
• Rebuild Indexes and Tables as part of performance tuning exercise.
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Designed overall database, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T-SQL Statements.
• Experienced hands on with Bulk Insert, BCP and Database consistency check using DBCC commands.
• Worked closely with audit team to implement SOX-Audit on all SQL servers.
• Experienced in Data Migration using SSIS across different databases like Oracle, MS Access, Sybase, & Flat Flies.
• Monitored and generated report for the database infrastructure and these reports are submitted to management on regular basis.

Environment: SQL Server 2012/2014, Windows, SSRS, SSAS, SSIS, Commvault, Control-M, Idera monitoring tools. HPSM ticketing systems, SharePoint 2007 and 2010.

Sr. SQL Server DBA

Confidential, San Antonio, TX

Responsibilities:

• Installed and configured SQL Server 2008 R2/2012.
• Involved in Migrating SQL Server Databases from SQL Server 2008/2012 to 2012/2014.
• Experienced with performance turning, use of DMV's, analyzing Locks and Deadlocks, checking the threshold values and baselines.
• Experience in Deploying and Consolidating Remote Instances.
• Involved in DBCC checks, solving database issues with Index fragmentation, Data Integrity, index tuning, Update Statistics, Error and Event Handlings, Query Optimization.
• Configured AlwaysOn Availability Groups for Disaster Recovery.
• Configured and monitored of database Mirroring and Log Shipping for multiple databases on Geographically separated cluster environments to provide High Availability and Disaster Recovery.
• Performed daily routine DBA tasks such as deployments, incident tickets, handling user permissions and space issues on production servers.
• Installed Active-Active and Active-Passive SQL Server 2012/2008 failover cluster on Windows SQL Server 2008 R2 cluster virtual environment.
• Tuned the queries based on high CPU, Memory and Logical reads and writes, for performance improvement.
• Deployed SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Provided production support for 24x7 over weekends on rotation basis.

Environment: MS SQL Server 2014/2012/2008 R2/2008, Windows Server, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS).

SQL Server DBA

Confidential, Austin, TX

Responsibilities:

• Worked in the administration, security and support of all SQL servers and databases.
• Involved in redesigning and redefining data warehouse and provided necessary documentation.
• Configured and monitored regular database backups and disaster recovery plans.
• Installed and administered clustered and stand-alone SQL server 2008 and 2012.
• Automated SQL Server Administration tasks.
• Designed and implemented backup plans as per the data retention policy outlined in the BRD (Business Requirement Document).
• Supported the multi-tier production and development environments.
• Solved several issues which comes from ticketing system and responsible to close the tickets.
• Migrated SSIS packages from SQL Server 2008 to SSIS 2012.
• Provided 24x7 production supports to the clients and application groups.
• Created and maintained the SQL Agents jobs and configured them to send the alerts and email on failure to DBA group.
• Installed upgraded and applied the latest service packs/hot fixes.
• Provided High Availability through Clustering (Active/Active and Active/Passive), Mirroring, Replication (Transactional), and AlwaysOn.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing and Contained Databases.
• Checked Database Health by using DBCC Commands and DMVS.
• Rebuilt and monitored the indexes at regular intervals for better performance.
• Experienced in suing SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Reviewed, Optimized and deployed database scripts requested by Application Development Team through change request.

Environment: SQL Server 2008/2012, Windows 2008, Clustered, DB2, Active Directory, SSIS, SQL Loader.

SQL Server DBA

Confidential, Bloomfield, CT

Responsibilities:

• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Worked on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Reviewed developer SQL code to ensure adherence to client standards and general best coding practices.
• Worked on Compliance issues.
• Analyzed long running slow queries and tuned the same to optimize application and system performance.
• Monitored SQL Server performance using profiler to find performance and dead locks.
• Rebuilt the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies implemented.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Managed the clustering environment.
• Implemented the online indexing on 24x7 environments.
• Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
• Involved in DATA Analysis like Analyzing and Accessing collection of Data.
• Managed to set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Implemented all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• Performed installations & performance tuning, managed capacity planning & user accounts and implemented database security for multiple instances of development, certification, QA and production SQL Server databases.

Environment: SQL Server 2008R2/2008/2005 with clustering, Replication, MySQL, T-SQL, Windows 2003 64-bit, SQL/PLSQL, DTS, SSIS, Profiler.

SQL Server DBA

Confidential

Responsibilities:

• Worked on Client/Server tools like SQL Server Management Studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL Server 2000/2005 databases into SQL Server 2005/2008/2008 R2 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Monitored transactional replication, Database mirroring on production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled large size databases with clustered and standalone environment.
• Configured Transactional replication on migrated server.
• Worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Developed, deployed and monitored SSIS packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implemented SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created Database maintenance planner for the performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Experienced in Data modeling and metadata services.
• Monitored SQL Server performance using profiler to find performance and deadlocks.

Environment: T-SQL, MS SQL Server 2000/2005/2008 R2, SSRS, Query Analyzer, Visual Studio 2005, Window Server 2000/2003, IIS, SSAS