SUMMARY:

• Assist requests from users & application developers, that they raise tickets, asking me to provide logins, permissions, do database refreshes, duplicate record deletion, release locks, backups and restore those are on demand from the user requests.
• Implemented and Maintaining HA through SQL Server Always on Availability Groups in SQL Server 2012
• Monitoring sync status on available replicas and troubleshooting.
• Setting up backups for the databases using SQL server agent and third party Backup tools and developing recovery procedures.
• Expertise in Performance Tuning, Index Tuning, Maintenance, Capacity planning, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Experience on Configured security and access as per SOX and PCI standards.
• SQL Server Installation, patch application, migration of data across different databases and different servers.
• Performed a successful DR Drill and played a crucial role in team in configuring and maintaining the environment.
• Extensive experience into troubleshoot and fix the root - cause of the CPU, Memory issues and blocking on a database/server.
• Experience in Monitoring Databases for Deadlock, capturing long running SQL queries, used HINTS for fine tuning SQL statements that better result in efficient SQL statements processing.
• Installing SQL Server 2016, 2014, 2012, 2008R2 on the servers for client testing environment, providing connections and managing databases.
• Experienced in using DMV and dynamic management functions for finding out long running queries.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Experienced in Data modeling and Database Design using DM tools like ER Studio, Erwin, Microsoft Visio and SQL Diagrams.
• Expert in automating the system by using SCOM and creating alerts, jobs and maintenance plans.
• Encrypted data and log files using transparent data encryption (TDE) solution.
• Very good expertise with Amazon Web Services (AWS).
• Experienced in Database development using T-SQL and PL/SQL in writing Stored Procedures, Functions, Indexes, Views and Triggers in SQL Server and Oracle.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Creation of new databases, planning the location of data and Transaction log files on disks.
• Providing support to the Application developers on the application databases, Administered and managed Service Now Experience.
• Strong individual contributor and a good team player with proven ability and excellent verbal and written communication skills to interact with clients and peers.
• Very good Knowledge and experience of PostgreSQL, Mongo DB and Cassandra NoSQL database operations.
• Working knowledge of .Net Framework 3.5/4 (VB.NET and C#.NET), IIS Web Server, Agile Methodology.
• Handled 24/7 Production and DR database Issues on call support.

TECHNICAL SKILLS:

Operating Systems: Windows 2012, 2008, 2003, 2000, XP, NT, Linux, Unix.

Databases: MS SQL Server 2016/2014/2012/ 2008 R2/2005/2000, Sybase, Oracle, MYSQL, TeraData, PostgreSQL, DB2.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, SCOM, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, DTS, SQL Server Management Studio, SCM, SAC.

Data Modeling Tools: Erwin, Red gate, SQL Lite speed, Fog lite, Redshift, Backup Utility, MS Visio, Veritas NetBackup, NetApp, Azure, AWS, Service Now.

Languages: T-SQL, C/C++, Shell Script, PERL, java script, XML, HTML, Python.

Network Topologies: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential,Chula Vista,CA

Senior MS SQL Server DBA

• Installed, managed and administrated the MSSQLSERVER 2008R2/2012 production and development servers.
• Involved in design and build of multi-subnet Always On clusters on SQL Server 2012.
• Automated regular DBA activities with the help of PowerShell.
• Involved in implementation of SQL Server Security (TDE, Backup Encryption).
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them and implemented the security Policies as per PCI and SOX compliances.
• By using 3rd party SQL Management Tools like Quest Spot Lite and Red gate tools monitoring the process, maximum optimization, diagnosis resource utilization like disk space used in percentage, IO/CPU bottlenecks.
• Created and scheduled a SSIS package for missing indexes, blocking and index fragmentation reports and configured database mail to deliver these reports.
• Attend meeting with business units and other support team like server engineers, network engineers, application support team and developer for project related solution and production support needs.
• Provided support to SharePoint servers, MySQL, PostgreSQL databases.

Environment: MS SQL Server 2012/2008 R2/2008/2005, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, .Net Framework.

Confidential,OMAHA,NE

Senior MS SQL Server DBA

• Involved in SQL Server migration from 2000 to 2005 and 2005 to 2008.
• Performed migration of SQL Server production servers from one data center to another data center.
• Reduced run time of critical SQL Server jobs with the help of fine tuning of queries and indexes.
• Provided technical support to offshore DBAs.
• Encrypting and Decrypting Databases using Transparent Data Encryption (TDE).
• Performed archival and purging of data without impacting performance of production server.
• Created triggers stored procedures, databases, tables and queries.
• Implemented backup and retention strategies based on business policies.
• Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts and granting the privileges to users and groups.

Environment: SQL Server 2005/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, Microsoft Windows2003/2008R2 Server.

Confidential,Dallas,TX

Sr. SQL Server DBA

• Involved in Planning for Upgrades and Migration of major systems from SQL Server 2005 to SQL Server 2008 R2 and from SQL Server 2008 R2 to SQL 2012/2014.
• Created SSIS packages for various Data Source and Data Destination Mappings for transfer.
• Working for a Healthcare company and we are a HIPAA Complaint we need to encrypt databases using Transparent Data Encryption (TDE).
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Performance tuning and optimization of procedures and queries.
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks. Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers& maintaining Referential Integrity depending on user requirements and converting them into technical specifications.

Environment: SQL Server 2014/2012/2008 R2/2005/2000, VMware, Virtualization, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, Lite Speed Backup, IDERA Diagnostic Manager

Confidential,Nebraska

MS SQL Server DBA

• Involved in installation and troubleshooting of SQL Server on Windows cluster.
• Created and managed database users, login Ids and security.
• Involved in configuration and troubleshooting of Replication, Mirroring and Log shipping.
• Perfumed migration of transaction replication distributor from one server to another server.
• Performed Isolation level changes and Fixed database corruption issues using DBCC utilities.
• Provided DBA support to application teams for releases on UAT and Production environments.
• Scheduled SQL Agent jobs for full, Differential and Transaction log backups and suggested backup strategies.
• Involved in installing Service Packs, patches and hotfix for SQL Server.

Environment: MS SQL Server 2012, 2008, 2005, SSIS, SYBASE Server, SSMA tool, BCP command. Microsoft Windows2003/2008R2 Server.

Confidential,Baltimore,MD

SQL Server DBA

• Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.
• Installed, configured and managed MS SQL 2008 and 2012 fail over Clustering for production servers on 64 bit platforms to provide high availability.
• Expert in performing multiple SSIS packages migration from SQL server 2005 to SQL server 2008R2.
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Extensively used Remedy Ticketing and CAMS (internal application) for change requests.
• Created Linked Servers between SQL server 2008/2012 and Oracle servers in the environment
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Running DBCC consistency checks, and fixing data corruption in user databases.

Environment: SQL Server 2008/2012, Windows Enterprise Server 2008/2012, SSIS, SSRS, SSMS, Microsoft Visio 2003, IIS Web Server, SharePoint, SAN, Query Analyzer, SQL-Profiler, Fog light, Oracle.

Confidential

SQL Server DBA

• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Migrated SQL server 2005 DTS to SQL Server 2008 and above into SSIS packages incoordination
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Helped the developers in writing Stored Procedures & Functions & Triggers.

Environment: MS SQL Server 2008R2, SQL Server 2005, Windows 2008 Server & Windows 2003 Server, Performance Monitor.

Confidential

SQL Server Developer

• Create and implemented stored procedures to perform database maintenance tasks like index rebuilding & reorganizing to take care of internal and external fragmentation.
• Used Execution Plan, SQL Server Profiler and Database Engine Tuning Advisor tools to trace the slow running stored procedures and tried to optimize the queries to improve performance.
• Create various types of triggers to keep track of DDL events at server and Database level on OLTP server.
• Created, maintained, optimized database objects such as tables, views, stored procedures, user defined functions, Triggers.
• Create tables, views, stored procedures, functions, CTEs and indexes in support of various databases and ETL applications.
• Apply different types of constraints to support table and column level integrity.

Environment: SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and site scope.