SUMMARY

• A Skilled and well - experienced SQL SERVER DBA professional with 5+ years of experience in delivering high-quality services in SQL SERVER Database Administration and I have accomplished projects as per user requirements (SLA) and I am a highly effective team-oriented able to collaborate with cross-functional personnel at all levels.
• Deployed Database, development, testing, UAT and production database server
• Created Tables, Views, Functions, Triggers and store procedures.
• Migration Database from MS access to SQL Server
• Managing Data Integrity ion
• Experience with Database 3rd part Tools like, SQL navigator and Toad
• Managing Security
• Implementing & Managing Database High Availability and
• Implementing Effective Backup Strategies For Disaster Recovery /Replication
• Database Performance Tuning & Query Optimization
• Troubleshooting & Problem Solving
• Experience in Patch Script, Using Dos and Power shell
• Deployed Service Pack SQL Server
• Documentation

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2005/2008/2012 , MS Access

SQL Server Technologies & Tools: Management Studio, SQL Profiler, ETL, Database Tuning Advisor (DTA) SSIS, SSRS &SSAS

Case Tools: MS Office

ETL Tool: SSIS

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

SQL Server DBA

Responsibilities:

• Developed, tested & implemented a robust database backup and recovery strategy
• Managed security by defining roles and rights.
• Upgraded/migration Database from SQL Server from lower to higher versions.
• Installed & configured multiple SQL Servers.
• Performed database upgrades & applied software patches to databases as per user requirements.
• Provided appropriate access to client so that they will have access to their respective needed server and database objects.
• Set up or created, maintained and administered maintenance plans and jobs.
• Implemented & managed DR/Availability technologies including replication, Log Shipping, database Mirroring, failover clustering and Always On as per the requirement.
• Conducted root cause and analysis for database incidents and problems.
• Ensured the Availability of the Database Server in a 24X7 Environment.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
• Created the SQL Server Integration Services (SSIS) and DTS Packages for data import and export.
• Supported the research, investigations and recommendation of best practices for information and application services, and contribute to work plans.

Environment: MS SQL Server 2012/2008R2/2005,T-SQL,SSIS,SSRS,ReportBuilder, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Always On, Windows XP/2000 and Windows 2003/2008/2012 Server.

Confidential, Houston, Texas

SQL SERVER ADMINISTRATOR

Responsibilities:

• Engaged and involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Index maintenance, database health and consistency check, Security maintenance etc.
• Involved in Install, configure, monitor, upgrade, patch and tune SQL Server 2008, 2008/R2 & 2012 servers.
• Upgraded/migration Database from SQL Server from lower to higher versions.
• Worked as team player in resolving issues, documentation etc.
• Security Administration: creation of users, Roles and granting appropriate privileges
• Worked on debugging and troubleshooting the database issues.
• Performed Performance Tuning of the database, Stored Procedures and SQL queries.
• Implemented patching of critical servers\instances.
• Involved in designing, configuring, monitoring and troubleshooting replication, log shipping and mirroring on critical databases and quickly resolving issues.
• Monitor and tune of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, DMVs & DMFs
• Created the SQL Server Integration Services (SSIS) and DTS Packages for data import and export.

Environment: MSSQL Server 2005/2008/2008 R2/2012, MS-Access, MS Excels, SSIS, SSRS, T-SQL, SQL Profiler…

Confidential, Houston, Texas

SQL Server DBA

Responsibilities:

• Responsible for the implementation and maintenance of database backup and recovery processes.
• Involved in designing, configuring, monitoring and troubleshooting of HADR technologies such as failover clustering, replication, log shipping and database mirroring on mission critical databases and quickly resolving issues.
• Monitor all instances of the server are up and running.
• Monitor SQL job failures and resolve.
• Monitor the performance and manage the parameters to give fast responses to users.
• Install and test the new version of database management system.
• Write documentation for a database including data standards, procedures and metadata.
• Control privilege and permission for Server and database level access.
• Checking the integrity and health of databases.
• Monitor SQL job failures, debug and resolve.

Environment: MSSQL Server 2005/2008/2008 R2, MS-Access, MS Excels, SSIS, SSRS, T-SQL, SQL Profiler…

Confidential, Houston, Texas

Junior SQL Server DBA

Responsibilities:

• Responsible for the implementation and maintenance of database backup and recovery processes.
• Involved in designing, configuring, monitoring and troubleshooting replication, log shipping and mirroring on mission critical databases and quickly resolving issues.
• Monitor all instances of the server are up and running.
• Monitor SQL job failures and resolve.
• Monitor the performance and manage the parameters to give fast responses to users.
• Install and test the new version of database management system.
• Write documentation for a database including data standards, procedures and metadata.
• Control privilege and permission for Server and database level access.
• Checking the integrity and health of databases.
• Monitor SQL job failures, debug and resolve.

Environment: MSSQL Server 2005/2008/2008 R2, MS-Access, MS Excels, SSIS, SSRS, T-SQL, SQL Profiler…