Sql Server Database administration
Resume:
SAI CHARAN GUMMADI
*******.**********@*****.***
PROFESSIONAL SUMMARY
Over 8 years of experience in SQL Server database administration and development for very large and complex databases in SQL Server 2016, 2014, 2012, 2008 and 2005.
Extensive experience in Installation, Configuration and Administration of SQL server in a Clustered and Stand-Alone environment.
Experience in configuring and working with MS SQL Server 2008 on VMware Environment.
Expert level skills in creating objects like Tables, Views, Functions, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T-SQL statements.
Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC, Re-indexing, Updating Statistics and online indexing. Expertise in SQL server Backup/Restore, having knowledge in upgrading of SQL servers.
Have extensive experience in DBCC and DMV's to check the health of the server.
Solid experience on High availability& Disaster recovery techniques like Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active-Active).
Implemented Always-on Availability Groups.
Experienced in Administering, configuring and managing SAN, EMC storage for backups and disaster recoveries.
Experience in creating and implementing maintenance plan with stored procedures, T-SQL Scripts to ensure smooth running of SQL server.
Experience in storage capacity planning, experience in regular maintenance activities like performance tuning, query tuning, update statistics, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues using DMV’s and DBCC commands.
Experience in automation of administrative tasks like creating Jobs, Alerts using SQL server Agent.
Expert in using Third party tools like Lite Speed, Red Gate to speed up backup operations.
Extensive experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis.
Configured TempDB with respect to the no of processors and resolved Application connectivity issues like connection timeouts, connection pooling and Blocking, Dead lock issues.
Implemented scripts to find out the orphan users in the servers and also successfully migrated logins and users between multiple servers. And also creating the audit reports as per the business requirements.
Experience in configuring DB Mail and Migration of Data from Excel, Flat file, Oracle to MS SQL server by using SSIS, BCP and DTS utility.
Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
Monitoring Event Viewer, SQL Error logs and Log File Viewer for rectifying the errors.
Experienced in SSRS dashboard, table, chart report designing and deploying
on Share point / SQL server.
Experience in creating various type of reports such as Complex drill down, drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.
Experience in In-Place and Side-by-Side migration of MS SQL server 2008/2008R2 and 2008R2 to 2012/2014/2016.
Experience working with change control process/change management which involves development, testing and production.
Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures in Database Management Prod Guide.
Had experience on SAN environments, RAID levels, VMwareEnvironments.
Design, Plan and create Azure virtual machines, Implement and manage virtual networking within Azure and connect to on-premises environments.
I have experience working on FACETS, which was used to process medical claims and hospital claims.
Experience in Oracle 11g/10g Databases installation and configuration.
Acquainted with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and Agile methodologies including SCRUM and Sprints.
Had a very good knowledge in network protocols (TCP/IP, FTP) and network devices (Routers, Switches, Fibers) and also involved in Networking Administration.
Strong experience in mentoring junior team members, documentation.
Extensively worked in 24x7 Production environment.
Education:
●B.S in Computer science from Acharya Nagarjuna University, A.P, India.
Technical Skills:
Programming Languages
C, C#, T-SQL, PowerShell, Core Java
RDBMS
MS-SQL Server 2000/2005/2008/2008R2/2012,Microsoft Access, Oracle 11g/10g
IDE Tools
Visual Studio.Net 2005/2008/2012
ETL Tools
SQL Server Integration Services(SSIS) 2005/2008/2008R2/2012, DTS
OLAP Tools
SQL Server Analysis Services (SSAS) 2005/2008/2008R2/2012
Reporting Tools
SQL Server Reporting Services (SSRS) 2005/2008/2012
Database Tools
SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), Enterprise Manager, SQL Profiler, Query Analyzer, Oracle 10g, 11g
Operating Systems
Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003/2008/2008R2/2012, Linux, Unix, Mac OSX.
PROFESSIONAL EXPERIENCE:
NCR Corp, Duluth, GA
Role: SQL Server DBA Sept 2015- Till Date Responsibilities:
Installation and configuration of SQL server 2016/2014/2012 and applying service packs in both Cluster and stand-alone environments.
Led database migration from SQL Server 2005/2008 to SQL Server 2008R2/2012/2014/2016.
Configured and worked with MS SQL Server 2008 on VMware Environment.
Tuned queries which are running slow using different ways such as evaluating joins, indexes, updating Statistics and code modifications.
Involved in daily routine activities like backup, restore, refreshing databases as per requirements.
Applied Patches and Service packs to update different versions of MS SQL Server in Clustered and standalone environments.
Configured log shipping with monitoring instance as a disaster recovery solution.
Configured, monitored and troubleshoot of SQL Server Always On High Availability groups in between the data centers.
Involved in Capacity planning and index maintenance plans like rebuild&reorganizing the indexes according to index fragmentation and Data Imports and Exports.
Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
Created jobs and alerts using SQL server agent, monitoring and troubleshooting the jobs.
Provided RAID level suggestion for data files, log files and tempdb drives.
Implemented data partitioning for large tables to increase the performance.
Administered, configured and managed SAN, EMC storage for backups and disaster recoveries.
Implemented and monitored the replication between two sites, support and maintenance of Transactional Replication.
Resolved blocking, deadlocks, client/server connectivity, database consistency checks using DBCC utilities.
For performance analysis used the tools like SQL server profiler, Index Tuning Wizard, and Database Tuning Advisor.
Experience in implementing SQL database in Azure cloud computing platform.
Design, Implement, manage, backup, and monitor storage solutions in accordance with the HA and DR requirements of the enterprise Hosting environment, Create and manage Azure AD tenants, and configure application integration with Azure AD.
Developed SSIS packages to transfer the data between production and development environments.
Created, deployed and managed reports using SQL Server Reporting Services
(SSRS).
Built, published customized interactive reports and dashboards and managed report scheduling using Tableau Server.
Used Third party tools like Lite Speed, Red Gate to speed up backup operations
Responsible for managing, compiling and deploying code on Team Foundation Server.
Interact With front end applications by Web and Client/Server Application development using Microsoft .NET Framework with C# and VB.NET, ASP.NET, C#, programming languages.
Involved in 24x7 on-call support on a weekly rotational basis.
ENVIRONMENT: T-SQL, Microsoft SQL Server 2000, 2005, 2008 R2, 2012, 2014 and 2016, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL, Microsoft Visual Studio 2012 IDE.
Wisconsin Department of Workforce Development, Madison, WI
Role: Sr. SQL Server DBA April 2014- July 2015 Responsibilities:
Experience with Multi- Servers and Multi-Terabyte Databases design for Very Large Databases.
Performed installations of SQL Server 2008R2/2012 Servers as per client requirements.
Performed migration from SQL server 2008 to SQL server 2012.
Proactively configuring and monitoring of live site production databases in a clustered environment.
Configured Failover Clustering features in SQL Server 2012 and AlwaysOn Availability Groups.
Created Logins and managed database objects like Tables, views, stored procedures, and indexes.
Automated regular Database Maintenance tasks by creating Jobs and Alerts using the SQL server agent and Database mail.
Perform database refresh from higher to lower environments.
Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
Experience in checking Actual and estimated execution plans to find out performance issues for long running quires and find out how SQL Server optimizer is behaving while the query is running in terms of (Nested loop, Hash and Merge Join).
Configured and managed database maintenance plans for update statistics, database integrity check and backup operations.
Backed up the databases in a way that meets the business’s Recovery Point Objectives (RPO).
Configured Database Mirroring with high performance and high safety mode.
Migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, Attach/Detach and Data Migration tools.
On the new SQL Servers configured required users and fixed orphan users with rev login script.
Experience in documenting the Root Cause Analysis for various issues like memory and outage of database and related hardware failure.
Extensively worked on Transparent Data Encryption (TDE).
Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via active directory.
Truncated/shrink transaction logs, checked data allocation errors and any data inconsistencies and updating database statistics.
Involved in system analysis & design of the Enterprise data warehouse implementation.
Extensively used Repositories like Team Foundation Server (TFS) and Clear Case for Data Archival.
Worked in collaboration with It Developing team to create web site support system to provide database access to applications and website. Applications were written in HTML, JavaScript, CSS, .NET and java with visual studio as IDE and connected using JDBC
Utilized SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.
Experience in Azure Cloud services, Azure storage, Azure active directory and Azure Service Bus. Managing Client's Microsoft Azure based PaaS and IAAS environment.
Documented procedures\processes and Trouble-shooting guides for various issues.
Supported 24 X 7 Production On call.
ENVIRONMENT: T-SQL, SQL Server 2012, 2008 R2/2005, Windows 2003/ 2008 Server, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2010.
Progressive Insurance, Mayfield, Ohio
Role: SQL Server DBA Jan 2012- Feb 2014
Responsibilities:
Finding out any missing standards and Providing Best practices for maintaining SQL Servers efficiently. Successfully implemented several new standards for the Client, with tremendous proven improvement as part of SQL Security Vulnerability Remediation.
Provided DBA support for multiple applications in development, test, and production environments.
Performed installation of SQL Enterprise 2005 64bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise data centers.
Developed strategies in migration of SQL server from one version to another.
Good hand on experience on Joins and sub-Queries to simplify complex queries involving multiple tables.
Implemented security and object permissions such as maintain database authentication modes, creation of users, configuring permissions and assigning roles to users.
Managed database backup and disaster recovery including Point-in-Time recovery.
Maintaining the database consistency with DBCC, DMV and DMF's at regular intervals.
Configured and maintained Mirroring (High performance and High safety modes).
Worked in both Active-Active and Active-Passive cluster Environment.
Created and scheduled SQL server automated jobs in a timely manner of daily, weekly and monthly processes.
Monitored SQL server error logs, job history logs, space usage, customer complaints, tickets, optimizing queries, tracing long running queries, blocking and deadlocks.
Implemented performance monitoring and database tuning using different tools such as SQL Profiler, Database Tuning Advisor.
Created Maintenance Plans for Regular Backups and for Reorganizing, Rebuilding of Indexes.
Used Performance counters to find the bottlenecks of servers in CPU, Disk I/O and memory devices to improve the server as well as database performance.
Designed and facilitated the implementation of data warehouses required by application systems.
Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, excel files and loading into SQL server.
Created Reports through Reporting server (SSRS) accordingly the business requirement.
ENVIRONMENT: SQL Server 2005/2008 R2/2012, T-SQL, Excel, Windows 2003/2008 Server, Integration Services(SSIS), Visual Studio 2010, Reporting Service(SSRS).
Global Info Solutions, Hyderabad, India
Role: SQL Server DBA/Developer July 2010-Oct 2011 Responsibilities:
Maintaining SQL Server 2005/2008 R2 servers for day-to-day activities.
Regular SQL Server Maintenance Activities that include Index rebuilds and updates statistics, Database Backup, Data Imports and Exports.
Managing Login Authentication and User Privileges for more than 100 users.
Created Stored Procedures, Triggers, Views and Functions for the Application.
Resolving security issues by creating new roles and granting required permissions to the users at various levels.
Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Used log shipping for synchronization of database.
Experience in Logical and physical modeling as well as Maintaining SQL Script for creation of database Objects and generating scripts using Erwin tool.
Involved in Optimization and normalization of database and tables.
Used SQL Profiler for troubleshooting blocking, deadlocks, optimizing stored procedures, and T-SQL queries.
Setup and maintained Linked Servers.
Involved in performance tuning of the SQL queries.
Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
ENVIRONMENT: T-SQL, MS SQL Server 2005/2008 R2, Windows 2003/2008 Servers, MS Access, Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Reporting Service(SSRS).
ICICI BANK, HYDERABAD, INDIA
Role: SQL Server DBA/Developer Jan 2009- Jun 2010
Responsibilities:
Involvement in the Design and Development of Database.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
Create Clustered and Non-Clustered Indexes to improve data access performance.
Identify Relationships between tables and enforce referential integrity using foreign key constraints.
Implementation of robust backup and recovery strategies.
Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
Troubleshoot the problems and document them.
Performance tuning using IDERA, Profiler, SCOM, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers.
Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.
Monthly auditing of the servers for security, performance and best practices.
Develop and deploy server reports using SSDT for managerial decisions.
ENVIRONMENT: MS SQL server 2005, 2008, T-SQL, Windows NT 2003.
Contact this candidate