SUMMARY:

• 5 years of experience in SQL Server DBA including SQL Server 2008, 2008 R2 and 2012.
• Experience in using and administering of SSIS package and modify content as required
• Experience in set up log shipping, Mirroring for Production database and troubleshoot issues
• Experience in upgrade and data center migration of SQL Server instance and databases.
• Knowledge of setting up active passive cluster in SQL 2008 R2 environment.
• Creating reports for users using SSRS
• Knowledge of AWS and Azure cloud services.
• Experience writing T - SQL query and Knowledge of logical and physical Database design.
• Set up security for logins and users and provide access accordingly with minimal privilege as possible.
• Working knowledge of Windows Server Administration, Active Directory, Network and SAN.
• Effective communication skills with all levels of management, both internal and external.
• Worked in a team environment. Perform all allocated tasks accurately and in a timely manner.

TECHNICAL SKILLS

• Knowledge of setting up active passive cluster in SQL 2008 R2 environment.
• Creating reports for users using SSRS
• Knowledge of AWS and Azure cloud services.
• Experience writing T - SQL query and Knowledge of logical and physical Database design.
• Set up security for logins and users and provide access accordingly with minimal privilege as possible.
• Working knowledge of Windows Server Administration, Active Directory, Network and SAN.
• Effective communication skills with all levels of management, both internal and external.
• Worked in a team environment. Perform all allocated tasks accurately and in a timely manner.

PRFESSIONAL EXPERIENCE:

SQL Server DBA

Responsibilities:

• Worked as production support DBA for SQL Server 2008, 2008 R2 and 2012 of up to 8 TB size database both OLTP and Data Warehouse. Performed installation, configuration, and applied hot fix and service pack.
• Develop maintenance plan for backup (SQL Native Tool and Red Gate), Index Rebuild and cleanup task for several databases. Creating backup policy according to business needs.
• Manage database backup procedures for mission critical production databases and restore in different environment as requested
• Monitoring and Troubleshooting real time production issues, database security issues, space issues, connectivity issues, integrity issues, blocking and deadlocking issues, CPU, memory I/O and disk issue.
• Applied DDL and DML from QA to production (Objects like tables, procs, functions, scripts, jobs, SSIS package, parser, and XML etc.) and validate them and corrected issue Using SQL data compare.
• Configured Database Mail, Setup Alert, Created Linked Server.
• Deployed SSIS packages on production server. Debugged and trouble shoot SSIS job related issue.
• Performed performance tuning using query plan and database engine tuning advisor to analyze workload and implemented recommendation for optimal set of indexes
• Setup Snapshot Replication from Production to staging environment
• Setup Mirroring and Log Shipping for production Databases in SQL Server 2008 R2.
• Implemented and executed successful disaster recovery test for multiple databases to ensure Redundancy of databases.
• Setup user permissions. Assist with Monthly PCI security audits.
• Provide user training and support to other teams related to SQL server
• Installation of SQL instances on new QA/UAT/PROD servers
• Support file processing teams with issues Like file failure and missing files
• Review and maintain DBA team process documentations
• Participated on 24 X 7 on call support. Familiar with change management process

SQL Server DBA

Responsibilities:

• Installed configured and maintained SQL Server 2005 and 2008 for managing databases up to 2TB of size for both OLAP and OLTP in production environment. Upgraded from SQL Server 2005 to SQL Server 2008.
• Created backup policy according to business needs and applied hot fix and service pack.
• Created user logins in server and user groups and roles in databases
• Developed maintenance plan for backup and Index Rebuild and cleanup task for several databases.
• Created/altered/modified and tuned T-SQL stored procedures, queries, views, tables, and functions on OLAP environments like data warehouse and reporting. 
• Analyzed SQL Servers and databases and came up with a plan for consolidation based on usage, performance, and compatibility. 
• Implemented and maintained routine DBA tasks like scheduling jobs, creating maintenance plans and checked servers for optimizations and implemented them. 
• Performed daily tasks including backup and restore using SQL Server Management Studio
• Managed performance issues using native tools like SQL Server Activity Monitor, Database Tuning Advisor, and SQL Server Profiler.  
• Developed automated backup jobs and DBCC scripts for databases and transaction logs. 
• Monitoring for disk spaces, error logs and making recommendations for performance improvement. 
• Documented Trouble-shooting guide for various issues

SQL Server DBA

Responsibilities:

• Involved in administration, performance analysis, 24X7 production Support for Databases up to 3 TB. 
• Analyzed bottlenecks and performance issues with large datasets. 
• Coordinating and triaging work items with separate teams and production issues to get resolution on time. 
• Worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's). 
• Managed Security using SQL logins, roles and security for various users. 
• Worked on Profiler, PerfMon, and DTA to tune the databases, servers and query tuning. 
• Responsible for monitoring and troubleshooting SQL jobs, Scheduled Tasks, Disk spaces, error logs for databases which involved index creation, index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics. 
• Deployed database objects from development/testing environment to production environment. 
• Responsible for testing in DB for integrity of the DB using update and insert statement