SUMMARY:

• SQL Server DBA with around 7 Years of experience in MS SQL SERVER 2016/2014/2012 ,2008R2/2008/2005 Database Administration in Production, Test and Development environment.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server, internet\internet environments.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2014/2012/2008 R2\2008\2005.
• Expert in RDBMS S/W installation, database server builds, applying patches, Applying patches in VM environments (VTM), upgrading, configuring, trouble shooting of SQL SERVER on Windows 2000/03/08 servers and Clustered VMware Environments.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Implemented High Availability in SQL 2012/2016 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Expertise in automating the system by using System Center Operations Manager (SCOM).
• Experience in configuring Replication and troubleshooting the issues with transactional replication.
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and also to Oracle Databases.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Data Center Experience.
• Expert in raising the Service Requests and keep tracking of requests.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code and improving Efficiency.
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Hands on experience in installing, configuring, managing and troubleshooting SQL Server.
• Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2016/2014 / 2012 / 2008 / 2008 R2 / 2005, MS-Access 2000 / 2003 / 2007 , My SQL 4/5, Oracle 9i / 10g.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio.

Languages: C#, XML, SQL, T-SQL

Operating Systems: Windows 2012, Windows 2008R2, Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0/7.0, Apache, Tomcat, Amazon web services (AWS), Service Center, Virtual Private Cloud(VPC).

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSRS, DTS.

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

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Disaster Recovery/SQL Database Administrator

Responsibilities:

• Installing and configuring Windows and SQL clusters including 3 node clusters, 4 node clusters, and adding a node to an existing cluster.
• Involved in the migration of databases from SQL server 2012 to SQL server 2016.
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Assign permission to users, roles, and object. Administrate security for server’s logins with Windows and SQL Accounts.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Implemented High Availability in SQL 2012/2016 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
• Implemented and configured Central Management Servers to centralize and manage about 30 instances of SQL Server 2008 R2 and SQL 2014.
• Implemented Data Collector and Data Management Warehouse to collect performance data of all the SQL instances.
• 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.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Used server scoped DMV’s and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Involved in full life cycle of the project from Requirement analysis, Design, Development and Testing.
• Analyzed the requirements and significantly contributed in developing database architecture for the application.
• Responsible for creating the Entity-Relationship diagrams, Class diagrams, Sequence diagrams and Flow diagrams using Visio 2002 and documenting the project architecture..
• Trouble shooting and fine-tuning of databases for its performance and concurrency.
• Backing up the databases and restoring them in different environments.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Created stored procedures, views, triggers, user defined functions to apply business rules to the data.
• Worked on replication and Change Data Capture
• Involved in testing and coordinated for integration testing, deploying applications on AWS cloud.
• Involved in AWS data backup (snapshot, AMI creation) techniques, along with data-at-rest security within AWS Deploying applications on AWS Cloud.
• Worked on migration from Datacenter to AWS.
• Monitor AWS Relational Database Service (RDS) for performance and availability in Cloud Watch based on events/metrics such as CPU utilization, database connection, read/write IOPS, read/write latency etc..
• Responsible for creating the reports based on the requirements using SSRS.
• Responsible for maintaining versions of source code using Team Foundation Server.
• Involved and communicated test results for application level testing, and Integration Testing.
• Involved in writing System Documentation and Code Documentation.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: Windows 2008,2012, MS-SQL Server 2016/ 2014/2012/2008 r2,T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, AWS,RDS, TFS,Alloy and TSRM Ticketing System.

Confidential, St. Louis MO

SQL Server DBA

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Created and maintained various databases for Production, Development and Testing environments using MS SQL Server 2014, 2012, 2008r2, 2008, 2005.
• 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.
• Conducted Database mirroring in High Performance and High Availability mode and trouble-shooted issues with witness servers.
• Worked on 2014 AlwaysOn High Availability node and the Availability Groups node.
• Involved in migration of SQL 2012 TO SQL 2014.
• Performed daily backups and developed recovery procedures.
• Patching all the SQL Servers 2008, 2008R2, 2012, 2014 with the latest service packs.
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Developed T-SQL Scripts with joins, sub queries and co-related sub queries where required. 
• Designed and Created databases, tables, views, stored procedures and DDL & DML triggers. 
•  Implement SQL Server security and object permissions such as maintain database authentication modes, creation of users, configuring permissions and assigning roles to users. 
• Design and implementation of large databases and data warehouses utilizing both relational and dimensional design concepts.
• Proficiency in analyzing large sets of data.
• Experienced in performance tuning using windows performance monitor and SQL profiler of MS SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Trouble-shooted issues with log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• 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
• Handled the database components of application releases
• Handled 24/7 production issues.
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Developed few reports using SSRS.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting..
• 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.
• Working with Remedy Tickets (Any changes on staging and development environment need to Create Remedy Tickets)
• 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 2003/2008,2012, MS-SQL Server 2014/2012/2008 r2/2005, .NET Framework, Visual Studio, i3 performance tool,SSRS,Powershell, Sites Scope monitoring tool, IDERA tool, PowerShell ,VMware machines, AJAX, Visual Studio,AWS, HTML, XML, XSLT,Servicenow.

Confidential, Richmond, VA

SQL Server DBA\ Developer

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• Migrating Databases from SQL Server 2005 to SQL Server 2008R2/2012.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• 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.
• Checking Database Health by using DBCC Commands.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSRS, ReportBuilder, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, San Antonio, TX

SQL Server DBA

Responsibilities:

• Installing, Configuring and Administering SQL server 2012, 2008R2.
• Developed backup strategies for Database Recovery.
• Performing Database maintenance activities like Backups, Restoring.
• As a part of the DBA team providing 24/7 production support to the clients.
• Creating and Monitoring the Scheduled jobs.
• Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options.
• Configured and administered SQL Clusters (Active/Passive, Active/Active).
• Experience in Understanding structured data analysis, data models and data normalization.
• Good experience in resolving blocking/locking and dead locks Issues.
• Verifying Index Fragmentation and performing re-org and rebuild as per %.
• Troubleshooting Log shipping and Database Mirroring and the failed jobs.
• Worked on migration from SQL 2005 to SQL 2012/2008R2 including databases, logins, users, jobs, DTS packages.
• Worked on setting up backup jobs for OLAP databases.
• Monitored and resolved Log shipping out of sync issues.
• Created and managed maintenance jobs for performing SQL Backups, DBCC, and Index creation/recreation.
• Performing daily tasks like Backup & DBCC job verifications and check in failures.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Verifying all error log files for any new entries.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server.  
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2005, 2008 and databases.

Environment: Windows 2003/2008,MS-SQL Server 2012/2008r2/2005, .NET Framework, Visual Studio, i3 performance tool, SSIS and SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, AJAX, Visual Studio, HTML, XML, XSLT.

Confidential, Dallas, TX

SQL Server DBA   

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008R2 in Production and test Environments.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.
• Creating Databases and Logins & users with permissions in SQL Server 2005/2008.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Define db scripts versioning system to keep track of database versions for all environments.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• 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.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Used server scoped’s and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Involved in full life cycle of the project from Requirement analysis, Design, Development and Testing..
• 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. 

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

Confidential

Jr Database Admin

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• 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.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: SQL Server 2008/2005, T-SQL, CVS, Windows NT/2000/XP