SUMMARY:

• A Database administrator with expertise in problem identification and solution, comes with a collective
• 10 years of experience in tangible people skills aimed at accomplishing Disaster and back up recoveries including tasks at hand and setting goals the successful implementation of any project at hand.
• Around 6+ years of experience in Database Administration for very large and complex databases.
• Create and run script s (DDl) to build and modify database objects in support of Application development.
• Expertise in SQL Server 2005, 2008,2008R2, 2012, 2014 and SQL Server 2016
• SSIS - creating packages, designing, testing, and development.
• Proficient in Database Administration on Production Servers with server configuration.
• Adept in performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in T-SQL; writing stored procedures, triggers, functions, joins, Clustered and Non-Clustered Indexes.
• Adept in Data Privacy and Data Security.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in Disaster Recovery Planning and Security Management operations and Diagnostic Skills.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Proficient in hands on experience in DR processes including Log Shipping and Database Mirroring.
• Adroit in hands on Fail-over-Clustering and Always-ON
• Expert in SQL Server migrations, Mirroring
• Experienced in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Proficient in Management of Database Space, Growth Monitoring of Data & Transaction log files.
• Well experienced in providing 24 x 7 production support & Excellent communication skills, organizing skills and an experienced team player.

PROFICIENCY & SKILL HIGHLIGHTS:

• SQL Server 2016
• Log Shipping
• Database Design, Schema Creation and Management
• Database Backup and Recovery
• Data Integrity
• Data Type Administration
• Enterprise Technologies
• Data Privacy applications
• High Availibilty
• Policy Base Management
• SSIS
• Microsoft Office Suite, Access & Microsoft Project
• TSQL/SQL
• Project Management & Agile methodologies
• Technical, Documentation & Writing
• JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Brimingham, Albama

SQL Server DBA

Responsibilities:

• Responsible for installation configuration and complete administration of different versions of SQL servers from
• Apply Service pack and Hot fixes on SQL server 2008R-20012,2014,2016
• Configure Log Shipping for multiple databases as a part of a disaster recovery
• Configure replication and database mirroring
• Sql server Auditing, Adopted new upgrade features of Sql server 2016 like Policy Base management, Temporial table, Resource Governer, Memory optimized tables,...
• Application Support for frontend feeds and resolved application connectivity issues like connection timeouts and connection pooling issues and memory leaks.
• Extensively worked with SQL profiler, activity monitor, DMVs and DMFs and DTA to time the databases, queries, performance related issues like memory CPU and IO issues.
• Analyze and tune long running and slow queries to optimize application and system performance.
• Configuring and maintaining log shipping and troubleshooting the issues.
• Reorganize, rebuilding the indexes, at regular intervals for better performance.
• Implementation of SQL log ins roles and authentication modes as part of security policies for various categories of users.
• Involved in trouble shooting and finetuning of databases for their better performances
• Improve the performance of SQL queries and stored procedure using SQL profiler.
• Implemented company policy,
• Technical procedure and standard for preserving the integrity and security of data, report sand access
• Database backup procedure, restoration procedure, disaster recovery procedure and contingency plans. Testing and implementation of the same
• Provided 24/7 technical database support for SQL database systems

Confidential, San Jose, California

SQL Server DBA

Responsibilities:

• Administrated, Upgraded and Managed SQL Server 2008R 2/2008/2005/2000 databases in Production, QA and development environments and mentored other technical staff.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Implementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Handled up to 2 TB Size databases with clustered and standalone environment.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans which covers Database Integrity Checks.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

SQL Server DBA/DEVELOPER

Confidential, San Jose, CA

Responsibilities:

• All Production, Development Environments running MS SQL Server 2005/2000.Involved in Migration of Production Database Servers from SQL Server 2005 to SQL Server 2008 Involved in Performance Tuning on Production and Test Servers. Implemented Database mirroring for High Availability.
• Maintained various databases for Production and Testing using SQL Server 2005.Involved in Monitoring Performance of different production servers.
• Planning the location of data, index, and Transaction log files on the disk. Performance tuning, and Optimization of Stored Procedures and Queries.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing. Managing schema objects Performed the role of Database Architect for the SQL Server database environment .Managed such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications. Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies .
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Environment: Microsoft SQL Server 2008/2005