SUMMARY:

• Over 10+ years of experience as SQL Server DBA (2016,2014, 2012, 2008, 2005, and 2000) in Production, Development and Staging, Data Warehouse environments (OLTP and OLAP) with healthcare, financial, insurance and retail management domains
• Certified MS SQL Server Database Administrator (MCITP - DBA)
• Certified SQL Server Administrator through BrainBench
• Experience in SQL Server 2016 installation, configuration and post installation validation.
• Experience in SQL Server migration from SQL 2005,2008R2 to SQL 2016 version.
• Experience in MS SQL Server Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, Backup/Recovery and Running DBCC Commands
• Experience in applying latest Service Packs and Rolling Patches and Upgrades for SQL Servers in Clustered (Failover) and Non-Clustered environments
• Experience in Configuration and Maintenance of Disaster Recovery solutions like Clustering, Database Mirroring, Log Shipping, Transactional & Merge Replication in SQL Server 2012/2008/2005
• Experience in using third party tools like Redgate, IDERA, Avamar, SQL Sentry, Symentic Backup for DB backups and restore.
• Installed and Configured SQL server 2014 on VMware environment.
• Have good experience with VMware ESXi servers
• Prepare, document and conduct Disaster Recovery exercises.
• Migrated SQL Server 2005 databases to SQL Server 2014 and configured Always on availability group.
• Managing SQL server using PowerShell scripts.
• Expertise in ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Encrypted data and log files using transparent data encryption (TDE) solution.
• Involved in Implementing of multiple multi-node clustered community environments, which supported multiple instances of SQL Server 2005 and later
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshooted issues with the same. Applied Hotfixes and Service Packs in clustered environments
• Configured Database Mirroring in High Performance and High Availability mode and troubleshooted issues with the same
• Experience in supporting Very Large databases (VLDB) like SAP and troubleshooting the associated problems
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Deadlocks and Handling the Isolation Level and Concurrency Effects
• Verifying and tuning stored procedures created by developers by using Execution Plans, SQL Server Profiler and Database Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Experience in administrative activities comprising Database Health Check, Index Optimization (Rebuild and Reorganizing Indexes with different fill factors), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, Database Security
• 24/7 Production Databases on Call Support
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Experience in BI Development and Deployment of DTS, SSIS packages to migrate data from MS-Access, Excel, Oracle, and Teradata
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service
• Worked closely with management, applications development Team, and users on database solutions to resolve business problems
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills

TECHNICAL SKILLS:

Relational Databases: SQL Server 2014/ 2012/2008/2005 /2000/7.0, Oracle 11g, 10g, 9i, 8.0, MS Access, DB2, SQL*PLUS

Operating Systems: UNIX, Windows 2000/2003/2008/2012 Server, Windows NT, XP

Languages: C, C++, PL/SQL, Java, VB and T-SQL

Web Technologies: ASP.NET, VB.NET, Web Services, HTML, DHTML, Java Script, VBScript, IIS, Application Server,SAP

Other Tools: VERITAS, IDERA, Crystal Reports, Test Director, PVCS Tracker, Rational Clear Quest, Compuware, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Sr. SQL Server DBA

Responsibilities:

• Involved in installation and configuration of SQL Server 2016 and implemented post installation validations steps.
• Prepared project related documents like SQL Server installation and migration.
• Installed SQL Server 2016 upgrade advisor and run on list of migration servers related to SQL 2005 and 2008R2.
• Migrated databases from SQL 2005, 2008R2 to SQL 2016.
• Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
• Recommended and implemented database security policies like using only Active Directory accounts that are consistent with security guidelines and best practices.
• Safeguarding data by instilling backup, managing user access and securing databases.
• Proactively monitored the database health through automated scripts and using DBCC utilities.
• Supported production based tickets using ServiceNow ticketing system.
• Involved in troubleshooting various database server issues to free up log space, update statistics, SQL Agent Job failures.
• Create various database objects, and create users with appropriate roles and levels of security.

Confidential, Austin, TX

Sr. SQL Server DBA

Responsibilities:

• Actively involved in installing and configuration of SQL Server 2008R2, 2node failover cluster set up in active/active environment as a High Availability mechanism.
• Expertise in migrating databases from physical to virtual environment.
• Working with different infrastructures like vSphere and EMC XtremIO storage array.
• Worked closely with application team, manager for planning and implementation of the migration.
• Ensure backup strategy is functioning correctly by monitoring and testing database backups.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Monitor database performance and advice on database tuning, index/query optimization and on additional hardware.
• Managed indexes on tables using various SQL Server Commands to reduce fragmentation.
• Validate disaster recovery strategy and provide recommendations for improvements.
• Verify database change scripts before promotion into production environments.
• Troubleshoot SQL Server unplanned outages, including during evenings and weekends.
• Provide input for future projects during the planning, design, implementation and maintenance phases of development.
• Creation of stored procs to cleanup data with minimum retention period.
• Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using Database Mail.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and indexing updates.
• Database refreshes from prod to stage, test and development environments.

Confidential, Overland Park, KS

Sr. SQL Server DBA

Responsibilities:

• Deeply involved in design, planning and execution of migration plan to migrate / decommission all application instances and servers.
• Collaboration with project management teams, vendors representatives, and technical subject matter experts to implement database and application migrations.
• Successfully managed migration of very complex infrastructure and critical production environments with no impact to business.
• Prepared documents like High Level & Low Level Design Templates, Migration implementation plan, HLD-SQL Database Configuration.
• Performed daily tasks including SQL Jobs, backup and restore by using Avamar Backup tool.
• Developed and tested extraction, transformation, and load (ETL) processes.
• Designed and developed ETL and Data Quality mappings to load and transform data from flat files to Salesforce.
• Involved in Datacenter migration and Responsible for Application and Server Migration from one domain to another domain.
• As a production DBA working on production and maintenance incidents, tracking and resolving them on daily basis.
• Install and run the Microsoft Assessment and Planning (MAP) Toolkit to investigate server inventory, assessment, and reporting tool that can securely assess IT environments for various platform migrations - including Windows 8.1, Windows 7, Office 2013, Office 2010, Office 365, Windows Server 2012 and Windows 2012 R2.
• Hands on experience in Installation and verification of Microsoft SQL server 2014.
• Implemented high availability with AlwaysOn Availability Groups with 3 replicas on migrated instances.
• Developed stored procedures, functions, triggers and views using T-SQL.
• Host weekly status meetings with senior management, business and technology teams.
• Performed Administrative tasks in SQL Server using PowerShell.
• Extensive experience with Backing Up, Restoring and Moving of Databases.
• Monitoring and Troubleshooting SQL Server by using SQL Sentry, Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2012.
• Maintaining USER PERMISSIONS, LOGINS and SECURITY Issues. Monitoring Event Viewers, SQL Error logs and Log Files.
• Automating administration tasks like regular db refreshes, managing SSIS packages, managing security, monitor server performance and activities.
• Good experience with Performance Tuning, Disaster Recovery, High Availability Clustering, Replication, Mirroring and Log Shipping.

Confidential, Lexington, KY

Sr. SQL Server DBA

Responsibilities:

• Responsible for day-to-day support of 35 SQL production servers and around 900 databases. The largest database is 1TB.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Installed and Configured SQL server 2014.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Expertise in ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases using IDERA Diagnostic Manager.
• Proactively monitor and profile production database servers for load and performance bottlenecks and provide solutions for query optimization and performance tuning.
• Performed daily tasks including SQL Jobs, backup and restore by using Redgate Backup tool.
• Daily tasks of DBA like space issues on Production Servers and handling maintenance Jobs handling and user’s permissions.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Confidential, Cleveland, OH

Sr. SQL Server DBA

Responsibilities:

• As a production DBA involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshooted issues with the same. Applied hot fixes and Service Packs in clustering environments
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012, 2008r2, 2005
• Conducted Database Mirroring in High Performance and High Availability mode and troubleshooted issues with witness servers
• 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
• Experience in Configuring, Managing and troubleshooting on SQL Server connection protocols like Kerberos and NTLM
• Expertise in registering a SPN for Kerberos Connection and Performing NTML Failback
• Expertise in fixing several issues while using Kerberos and NTLM authentication like "Login Failed for user", "Could not open a connection to SQL Server", "Cannot generate SSPI Context", etc.
• Involved in migration of SQL 2005 TO SQL 2008r2
• Performed daily backups and developed recovery procedures
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools
• Involved in Change Control Management and follow the discipline of systematically identifying and controlling change requests of a project from both internal and external sources
• Troubleshooted issues with log file full and database size increasing beyond threshold errors
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Capacity Planning, Data Modeling and Logical/Physical Database Design
• Provided support to the application developers on the application databases
• Handled the database components of application releases
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users
• Managed 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
• Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions using TOAD and SSMS
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting
• Worked closely with development teams for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts et.
• Extracted data from various sources like SQL Server 2005/2008/2012, Oracle, Teradata, .CSV, Excel and Text files from Clients using FTP servers
• Involved in all ITIL process like Change management, Incident Management & Problem Management
• 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
• 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
• Proactively monitored, determined and solved issues at sql/database/server levels with the help of SCOM server and its agents
• Handled 24/7 production issues

Confidential, MO

Sr. SQL Server DBA

Responsibilities:

• Ensure backups and redundancy is maintained to assure failover mechanisms
• Proactively monitor the database systems to ensure secure services with minimum downtime
• Troubleshoot and problem solving of SQL related issues, including advising on customer issues
• Set up SQL server cluster and Always ON technologies
• Data Migration (transformations) from DB2 & Oracle to SQL Server 2012/2008 using SSIS, BCP and Import/export tools
• Developing queries and various database objects like stored procedures, functions and triggers using TOAD and SSMS
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder
• Improve and maintain databases to include rollout and upgrades
• Implement and release database changes according to agreed time scales and costs
• Monitoring SQL instances and correcting issues that arise
• Work with application development staff to abide by database architectures, coding standards, and quality assurance policies and procedures
• Work with Application Development Manager to create models for new database development and/or changes to existing ones
• Install and configure relevant network components to ensure database access as well as database consistency and integrity as approved by management
• Respond to and resolve database access and performance issues
• Monitor database system details within the database, including sp’s and their execution time
• Monitor, optimize and allocate physical data storage for database systems as approved by management
• Experience with SCOM to monitor and manage critical database servers from a centralized location
• Create, or support creation of, required reports in response to business user needs
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts
• Assist with database transaction and security audits
• Develop routines for end-users to facilitate best practices for database use
• Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases
• Setup, monitor, and resolve database mirror issues
• Apply SQL service packs and patches

Confidential, Springfield IL

Sr. SQL Server DBA

Responsibilities

• Experience in installing and configuring Windows and SQL clusters
• Performed regular Administration activities from managing system resources, users and database to the fine-tuning level and implemented projects successfully
• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Configured Transactional Replication and Log Shipping with SQL Server Management
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Ensured that all business critical processes and architectural components are clearly documented
• Worked on Dynamics CRM as a server-client application
• Setup system center operations manager agents on critical database servers. Used SCOM to monitor the health and performance of the critical database servers with help of various alerts and historic information stored on SCOM database
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Performed production support and on call duties
• Made efforts to identify and recommend Standard Policies & Procedures where they might not exist or need enhancement. Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them)
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization
• Master in performing administrative tasks: database files management, backup/restore, Database Mirroring, data integration and synchronization
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2008/2008R2
• Responsible for performance tuning, optimizing of queries (TSQL statements), removing redundant and inconsistent data, optimizing joins between various tables and also their normalization
• Conducted risk evaluation of database security for enterprise wide SQL server Databases and managed mitigation of identified areas with diverse teams in a record time

Confidential, Pittsburgh, PA

SQL DBA/DEVELOPER

Responsibilities:

• Involved in Installation and Maintenance of SQL Server 2005 and 2008 R2 on Development, UAT and Production Environments
• Maintaining SQL Server 2008R2/2008/2005 (64 bit) on Active/ Passive Cluster with latest Service Packs, Hot Fixes
• Monitoring and making recommendations for performance improvement in hosted databases
• This involved index creation, index modification, code optimization and adding scheduled jobs to re-index and update statistics in databases
• Providing production support to the users
• Maintain the integrity, availability, and recoverability of all production data systems. Planning for overall data deployment and operational health
• Setup database HA environment (Replication, Log Shipping) & supported Application DR test
• Responsible and Involved in SQL Server Performance Monitoring, Server and Database optimization and Query tuning
• Analyzed database performance with SQL Profiler and Perfmon Optimized indexes to significantly improve queries
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues
• Conducting Database Refresh once in every week from PROD to UAT, DEV, and Test Environments
• Monitoring SQL server Error logs, Disk Space growth, Clustering Environment
• Planning and applying latest Service Packs to different versions of SQL Server
• Worked on performance and tuning, identifying locking and blocking for long running queries
• Monitoring clients' application and escalating code bugs to development team. Supports Production, UAT, and Development Environment
• Implemented the Security Best Practices for Databases using the Policy Based Management in SQL Server 2008
• Worked with Backup Compression, Policy-based management, Resource Governor, SQL Server Audit
• Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes/key and SSIS Configuration Scripts
• Updated the existing stored procedures to eliminate cross server joins
• Involved in cleaning up and archive the redundant data from production server
• Maintained the table performance by following the tuning tips like normalization, creating Indexes
• Created Views as per the technical design
• Involved in developing ad-hoc queries and pl/sql procedures using TOAD
• Involved in Upgrading DTS packages to SSIS. Creating flowcharts for DTS packages for review
• Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill- down Reports, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on Business Requirement Document
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005

Confidential

Jr. SQL DBA/Developer

Responsibilities:

• Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Implementing Load balancing Replication across the Databases
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O