SUMMARY:

• A Skilled SQL SERVER DBA professional with 10 + years of experience delivering high - quality services.
• Well-versed in industry leading SQL SERVER Database Administration.
• Accomplished projects as per user requirements (SLA).
• Highly effective team-oriented able to collaborate with cross-functional personnel at all levels.
• Performing Capacity Planning Installing, Configuring & Upgrading Microsoft SQL Server 2000, 2005/2008/2012/2014
• Managing Data Integrity Managing Security
• Implementing & Managing Database High Availability Implementing Effective Backup Strategies For Disaster Recovery
• Database Performance Tuning & Query Optimization
• Team Building Project Coordination
• End User Training Hardware & Software Testing Technology Implementation Process Improvements
• Communication Systems Analysis Troubleshooting & Problem Solving Coaching & Documentation

TECHNICAL SKILLS:

RDBMS: Microsoft SQL Server 2000/ 2005/2008/2012/2014 , MS Access, Integration Server, Analysis Server,Reporting Server, Oracle

SQL Server Technologies & Tools: Enterprise Manager, Management Studio, SQL Profiler, DTS (ETL), Database Tuning Advisor (DTA), SQL* Plus, IDERA, Red Gate, HPDM, Squirrel, DB Visualizer

Scripting Language: DOS/PowerShell & T-SQL

Case Tools: MS Office, MS Access, MS Excel, MS Outlook, MS Visio, MS Project.

ETL Tool: SSIS, SSRS, SSAS, Erwin, PDMPlatforms Windows, Mac OS, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Sr. SQL Server DBA

Responsibilities:

• Upgraded/migration Database from SQL Server from lower to higher versions.
• Installed & configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Participated in meetings impacting databases physical design.
• Automated the SQL Server Job
• Backup and restore the database
• Provided appropriate access to client so that they will have access to their respective needed server and database objects.
• Developed & maintained T - SQL scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database Mirroring, clustering, failover and load balance technologies as per the company s requirement.
• Developed, tested & implemented a robust database backup and recovery strategy
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Researched, reviewed and recommended for preventive maintenance.
• Set up security and access profiles and procedures for database system administrators.
• Set up, implemented & managed replication, Log Shipping, and Database Mail.
• 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.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
• Identified and evaluated industry trends in database systems to serve as a source of information and advice for upper management.
• Created the SQL Server Integration Services (SSIS) and DTS Packages for data import and export.
• Participated in the preparation of project plans, providing technical expertise regarding architecture, development tools, and work effort estimates.
• 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/2000,T-SQL,SSIS,SSRS,ReportBuilder,Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, AlwaysOn, Windows XP/2000 and Windows 2003/2008/2012 Server.

Confidential, Houston, Texas

SQL Server DBA

Responsibilities:

• Upgraded/migration Database from SQL Server from lower to higher versions.
• Installed & configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Participated in meetings impacting databases physical design.
• Automated the SQL Server Job
• Backup and restore the database
• Provided appropriate access to client so that they will have access to their respective needed server and database objects.
• Developed & maintained T - SQL scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database Mirroring, clustering, failover and load balance technologies as per the company s requirement.
• Developed, tested & implemented a robust database backup and recovery strategy
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Researched, reviewed and recommended for preventive maintenance.
• Set up security and access profiles and procedures for database system administrators.
• Set up, implemented & managed replication, Log Shipping, and Database Mail.
• 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.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
• Identified and evaluated industry trends in database systems to serve as a source of information and advice for upper management.
• Created the SQL Server Integration Services (SSIS) and DTS Packages for data import and export.
• Participated in the preparation of project plans, providing technical expertise regarding architecture, development tools, and work effort estimates.
• 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/2000,T-SQL,SSIS,SSRS,ReportBuilder,Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, AlwaysOn, Windows XP/2000 and Windows 2003/2008/2012 Server.

Confidential

Sr. SQL SERVER ADMINISTRATOR

Responsibilities:

• Involved in Install, configure, monitor, upgrade, patch and tune SQL Server 2000, 2005 and 2008 servers.
• Worked on debugging and troubleshooting the database issues and code issues.
• Performed Performance Tuning of the database, Stored Procedures and SQL queries.
• Designed and implemented Logical and physical database design upon requirement, also the patching the critical servers\instances.
• Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases and quickly resolving issues.
• Involved in Day - to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), issue\ problem maintenance and management, Incident management, Security maintenance etc.
• Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, Dynamic management views
• Involved and implemented the Disaster recovery process to the critical databases and Instances as per MSFT standards.
• Configured SQL Server clustering and application services clustering.
• Managed internal and external MS SQL database security.
• Created stored procedures, functions, views, triggers, replication code, reports etc.
• Designed and implemented Operational automation tasks using SQL Server Job using DOS/PowerShell/T-SQL scripting
• Backup and restore the database using DOS/PowerShell/T-SQL scripting
• Developed & maintained using DOS/PowerShell/T-SQL scripts, utility jobs or implement needed software for database maintenance.
• Designed and developed SSIS packages for data extraction, data comparison and validation from multiple data sources and generate excel reports and SSRS reports.
• Involved and worked with the Change management, Release management for the smooth releases and of application\server\db installation or db patch\upgrade.
• Manage SQL Server security, application users, assist developers and users for access issues.
• Worked as team player in resolving issues, documentation etc.
• Security Administration: creation of users, Roles and granting appropriate privileges.

Environment: MSSQL Server 2000/2005/2008/2008 R2, MS-Access, MS Excels, DTS, SQL Diagrams, T-SQL, SQL Profiler, and Query Analyzer.

Confidential

DATABASE ADMNISTRATOR

Responsibilities:

• Monitor all instances of the server are up and running.
• Monitor the performance and manage the parameters to give fast responses to users.
• Process the logical data model in a way that it can be transformed to a database design.
• Refine the physical design to meet the requirements of system storage.
• 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 access.
• Discuss with the technical staff to make sure the integrity and security of the database.
• Support development and deployment of software applications
• Design database systems and data structures in collaboration with software development teams for existing and new applications.
• Designed and implemented Operational automation tasks using SQL Server Job using DOS/PowerShell/T - SQL scripting
• Backup and restore the database using DOS/T-SQL scripting
• Participated in writing the functional requirements with the team.
• Monitor SQL job failures, debug and resolve.
• Work with programmers team to create development and support strategies for database systems.
• Responsible for the implementation and maintenance of database backup and recovery processes.

Environment: MSSQL Server 2000, MS-Access, MS Excels, DTS, SQL Diagrams, T-SQL and Query Analyzer.