SUMMARY

Kavitha Chenchaiah

Raleigh, NC ad4cdh@r.postjobfree.com +669-***-****

LinkedIn: linkedin.com/in/kavitha-chenchaiah-0991a9b0 Database Administrator with 3 years of experience in Oracle and MSSQL systems, skilled in all facets of database management, including installation, configuration, and performance tuning. Adept in Oracle and MS SQL server maintenance, security, backup, refresh, and recovery procedures, additionally I excel in troubleshooting, migrations and implementing HA/DR strategies. My collaborative approach and ITIL knowledge enhance team support and incident management. WORK EXPERIENCE

Cognizant technology solutions, Bengaluru, India

Title: Sr System’s engineer (Database administrator) Feb 2017 – Oct 2019

• Managed Oracle (9i to 19c) and MSSQL databases in on-premises and Azure environments, overseeing lifecycle phases and daily administration tasks and possess good knowledge of AWS RDS

• Expert in performance tuning, including AWR/ASH report analysis, SQL/query optimization, and index analysis for both Oracle and MSSQL databases.

• Performed backup and recoveries using RMAN and data pump export/import processes for Oracle.

• Contributed to the design and implementation of a high-availability architecture using Oracle Golden Gate and Data guard

• High-level expertise in managing and administering OEM along with a solid aptitude for identifying issues, utilizing shell scripting, and proficiently monitoring to enhance database performance.

• Managed RAC clusters, database objects, tablespaces, and schemas; executed code deployments and refreshed environments for development and testing.

• Conducted real-time troubleshooting, resolving performance bottlenecks, and ensuring data integrity with regular backups and restores.

• Set up and optimized Oracle networking elements like tnsnames, and performed database upgrades, patching from Oracle 11g to 12c, and OS patch application.

• Performed and maintained Full, differential and transaction log database backups, restore and recovery strategies to ensure data integrity on MSSQL servers and expertise in rewriting stored procedures and packages to enhance system efficiency and performance.

• Implemented Microsoft SQL Server High Availability solutions such as SQL Clustering, AlwaysOn, database mirroring, replication technologies and used traces and SQL profiler to optimize queries and refine indexes for enhancing database efficiency.

• Established and enforced database security policies, managed user roles and privileges, ensuring compliance with data security and privacy standards, proficiency in using SSMS, SSRS, SSCM and SSIS SQL tools.

• Collaborated with software development teams for database schema changes and monitored database performance metrics on Azure.

• Provided technical guidance, shared expertise, and facilitated cross-training within the team. TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, SQL, C, C++, Python, Shell Oracle Database versions: Oracle 9i, 10g R1/R2, 11g R1/R2, 12c, 19c RDBMS: SQL Server 2003 – 2016

Operating Systems: Linux, AIX, and Windows

Tools/Utilities: Oracle Management server, MSSQL Server, SSMS, SSRS, SSIS, SSCM, Microsoft Azure, AWS RDS, RMAN, OEM, Data pump, VMware, SQL*Loader, Avamar, AWR and ASH reports, PowerShell, SQL profiler

CERTIFICATION

Microsoft certified: Azure Data Fundamentals

EDUCATION

Visvesvaraya Technological University (2012 – 2016) Bachelor of Engineering in Computer science