Sql Server Technology Solutions

BHARGAVA POTUKUCHI

Plano, TX ***** 513-***-**** adzelh@r.postjobfree.com

Professional Summary:

A highly skilled and experienced Database expert with over 16 years of experience in leading teams of Database administrators, architects, and developers to design, implement, and maintain highly available database solutions. Proficient in a wide range of database platforms, including Oracle, MSSQL, Sybase, MySQL, PostgreSQL, MongoDB and MarkLogic, as well as cloud technologies and DevOps automation tools. A proven track record of delivering successful projects on time and within budget while exceeding customer expectations. Vast experience working with major clients in banking, education & media. Proficient in data modeling, project management and communication. Professional Experience:

SM - Infra. Technology Expert Plano, TX Cognizant Technology Solutions Dec 2015 – Present Client: Cengage Learning

• Managing a team of 20+ Database, Unix and Middleware administrators, architects responsible for managing over 100 mission-critical applications. Conduct cross skill training to improve team productivity.

• Design and build databases on various DB technologies like Oracle, MSSQL, Sybase, MySQL, PostgreSQL, MongoDB and MarkLogic, including on-premises, cloud, and hybrid, based on customer requirements.

• Implement high availability, DR, and backup strategies across DB technologies according to the RPO, RTO.

• Plan and execute P2V migrations for scalability, performance, and cost efficiency.

• Build, monitor, maintain Amazon AWS/RDS and Azure cloud solutions. Plan and perform migrations between in-house datacenter and cloud.

• Performed in-house Oracle data warehousing environment migration to Snowflake analytics engine using Amazon S3 bucket as staging area and enabled Goldengate for continuous replication of deltas.

• Automated server/database build and deployments using Terraform, Jenkins and Ansible to standardize, speed-up production processes and reduce human errors.

• Implemented encryption in various DB technologies as per GDPR data privacy requirements.

• Host web applications in Tomcat/PHP, using MySQL as backend along with handling certificate renewals.

• Handle license renewals with various vendors and look for license optimization options.

• Conduct regular performance reviews, provide feedback, and mentor team members to faster growth and development.

M - Infra. Technology Expert Pune, India Cognizant Technology Solutions Mar 2012 – Dec 2015 Client: Pearson/Time Inc.

• Led a team of 10 database admins responsible for managing Oracle, MSSQL, MySQL and Sybase databases.

• Install and configure SQL Server high availability features such as AlwaysON, Clustering, Replication.

• Design, install, and configure Oracle RAC with ASM including networking requirements.

• Performance Tuning of I/O, Memory, SQL by using tools/utilities like TKPROF, SQL PROFILE, AWR, ADDM.

• Worked on backup & disaster recovery as per application needs and performed quarterly patching and recovery tests to validate consistency of backups.

• Developed and evaluated highly complicated system standards and thresholds.

• Rebuild all the Sybase ASE and ASA instances exactly like existing ones as part of Quarterly DR activity. Infra. Technology Specialist Newark, DE Cognizant Technology Solutions Mar 2010 – Mar 2012 Client: JP Morgan Chase

• Worked as onsite lead/coordinator bridging the communication between client and offshore.

• Performed Datacenter hardware maintenance and new server provisioning.

• Secured the web applications by enabling https and importing SSL certificates on F5 load balancer and on Apache proxy servers.

• Performed configuration, monitoring, and maintenance on production and troubleshooted issues if any. Technical Lead Pune, India Cognizant Technology Solutions Feb 2009 – Mar 2010 Client: JP Morgan Chase

• Troubleshoot and resolve SQL Server issues related to connectivity, security, performance, and blocking.

• Enhanced performance using index management, integrity checks, configuration, and patching.

• Troubleshoot Sybase issues like log segment/tempdb full, blockings, deadlocks, and slowness.

• Sybase replication troubleshooting and maintenance. Sybase DBA Consultant Singapore ITCAN PTE LIMITED Aug 2008 – Jan 2009 Client: Credit Suisse

• Participated in the areas of database design, performance and management, User creation, syncing etc.

• Managed SQL server clustering and bi-way heterogeneous replication between Sybase and SQL server.

• Setup jobs on control-M for daily backup, maintenance, and monitor, fix failed jobs.

• Monitor the remedy queue and act immediately on high priority incidents raised by users. Project Engineer Bangalore, India Wipro Technologies Sep 2006 – Aug 2008 Client: Lehman Brothers

• Managed 500+ mission-critical databases in a 24x7 production environment, ensuring high availability.

• Implemented Sybase database configuration changes, Kerberos Installations and EBF upgrades.

• Worked on Sybase replication installation, configuration of replication, troubleshooting and maintenance.

• Worked on resolving database outages/performance issues. Education:

C-PGDBA in Information Technology – Symbiosis Centre for Distance Learning, Pune, India 2012-2014 Bachelor of Technology in Computer Science & Engineering – Kakatiya University, Khammam, India 2002-2006 Technical Skills:

• Databases: Oracle, SQL Server, Sybase, MySQL, PostgreSQL, MongoDB, MarkLogic

• Cloud Technologies: AWS, Azure, Snowflake

• Automation: Terraform, Ansible, Jenkins

• Tools: Toad, OEM, McAfee ADS, F5, Actifio, GitHub, SVN, Stash, Nagios, Cygwin, SOAPUI, Cockpit

• Languages: SQL, PL/SQL, TSQL, Shell, Perl, Python

• Methodologies: Agile, DevOps

• Other: High Availability, Disaster Recovery, Security

Contact this candidate