Sql Server Maintenance

Location:

Chicago, IL

Posted:

May 09, 2018

Contact this candidate

Resume:

SADHANA BANDAKUNTA

Mail: *****************@*****.***

Phone: +1-773-***-****

PROFESSIONAL SUMMARY:

Around 7.7 years of experience in SQL Database Administration and Development for very large and complex databases in SQL Server 2016/2014/2012/2008R2/2008/2005/2000 on cluster and standalone environments, databases ranging from GB’S to TB’S in size.

Experience in Installing, Configuring, Administration and Maintenance of more than 600 huge and complex mission critical client databases in SQL server 2000, 2005, 2008R2, 2008, 2012, 2014 and 2016 versions.

Experience in working on Very Large Databases (VLDB) over 8 TB for OLTP.

Extensive Experience in Upgrading to SQL Server (In place Up gradation and Side by side Up gradation) based on application compatibility and fixing the orphan users.

Extensive experience in migrating huge databases from all SQL server versions based on application compatibility and fixing the orphan users.

Experience in operating the new features of SQL 2016 version i.e. Query store, Stretch Database.

Installs, configures, supports, patches and upgrades MS SQL and related services.

Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.

Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using the ticketing tool Service Now

Experience on Audit procedures and SOX compliance.

Experience in managing the SQL monitoring tool i.e. SCOM, Remedy and Nagios

Participated in DR Exercises

Good Experience in Capacity Planning

Good experience with implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and HA/Always ON.

Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets and Transparent Data Encryption.

Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.

Managing and administrating tasks in SQL server using PowerShell scripts.

Basic knowledge in AWS Relational Database Management system, Azure SQL servers and EC2.

Responsible for performance tuning of stored procedures and queries using SQL Profiler, Database Tuning wizard and Query Store.

Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.

Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganize based on fragmentation.

Experience in T-SQL Programming like stored procedures, functions and triggers and T-SQL scripts for the monitoring the production environment in an effective way.

Hands on Experience in third party backup tool i.e. Commvault

Strong experience on indexing strategies, Creating and tuning the indexes based on the workloads.

Strong working knowledge with system databases like Master, Model, Temp, MSDB and maintaining them for the smooth execution.

Experience in installing SQL Server Integration and Reporting Services (SSIS & SSRS) and configuration on both standalone and Clustered Environments.

Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment

Good interpersonal skills, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS:

RDBMS: MS SQL server 2016, 2014, 2012, 2008R2, 2008, 2005, 2000,

MySQL, MongoDB, Oracle 10g, Hadoop

Operating System: Windows server 2012, 2008, 2008R2, 2007, 2003.

Languages: C#, T-SQL, SQL, CSS XML, HTML, VB.Net, .Net

BI Tools: SQL Server Reporting tools (SSRS), SQL Server Integration

Services (SSIS)

Application Servers: IIS 6.0 and Web Sphere.

Development Tools: Visual Studio.Net 2005,2008, 2010 and 2013

COM: ActiveX DLL/EXE/OCX and D-COM.

.Net Framework: Framework 2.0, 3.0, 3.5 and 4.0, MVC/MVP.

Client Tools: SSMS, SQL CMD, SQL Profiler, Perfmon, DTA, SSIS, SSRS,

Backup Tools: Commvault

SQL monitoring tool SCOM, Patrol and Redgate.

Storage: SAN/ NAS.

Professional EXPERIENCE:

Employer : Tata Consultancy Services Limited

Client : CNA (Continental Casualty Company), Chicago

Environment : SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014 and 2016, Windows, SQL

Profiler, SQL agent, Database Migrations, Availability Group, DB

Mirroring, MS SQL Server Reporting Services (SSRS), SSIS, Database

Upgradations, DTA, T-SQL, Patrol, Azure SQL Server, AWS

Role : SQL Server DBA

Duration : June 2016 to Present

Responsibilities:

Administration of large databases in SQL Server 2000,2005,2008,2008 R2, 2012, 2014 and 2016.

Experience in deploying the scripts in Production environment by following the proper change management process.

Closely working with application developers to provide the required support from backend side for the smooth operations.

Maintaining applications and database security in accordance with SOX requirements and taking care of Audit reports with External Auditors

Participated in DR exercises on a regular basis

Good experience in using the latest features of SQL Server 2016.

Routine DBA jobs like Backups. Restores, checking the integrity of the databases, configuring DB Mail and assigning required roles and permissions to the users.

Data Migration (Import & Export) from various sources like flat like, MS Access, Oracle, Sybase to SQL Server tables.

Expertise in Server Management issues like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach.

Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance jobs.

Upgrading SQL Server 2005 to SQL Server 2008R2 or 2012/2014 (In-Place upgrade / Side by side upgrade)

Extensive experience in troubleshooting the issues during the database migration.

Expertise in implementing, HA/Always On, Database Mirroring and failover cluster on SQL Server 2005, 2008 and 2012 for high availability.

Configured the SQL Server in AWS (Amazon Web Services) RDS and EC2

Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Periodically running DBCC checks and fixing data corruption issues if any in application databases.

Experience in configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganization based on fragmentation.

Configuring SQL Server Agent-Events, Jobs, Alerts, maintenance plans, Database Mail and Operators.

Configuring and managing High Availability solutions (Clustering, Mirroring, Log shipping, Replication (Transactional and Merge)) and HA/Always ON.

Extensive experience in troubleshooting and solving the issues related to HA/Always On in SQL 2012/2014 versions.

Solved problems related to database/Server performance issues like slow running queries, blocking and high CPU Utilization.

Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and providing support on the databases and applications.

Professional EXPERIENCE:

Employer : Tata Consultancy Services Limited

Client : Advanced Micro Devices (AMD)

Environment : SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014 and 2016, Windows, SQL

Profiler, SQL agent, Database Migrations, Availability Group, DB

Mirroring, T-SQL, Service Central Ticketing tool, MS SQL Server

Reporting, ITIL, DB upgradations, TDE,

Services (SSRS)

Role : SQL DBA

Duration : July 2014 to June 2016

Responsibilities:

Administration of large databases in SQL Server 2005 and 2008, 2008 R2, 2012 and 2014.

Expertise in Server Management issues like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach.

Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Managing SQL server using PowerShell scripts.

Installation and configuration of SQL server 2005, 2008, 2008R2, 2012, 2014 and 2016.

Upgrading SQL Server 2005 to SQL Server 2008R2 or 2012/2014 (In-Place upgrade / Side by side upgrade)

Extensive experience in troubleshooting the issues during the database migration.

Experience in configuring Transparent Data Encryption (TDE) to standalone databases also with Availability group databases in SQL Server.

Experience in fixing Orphan users after the SQL database migration from 2005/2008R2/2012/2014 to 2016.

Expertise in implementing Database Mirroring and failover cluster on SQL Server 2005, 2008 and 2012 for high availability.

Maintaining applications and database security in accordance with SOX requirements.

Experience in monitoring tools such as SCOM.

Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Ran DBCC and fixed data corruption in application databases.

Configuring SQL Server Agent-Events, Jobs, Alerts, maintenance plans and Operators

Providing Support on Weekends and attending weekly calls/meetings

Configuring and managing High Availability solutions (Clustering, Mirroring, Log shipping, Replication (Transactional and Merge)) and HA/Always ON.

Extensive experience in troubleshooting and solving the issues related to HA/AlwaysOn in SQL 2012/2014 versions.

Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and providing support on the databases and applications

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Professional summary:

Employer : Automatic Data Processing Inc

Client : ADP Dealer Services, Texas, USA

Environment : SQL Server 2000/2005/2008/2008 R2 and 2012 Enterprise, Query Analyzer,

T-SQL, DB migrations, DB Upgradations

Databases : SQL Server 2000, 2005, 2008, 2008 R2 and 2012

Role : SQL Server DBA

Duration : SEP 2010 to JUNE 2014

Responsibilities:

Administration of large and complex databases in SQL Server 2000, 2005, 2008, 2008R2 and 2012.

Installation and configuration of SQL server 2008R2 and 2012 on Test, Development and Production Environments

Performance Tuning, Query Optimization

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.

Created Logins and Roles with appropriate permissions.

Created and Maintained Database Maintenance Plans.

Experience in T-SQL Programming (DML and DDL).

Implementation of Backup and Recovery strategies as per RTO and RPO.

Responsible for performance tuning of stored procedures using SQL Profiler and Database Tuning wizard.

Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using the ticketing tool Vision.

Experience in taking the backups using the third-party tool called Veritas.

Provided Support on Weekends and attending weekly calls/meetings.

Configured and managed High Availability solutions (Clustering, database Mirroring, Log shipping, Replication (Transactional/Merge))

Solved problems related to database Performance issues.

Ran DBCC and fixed data corruption in user and system databases.

Qualifications:

Bachelor’s Degree in Computer Maintenance from Loyola Academy (Osmania affiliated)

Achievements And Strengths

Certificate of Appreciation and Employee of the year from AMD client partners within six months of joining TCS.

Awarded “Titan of the month”, “Star of the month” and “Associate of the Quarter” several times from the time of inception in ADP.

Got 2 GIFT Awards (Give it a fresh thought) for the innovative ideas which I posted and implemented.

I hereby, declare that the information provided above is true and genuine to the best of my knowledge.

Sadhana Bandakunta

Contact this candidate