Revathi Pittala

Email ID: adjgm5@r.postjobfree.com

Contact: 201-***-****

Summary

IT Professional with 5+ years of Administration Experience on MS SQL Server 2016/2014/2012/2008R2 systems in OLTP and OLAP environments and 3+ years of Desktop Support.

SQL Server database administration strengths include: Installation, Configuration, Database design (physical and logical) using Erwin, Server and System security, Patching, Database creation, Performance tuning, Change Management, Schema change, Space management, Query optimization, Backup, LiteSpeed, Recovery, Normalization, Hot and Cold Backups, Data conversion, Authorizations, Tables, Indexes, Migration, running Database Consistency Checks (DBCC), Data mapping, Data dictionary tables, Planning capacity, Monitoring growth, Application database replication, Replication server, Logshipping, Database Mirroring, DTS, Security administration, User administration, Support, Maintenance,

Upgrading and Migrating SQL Server 2016/2014/2012/2008R2/2005 on Clustered and Standby Environments by using In-Place upgrade process and as well as side-by-side upgrade process and documented the Upgrade Process.

Auditing of database for user's transaction, login and database action and removing orphan users.

Implement and manage SQL Azure database for cloud server.

Good experience in SQL Server Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)

Experience in supporting Very Large Database (VLDB) more than 20TB and troubleshooting problems.

Extensively worked on Active - Active and Active-Passive Clustering.

Setting up and Monitored transactional replication, Snapshot, Database mirroring on Production and QA servers.

Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries.

Good experience with implementing DR solution using Logshipping and DB Mirroring.

Extensively worked on 32bit, X64 bit and i64 clustered and standalone server environment.

Good experience in creating and maintaining database security policies and SQL Authentication and Windows Authentication.

Proficient in creation and maintenance of database, creating roles and managing user permissions.

Performed database design, review and optimize queries to help development teams to achieve better performance.

Experience in Index tuning wizard for fine tuning the table indexes for better query performance.

Proficient in maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.

Good experience in SQL Statement performance (indexing, profiler, execution plan analysis).

Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.

Extensively involved in 24/7 Production support of the databases and round-the-clock database operations.

An enthusiastic and goal-oriented team player possessing good communication, interpersonal skills with good work ethics. Can work in fast pasted environment with multiple teams and clients.

Technical Skills

RDBMS: MS SQL Server 2017/2016/2014/2012/2008R2/2005/2000

Languages: T-SQL

Operating systems: Windows Server 2003 EE, Windows 2000 Server/Advanced Server and

Windows 10/8/7/Vista/XP/NT/2000

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and

MS Access/Excel to SQL Server

Domain/AD: Active Directory, DN

Monitoring Tools: SQL Server Profiler and Perf Mon, FogLight, Idera, Spotlight

Professional Experience

Job Title: Sr. MS SQL Server DBA

Mizen Group INC, NY

March 2020 – Till Date

Responsibilities

Worked on SQL scripts to load data in the tables.

Validated the data movement, and transformations are done correctly.

Source System Analysis, Data Points identification for ETL Testing.

Created Test Cases meeting the business requirements.

Execution of Testcases and identifying detects if any.

Web Interface testing of the ACE application for the new requirements

Country Derivation Analysis based on Input and output results

Installed, Configured, and Maintained SQL Server 2017,2016,2014, 2012 and 2008R2 in development, test, and production environment.

Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2008 R2 to 2016/2017.

Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Creating logins, groups, and users, roles, checking for database consistency, monitoring error logs, database space allocations and transaction log space allocations.

Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.

Job Title: Sr. MS SQL Server DBA

Object win technologies, India

May 2014 – November 2014

Responsibilities

Performed server installation and configurations for SQL Server 2008R2 and 2012, 2014/2016.

Migration of SQL Server 2008 to 2012/2014, SQL Server 2005 to 2008 in clustered and non-clustered environment.

Performed installation of SQL Server Service Packs.

SQL Server Best Practice Implementation.

Analyzing problem and Handling Tickets of Salesforce.

Experience working with 24 x 7 on call environments.

Involved in capacity planning, sizing and database growth projections.

Scheduled Full and Transactional log backups for the user created and system databases in the production environment using Lite speed.

Installed and Configured Transactional and Snapshot replication to replicate data to OLTP and Data Warehousing.

Used Query Store to troubleshoot query performance, as well as capturing query execution information in SQL Server 2016.

Perform day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.

Used live Query Statistics in 2016 to debugge the Queries.

Experience with HA/DR SAN Production environment - Always On, Mirrored Cluster, Log Shipping & Replication.

Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Participating in the deployment of different patches, builds and applications latest versions using build deployment tool Octopus

Performing Smoke tests on the applications and resolving the issues observed so that the end user doesn’t face any issues.

Migrated databases to cloud environment on Microsoft Azure.

Used SQL Server Profiler, DMV’s to monitor and record database activities of particular users and AWS applications.

Creating logins, groups, and users, roles, checking for database consistency, monitoring error logs, database space allocations and transaction log space allocations.

Used Index tuning wizard to redesign and created the indexes for better performance.

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.

Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.

Reviewed DB Scripts from the development team before releasing them into the Production.

Environment Tools: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, SQL Safe, SQL Profiler, Idera SQL Diagnostic Manager, Mirroring, Replication, MS Clustering, Sales force, Windows XP/2000 and Windows 2003/2008/2012 Server.

Job Title: Sr. MS SQL Server DBA

Indigm Solutions, India

January 2013 - May 2014

Responsibilities

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node Cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

SQL Server Best Practice Implementation.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding/monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Monitoring the servers using Idera third party software.

To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Environment Tools: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, SQL Profiler, Ignite, Mirroring, Replication, MS Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Job Title: Sr. MS SQL Server DBA

Apollo Health Street, India

June 2010 - December 2012

Responsibilities

Performed server installation and configurations for SQL Server 2005 and SQL Server 2008R2.

Installed SQL Server 2012 on standalone servers.

Performed installation of SQL Server Service Packs.

Upgraded databases from SQL Server 2005 to SQL Server 2008R2.

SQL Server Best Practice Implementation.

Involved in capacity planning, sizing and database growth projections.

Scheduled Full and Transactional log backups for the user created and system databases in the production environment using Lite speed.

Created transactional replication for the reporting applications.

Implemented disaster recovery solution at the remote site for the production databases using Database Mirroring.

Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Used Ignite monitor tool to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.

Used SQL Server Profiler, DMV’s to monitor and record database activities of particular users and applications.

Used DBCC commands to troubleshoot issues related to database consistency.

Used Index tuning wizard to redesign and created the indexes for better performance.

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.

Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) 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.

Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.

Reviewed DB Scripts from the development team before releasing them into the Production.

Environment Tools: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, SSRS, Lite Speed, MSX, BCP, SQL Profiler, Spotlight, IBM Tivoli Monitoring, HPSM, Mirroring, Replication, MS Clustering, Maximo, Windows XP/2000 and Windows 2003/2008 Server.

Job Title: Sr. Technical Support Engineer

Janya Solutions, India

April 2009 - April 2010

Responsibilities

Providing complete support with regards to the software and hardware being used by the Customers. There are no specific support boundaries in this job profile. Hence a lot of research work is involved at this point of time and we are in a process of building a database of all sorts of issues and also are working with developers to role out a Troubleshooting Tool that would be used in helping the customers with their specific issues.

Improve hardware and network performance by identifying problems, recommending changes

As a 2nd level support as the job profile includes providing the end results of the Issue. Making Call Backs to the members with their relevant issues and also with the correct Resolutions.

Job Title: Technical support Engineer

America Online (AOL), India

April 2006 - April 2008

Responsibilities

Provided worldwide Technical Support for various products on a 24/7 basis.

Performed upgrades, installation of software and drivers and essential desktop troubleshooting).

User rights and permission, disabling and enabling accounts, file and folder permissions and configuring security templates as per need.

Providing ISP support.

Resolved technical issues pertaining to any hardware or software related problem.

Education:

Master of Computer Applications Osmania University (2005) India

Contact this candidate