SUMMARY:

• Microsoft SQL SERVER DBA professional wif 4 plus years of experience delivering high - quality services. Well versed in industry leading SQL SERVER Database Administration. Accomplished projects as per user requirements. Highly effective team-oriented able to collaborate wif cross-functional personnel Confidential all levels.
• Extensive experience in Installation, Configuration & Maintenance of MS SQL Server 2008, 2008R2, 2012 and 2014 Versions.
• Professional working experience wif Production 24/7, Testing and Development Environments.
• In depth experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Involved in capacity planning, BRP (Business recovery plans) and EPP (Emergency prepared plans).
• Enormous experience in planning and installing Replication environment (Transactional & Snapshot method used) to replicate data to regional servers.
• Expertise in High Availability setup (DB Mirroring, Replication & Log Shipping).
• Experience in Database Consistency Checks Using DBCC Utilities.
• Monitoring and tuning SQL Server performance wif multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard to achieve better performance, accessibility and efficiency.
• Expert in improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Effective in working wif developers and application process design.
• Involved in designing SSIS packages using SSIS (SQL Server Integration Services).
• Involved in configuring and managing clustering in MS SQL Server.
• Experience in transforms logical data models into physical database designs.
• Extensive experience of creation of databases, objects, stored procedures, triggers.
• Ample knowledge in overall database design, creating databases, queries, creation of tables, views using SQL Server.
• Setting up teh migration from SQL Server 2008 to SQL server 2012 and up.
• Excellent interpersonal communication skills, able to work both in teams and individually.

TECHNICAL SKILLS:

RDBMS: Microsoft SQL Server 2008/2008R2/2012/2014, MS Access

BI: Integration Server, Analysis Server, Reporting Server

Operating Systems: Windows2003, Windows XP and Windows 98

SQL Server Technologies & Tools: Management Studio, SQL Profiler, ETL, Database Tuning Advisor (DTA), TSQL, Query Analyzer.

Languages: Transact-SQL

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SQL SERVER DBA

Responsibilities:

• Involved in Install, configure, monitor, upgrade, patch and tune SQL Server 2005, 2008, 2008R2, 2012 and 2014 servers.
• Performed Performance Tuning of teh database, Stored Procedures and SQL queries.
• 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, Restore, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), 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 Performance Profiler, Dynamic management views.
• 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.
• Worked as team player in resolving issues, documentation etc.
• Security Administration: creation of users, Roles and granting appropriate privileges.

Confidential

Jr. SQL DBA

Responsibilities:

• Participate in installation and configuration of MSSQL 2008, 2008R2, 2012.
• Document teh company’s database environment.
• Assist in migration from MS SQL server 2005 to MS SQL server 2008R2.
• Deploy scripts from Development server to production/test servers.
• Restore backups on Development and test servers for refreshment.
• Effectively, professionally, and respectfully represents other Information Technology staff members, teams, and their services to teh client community.
• Determine teh most effective manner to resolve customer's technical issue. Engages in research and in depth troubleshooting to resolve technical issues.
• Verified suggested solutions effectively to resolve teh user’s problems through verbal or email follow up.
• Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced wif Point-in-Time Recovery that meets company’s RTO and RPO. Plan backup strategies based on teh recovery models, size of data and me\O activity.
• Design, implement and manage database maintenance and disaster recovery plans including full/differential/transactional backups and recovery procedures.
• Implemented pre/post strategies for upgrading and migration of user databases by scripting all SQL server replications, login/users, linked servers, scheduled job, database mail profiles and server level configurations.

Confidential

Jr. SQL DBA Internship

Responsibilities:

• Relocation of Databases from one server to another server using attach and detach databases.
• Involved in upgrading of Databases.
• Installing SQL Server wif minimum access privileges service account to improve security.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented log shipping and database mirroring between two instances of servers using Databases.
• Designed and implemented comprehensive backup plan and disaster recovery strategies implemented and scheduled Replication process for updating our parallel servers.
• Providing 24x7 production support for SQL Server databases on Clustered Servers wif sizes ranging from half to one Terabyte to achieve maximum performance and uptime in production environment.
• Rebuilding teh indexes Confidential regular intervals for better performance.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Maintaining teh database consistency wif DBCC Confidential regular intervals.
• To set up SQL Server configuration settings to resolve various resource allocation and memory issues for SQL Server databases and to setup ideal memory, min/max server options.