OBJECTIVES

An enthusiastic IT professional very much committed to maintaining and acquiring cutting edge technical skills and up - to-date industry knowledge. Deadline-focused with broad skill range including, 24/7 database Support of MS SQL Server in Production, Test, Development and managing cluster Server Environments. Work well independently or in a group. Deep knowledge in installation, upgrade, high availability, disaster recovery solutions, performance tuning, backup and recovery. Dedicated to providing the upmost quality and support to the client.

PROFESSIONAL SUMMARY

• 5+ years of experience in Database Administration for very large and complex databases in SQL Server 2014, SQL Server2012, SQL Server 2008 R2, 2008 and 2005.
• Experienced in Always-On Availability Groups (AAG) configuration and managing.
• Expertise in database administration on production servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis, write effective documentation and specifications.
• Experience in T-SQL and writing stored procedures.
• Administering SQL server high availability and disaster recovery strategies.
• Implemented data transformation services using SSIS to different platforms.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Worked extensively on clustering and server consolidation. troubleshooting production issues and raising high availability.
• Proficiency and expertise in SQL server replication, backup/recovery, disaster recovery including log shipping and Database Mirroring.
• Worked on configuring SQL server with minimum privileged access.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2014 migration from SQL Server 2012/ 2008 / 2005.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Configured and managed Windows Failover Clustering (WFS).
• Experience in supporting Very Large databases (VLDB) and troubleshooting.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

SKILLS:

Databases: MS SQL Server 2014, 2012, 2008, MS SQL Server 2005

Programming: T-SQL, JAVA

DBA: Database administration of MS SQL Server 2014, 2012,2008, 2005

Operating System: Windows 2012/ 2008/2003 Advanced Server, Windows7,Windows 8.1, windows10

Other Software: SCCM, SCOM, Microsoft Exchange

Tools: Backup Utility, SQL-sentry, Redgate, Remedy.

EXPERIENCES: 

SQL Server Database Administrator

Confidential, Richmond, VA

• Installed, configured, and managed SQL server 2014/ 2012 and migrated databases from SQL server 2008R2/2005.
• Configured and maintained windows failover cluster with SQL server 2012 R2.Configured and administered always on availability group.
• Configured and maintained snapshot, peer-to-peer replication and troubleshoot replication issues.
• Configured SQL Server Backup/Recovery, disaster recovery and planning.
• Managed and worked on security, permission of SQL server and data encryption.
• Managed index usage and fragmentation and updated statistics in databases.
• Involved in troubleshooting, fine-tuning database performance, concurrency and root cause analysis.
• Worked on query optimization and tuning using SQL server profiler, database engine tuning advisor, and activity monitor and analyzing execution plan.
• Checked database health by using DBCC commands and DMVS.
• Created SSIS package and jobs to run on schedule time.
• Deployed SSRS reports to the production environment.
• Supported end users through remedy ticketing system.
• Applied SQL server software patching and day to day management.
• Provided 24/7 on call support for all the production servers.

SQL Server Database Administrator

Confidential, Research Triangle Park, NC

• Installation and administration of SQL server 2012R2/2008/2008R2.
• Implemented procedure documents in place to ensure smooth day to day administration of databases.
• User management and database security imposition by creation and granting of roles and privileges.
• Create logins and granting privileges as per requirement.
• Implement DBA maintenance tasks for increase the database performance with the help of re-indexing, re-organize index, and update statistics.
• SQL server jobs scheduling, creating alerts, operators and troubleshoot the Job failures.
• Addressing user requests which comes in the form of e-mails (tickets).
• Configured and managed mirroring as a high availability solution.
• Implemented log-shipping as disaster recovery solution.
• Implementation of backup strategy.
• Creating and maintaining database maintenance plans.
• Checking of logs, windows system monitor alerts.
• Developed, implemented, configured and maintained operational procedures and programs including disaster recovery and system security.
• Created view, schemas and basic stored procedure.
• Provide 24*7 on call support as per the scheduled routines.

SQL Server Database Administrator

Confidential, Atlanta, GA

• Performing database installations, upgrades and configurations.
• Applying patches as needed for security and bug fixes.
• Monitoring databases and troubleshooting SQL server performance issues using SQL server profiler, trace, DTA and index tuning wizard
• Performing Database integrity checks using DBCC utilities
• Maintenance planning using scripts and configuration wizard
• Scheduling SQL server jobs to monitor disk space, CPU activity and index fragmentation
• Planning, automating and implementing database backup and recovery
• Hands on experience in DR planning processes including replication, log shipping and database mirroring
• Installed, configured and maintained fail-over cluster servers in SQL server 2005 & 2008
• Creating and managing users, roles, security at object level and data encryption
• Provide 24*7 on call support as per the scheduled routines