OBJECTIVE

• Result Driven SQL Server DBA with 6+ years of Database Administration and IT experience in various industries such as health care, communication, and IT Consulting Companies. Experience in designing, implementing, supporting and maintaining Databases. Extensive knowledge in architecting, building and scaling databases for future growth. Experience in managing multiple MS SQL Server with very large OLTP Databases in development, testing/QA and production environments. Excellent team player with abilities to work independently.

SUMMARY

• Experienced in working 24X 7 dedicated support for production database servers.
• Experience in implementing backup/recovery procedures following strict RPO and RTO guidelines
• Undertook database consistency and integrity checks after software upgrades and run different types of maintenance tasks.
• Experience in Monitoring, fine - tuning and troubleshooting performance issues in test, development and production servers using native and various third party tools.
• Experience in applying Service Packs and Hot Fixes to all production and non - production servers.
• Experience in planning, managing HADR solutions such as log shipping, mirroring, clustering, replication and always on
• Worked with SQL server Profiler, and generated traces to optimize the performance of the database.
• Expertise in automating maintenance Plans in SQL Server agent jobs and task scheduler.
• Experience in configuring logical drives/array and their RAID level using HP array configuration utility.
• Hands on experience in applying columnstore index for data warehouse performance.
• Extensive knowledge on the installation, configuration in clustered environment.
• Experience in creating virtualized environments by using VM ware tools.
• Excellent experience in Creating Views, stored procedures and other database objects.
• Hand on experience installing, configuring and managing SQL Server Reporting Service
• Skilled in creating snapshots, subscriptions, cashing using SQL Server Report Manager
• Expert in Creating reports using SSRS for different purposes.
• Strong time Management skills and excellent team player.

TECHNICAL SKILLS

Relational DBMS: Microsoft SQL Server 2008/2008R 2/2012/2014/2016 , Microsoft Access.

Server operating systems: Windows Server 2000/2008/2008 R2/2012

ETL tools: MS SQL Server integration services /SSIS/, Data Transformation services /DTS

Reporting: SSIS /SSRS/.

Third party Technology Tools: Redgate, Idera, Spotlight

Applications: IIS, Visual Studio, SharePoint

Network Topologies: TCP/IP, FTP, SMTP

Cloud Computing Services: AWS, AZUR

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• SQL Server installations, patches and upgrades, including both standalone and clustered environments of production, test and development.
• Implemented conceptual, logical and physical database design and maintenance.
• Automated maintenance plan jobs in SQL Server agent and task scheduler: such as shrinking database, database backups, index rebuilding, index reorganizing, clean ups, and updating statistics.
• Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/troubleshooting.
• Used third party tools like (IDERA) to maintain, manage, and monitor performance
• Analyzed Locks, Dead Locks using both Spotlight and DMVs and DMFs, and handled the isolation Level and Concurrency Effects.
• Implemented and manage transactional log shipping, SQL server Mirroring (Synchronous/ Asynchronous), Fail over clustering and transactional replication.
• Created Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
• Developed T-SQL scripts to create database objects and perform DML and DDL tasks.
• Creating SQL Server Logins and Authentication Modes as a part of Security Policies for various categories of User Support.
• Implemented and managed database maintenance and disaster recovery plans including merge and transactional replication.
• Performed SQL Server 2008R2 migration to SQL Server 2012 and performed post upgrade configurations.
• Designed and implemented SSIS package to migrate data from multiple data sources.
• Provided proactive and reactive data management support to users.

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Developed, and deployed SPROCs, UDFs, and other database objects as requested by clients.
• Developed, monitored and tested database backup processes.
• Developed and monitored automated maintenance processes to ensure continued optimal performance of client servers.
• Ensured security of SQL Server systems by auditing logins and user accounts permissions, implanting server hardening "Best Practices", and implementing encryption as requested by clients.
• Reviewed server configuration, monitor and optimize query execution, monitor server resource utilization ensure optimal performance of server.
• Designed, Installed and configured clustering for SQL Server instance on SQL2008R2, SQL2012 and SQL 2014, Always ON.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of insurance and systems.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Daily Database backup and recovering at regular intervals to make sure the backup and restore is proper for SQL Servers 2005/2008/2012
• Developed database maintenance plan for database backups and recovery, reorganizing data and database integrity check.
• Responsible for daily operational management and troubleshooting of MS SQL 2008R 2/2012/2014.
• Responsible for the design, deployment and control of MS SQL in a virtual VM environment.
• Used SQL server management studio and reporting tools to design, and manage SQL environments.
• Exported and Imported data from other data sources like flat files using SQL server Import/Export wizard and SSIS.
• Ensured that all levels of the migration and deployment processes are going as intended on the SQL 2008-R2, 2012, and 2014 servers.
• Worked closely with developers to resolve issues.