SUMMARY:

• Highly Accomplished SQL Server Database Administrator
• Database administrator (DBA) with extensive experience installing, configuring and supporting next - generation database solutions in SQL Server environments; an effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business/management & significant experience working with steering committees
• Self-motivated team player with excellent verbal and writing communication skills & ability to learn things fast and a discerning mind;
• Administering MSSQL Server 2016, 2014, 2012,
• Experience on Azure databases
• Installation and configuration SQL 2016/ 2014/2012/2008 R 2/2008/2005.
• Upgraded inplace and sidebyside upgrade from SQL 2008, 2008 R2 to 2014 & 2016.
• Performance tuning
• Data modeling, purging/archiving databases
• Security Auditing and maintaining server/ database level permissions
• Installing, configuring and troubleshooting MSQL cluster instances
• Expertise in Database administration activities like Installation, Configuration, Backup &Recovery, Database Security, Data Integration Services, Database designing and Query optimization.
• Windows DNS, DHCP, Active Directory, Kerberos, Windows Administration and Group Policies
• Running Database Consistency Checks using DBCC
• Experience in configuring Always on with High Availability (HA) and Disaster Recovery (DR)and Windows Server Failover Clusters, Contained Databases, Online Index Rebuilds, CDC, TDE
• Installing and configuring Foglight
• Partitioning, Log shipping, Linked Servers
• Good hands on experience on Microsoft Operations Manager( MOM)
• Snapshot and Transactional replication implementation & troubleshooting
• DTS Packages, SQL Server Integration Service (SSIS) and SQL Server Reporting Service (SSRS)
• Database Objects development (Tables, Views, Stored procedures, Cursors, T-SQL scripts and batch files)
• Database Mirroring, Database Snapshot and Service Broker.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Expert in Database Capacity Planning and Maintenance.
• Supporting and configuring SQL Server Reporting Services.
• Good knowledge on SQL Server database, t-log and memory architectures and internals.
• Experience in AWS design and Administration with knowledge in EC2 and AWS.
• Experience in Microsoft Azure and Amazon AWS cloud implementation.
• Participated in planning of Disaster Recovery Planning, Execution and Testing.
• Basic T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers.
• SQL debugging and query optimization and Schema Maintenance
• Good hands-on experience on all high availability solutions
• Data Security, Backup & Recovery
• SQL server profiler and Index Tuning Wizard
• Standby/Failover Administration
• Ability to work in OLTP & OLAP environments
• Working on 2.2, 2.6 & 3.0 mongo DB
• Upgraded from 2.2 to 3.0 and 2.6 to 3.0.
• Implemented 3 node replication
• Worked on unix platform like Solaris and linux.
• Good theoretical knowledge on new features in SQL Server 2008, 2012.
• Working on sharding environment.
• Created index for performance.
• Implemented wired tiger from default storage.
• Worked on basic shell scripting and created shell scripts and updated the scripts as per the requirement for automate the process.

PROFICIENT IN AN ASSORTMENT OF TECHNOLOGIES, INCLUDING;

Programming: C, C++, TSql, HTML

Operating System: WINDOWS 98|XP|2000|VISTA| and WINDOWS Server 2000, 2003, 2008, 2012,2014 & 2016

Front-end: MS-OFFICE, Foglight, SQL Client Tools, SSCM, Management Studio, Query Analyzer, SQL Profiler, SSIS, Netbackup,SQL monitoring tool, DPA(Ignite) & OEM.

Backend: Mongo db(nosql), RDBMS Concepts, SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014 & 2016, Oracle 9i & 10g

Others: SCOM 2012, Foglight Deployment and Administration and administration

WORK EXPERIENCE:

Confidential, MO

Responsibilities:

• Primarily working as a PRODUCTION support DBA giving round the clock support for SQL instances running on SQL Server 2016/ 2014/2012/2008 R2/2008 on virtual, physical and cloud environments.
• Installed, configured, and migrated to SQL Server 2016 from 2012/2008R2 on physical, virtual and cloud.
• Upgrading all the lower version from 2008, 2008 R always on environment.
• Implemented High Availability in SQL 2016 by configuring Always on Availability groups across Windows Server Failover Clustering using Failover Clustering Instances.
• Preparing the Run plans on lower environments to migrate/upgrade the sql server instances.
• Migrating the SSIS packages, SQL Jobs, Linked servers on to new instance.
• SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.
• Consolidating client foot print by planned unused databases and moving from physical server to virtual servers.
• Database refreshes will be done with Netbackups with a scheduled sql jobs.
• Set up SQL server Clustering and Always On technologies
• Migration of database from one datacenter to another datacenter by using db mirroring and XIV storage replication around 500 databases.
• Experience in working on PowerShell scripts for DBA reports.
• Experience in working on all the High Availability Disaster Recovery Methods during migration/upgrades.
• Worked on creating and maintaining Azure SQL Databases (PAAS) on singleton, elastic pool and managed instance.
• Created and managed databases on Azure Virtual Machines (IAAS).
• Involved in Performance Tuning on Production, QA and Development SQL servers for on premise and cloud-based servers on Azure VMs (IAAS).

Confidential, TX

Responsibilities:

• Installed and administered 2014 and 2016.
• Database backup taken to azure account in 2016.
• Created a table in memory for better performance in 2016.
• Installed, managed and administrated MS SQL Server 2014/2012/2008 R2/2008/2005 Production and Non-Production Servers.
• Consolidating client foot print by planned unused databases and moving from physical server to virtual servers.
• Migration of SQL Server 2008R2 to 2012/2014.
• Set up SQL server Clustering and Always On technologies
• Migrating all the databases from physical standalone to virtual cluster server.
• Migration of database from one datacenter to another datacenter by using db mirroring and XIV storage replication around 500 databases.
• Daily database refresh methods I have used are sql native restore, Flexclone restore (netapp tool) & XIV snap.
• Performed always on configuration with HA (FCI) and DR.
• Experience in working on PowerShell scripts for DBA reports.
• Experience in Configured and maintained database refresh from Production to UAT and Development Servers with NetApp FlexClone technology and XIV snaps.
• Provided End to End SQL Server Administration Support to around 900 SQL Servers.
• Designed and Implemented database maintenance plans for various database activities.
• Performing SQL Server installations, service pack upgrades configuration.
• Worked extensively on monitoring the database, checking error logs, checking the log file size and free space in the data drives.
• Worked on setting up log shipping, database mirroring and building redundancy to eliminate single point of failure and troubleshooting Log shipping and SQL clustering issues.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Used Database Consistency Checks- DBCC commands for database maintenance
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools such as Profiler and the Activity Monitor
• Running Index Tuning wizard for optimal query performance
• Performed all aspects of database administration, including backups and recovery
• Handled orphaned users while moving databases.
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
• Setting up and maintaining linked servers, replication and SQL cluster servers.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers, and query tuning.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensively worked on Business Intelligence tools such as SSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analytical tool (SSAS).
• Mongo DB administration for content assistance and proposal builder application.
• Regular mongo backups and restores on lower environments.
• Built the replication nodes for high availability.
• Upgraded mongo database from 2.2 to 3.0 versions.
• Regular heath checks on database by monitoring the space.
• Based on client required need to do collection backup and restore.
• Performing DML operation on data.
• Experience on sharding environment.
• Monitor MongoDB cluster connectivity and security
• Manage and review MongoDB log files
• File system management and monitoring

Confidential, NC

Responsibilities:

• Providing End to End SQL Server Administration Support to all the IT-managed MSSQL Servers.
• Installed and Configured MS SQL Server 2005/2008/2008 R 2/2012/2014.
• Designed and Implemented database maintenance jobs for various database activities.
• Performing SQL Server installations, SQL cluster builds, service pack upgrades and post-SQL build configurations.
• Setting up database monitoring solutions TSQL scripts and SCOM 2012, checking error logs, checking the log file size and free space in the data files and drives.
• Building redundancy to eliminate single point of failure and troubleshooting Replication, Log shipping and SQL clustering issues.
• Designing and configure Sql failover cluster instance for Sharepoint site for maintaining the DB Inventory, team technical, process and standards documents.
• Resolving SQL Clustering (FCI) Failures.
• Experience in working on PowerShell scripts for DBA reports.
• Planning storage capacity and accessing the hardware requirements for the upcoming requirements.
• Maintaining server and database level user security and conducting SOX-compliance audits.
• Worked on production Break fix issues which include performance, blocking and space related issues.
• Database Migrations from SQL &2012.
• Using UIM tool (CA monitoring tool) to monitor/Test the SQL Server Databases alerts.
• Implementing change requests, processing user work requests and resolving incident tickets.

Confidential, TX

Responsibilities:

• Performing regular server health checks before starting the business hours.
• Performed always on configuration with HA (FCI) and DR.
• Experience in Configured and maintained database refresh from Production to UAT and Development Servers with NetApp FlexClone technology.
• Automating Database refreshes on SQL Server instance
• Worked on various Recovery Models, Performing Backups & Recovery of data.
• Provided End to End SQL Server Administration Support to around 1000 SQL Servers.
• Designed and Implemented database maintenance plans for various database activities.
• Performing SQL Server installations, service pack upgrades configuration.
• Worked extensively on monitoring the database, checking error logs, checking the log file size and free space in the data drives.
• Worked on setting up log shipping, database mirroring and building redundancy to eliminate single point of failure and troubleshooting Log shipping and SQL clustering issues.
• Setting up and maintaining linked servers, replication and SQL cluster servers.
• Maintaining server and database level user security privileges.
• Experience on Working in table level partitioning for huge table for improving performance.
• Defragmentation of tables and indexes for improved performance and effective space management
• Monitored, set and controlled system capacity plan for future system requirements and made recommendations for space management and monitoring
• Implementing change requests, processing user work requests and resolving incident tickets.

Confidential

Service Design Engineer

Responsibilities:

• Involved in designing the Infrastructure of SharePoint application.
• Installed and Configured MS SQL Server 2012, 2008/2008R2/2005
• Performed migration/upgradation from lower to higher version.
• Performing regular server health checks before starting the business hours.
• Worked on various Recovery Models, Performing Backups & Recovery of data.
• Setup backup and recovery procedure using SQL native Backup.
• Provided End to End SQL Server Administration Support to around SQL and Web Servers.
• Designed and Implemented database maintenance plans for various database activities.
• Worked extensively on monitoring the database, checking error logs, checking the log file size and free space in the data drives.
• Worked on setting up log shipping, database mirroring, SQL AlwaysOn, transactional replication and building redundancy to eliminate single point of failure.
• Experience in Performing Cluster operations, failover and failback, adding dependencies and troubleshooting.
• Worked with other Technical Teams like Application Admin team, Server team and Network team to solve Performance and/or connectivity issues.
• Troubleshooting functional/technical issues in the application and raising bugs with the Env team.

Confidential

Primary DBA

Responsibilities:

• Identifying and automating frequently performed activities at work.
• Planning and configuring of MS SQL 2005/2008, SQL Cluster servers, SQL Litespeed.
• Tracking recurring issues and providing solutions/fixes.
• Installing and configuring Foglight (a third-part monitoring tool).
• Setting up and maintaining linked servers, replication and SQL cluster servers.
• Troubleshooting Replication, Log shipping and SQL clustering issues.
• Maintaining server and database level user security privileges.
• Configuring and troubleshooting Service Broker and Database mirroring.
• Monitored and controlled system capacity plan for future system requirements.
• Made recommendations for space management and monitoring.
• Handled routine administration of SQL Server 2000/2005/2008.
• Configured replication in SQL 2005 on test and production servers.
• Working on service requests (SR) raised by users to meet their needs meeting SLAs.
• Uploading report files (.rdl) in SSRS report sites and SSIS packages/files (.dtsx) to meet the business needs.

Confidential

Responsibilities:

• Involved in Installing and Configuring of MS SQL 2000/2005, SQL Cluster servers, SQL Litespeed (a third party tool for SQL server backups and restores) and upgrading servers and Migrating databases from SQL Server /2008.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Maintained server and database level user security privileges.
• Worked on performance issues and optimized SPs and queries.
• Set up and maintained linked servers, replication and SQL cluster servers.
• Maintained the database consistency with DMV and DMF’s at regular intervals.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Involved in Troubleshooting Replication, Log shipping and SQL clustering issues.
• Instrumental in Configuring and troubleshooting Service Broker and Database mirroring.
• Set up and Monitored Backup jobs and DBA maintenance jobs using ignite tool.
• Performed regular server health checks.

Confidential

Responsibilities:

• Installed and configured different edition of SQL Server 2005 like Express edition, Enterprise edition with the latest service pack.
• Successfully migrated from SQL Server 2000 to SQL Server 2005 on Development and Testing Environment.
• Created SSIS packages for the extracting, transforming and loading the data from SQL Server 2005 and flat files.
• Converted all existing DTS package of MS SQL 2000 to SSIS packages by using package migration wizard and Deployed new Package in different Server.
• Participate in Operational Calendar for maintaining DB for month and follow that Schedule
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Successfully implemented Database Mirroring in SQL Server 2005
• Created Maintenance Plans for production servers (Full, Differential and Transaction Log Backups) using Litespeed.
• Managed the SQL clustering environment.