SUMMARY

• 7+ years of strong professional experience as Database Administrator in SQL Server 2016/2014/2012/2008 R2/2005/2000 in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP).
• Highly experienced in installing, configuring, and administering SQL Server 2016/2014/2012/2008 R2 on Standalone, Cluster and VM Ware Servers with Wintel OS (Windows Server 2016/2014/2012/2008 ).
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, User Defined Data - Types, Rules, And Defaults.
• Expertise Experience in provisioning and configuring Servers and Databases in Microsoft Azure Platform as a Service (PaaS) and Microsoft Azure Infrastructure as a Service (IaaS).
• Expertise in Migration\Upgrade of SQL Servers ranging from 2000 and to higher versions of SQL Servers.
• Extensive experience in designing and administration of SQL Servers in multi node clustering with Active/Active, Active/Passive Architecture.
• Extensive experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Fail-over) and Non-Clustered Environments.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Replication, Linked Servers, Database Maintenance Plan.
• Handled up to 4 TB databases in Clustered environment with good Physical storage configuration.
• Ample experience in implementing Replication Models (Snapshot, Merge and Transactional) with different topologies.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Highly experienced with Business Intelligence in MS SQL Server 2014/2008R2 in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Experience in using tools likeSQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Good noledge and working exposure in Storage Concepts of RAID levels and SAN environment.
• Deployed SSIS packages from various Dev environments to QA and Prod.
• Database Integrity Checks, Update Database Statistics, and Re-indexing.
• Experience in Extracting, Transforming, and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server DTS and SSIS services.
• Experience in creating and scheduling SQL Server Integration Services (SSIS) packages.
• Migrated DTS packages to SSIS packages.
• Used SSRS for daily client reporting.
• Experience in using features of SQL Server 2008 and above versions like Spatial, CDC, Encryption, File stream Data functionality, Data Compression, and Transparent Data Encryption (TDE).
• Expert in Tuning the SQL Server with tools like SQL Server Profiler, Database Engine Tuning Advisor, PerfMon and use DBCC commands and Dynamic Management Views for monitoring and tuning.
• Good working noledge in .Net Framework 2.0/3.0/3.5, VB.Net, C#, ASP.Net, ADO.Net, XML and Web Services.
• Provided expertise in Data warehouse\Data Marts methodologies as well as extensive noledge of OLTP/OLAP technologies. Well Versed with Different Data warehouse and Data Mart Building methodologies.
• Experience in raising the Service Requests and keep tracking of requests.
• Experience in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Maintaining the Service Level Agreements (SLA’s) according to the client’s requirement.
• A Team Player with Excellent Written, Analytical Skills, and Verbal Communication skills with a customer service oriented attitude. Worked with offshore team as onsite coordinator to provide updates on daily basis.
• Highly organized, ability to manage multiple tasks and meet deadlines. Capable of working independently with minimal supervision.

TECHNICAL SKILLS

Platforms: Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/2008 server/2012Server/2014 PSI, VM Ware servers.

Databases: SQL SERVER 2000/2005/2008/2008 R 2/2012/2014/2016, MySQL, MS-Access, MongoDB.

Backup Tools: Tivoli Data Protection (TDP), Tivoli Storage Manager (TSM), LiteSpeed, NetBackup

Programming Languages: SQL, Python, PL/SQL, VB, VB.Net, C, C#, VBScript

Web Technologies: Asp.Net, HTML, CSS, XML, Java Script

Tools: SQL Server Management Studio / Enterprise Manager, IDERA, SQL Diagnostic manager, IDERA SQL safe, SSRS, SSAS, SSIS, Enterprise Manager, SSMS, Visual Studio 2005/2008/2012/2014/2016, Quest, Red Gate, SCOM, ESM, RSAM.

Cloud Platforms: Microsoft Azure, Amazon Web Services (AWS).

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

SQL Server DBA

Responsibilities:

• Installed, managed and administrated SQL Server 2016/2014/2012/2008 R2 Databases.
• Creating and administering Databases in Cloud - Azure SQL and on-premises environment.
• Migration of SQL Server 2008R2 to SQL Server 2012.
• Implemented SQL Server 2012 new features like Always on Availability Groups for high availability of multiple databases in place of database mirroring.
• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using PowerShell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Monitored Log shipping/Transactional Replication and troubleshooting of errors.
• Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments.
• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Rebuilt indexes with different fill factors and update statistics manually.
• Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Involved in the installation, configuration and support of Oracle 11g R2 databases.
• Execute Hot, Cold backups and recoveries.
• Used Database Consistency Checks - DBCC commands for database maintenance
• Supported load and performance (L&P) testing and suggested design fixes.
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
• Running Index tuning wizard for optimal query performance.
• Handled orphan users while moving databases.
• Used SSIS to populate data from various data sources and also in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
• Used SSRS to create reports dat draw content from a variety of data sources
• Define DB scripts versioning system to keep track of database versions for all environments
• Prepared the reports for the day-to-day as well as weekly/monthly purposes
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies
• Worked on documentation of the projects in the SharePoint
• Used HP Service Manager System for managing and completing all service requests.

Environment: TSQL, MSSQL SERVER 2008R2/2012/2014, SSRS, SSMS, VISUAL STUDIO 2010/2012, WINDOWS Enterprise Server 2008/2012, IIS, RMAN, Linux 6.0 RHEL, Virtual box.

Confidential, Cleveland, OH

SQL Server DBA

Responsibilities:

• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2008R2, 2012, 2014, and 2016.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Use of PowerShell scripting to automate jobs and reporting on the centralized database environment.
• Worked as a SQL developer/DBA for inventory application which involved design and development of database, stored procedures and SQL queries. Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Involved in migration of SQL 2005 TO SQL 2008R2, 2012, 2014.
• Performed daily backups and developed recovery procedures.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshoot issues. Applied hot fixes/Service packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshoot issues with witness servers.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 4 Terabytes.
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Troubleshooting issues with log file full and database size increasing beyond threshold.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Provided support to the application developers on the application databases.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Developed few reports using MS SQL Reporting Services.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
• Proactively monitored, determined, and solved issues at SQL/database/server levels.

Environment: Windows 10/8/7, MS-SQL Server 2008R2/2012, .NET Framework, Visual Studio, i3 performance tool, SSIS and SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, Visual Studio, HTML, XML.

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Planned and Successfully Installed SQL Server 2005, 2008,2008R2,2012 on the Production and
• Development Servers.
• Successfully Installed the Service Packs and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.
• Involved in migrating the existing 2005 databases to SQL Server 2008R2, 2012, and 2014 (Side by Side).
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Raising the change management request and following up with the customer approval, for making any changes in the production server.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional and Merge.
• Implementing Database maintenance plan for Database consistence & Integrity
• On call 24/7 support to databases on weekly rotation.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Used SSRS to build health check reports & deploying the SSRS.
• Monitoring SQL server performance using profiler to find the performance and deadlocks.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Recovered many Databases at the time of Database crashes or data loss.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Lite Speed, BCP, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows 7 and Windows 2008 & 2012 Server.

Confidential

SQL DBA

Responsibilities:

• Installed SQL server 2005 on windows 2003 advanced servers, applied security fixes.
• Involved in Migrating SQL Server 2000 Servers to SQL server 2005.
• Installed and Configured MS SQL Server 2005, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models dat describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server.
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2000/2005.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle, Sybase and DB2 UDB.
• Implemented MS SQL Server security policies and granted object level permissions.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.

Environment: SQL Server 2000/2005/2008 Enterprise Edition with Clustering, OLTP & OLAP environment dat includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Teradata, DB2 UDB.