SUMMARY:

• Specialized in SQL Server 2005 / 2008 / 2008 R2 and SQL Server 2012 having 10 years of software life cycle experience with Database Administration.
• 1.3+ years of experience in financial services industry dis includes one year as a market research analyst.
• Experience in Installing, patching, maintaining sound backup policies, procedures and routine operational monitoring activities to ensure a stable database environment capable of meeting ongoing business needs.
• Good exposure on ITIL process (Service Requests, change management, incident management and problem management)
• Possess skills to handle alone or work in a team also, possess Excellent problem solving and Communication Skills
• Experience in high availability SQL Server solutions, including Log shipping, Mirroring
• Experience in resolving MSI & MSP Files missing issues.
• Experience in Always On Configuration Type 1 and Type 2
• Experience on Cluster Installation and Up gradation (active\passive & active\active)
• Experience in Creating Jobs and Sending Alerts using DB Mail.
• Experience in high availability SQL Server solutions including Transactional replication (Push & Pull Subscriptions).
• Performed DBA activities including database backups, restores, attaching and detaching databases, shrinking databases etc.
• Implementing Disaster Recovery by means of various backup and Restore strategies according to the situation and requirement of client
• Taking all types of Backup (Full, Differential and T - Log) and restoration.
• Managing the Disk Space and Memory management and maintaining the daily checkup of Systems.
• Experience in implementing Log shipping, and Replication.
• Involved in Security like giving privileges to the users and creating logins.
• Extensively involved in Performance and tuning.
• Good Knowledge in DBCC, Stored procedures and T-SQL Statements.
• Involved in updating the patches to SQL Server like installing the Hot fixes and service packs etc.,
• SSIS packages deployment and re-deployment
• Report services configuration (SSRS) and installation.
• IIS certificate export and import and deployment.
• Implementation of Maintenance Plans and Shrinking for Database Consistency and Integrity.
• Involved in Upgrading and migration from lower version to higher versions (2000 to 2012 and 2005 to 2012

TECHNICAL SKILLS

Operating System: Windows Server 2003, 2008 & 2012

Databases: Microsoft SQL SERVER 2005/2008/2008 R2and 2012

Performance Tools: SQL Profiler/Perfmon, SCOM, Activity Monitor (system central Operations manager):

3rd Party Tools: Lite Speed, Red Gate

Ticket Tools: TFS 2008, HPSM and BMC Remedy

Process: Good exposure on ITIL process (Service Requests, change management, incident management and problem management)

Remote Access Softwares: Terminal Services, Remote Desktop, Remote- Admin, Tight VNC Server and Team Viewer.

PROFESSIONAL EXPERIENCE

Confidential, Maine

Environment: Windows Server 2008, 2012

SQL server Database administrator

Responsibilities:

• Involved as L3 Support, Experience in installing, managing and troubleshooting SQL Server 2012, 2008R2, 2008. Configured ALWAYS ON setup between different Datacenters and on Multi Subnet Cluster. Configuring and Managing Log Shipping and Database Mirroring.
• Creating Jobs and Schedule them for execution on Daily, Weekly, and Monthly bases. Checking the SQL Error logs for any errors that may have occurred overnight
• Checking available physical Disk space, Log Space, jobs for failed completion, backups and log sizes, Monitoring performance with PERFMON COUNTERS
• Implemented DMV and dynamic management functions for finding out long running queries. Extensively worked on DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters
• Checking for outstanding active or blocked transactions. (stored procedure) Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements Expert in implementing the snapshot isolation and DDL triggers
• Migrated SQL server 2008 R2 to SQL Server 2012 and SQL SERVER 2008 R2 to 2012
• Installed patching and administered 2-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment
• Extensively worked on SQL Server Integration Services (SSIS)
• Rebuilding/Reorganizing the indexes at regular intervals for better performance.
• Experience in using SQL Server Profiler, SQL Server Agent. Experience in query optimization & performance tuning. Used execution Plan, DBCC Commands, Profilers and WAIT TYPES
• Periodically checking the health of the server and providing recommendations.

Confidential, Wilkes-Barre,PA

Environment: Windows Server 2003, 2008, 2012

Database administrator

Roles & Responsibilities:

• Involved in L2 as well as L3 Support
• Installation of SQL Server 2008, 2008 R2 & SQL2012 on Standalone Servers
• Installation of SQL Server 2008 R2 & SQL2012 on Cluster nodes.
• Applying Service packs and Patches on standalone servers & cluster nodes
• Resolving the issues related to installations and up gradations
• Worked on Test, Dev., and pre-prod and production servers.
• Configuration of Log shipping and maintaining the log shipping.
• Configuration of Mirroring (Synchronous & Asynchronous)
• Configuration of Transactional replication (Push & Pull Subscriptions)
• Monitor SQL Servers using SCOM 2012 monitoring tool.
• Up gradation of SQL Server 2008, SQL Server 2008 R2 to SQL Server 2012
• Migration of SQL Server from physical servers to Virtual servers and Vice versa
• Configuration of Always-on on Type 1 and Type 2
• Creation of Jobs and Sending Alerts using Database Mail.
• Implementation of Maintenance Plans and Shrinking for Database Consistency and Integrity.
• Creation of Logins, users and groups with appropriate roles.
• Developing Successful Backup Strategies based on recovery model.
• Recovery of Database at the time of Database crashes.

Confidential, Dallas, TX

SQL Server

Environment: Windows Server 2003, 2008, 2012

Roles & Responsibilities:

• Involved in L2 Support
• Backup/Restore planning and Capacity Planning.
• Solution implementation.
• Troubleshooting.
• Up gradation of SQL Server 2008, SQL Server 2008 R2 to SQL Server 2012
• Migration of SQL Server from physical servers to Virtual servers and Vice versa
• Configuration of Always-on on Type 1 and Type 2
• Creation of Jobs and Sending Alerts using Database Mail.
• Implementation of Maintenance Plans and Shrinking for Database Consistency and Integrity.
• Creation of Logins, users and groups with appropriate roles.
• Developing Successful Backup Strategies based on recovery
• Monitor the performance of the SQL Servers and queries using DMVs.
• Manage assigned support tickets to insure timely escalation and resolution of issues and provide required status to customer. Take ownership of assigned support issues, including “misdirected issues” when reported by the customer.
• Provide all levels of email/phone technical support for Change Management
• Work directly with MSIT customers, partners, and sales technical staff to provide technical support services.

Confidential

Environment: Windows Server 2003, 2008, 2012

System Engineer (SQL DBA)

Roles & Responsibilities:

• Involved in L2 Support and Change Management
• Installation of SQL Server 2008 R2 & SQL2012 on Standalone Servers
• Installation of SQL Server 2008 R2 & SQL2012 on Cluster nodes as a standalone installation.
• Installation of SQL Server 2008 R2 & SQL2012 clusters
• Applying Service packs and Patches on standalone servers & cluster nodes
• Resolving the issues related to installations and up gradations
• Worked on Test, Dev., and pre-prod and production servers.
• Configuration of Log shipping
• Configuration of Mirroring (Synchronous & Asynchronous)
• Configuration of Transactional replication (Push & Pull Subscriptions)
• Up gradation of SQL Server 2008, SQL Server 2008 R2 to SQL Server 2012
• Migration of SQL Server from physical servers to Virtual servers and Vice versa
• Configuration of Always-on on Type 1 and Type 2
• Creation of Jobs and Sending Alerts using Database Mail.
• Implementation of Maintenance Plans and Shrinking for Database Consistency and Integrity.
• Developing Successful Backup Strategies based on recovery model.
• Recovery of Database at the time of Database crashes.
• Worked on MSI & MSP files issues which were raised at the time of SQL up gradation.
• Monitor the performance of the SQL Servers and queries using DMVs.
• Manage assigned support tickets to insure timely escalation and resolution of issues and provide required status to customer. Take ownership of assigned support issues, including “misdirected issues” when reported by the customer.
• Provide all levels of email/phone technical support for Change Management
• Work directly with MSIT customers, partners, and sales technical staff to provide technical support services.

Confidential

Environment: Windows Server 2008

SQL Server DBA

Responsibilities:

• Installing and Configuring SQL Server, including service pack deployments.
• Checking the health of the servers and the databases.
• Check OS Event Logs and SQL Server Logs for unusual events.
• Regularly monitor and identify blocking issues.
• Monitor disk space to ensure you're SQL Servers won’t run out of disk space.
• Experience in implementing Log shipping, Mirroring and Replication.
• Requirement basis Failback/Failover of Clusters.
• Maintaining database backup strategies and recovery scenarios.
• Monitoring the Data file, log files & Database Backup & Recovery.
• Managing the space and monitoring the free space etc.
• Ensuring Data consistency in the database through DBCC commands.
• Creation of database maintenance plans, rebuilding indexes.
• Involved in Security giving privileges to the users and creating logins

Confidential

Environment: Windows Server 2008

Roles & Responsibilities:

• Was part of whole development
• Researching on different ways to make dis happen.
• Applying the latest service packs released by Microsoft.
• Monitoring the scheduled tasks and trouble shooting their failures.
• Performing regular maintenance tasks.
• Being proactive to avoid certain job failures and failures of the server that leads to business loss
• Performing daily applications and database health checks
• Checking the slow running stored procedures and taking corrective action in time.