SUMMARY

• Over 7+ years of IT experience in Database Administration, development, design, support and migration of Microsoft 2008R2/2008/2005 databases to SQL server 2012.
• Experience with MS SQL Server 2012/2008R2/2008/2005 and their Installation, Configuration and Maintenance.
• Experience in Data Migration from MS SQL server /2008R2.
• Expertise in the following database technologies MySQL, MS Access.
• Good Experience in Database Backup, Recovery and Restoring as daily activities.
• Familiar with SQL Server 2005/2008/2012 concepts like Data Compression, Backup stream compression, DMV/DMF.
• Expert in performance tuning and handling blocking situation and deadlock situations. Experience in Query Optimization, Client/Server Connectivity, Database consistency checks, Index Tuning.
• Good Administration skills back up strategies, Model (Full, Bulk logged, Simple), Database creation, Table, Indexes.
• Implemented backup policy using Full, Differential, Transactional log and Recovery and Disaster Recovery Procedures.
• Experience in Disaster Recovery & Capacity Planning models for corporate databases.
• Implemented different types of Replication Models, Database Mirroring modes and Clustering environments (active/passive and active/active) to further increase scalability and stability of business critical systems.
• Worked on Replication and Log shipping for SQL Server High Availability.
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication.
• Having hands on experience in Database Mirroring.
• Configured Always ON and Failover Clustering in SQL server 2012.
• Worked on configuring SQL Server with minimum privileged access.
• Managed day - to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.
• Done Password Changes on cluster and Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
• Good Knowledge at SQL Server 2008 new features like Policy Based Management, Performance Data Collector and Transparent Data Encryption (TDE).
• Proficient in monitoring SQL Server Performance using SQL Profiler, Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard, DTA, Windows Performance Monitoring.
• Knowledge in creating ETL packages using SQL Server 2008/2005 Integration Services (SSIS).
• Experience in developing reports using SQL Server 2008/2005 Reporting Services (SSRS).
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Good communication and written skills and can handle multiple projects simultaneously.
• Worked 24 x 7 for production support with multiple SQL Instances.

TECHNICAL SKILLS

Database: SQL Server 2012/2008R2/2008/2005 Enterprise

Application Packages: MSOffice

Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2012 R2/2008R2/2008/Windows XP

Languages: TSQL, PL/SQL, SQL Plus, My SQL, C/C++, .NET, HTML.

Methodologies: Object-Oriented Analysis& Design, Data Modeling, Scrum Agile

Other Tools: Red Gate, Lite Speed, Idera

PROFESSIONAL EXPERIENCE

Confidential, Ashburn, VA

SQL DBA

Responsibilities:

• Installed and configured SQL Server 2012. Applied service packs and hot fixes to all SQL Servers
• Design/develop testing databases using 2012.
• Migrated the database from MS Access to MySQL which increased speed and resulted in better management of the database.
• Worked on SQL Server 2012 migration from SQL Server .
• Managing user creations, assigning Roles to SQL Databases
• Creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures, Triggers, Rules and Defaults.
• Evaluate back-up and recovery hardware and software and make recommendations to management to automate and implement on-going improvements.
• Create and implement best backup and recovery strategies (Full Backup Model with transaction logs backups).
• Designed and implemented Disaster Recovery site using SQL Server Database Mirroring with High Performance Mode.
• Created new Transactional replication and addressed the Replication Issues to maintain high availability of the data between the servers.
• Implementing high availability with AlwaysOn Availability Groups and Failover Clustering.
• Created SQL Jobs and Schedule these jobs in SQL Server Agent.
• Oversee and database developers and web programmers in query writing, query optimization, performance tuning.
• Responsible to improve the Server performance and SQL server optimization.
• Troubleshoot performance-tuning issues by running SQL server Profiler, creating trace and run these traces in SQL Server Database Engine Tuning Advisor and analyzing the reports.
• To analyze poor performing queries and tune the same to optimize application and system performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.
• Created the SSIS packages for import and export processes.
• Prepared Database Documentation.
• On call 24/7 support to databases on weekly rotation.

Environment: Windows 2012/2012/2008 R2, MS-SQL Server 2012/2008R2, Clustering, Replication, Oracle 11g /10b, DTS/SSIS, SSRS.

Confidential, Richardson, TX

SQL Database Administrator

Responsibilities:

• Management of SQL Servers, databases, storage management for databases.
• Management of database objects such as tables, views, indexes.
• Managing and configuring SQL Servers asLinked serversas well as setting configuration options
• Creating database usersand managing theDBsecurity issues
• Troubleshooting and writingstored procedures,triggers,Functions,views and make changes to the code if necessary
• 3rd party back up tool such asLiteSpeed, idera, Red Gate (System level back up)
• T-SQLqueries to diagnose data problems and fix scripts to correct the data problems
• Fix scriptsincluded update, delete, insert, etc.
• Management of users including creation/alteration, grant of system/dB roles and permissions on various database objects.
• Involved in writing Transact-SQL command line script for various needs.
• Evaluated data storage considerations to store databases and transaction logs.
• Migration of SQL Server 2008R2 to 2012 and also on new hardware with the platform of Windows 2012.
• Used DTS/SSIS to perform the ETL tasks from source to target.
• Tuned the database to perform efficiently by managing databases.
• Monitoring the server for High availability of the servers solving the raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.

Environment: Windows 2012/2008R2/2008, SQL Server 2008/2008R2/2012, DTS, SSIS, SSRS.

Confidential, Harford, MD

SQL DBA/developer

Responsibilities:

• Identified the necessary steps to enhance user response time by checking fragmentation and re-index tables for efficient application access methods.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore
• Rebuild Indexes on Various tables using DBCC Command & maintenance plans.
• Scheduling activities for Maintaining Databases and installed MS SQL Servers 2008/2008R2.
• Designed DTS package to export SQL Server data to Access Database.
• Set up, configure and administer Snapshot and Transactional Replication on MS SQL Server 2008.
• Administered Backup and recovery and administered Disk and Database Space.
• Administered the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, granting the privileges to users and groups.
• Assign users to particular roles and scheduled the job for Database Backup, Transaction Log Backup.
• Ran various DBCC commands like check dB/checktable, showconfig, showstatistics for checking database/table consistency and system performance.
• To ensure all scheduled administrative jobs are running/completed for Microsoft SQL Servers.
• Involved in installing SQL Clustering for production environments, implementing Log Shipping

Environment: MS SQL Server 2008R2/2008, DTS, SQL LiteSpeed, Red Gate, SQL Profiler, Perfmon.

Confidential, Richardson, TX

SQL Database Administrator

Responsibilities:

• Management of SQL Servers, databases, storage management for databases.
• Management of database objects such as tables, views, indexes.
• Management of users including creation/alteration, grant of system/dB roles and permissions on various database objects.
• Involved in writing Transact-SQL command line script for various needs.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Migration of SQL Server and also on new hardware with the platform of Windows 208R2 and 2008.
• Used DTS/SSIS to perform the ETL tasks from source to target.
• Tuned the database to perform efficiently by managing databases.
• For transferring, used data import and Export utility and BCP command line utility.
• Monitoring the server for High availability of the servers solving the raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.

Environment: SQL Server 2008 & 2005, DTS, SSIS, SSRS.

Confidential

Database Admin

Responsibilities:

• Installing and Configuring SQL Server 2005.
• Upgrading/Migrating and Consolidating databases from different DBMS and versions to current version of SQL Server
• Updating Service packs and Security patches for the Servers
• Analysis of the existing setups and specifications of the Project.
• Routine DBA activities like analysis of Space issues, memory issues, Backup job issues.
• Backup and recovery, creating users, roles, permissions.
• Taking backups, restoring the databases and refreshing the testing and development environments.
• Setting up log shipping for reporting and DB Mirroring
• Creating different instances and databases of sql server 2005 corresponding to the applications.
• Designing tables with Primary Key, Foreign keys, unique keys, covering indexes, Clustered and Non clustered indexes, constraints and triggers.
• Actively involved in Normalization and De-normalization of database.
• Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues
• Involved in administration of the SQL Server by creating users & login ids with appropriate roles and grant privileges to users and roles.
• Created and used stored procedures, triggers for database transactions in SQL Server.

Environment: SQL Server 2005/2008, Windows Server 2003R2, .Net Framework 2.0, Visual Studio 2003.