Harika Lakshmi Yanala

• Providing SQL Server implementation changes requested from application teams.
• Responsible for installing, configuring, and maintaining as per supported LOB applications.
• Writing and improving SQL Server T-SQL queries.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Knowledge in installation, maintenance of different versions of SQL Servers (2017, 2016, 2014, 2012, 2008R2/2008) in Production and lower environments.
• Good Experience in high availability and recover ability of databases by using Always On, Clustering, Replication, Mirroring, Log shipping, Backup and Restore to meet the contractual RTO/RPO objectives.
• Knowledge in Database administration activities for DB security (creating users, logins and assigning permissions to them)
• Knowledge on Upgrading/Migrating SQL Server from 2005, 2008 r2 to higher versions 2012, 2014, 2016,2017 & 2019.
• Having hands on experience in Database Mirroring and ensuring high availability to the database by testing the fail-over.
• Have good knowledge on ALWAYS ON
• •Knowledge in deploying, configuring, and administering Always on Availability Groups. Have Some knowledge in finding and clearing blocking.
• Experience in using DBCC, DMV's and Extended Stored procedures.
• Experience in working Disk & Drive Space issues, managing indexes.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Thorough understanding of blocking/lock issues, Temp DB Optimization, File group management

Worked as a Business associate for TCS client

Responsibilities:

• Installed and configured SQLServer2008 R2/ SQLServer2008 with backup jobs, database mail and configuration options.
• Upgraded SQL Servers with latest service packs.
• Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.
• Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
• Configured and maintained transnational replication for flow of data from QA and Dev. Server to the replica servers.
• Monitored data activities like database status, logs, space utilization, locks and long transactions.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.
• Involved in resolving deadlock and blocking issues for concurrent users. · Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.
• Provided appropriate access to users except system databases owners. · Refreshed databases for pre or post data loads activities.
• Supported SQL server developers working on different projects with various requests.
• Developed SSIS packages to import and export data from existing systems to upgraded system.
• Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.

Environment: MS SQL Server 2008R2/2008/2005, T-SQL, Lite Speed, SQL Profiler.

Responsibilities:

• As a L2 support,we worked on incident tickets escalated from L1 support team.
• Responsible for MS SQL Server 2005 and 2008 and database administration.
• 24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.
• Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented/revised those processes.
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.

Environment: MS SQL Server 2008/2005, T-SQL, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows 2003 Server.

Responsibilities:

• Knowledge in installation, maintenance of different versions of SQL Servers (2017, 2016, 2014, 2012, 2008R2/2008) in Production and lower environments.
• Good Experience in high availability and recover ability of databases by using Always On, Clustering, Replication, Mirroring, Log shipping, Backup and Restore to meet the contractual RTO/RPO objectives.
• Knowledge in Database administration activities for DB security (creating users, logins and assigning permissions to them)
• Knowledge on Upgrading/Migrating SQL Server from 2005, 2008 r2 to higher versions 2012, 2014, 2016,2017 & 2019.
• Having hands on experience in Database Mirroring and ensuring high availability to the database by testing the fail-over.
• Have good knowledge on ALWAYS ON
• Knowledge in deploying, configuring, and administering Always on Availability Groups. Have Some knowledge in finding and clearing blocking.
• Experience in using DBCC, DMV's and Extended Stored procedures.
• Experience in working Disk & Drive Space issues, managing indexes.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Thorough understanding of blocking/lock issues, Temp DB Optimization, File group management
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.

Environment: SQL Server 2005, SQL server 2008, T-SQL, Oracle PL/SQL, Windows 2003/2008 Server, Import & Export Data.

Responsibilities :

• Monitoring all the agent's schedules that they don't exceed their breaks and lunches.
• Using ADHOC tool downloading the ticket data and pulling the ticket accuracy reports.
• Creating SQL queries and sending the agent productivity report & creating the temp table and moving data to main table by uploading data to oracle dba server using SQL import export wizard tool.
• Maintained occupancy and service level and met the business target.
• Confirming agent requests by considering operations management approval.
• Offered overtime for agents to met the business targets.
• Created whole day attendance, absenteeism, shrinkage reports by using Acd lite, Touch commerce, SQL queries(estart.)
• Created intraday reports interval wise and updated login logout data for all agents and sending tardiness reports.

Responsibilities:

• Monitoring all the agent's schedules that they don't exceed their breaks and lunches.
• Using ADHOC tool downloading the ticket data and pulling the ticket accuracy reports.
• Creating SQL queries and sending the agent productivity report & creating the temp table and moving data to main table by uploading data to oracle dba server using SQL import export wizard tool.
• Maintained occupancy and service level and met the business target.
• Confirming agent requests by considering operations management approval.
• Offered overtime for agents to met the business targets.
• Created whole day attendance, absenteeism, shrinkage reports by using Acd lite, Touch commerce, Sql queries(estart.).
• Created intraday reports interval wise and updated login logout data for all agents and sending tardiness reports.
• Creates agent performance report and their AHT , productivity , total staff time ,and their KPI metrics (5ssd,ARZ,FTR ) ,shrinkage and other metric reports data has been updated on daily basis.