SUMMARY:

Highly Accomplished SQL Server Database Administrator ( Total Exp . 10+ years). 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.

TECHNICAL SKILLS:

Programming: C, C++, TSql, HTML

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

Frontend: MS-OFFICE, MOM, Foglight, SQL Client Tools, SSCM, Management Studio, Query Analyzer, SQL Profiler, SSIS, SQL monitoring tool & OEM.

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

Others: SCOM 2012, Foglight Deployment and Administration and administration

PROFESSIONAL EXPERIENCE:

Confidential, TX

Responsibilities:

• Consolidating client foot print by planned unused databases and moving from physical server to virtual servers.
• 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.
• Setting up and maintaining linked servers, replication and SQL cluster servers.
• Defragmentation of tables and indexes for improved performance and effective space management
• 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 check 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 2005 to 2008 &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, TX

Responsibilities:

• Performing a role an application Service Design Engineer, responsible for Infrastructure planning, design and maintenance required Business applications
• 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

Responsibilities:

• Performing a role of Primary DBA, handling about all SQL server databases.
• 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 2000 to 2005/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.