PROFESSIONAL SUMMARY:

• Microsoft Certified Professional with over 6 years of extensive experience in Administering and Managing of multiple MS SQL Server Databases in Production and non - Production environments. Primarily concerned with managing the SQL Server relational database management systems hosted on Microsoft Window 2003/ 2008/ 2008 R servers running on Physical and Virtual hardware platforms in a 24 x 7 environment Using SQL native tools and third-party products.
• 6+ years of experience in database Administration, Design Development and Support of MS SQL Server 2014/2012/2008 R2/2005 in Production, Test, Development and Cluster Server Environments.
• Extensive experiences in MSSQL Server Database administration including monitoring and troubleshooting, database migrating, job automation, backup/recovery, maintenance, and alert set up.
• Hands on experience on high availability SQL Server solutions: Mirroring, Log shipping, Replication and Always on Failover Cluster Instance (FCI) and Always on Availability Groups.
• Solid experience and knowledge in SQL server upgrade and Data migration from SQL Server 2005, 2008, 2012 to SQL 2016 versions.
• SQL Server setup, configuration, migration customer’s database from their data center to AWS and restore to EC2 instance.
• Worked in Microsoft Business Intelligence technologies using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, Views and user defined functions and complex joins.
• Expert level skills in using PowerShell for backups, DBCC DB cheeks, post installation setups (security (user & logins), and automating some jobs
• Experienced in DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages
• Expertise in Always-On Availability Groups (AAG) and HA/DR configuration and set up.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management procedures.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Migrated Oracle, DB2, and MySQL databases to SQL Server 2008/2008R2/2012.
• Did resource Capacity Planning for database servers, design and deploy databases to development, test and production environment.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, New York

SQL Server Database Administrator

• Installation, configuration and administration of SQL Server 2008, 2008 R2 and 2012.
• Scheduled Full and Transactional log backups for the user created and system databases in the using the Database Maintenance Plan Wizard.
• Administering the MS SQL Server security in relation to users, logins, groups, Principle of Least Privilege (PLP), Securable, Permission, Roles and Authentication Modes as a part of Security Policies.
• Creating and managing databases, schema objects such as tables, views, indexes procedures, triggers and DB constraints to meet business requirements and policies and maintained referential Integrity.
• Implementing a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and provided support 24x7.
• Upgraded SQL Server 2008 R2 to SQL 2012 server for high volume processing databases on a clustered environment.
• Experience with SQL Auditing, Resource Governor, Policy Based Management (PBM) data and Network Encryption using certificates.
• Implementing SQL server high availability solutions/tools like Log shipping, Mirroring and Replication as well carefully scheduled maintenance plan to minimize downtime.
• Managing the use of disk space, memory and connections/network.
• Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
• Create and deploy different reports for different business purpose in a team
• Used DBCC commands to troubleshoot issues related to database consistency.
• Worked with the database optimization, Performance tuning and index tuning for optimization of queries.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Work with installation engineer to setup AWS test/QA environments for different clients
• SQL Server setup, configuration, migration customer’s database from their data center to AWS and restore to EC2 instance.
• Creating, managing and modifying Volume/Drive in AWS S3 environment.
• Review T-SQL code to verify it meet standards for both performance and error handling per DBA standards. Wrote SQL, T-SQL, Stored Procedure, Functions, Triggers and views.

Confidential, Horsham, Pennsylvania

SQL Server Database Administrator

Responsibilities:

• Install, configure and administer MS SQL server 2012 and 2014.
• Migrate instances and databases from SQL 2012 to SQL 2014.
• Configure and administer Availability Groups for high availability/Always On of multiple databases.
• Successfully Installed, configured and administer a traditional SQL Server failover Cluster with 2 nodes.
• Created and administered various jobs to handle different tasks and to monitor resources on various servers and to email the necessary information when threshold was reached.
• Apply SQL Server patches; SP, Hot-fixes, and CU as required and created documentation for tracking.
• Design, Develop and implement SQL server reporting service that extracts data and present in the user-friendly formats.
• Intensively analyzed the existing system regarding the database administration and produced an inception report which describes the existing situation, pros and cons, and future intervention and plan of action (short, midterm and long-term)
• Created linked servers to perform distributed queries and data transfer.
• Worked with database developers’ team for database design, data modeling and normalization.
• Assisted developers in the process of Extract, Transform, and Load (ETL) in data warehouse.
• Run DBCC commands to check the database consistency and shrink the databases.
• Manage Very Large databases (VLDBs) of 1TB and more using Table Partitioning Backup and data Compression and Multiple file-groups.
• Responsible for Designing and implementing the backup strategy required as per the requirement on production and development environments.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Create and deploy different reports for different business purpose using SSRS

Confidential, Frisco, Texas

SQL Server Database Administrator

Responsibilities:

• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Responsible for large scale of database migration from SQL server r2, 2012, 2014 and to 2016.
• Responsible for creating stored procedures, tables, views, functions, triggers and indexes.
• Involved in database backups/restoration and planning backup strategies.
• Backing up master & system databases and restoring them when necessary.
• Rebuilding the Indexes at regular intervals for better performance.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL Failover clustering for two production environments.
• Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.
• Working with SSIS package to import and export operations in and out of the SQL Servers.
• Scheduling jobs and alerts using SQL Server Agent. Administrating Microsoft Operation Manager (MOM) 2005 in an existing IT infrastructure.
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Set up SQL/database mail to produce database health reports and other alerts.

TECHNICAL EXPERTISE:

Databases: MS SQL Server 2014, 2012, 2008/R2 and 2008

ETL tools: SSIS/DTS, BCP

Programming: SQL, T-SQL, Stored Procedures, Trigger, Functions, Windows PowerShell Scripting

SQL Server Tools: Management studio, Profiler, Query Analyzer, Import and Export, DTS, SSIS, SSRS and Replication

Operating System: Windows server 2012/2008/2003 Advanced Server, NT & Windows

Hardware/Storage: SAN, RAID, S3

Server Virtualization: Worked on migrating and managing database systems on Hyper-V and VMware virtual machines and Amazon web service (AWS)

Third party Tools: Idera, Erwin