SUMMARY

• 10 years of experience in SQL Server Database Administration Support Services.
• Currently associated with Confidential, New York as a SQL DBA.
• Experience on different versions of SQL Server i.e. SQL Server 2000, 2005 and 2008 and 2008 R2,2012
• Experience in Migrating databases from SQL Server and 2008, 2008R2, 2012, 2014
• Operational knowledge on Oracle, Share point & TFS servers
• Experience in Azure (similar to AWS)
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, and Database Security.
• Experience in working with cloud database providers like AWS, Azure etc
• Experience in PowerShell & operational automation
• Good expertise in handling vulnerability remediation activities.
• Exposure in handling the entire production servers with skills and understanding client’s requirement.
• Good expertise in handling Suspect Modes.
• Having experiencing on SQL Server SSIS & SSRS & SSAS.
• Hands - on experience in High Availability options like. Log Shipping, Mirroring, Replication &Clustering. ALWAYS ON Group.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such asSQLServer Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in Migration fromSQLServer2000 toSQLServer (side by side), as well as DTS exchange tool for migrating DTS packages to SSIS packages.
• Developed, monitored and deployed SSIS packages Involved in implementing the Data ware houses.
• Developed complex stored procedures using T-SQL.
• Expertise in planning and implementingMSSQLserversecurity and database permissions
• Experience in implementing different types of Replication models like Snapshot, Merge and transactional
• Transformed data from oneserverto otherserversusing tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS), SSIS (SQLServerIntegration Services) and logshipping.
• Experience in Installing, Configuring and maintainingSQLServerActive Active and Active Passiveclusters.
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication inSQLServer2005,SQLServer2008 andSQLServer2008R2 in OLTP Environments.
• Experience in Performance Tuning, Query Optimization, ClientServerConnectivity, Database consistency checks using DBCC Utilities.
• Troubleshooting SQL Server Blocking and Deadlock issues. Using Performance Monitor Profiler to solve Dead Locks Long running queries .
• Expertise with Table Design, Index Design and Performance Tuning.
• Possess experience in translating new ideas into client’s solutions including opportunity identification, providing high availability solutions, delivery, support.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and Integrity of the company database.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and client service.

TECHNICAL SKILLS

Operating System: Windows 2000, 2003, 2008, 2012

Database: SQL Server 2000, 2005, 2008, 2008 R2, 2012 & 2014, Oracle

Tools: Ticketing, Monitoring, Backup Tool, AZURE, SERVICENOW, TIVOLI, LITE, SPEED, ORION.

PROFESSIONAL EXPERIENCE

Confidential, New York

SR SQL Database Administrator

Responsibilities:

• Maintaining of over 2000+ standalone\Cluster servers.
• SQL Server 2000, 2005, 2008, 2008 R2, 2012 and 2014 migrations, installations, configuration and security settings for standalone\Clustered servers.
• Configured ALWAYS ON setup between different Datacenters and on Multi Subnet Cluster.
• Installed and Worked on SQL Server 2012 failover clustering which is built on top of a Windows 2012 server cluster.
• Having good experience on building the SQL Server production and DR servers.
• SQL Server Cloud Migration to AWS, Microsoft Azure and Private Cloud
• Operational experience in PowerShell automation
• Windows Azure (Cloud Computing) in the Test Lab environment, build out new servers and setup clusters.
• Upgrade servers to most recent Windows Server 2012 in Data Centers valued at $1.2 million Dollars.
• Implement database administration/ maintenance plans with database backup and restorations.
• Having experience on database backup and restorations.
• Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication, Clustering, ALWAYS ON.
• Upgrade servers to most recent WindowsServer2012 in Data Centers
• Strong experience in monitoring and tuningSQLserver databases for optimum performance and assistance in capacity planning ofSQLserver database servers.
• SQL Server upgrade with service packs and hot fixes in Clustered and standalone environments.
• Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure with request of application team .
• Maintaining/Creating logins/users and giving permission to them as per request.
• Creating and Maintaining scheduled jobs and implementing automation for other tasks.
• Heavily involved in troubleshooting, resolving data integrity and performance monitoring issues.
• Having a good knowledge and minimal experience on PT Performance Tuning .
• Establishing availability baselines and set thresholds for monitoring and alerting.
• Handling blocking/locking issues and troubleshooting accordingly.
• Speaking with clients/application & development teams regarding issues and keeping track of the issue till it gets resolved.
• Working on file moment activities as per request with application teams.
• Creating snapshots as per requirement of Application teams.
• Having experience on resolving suspect databases issues .
• As per hardening measure, changing system/user databases default location
• Having experience on SSIS and SSRS.

Confidential

Sr. SQL Database Administrator

Environment: SQL Server 2000/2005/2008 on Win Server 2003/2008

Responsibilities:

• Maintaining of over 2800 standalone\Cluster servers.
• SQL Server 2000,2005 installations, configuration and security settings for stand alone servers.
• Working on Audit remediation activities in Confidential Database servers Approx. 2400.
• Managed a project to find servers which are not covered in any Security tools. I have created a process document for the auditing and also the process to remediate it.
• Supported vulnerability remediation activity by supporting system administrators and System engineers by providing direction and guidance and conducted regular meetings for the remediation activity.
• Involved in the planning and execution of upgrades to the Security Controls Management server and agent software.
• Managing Security, Permissions of Server Roles and Database Roles.
• Follow up with application team and scheduling meetings and revoking /granting appropriate permission as per application team confirmation .
• Having experience on database backup and restoration issues.
• Having experience on job failures & disk space issues .
• Having experience on file moment activities on standalone servers.
• Develop and implement database administration/ maintenance plans.
• Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication.
• SQL Server upgrade with service packs and hot fixes on standalone servers.
• Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure.
• Maintaining/Creating logins/users and giving permission to them as per request.
• Creating and Maintaining scheduled jobs and implementing automation for other tasks.
• Handling blocking issues and troubleshooting accordingly.

Confidential

SQL DBA

Environment: SQL Server 2005/2008 on Win Server 2003/2008.

Responsibilities:

• Maintaining of over 1200 standalone/Cluster servers.
• SQL Server 2000,2005,2008 installations, configuration and security settings for standalone servers.
• Having experience on database backup and restoration issues.
• Having experience on job failures & disk space issues .
• Monitoring database performance using SQL Profiler and the DB’s percent log space for all database servers using SCOM and Windows Performance Monitor counters.
• Maintained the Active-Passive Clustering as a disaster recovery solution
• Having experience on file moment activities on standalone servers.
• Develop and implement database administration/ maintenance plans.
• Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication, Clustering.
• Performed DBCC utilities and fixed data corruption in application databases.
• Traced long running queries and deadlocks using SQL Profiler
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers maintained Referential Integrity.
• Analyzed designed, developed, implemented and maintained the instances of databases. Worked on monitoring and tuning the SQL scripts
• Added Indexes to improve performance on tables. Used multiple join statements to retrieve data from multiple tables.
• Creating CR’s for every client\Customer-raised request and from users/application team.
• Keeping the track of all critical databases & server related information in Excel sheet.
• Documenting all new resolved tasks/environment details in share point for reference KEDB .
• Monitoring, Reviewing & approving change records with 100% SLA.
• Attending ST Service Transition record presentations.
• Providing KT for New joiners about the processes of Confidential project standards and usage of tools like ticket, monitoring, backup.
• Always maintains 100% Non-complaint to follow the ITIL processes.