Ayyappa Reddy - 12Y Exp - SQL Server Administrator and Architect - Knowledge in BigData analytics I have 12 years of rich experience in SQL Server Administration and Architect the environment. Microsoft Certified Solutions expert in SQL Server 2012 (MCSE - Data Platform ). Certified MongoDB administrator. Certified Cloudera Hadoop Administration (CCA410) As Database Specialist I am providing SME support for SQL Server administration. My expertise includes Installation, Up-gradation, Migrations, Server consolidation, High Availability clusters, Architectural designs, Server Configurations, Security management. Expertise on technology best practices and performance fine tuning. Have excellent verbal and written communication skills. MySQL and Oracle database administration are my secondary skill set. Also I have knowledge on big data analyticals. Following the technology trends and blog posts by industry experts and Technical fellows about the next generation of the Database Management systems, I have been putting my efforts in understanding the benefits of implementing BIGDATA and No-SQL technologies such as MongoDB and Apache based Hadoop to enhance the business application’s scalability and developing more real-time enhanced management products such as monitoring solutions of infrastructure devices etc. Certifications: ITIL V3 certified MCSE – SQL Server 2012 Microsoft Certified Solutions Expert MCTS – SQL Server 2008 Microsoft Certified IT Professional MCITP – SQL Server 2005 Microsoft Certified IT Professional MCDBA – SQL Server 2000 Microsoft Certified Database Administrator Other Certifications: CCA-410 - Cloudera Certified Administrator for Apache Hadoop (CCAH) CDH 4 M102: MongoDB for DBAs

Lead - Database Architect @ 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 From December 2014 to Present (1 year 1 month) Lead - Database Specialist @ 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. From April 2009 to October 2014 (5 years 7 months) Senior SQL Server DBA @ 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. From June 2006 to March 2009 (2 years 10 months) SQL Server DBA @ 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. From September 2005 to June 2006 (10 months)

Bachelor of Technology (B.Tech.), Civil Engineering @ G Pulla Reddy Engineering College From 1998 to 2002 Board of Intermediate Education, MPC @ Siddartha Jr College From 1996 to 1998 Ayyappa Reddy Basireddy is skilled in: Databases, Microsoft SQL Server, Data Migration, Database Administration, High Availability, MongoDB, Hadoop, SQL, MSBI, database architect, SSIS, SSRS, SSAS, hadoop administration, Big Data