Database Administrator Technology Solutions

SUMMARY

Kavitha Chenchaiah

Raleigh, NC ************@*****.*** +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 Client: Payless and Polo Ralph Lauren

The aim of these projects is to provide support in expanding needs of the retail operations, focusing on improving inventory tracking, customer behavior analysis, and sales forecasting. As a dba my responsibilities included designing and implementing a scalable database architecture, optimizing data flows, and ensuring high levels of data availability and security to support real-time analytics and decision-making processes

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

• 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.

• Adept at performance troubleshooting on Oracle RAC and Oracle Data Guard, enhancing system reliability.

• 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

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

• Expert knowledge of MS SQL servers (2003 – 2016) database administration including installation, management, troubleshooting, patching, migration, upgrading, and tuning

• Experience in migration, applying service packs, security updates and hotfixes as per the requirement for MS SQL Servers

• Proactively monitored MS-SQL databases and responded to alerts, ensuring system health and stability.

• Performed and maintained database backups, restore and recovery strategies, index rebuilds, statistics updates to ensure data integrity and enhance performance.

• Implemented Microsoft SQL Server High Availability solutions such as SQL Clustering, AlwaysOn, database mirroring, log shipping and replication technologies.

• Made use of traces, Windows performance monitor, Database engine tuning advisor, DMVs, DBCC 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.

• Provided technical guidance, shared expertise, facilitated cross-training within the team and collaborated with other developers and administrators to resolve issues.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, C, C++, Python, Shell

RDBMS: SQL Server 2003 – 2016, Oracle 9i, 10g R1/R2, 11g R1/R2, 12c, 19c 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

Contact this candidate