Phaneendra Datla Email & Phone Number

Charlotte, Nc, Us

Matthews, North Carolina, Us

 Install, configure, upgrade, Migrate databases from SQL 2008/2012/2014/2016 to 2017/2019 on-prem environment Experienced in Administration, Database Design, Performance Analysis and 24X7 Production Support for Large (VLDB) and Complex Databases.  Strong knowledge and working experience in Database Backup, Disaster Recovery & Backup strategy for production & NonProd environment Database servers architecture reviews, Design and configuration changes Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, backup/restore Participate in AlwaysOn Availability Group failover testing of High Availability and Disaster Recovery environments during DR test Contributed to implementation of HA/DR solutions for database servers of SQL 2017/2019 including Failover Clusters, mirroring and Always On Availability Groups Work with developers to optimize the code if required to minimize the duration and look if the indexes are used appropriately Configure and refine IDERA monitoring tool and alerts

Aliso Viejo, Ca, Us

 Install, configure, upgrade, Migrate databases from SQL 2008/2012/2014/2016 to 2017/2019 on On-prem & Azure/AWS IAAS VMs Experienced in Administration, Database Design, Performance Analysis and 24X7 Production Support for Large (VLDB) and Complex Databases. Managed over 200+ SQL Servers including Production and Non-Production servers Plan and execure the server and applications upgrade [rocess including patches and hot fixes Strong knowledge and working experience in Database Backup & Disaster Recovery & Backup strategy for production & development environment Experienced with Point-in-Time Recovery, Restored Database from backups Database servers architecture reviews, Design and configuration changes Configured & managed Transactional Replication by using Attunity tool for replicating the data from one server to other using CDC (change data capture) Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, backup/restore Worked with developers to optimize the code if required to minimize the duration and look if the indexes are used appropriately Configure and refine IDERA monitoring tool and alerts Good understanding Cloud technologies and help migrate on premise database to Azure IAAS

San Francisco, California, Us

MCTS:70-462 Administering Microsoft SQL Server 2012/2014 Databases Responsible for supporting & troubleshooting issues with databases using 2008R2/2012/2014/2016 enterprise edition  Install, configure, upgrade, and maintain database instances from SQL 2008/2012 to 2014/2016 on clustered and standalone servers of Non Prod & Prod servers Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards at Wellsfargo Contributed to implementation of HA/DR solutions for database servers of SQL 2012/2014/2016, including Failover Clusters, mirroring and Always On Availability Groups Manage application and user access to SQL Server environments Deploy and test maintenance jobs, and change scripts in both test and production environments Performance tuning on long running queries and stored procedures, using SQL Profiler, server side traces, Database Tuning Advisor, and query execution plans Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, and transaction log file sizes, backup/restore Configure and refine IDERA monitoring tool and alerts Used DBCC and DMV commands for day-to-day troubleshooting tasks Participate in AlwaysOn Availability Group failover testing of High Availability and Disaster Recovery environments during DR test Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines

Indianapolis, Indiana, Us

 Responsible for supporting & troubleshooting issues with databases using 2008R2/2012/2014 enterprise edition  Builds and supports all required database environments including development, test and production Experienced in Administration, Database Design, Performance Analysis and 24X7 Production Support for Large (VLDB) and Complex Databases. Managed over 100+ SQL Servers including Production and Non-Production servers Participates within the DBA team to troubleshoot any issues on the SQL Server installs, including any errors or slow running queries Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines Deploy and test maintenance jobs, and change scripts in both test and production environments Deployed, and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, and transaction log file sizes, backup/restore Configure and refine SQL Sentry monitoring tool and alerts Ensure native database back up processes and schedules meet defined Recovery Point Objectives (RPO) and that backups are routinely tested to ensure consistency and the ability to meet Recovery Time Objectives (RTO) Experienced in providing production support for 24x7 over weekends on rotation basis Implemented data security features of Transparent Data Encryption(TDE), Column level encryption, table partition

San Francisco, California, Us

MCTS:70-462 Administering Microsoft SQL Server 2012/2014 Databases Responsible for supporting & troubleshooting issues with databases using 2008R2/2012/2014/2016 enterprise edition  Install, configure, upgrade, and maintain database instances from SQL 2008/2012 to 2014/2016 on clustered and standalone servers of Non Prod & Prod servers Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards at Wellsfargo Contributed to implementation of HA/DR solutions for database servers of SQL 2012/2014/2016, including Failover Clusters, mirroring and Always On Availability Groups Manage application and user access to SQL Server environments Deploy and test maintenance jobs, and change scripts in both test and production environments Performance tuning on long running queries and stored procedures, using SQL Profiler, server side traces, Database Tuning Advisor, and query execution plans Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, and transaction log file sizes, backup/restore Configure and refine IDERA monitoring tool and alerts Used DBCC and DMV commands for day-to-day troubleshooting tasks Participate in AlwaysOn Availability Group failover testing of High Availability and Disaster Recovery environments during DR test Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines

Milwaukee, Wisconsin, Us

Noida, Uttar Pradesh, In

 Acting as a primary point of contact for clients based in the onshore location. This involves managing client relationships, understanding their requirements, and ensuring that the offshore team delivers solutions that meet client expectations. Coordinating project activities between onshore and offshore teams, ensuring that project timelines are met, and addressing any issues that may arise during project execution. Allocating resources effectively between onshore and offshore teams to ensure optimal project delivery and efficiency. Identifying and mitigating risks associated with project delivery, such as scope creep, resource constraints, or communication challenges between teams. Ensuring that the deliverables meet the required quality standards and facilitating communication between teams to address any quality-related issues. Facilitating knowledge transfer between onshore and offshore teams to ensure that information is shared effectively and teams are aligned in terms of project goals and objectives. Monitoring the performance of the offshore team, tracking key performance indicators, and providing feedback for improvement. Resolving conflicts that may arise between onshore and offshore teams, ensuring smooth collaboration and effective teamwork.

Coventry, England, Gb

Us