Ayyappa Reddy Basireddy Email & Phone Number

San Francisco, Ca, Us

San Francisco, Ca, Us

Santa Clara, California, Us

Responsibilities: * Analyzing the db environment and provide cost effective server Consolidation * Upgrading the entire corporate SQL Server estate to SQL Server 2012 SP2 * Installation\Migration\Upgradations to SQL Server 2012 * SOX\PCI audit compliance Database management * Implemented data compression on databases and backups for storage savings * Database security standardization for unauthorized access prevention * Proactive patch management to keep the environment secure and up to date * Multi node cluster installations for high availability * Configured Backup & Recovery strategies for mission critical databases DR environment * Implemented SQL Server 2012 Always On Availability groups for Sharepoint databases * SQL Server 2014 deployments and database migrations for testing * POCs for Azure VMs integration with On premise servers for HADR and Backups * MySQL Server database administration * MySQL Enterprise backups (MEB) configuration and verify the restores * Hands on experience with MySQL Replication configuration and maintenance * MySQL Server user management and basic administration tasks

Global, Us

• Managed Team of 22 Database Developers, Architects, DBAs at Onsite and Offshore• Managing Mission Critical OLTP Database Servers• Defining, Documenting, Implementing Data Architecture for OLTP and OLAP environments• Establishing standard operating procedures for administering operational databases• Mentor fellow DBA’s on SQL Server, NoSQL Administration and Development• Data Center Migration of SQL Servers• Analyzing the db environment and provide cost effective server Consolidation • Installation\Migration\Upgradations to SQL Server 2008R2/2012• SOX\PCI audit compliance Database management• Proactive SIPs for high performance database environments• Implemented data compression on databases and backups for storage savings• Database security standardization for unauthorized access prevention• Proactive patch management to keep the environment secure and up to date• Multi node cluster installations for high availability• Configured Backup & Recovery strategies for mission critical databases• Implemented SQL Server 2012 Always On Availability groups for meeting various businesses demands where extremely HA and load balancing is needed• Optimized 4TB of Warehousing SQL Database for better performance• Hand on experience in installing and configuring the SQL Server Reporting services.• Hands on experience with installing SQL Server integration services and deploying the SSIS packages through SQL Agent jobs, troubleshooting the execution failures. • Managing the security to the SQL Server Reporting services sites.• SQL Server 2014 deployments and database migrations for testing• POCs for Azure VMs integration with On-premise servers for HADR and Backups

Global, Us

Responsibilities: * Leading a team of 19 resources and providing SME support * Data Center Migration of SQL Servers * Analyzing the db environment and provide cost effective server Consolidation * Installation\Migration\Upgradations to SQL Server 2008R2/2012 * SOX\PCI audit compliance Database management * Proactive SIPs for high performance database environments * Implemented data compression on databases and backups for storage savings * Database security standardization for unauthorized access prevention * Proactive patch management to keep the environment secure and up to date * Multi node cluster installations for high availability * Configured Backup & Recovery strategies for mission critical databases DR environment * Implemented SQL Server 2012 Always On Availability groups for meeting various businesses demands where extremely HA and load balancing is needed * Optimized 4TB of Warehousing SQL Database for better performance * Hand on experience in installing and configuring the SQL Server Reporting services. * Hands on experience with installing SQL Server integration services and deploying the SSIS packages through SQL Agent jobs, troubleshooting the execution failures. * Managing the security to the SQL Server Reporting services sites. * SQL Server 2014 deployments and database migrations for testing * POCs for Azure VMs integration with On premise servers for HADR and Backups.

Global, Us

Responsibilities: * Leading a team of 12 resources and providing SME support * Executed Server Consolidation project (Reduced the server count by 50%) * Migration of SQL Server 2000/2005 Databases to SQL Server 2008/R2 Completed. * Defined the Security Standards for SQL Server to Comply with SOX Controls. * SQL Server Risk Analysis Program for environment assessment and implementing the recommendations * Disaster recovery solution implementations and quarterly/annual testing * Implemented all kinds of SQL Server Failover Cluster installations (including A/A or A/P) of various SQL Server versions including 2005, 2008 and 2012 * Configured database mirroring as disaster recovery solution * Optimized 1TB of Warehousing SQL Database for better performance * Implemented Transparent Data Encryption to protect sensitive data * Experience in using SQL Server Wait-statistics to troubleshooting performance issues * Business intelligence solution thru SSRS, SSIS and SSAS.

Mumbai, Maharashtra, In

Responsibilities: * Installing SQL Server from IPAK's * Configuring Log shipping for data bases and ensures that servers are in sync. * Configuring Backup jobs and trouble shooting * Restoring the data bases using SQLLITESPEED. * Maintained SQL Server upkeep to 99.9% * Set up SQL accounts, Security roles, new releases and service packs. * Knowledge on Microsoft Operations Manager. * Dealing with regular and common issues reported by the application support teams includes slowness, timeouts, deadlocks etc * Effective Communication made through conference calls and emails.