SUMMARY

• Over 8+ years’ experience in Database Administration, System Analysis and Administration, Development & Support of MS SQL Server2000, 2005, 2008 R2, 2012 and 2014 in Production, Development & Replication Environments.
• Extensive knowledge about the environments like Commercial, Oil & Gas.
• Hands on Experience as Core Production Support MS - SQL SERVER DBA for Databases ranging from 100 GB to 5 TB.
• Extensive experience in handling DBA duties such as Installation, up gradation of MS SQL Server software on Windows Platforms, Database Creation, Database Auditing, and Production Database Support & Maintenance, enhancement, automation, tuning and optimizing databases for high Availability, Performance and Security.
• Experience in handling Database Migration for DB Version Upgrade.
• Experience in Database Migration from MS-Access to SQL Server.
• Expertise in setting up and troubleshooting Database Clustering in Active-Active and Active-Passive Mode on a mount point storage cluster.
• Expertise in setting up and troubleshooting Always on availability.
• Experience in configuring high availability methods like Mirroring, log shipping, Replication.
• Experience in PowerShell Scripting.
• Experience in creating and troubleshooting SSRS reports and sending notifications through SSRS.
• Knowledge in database modelling using Microsoft Visio tool.
• Monitored and modified Performance using Wait States, Index tuning & Execution Plan management.
• Performed query tuning to reduce response time by 60% in some cases, using cache plans, execution plans and index tuning.
• SME for Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. & Monitor log files to proactively resolve issues
• Knowledge in working with third party tools like TOAD, LiteSpeed, Commvault & Foglight
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

Operating System: Windows 2003/2008/2008 r2/2012

Databases: SQL Server 2000/ 2005/2008/2008 R2/2012, MS-Access

Languages: HTML, T-SQL, PowerShell

Tools: & Utilities: Data Protector (Backup Tool), Data Protection Manager (DPM), Red Gate for SQL Server & SQL Litespeed, Red Gate, TOAD, Oracle SQL Developer, MS Visio, Commvault, Foglight.

PROFESSIONAL EXPERIENCE

Confidential, California

System Analyst

Responsibilities:

• Handling Production Databases
• Installing, configuring, upgrading & administration of MS SQL Server 2005/2008/2008 R2/2012.
• Develop and test a backup and restore strategy.
• Perform Health check on the servers frequently.
• Trouble shooting SQL server Performance Issues.
• Monitoring the CPU, Memory utilization and Disk Spaces on servers.
• Monitoring job failure alerts and resolve if any job failure issues.
• Develop Performance baseline and fine-tuning queries.
• Manage security of database structures and corporate data held within databases.
• Establishing the needs of users and monitoring user access and security.
• Controlling access permissions and privileges;
• Design SSIS package to extract data from External data source to SQL Server.
• Analyse the database growth & trends and Planning the Capacity of the Servers.
• Check the Integrity of the databases and tables.
• Database modelling using MS Visio.
• Monitoring the error logs, Database Availabilities, Space to avoid the failure of applications on regular intervals.
• Periodically identifying mismatch, orphan ids and fixing the same.
• Automating Administrative Tasks by creating alerts, jobs, scheduling jobs.
• Configuring the audit alerts to capture the failed login attempts and Monitor the unauthorized user access to the databases and remediate the
• Automating the administrative tasks writing system side stored procedures and programs
• Interacting with the support teams so that the database environment is always available without any downtime
• Secure the database environment following the Information Security and Standards of client
• Installing/Configuring/Monitoring/Troubleshooting SQL Server on Clustering, Always On availability.
• Configuring/Monitoring/Troubleshooting log shipping, database mirroring and replication
• Monitoring the servers with various windows performance counters to identify server status
• Moving System databases from one location to another.

Environment: MS-SQL Server 2014\2012\2008\2005, Windows 2008\2003\2000, MS Excel 2007\2003, MS-ACCESS 2007\2003, T-SQL, MS-OFFICE, SQL Litespeed, MS Visio

Confidential

SQL Server DBA

Responsibilities:

• Performed server installation and configurations for SQL Server 2005\2008\2008R2.
• Performed installation of SQL Server Service Packs and Cumulative Updates.
• Regular monitoring of production databases.
• Creating users in the server and databases and assigning required privileges.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard
• Shrinking transaction log and databases as per requirement.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Trouble shooting of the performance issues and tuning.
• Monitoring and troubleshooting activities like blocking, locking and deadlock etc.
• Maintaining the database consistency with DBCC at regular intervals.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, IIS, Red Gate.

Confidential

Responsibilities:

• Contact Centre System Engineer designing, deploying and supporting Contact Centre infrastructure.
• Monitoring Daily Health checks.
• Performing Database operations (Purging data, Backup data) on Brightware DBstandards coordinating.
• Point of contact for the Contact Center Applications
• Creating and managing the mail routing rules in Firepond (Brightware).

Environment: MS SQL Server 2000/2005/2008 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Toad, Oracle