SUMMARY:

• 7 years of experience in Database Administration for very large and complex databases in MSSQL 2000/2005/2008/2008 R 2/2012/2014/2016 in Production, Test and Development environment.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2016/ 2014/2012/2008 R 2/2008/2005.
• Experience in Database Administration, Supporting, MS SQL Server 2000/2005/2008/2 Production database in Replication/Mirroring & Cluster Server Environments.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experience on SQL Server 2005/2008/2012 tools like SQL Server Profiler, SQL Server Agent, Execution Plan, Performance monitor, DBCC commands and troubleshooting and SQL Server Surface Area Configuration, Database Engine Tuning Advisor.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Always On.
• Managed day - to-day User activities like creating logins, granting permissions, applying security for new users, manually running the jobs etc.
• Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Scheduled Replication process for updating our parallel servers.
• Experience in creating database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.
• Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSRS)
• Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery.
• Designed and implemented incremental and full backup policies and procedures.
• Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.
• Worked Clustering environment and configures SQL server cluster groups as a High Availability Solutions.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Monitoring server health, capacity planning, analyzing risk & reporting potential

TECHNICAL SKILLS:

Relational Databases: MS-SQL Server 2000/2005/2008/2008 R2/2012/2014,2016 Oracle, MS Access 2003/ 2007.

Operating Systems: Windows 2016/2012/2008/2003/2000/ Professional/ NT 4.0 Advanced Server

Database Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Business Intelligence Studio, Profiler, Query Analyzer, Export & Import, and Precise i3 for SQL Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Languages: T-SQL, Java

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor.

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Sr. SQL Server DBA

Responsibilities:

• Experience working with SQL servers/databases (2000, 2005, 2008, 2008R2, 2012,2014,2016).
• Implemented and tested all the Microsoft recommended best practices and configurations during pre and post migration steps at instance and database level before going to production.
• Migrated SQL server 2000, 2005, 2008, 2008 R2 to SQL Server 2012, 2016 in Microsoft Windows Server Enterprise Edition.
• Worked with Terabytes of Data with over 2000 databases.
• Planning the location of Data, Index, and Transaction log files on the disk.
• Setup and configured Always on Availability Groups for DR and Reporting.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Used DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Configured Database mail, linked servers.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Ensure backups are functioning correctly by monitoring and testing database backups.
• Migrated databases from .
• Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
• Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using Database Mail.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Monitoring the servers using third party software.
• Performed Production support and on Call duties.
• Developed database administration reports for disk utilization, backup check, daily Replication status check, Job status and other daily monitoring tasks.
• Performed Production support and on Call duties.
• Used SQL Profiler, Server-side trace to identify performance issues on the server.
• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
• Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.
• Implemented High Availability in SQL 2012 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances.
• Performing root cause analysis on the production issues.
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail.
• Worked on Data Archival on Server Decommissioning process.
• Performed Database refreshes from Prod to UAT and Dev servers.

Environment: MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005, 2000, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio.

Confidential, Omaha, NE

Sr. SQL Server DBA

Responsibilities:

• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• High Availability Disaster Recovery during SQL 2014 migration.
• Migration of 2005 and and 2014 Migrations.
• Production supporting DBA activities in OLTP environments.
• Query tuning based on High CPU, Memory and Logical reads and writes.
• Analyzing and designing and implementing different types of Replication Models.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Configured log-shipping, replication for some of the databases.
• Installed SQL Server 2016 on some of the newly procured servers.
• Solving the request raised by user support.
• Migrating databases from SQL Server 2005/2008 to SQL Server 2012/2014 as part of Data Center migration.
• Setup and configured Always on Availability Groups for DR and Reporting.
• Created ETL Process Consisting of SSIS Packages, Stored procedures, PowerShell Scripts and SQL Agent jobs.
• Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results etc.
• Provide input for future projects during the planning, design, implementation and maintenance phases of development.
• Installed and configured Synchronous and Asynchronous Mirroring for Production and DR environments.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeeded.
• Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
• Maintaining SQL Script for creation of Database Objects.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005, 2000, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio.

Confidential, Norfolk, VA

Sr. SQL Server DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining SQL Servers database servers in prod., Dev, UAT, SIT and QA Environments
• Installed SQL Server 2014 and SQL Server 2012 on windows 2012 servers, applied service packs and security fix for all servers.
• Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
• Involved in implementation of Replications like Snapshot and Transactional in OLTP environments.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR.
• Implemented Failover clustering for Active/Active and Active/Passive for High availability and Managed SQL Server Clusters in a SAN environment
• Extensive experience with SSIS packages in creating ad hoc reports using EXCEL and XML files, used as a ETL tool to pull data from SQL server(OLTP) to Teradata(data warehouse), maintenance tasks, providing alerts through email, Scheduling tasks and to generate scripts during migration and upgradation.
• Upgraded server from MS SQL Server 2008/2008R2 to MS SQL Server 2012.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Experience in taking Backups and restoring using various 3rd party tools and created Disaster recovery strategy and automated the tools to perform scheduled backups.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Implemented High Availability in SQL 2012 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Worked extensively in performance tuning of databases including query tuning, server tuning.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Managing and Coordinating with the offshore team on daily Database maintenance activities
• Worked as a team member for 24X7 on call production support.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Creating, Scheduling and deploying extensive SSIS packages from Development to Production.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues.
• Administer, maintain, develops and recommends policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery & Automation of Backups using maintenance plans.

Environment: SQL Server 2012/2008R2/2005, Windows 2003/2008, ETL, SSIS, SSRS, .ASP, VB scripting, MS Excel and MS Access, Oracle, Teradata, SSAS, System Monitor / Performance Monitor.

Confidential, Sanjose, CA

SQL Server DBA.

Responsibilities:

• Managed 100+ Prod. Dev and UAT SQL Servers in Virtual and Physical Environments.
• Installed and configured SQL Server 2012,2008 R2 and SQL Server 2005 on windows 2008 R2 and 2012 servers, applied service packs and security fix for all servers.
• Planning and implementation of database backup/restore and disaster recovery.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R2.
• Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2
• Installed and configured Mirroring for Production and DR environments
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Performance Monitoring of MS SQL Server 2005/2008.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Involved and communicated test results for application level testing, and Integration Testing.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Performed Database refreshes from Production to UAT and Development servers.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Experience with third party tools like Fog Light, etc.
• Used extensive SQL Server DMV's for Performance and System Monitoring
• Creating, Scheduling and deploying extensive SSIS packages from Development to Production.
• Performance tuning, and optimization of procedures and queries.
• Worked on replication and Change Data Capture.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Helping application teams in query analyzing and its optimization. Coordinating with users for downtime.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.
• Create and maintain SSIS packages (for data transformation).
• Created extensive reports using SSRS (Tabular, Matrix).
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Develop and recommend policies and procedures for ensuring the security and integrity of the company’s databases.

Environment: SQL Server 2012/2008R2/2005, Windows 2003/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel and MS Access, Oracle.

Confidential

SQL Server DBA.

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008R2/2012 on Various Production Servers.
• Involved in the migration of databases from SQL server 2005 to SQL server 2008 R2.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Working on Projects to provide DBA support for building SQL Servers for new applications (begin to end support).
• Enabled Transparent Data Encryption on critical databases.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Used server scoped DMV’s and database scoped DMV’s to troubleshoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS).
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for applications by using T-SQL.
• Used log shipping for synchronization of databases.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Implementing Load balancing Replication across the Databases.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• 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.
• 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.
• Developed few reports using MS SQL Reporting Services
• Involved and communicated test results for application level testing, and Integration Testing.
• Setup, monitor, and resolve database mirror issues.
• Apply SQL service packs and patches.
• Involved in writing System Documentation.
• Used Various Third-Party tools for monitoring SQL Servers and Backing up Databases.

Environment: T-SQL, Query Analyzer, SQL-Profiler, Windows 2003/2008, SQL Navigator. SQL Server 2000/2005 Enterprise Edition, Crystal Report 11.0 SQL Server Reporting services (SSRS) SQL Server Management Studio (SSMS), IIS and Oracle.

Confidential

INTERN

Responsibilities:

• Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.
• Managing of database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Configured the Log shipping and scheduled jobs to setup log shipping between production servers.
• Planning and applying latest Service Packs to different versions of SQL Server.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.
• Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Users and Roles, and managed security and permission of different SQL Server objects.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Migrated SQL server 2005 databases into SQL server 2008 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Generated Complex reports using Cascading parameters like Snapshot reports, Drill-down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on Business Requirement Document.
• Assign permission to users, roles, and object. Administer security for server’s logins with Windows and SQL Accounts.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003, T-SQL, HTML 4.0.