Data Sql
Resume:
Shravanti N
**********.******@*****.***
Highlights:
SQL Server DBA with 5+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.
Experience in Installing, Upgrading and Migrating databases from SQL Server 2014/2012/2008R2\2008\2005.
Experience in SQL installation, Applying windows patches on server,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.
Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring .
Experience in configuring 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 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.
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.
Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
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
Expert in raising the Service Requests and keep tracking of requests.
Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
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, Store Procedures, Triggers, Optimizing code and improving Efficiency.
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.
Testing methodologies and tools - Automation and Performance testing.
Strong Communication & Management skills and Excellent Team player.
Technical Skills:
Education:
Bachelors in Computer application from IIBMT 2009 to 2012
Relational Databases: SQL Server 2016/2014 / 2012 / 2008 / 2008R2 / 2005, My SQL.
Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, NET, Business Intelligence Studio.
Languages: C#, XML, SQL, T-SQL
Operating Systems, Windows 2016, Windows 2012, Windows 2008R2, Windows 2003,
Architecture: Relational DBMS, Clustering, Replication, ETL: SSRS. OLAP, OLTP.
Other Tools: Microsoft Visual Studio 2005/2008, Service now, Idera monitoring tool, DD Boost backup, Windows System Monitor,Avamar backup tool.
Professional Experience:
Client: Community Health Systems. Franklin, TN. June 2019 – Till Date SQL Server DBA
Responsibilities
Installing, Configuring and Administering SQL server 2012, 2016.
Developed backup strategies for Database Recovery.
Performing Database maintenance activities like Backups, Restoring.
Creating and Monitoring the Scheduled jobs.
Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
Involved in the migration of databases from SQL server 2012 to SQL server 2016.
Implemented and maintaining Log shipping, 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/2016 including databases, logins, users, jobs.
Monitored and resolved Log shipping out of sync issues.
Implemented High Availability in SQL 2012/2016 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
Created and managed maintenance jobs for performing SQL Backups, DBCC, and Index creation/recreation.
Enabled Transparent Data Encryption on critical databases.
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.
Creating databases and logins and users with permissions in SQL server 2012/2016.
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.
Experience in configuring Avamar backups on SQL database level and windows level.
Verifying all error log files for any new entries.
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.
Client: Maximums Inc. MD Fed 2018 –May2019
SQL Server DBA
Responsibilities:
Migrated Databases from SQL Server 2005/2008r2 to SQL Server 2012/2016 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.
Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
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 2012/2016.
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.
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.
Client: Charter Communications, St. Louis,MO Oct2016 -Jan 2018
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.
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
Worked in Active, Active Passive Cluster environment as a High availability solution.
Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
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.
Client: Nations Info Corp, Westlake village, CA June 2015-Sep 2016
Jr Database Admin
Responsibilities:
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.
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.
Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
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
Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
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.
Contact this candidate