SUMMARY

• Having Seven+ years of hands - on experience as SQL Server DBA in Production support.
• Expertise in Database Administration on production servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008
• Maintaining 4000+ of SQL Servers with multi instances, with different environments (RTE, DEV, Preprod and Production).
• Proficiency in installing MS SQL Server 2000, 2005, 2008 and 2008R2.
• Administering, maintaining policies and procedures for ensuring the security and integrity of the company's databases and systems.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Performing SQL Server service pack and Windows Service pack upgrades.Hands on experience in configuring database Mirroring and log shipping.
• Continuously monitoring and updating the Backup and Recovery strategy via different backup tools like TDP and RedGate tool.
• Implementation of Database maintenance plans for Database consistency & Integrity.
• Creation and maintenance of databases, creating roles and assigning to the particular users and managing user permissions based on the client requirements.
• Handling blocking/locking incidents in order to avoid the performance issues. Implementing and restricting the security on server and database level.
• Administering SQL Server High Availability and Disaster Recovery strategies.Expert in data transformation services like SSRS.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Handling multiple SQL Instances on Cluster environment for server consolidation projects built on SAN.
• Maintained individual service accounts for SQL Server services with different Security groups to raise security mark.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and application support.
• Experience in using DBCC commands to improve server performance.
• Weekly activity of implementation of scripts in the databases in different regions. Providing 24X7 production support to critical databases.
• Proven ability to quickly learn new technologies and apply them in business solutions.

TECHNICAL SKILLS

Databases: SQL Server 2000,2005, 2008 and SQL Server 2008R2

Languages: C, C++,Java, .NET & SQL, Visual Basic, HTML, XML.

Operating Systems: Windows server 2003, Windows Server 2008, Windows NT/95/98/XP.

Technologies: ASP.Net, Web services, .Net Frame work 2.0/3.0, Teradata.

Front End Tools: MS Office 97/2000/XP, MS Outlook 97/2000.

Database Tools: Profiler, Query analyzer, SSRS, SSIS, SSAS.

Managing Tools: HP Service Managar 9.3, Service center, Maximo, Managenow

Backup Utilities: Tivoli-TDPSQL, RedeGate Tool.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

SQL Server DBA

Responsibilities:

• Installing MS SQL Server 2005, 2008, and 2008R2 (Database Engine, Analysis services, Reporting services in standalone & Cluster Environments as per the client requirement.
• Installing SQL Server service packs.
• Creating and configuring Databases based on the specifications sent by the client.
• Continuously monitoring and updating the Backup and Recovery strategy.
• Maintaining the Database Consistency with DBCC commands.
• Implementation of Database maintenance plan for Database consistency & Integrity
• Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Used log shipping for synchronization of databases.
• Recovered the System and User databases from suspect mode.
• Handling blocking/locking incidents if any.
• Working with customers on Application rollouts and server migrations.
• Creation of LOGINS, ROLES and granting rights, assigning permissions and mapping user databases as per the client’s request.
• Performing SQL Server service pack and Windows Service pack upgrades
• Scheduling JOBS (Daily, Weekly, Monthly) as per the client request.
• Performing Database Restoration (Native backup, Tivoli TSM - TDP) in different environments like Prod, PreProd, Dev, RTE.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Meet the SLA (Service Level Agreement) established.
• Automated messaging services on server failures, for task completion and success
• Executed procedures resquested by the application team to accomplish short-term business goals.
• Configured SQL server Reporting Services (SSRS).
• Deploying new code base release to UAT and Production Environments.
• Configuring TDP Nodes and installed TDP-SQL in standalone and Cluster environments.
• As part of the DBA team, providing 24x7 productions supports to the clients.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool - Manage Now.

Confidential

SQL DBA

Responsibilities:

• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Continuously monitoring and updating the Backup and Recovery strategy.
• Maintaining the Database Consistency with DBCC commands.
• Implementation of Database maintenance plan for Database consistency & Integrity
• Checked Database Health and consistency by using DBCC Commands and DMVs.
• Installing MS SQL Server 2005, 2008, and 2008R2 (Database Engine, Analysis services, Reporting services in standalone & Cluster Environments as per the client requirement.
• Installing SQL Server service packs.
• Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices

Environment: SQL Server 2008 R2/05/00, Windows 2003,2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool - Service Manager, Service center.

Confidential

SQL DBA

Responsibilities:

• Performed daily tasks including backup and restore by using Tivoli TDP, SQL Server Management Studio.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved scheduled jobs to re-index and update statistics in databases.
• Experience in using DMV for finding out long running queries
• Having Experience on Data center servers and handling 1.4 TB databases.
• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS)
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• To set up SQL Server configuration settings for better server management.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool - Manage Now.

Confidential

SQL DBA

Responsibilities:

• Continuously monitoring and updating the Backup and Recovery strategy via TDP and RedGate tool.
• Daily routine DBA tasks like handling user’s permissions and space issues on production and pre-production servers and handling maintenance Jobs.
• Weekly activity of implementing scripts in the databases.
• Scheduled and monitored all maintenance activities including database consistency and backups.
• Performed all basic database activities like creation, backup, restore between servers.
• Checked Database Health and consistency by using DBCC Commands and DMVs.
• Worked on blocking/locking incidents in order to avoid the performance issues.
• Worked on critical change activities on production servers.
• Worked with customers on Application rollouts and server migrations.
• Provided 24x7 production support for SQL Server databases achieve maximum performance and uptime in production environment.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, .net, VB and, RedGate & Tivoli TDP as backup utilities, Ticketing tool - Maximo.