Summary
Overview
Work History
Education
Skills
Certification
Software
Timeline
Generic

Priyanka Saravanan

Senior software engineer
Chennai

Summary

6+ Years of Experience in Oracle PL/SQL development, proficient in optimizing queries and collaborating on efficient database solutions. Skilled Oracle DBA adept at installation, security, and performance monitoring for optimal functionality. Specialized in performance tuning, analyzing SQL queries, and implementing strategies like indexing and partitioning for enhanced efficiency.

Overview

7
7
years of professional experience
1
1
Certification
2
2
Languages

Work History

Senior Software Engineer

Dun & Bradstreet Technologies
11.2020 - Current
  • Proficient in Oracle Database Administration, encompassing installation, configuration, and maintenance.
  • Skilled in ensuring database security, implementing backup and recovery procedures.
  • Experienced in monitoring database performance and identifying areas for optimization.
  • Adept at implementing performance tuning techniques such as indexing, partitioning, and caching.
  • Strong knowledge of Oracle PL/SQL development, including writing and maintaining procedures, functions, and packages.
  • Collaborative team member, able to work effectively with cross-functional teams to deliver database solutions.
  • Detail-oriented and analytical approach to problem-solving, with a focus on optimizing database performance and efficiency.

Application Development Analyst

Accenture
04.2017 - 09.2020
  • Proficient in developing and maintaining Oracle PL/SQL procedures, functions, and packages. Skilled in optimizing database queries and collaborating with teams to deliver efficient database solutions.
  • Experienced in managing Oracle databases, from installation to security and backup. Proficient in monitoring database performance and resolving issues to ensure optimal functionality.
  • Skilled in analyzing SQL queries and optimizing database performance. Implement strategies such as indexing and partitioning to enhance efficiency and resolve performance bottlenecks.
  • Developed packages and procedures for monitoring the
  • growth of the databases, long running, blocking and high temp space using sessions in the database.
  • Expertised in SQL / PL-SQL performance tuning using various optimization techniques such as parallel processing, indexing, partitioning, influencing Oracle optimizer via hints and creating SQL profiles
  • Interpreted Oracle operations/processes using Explain Plan to identify the root cause of performance issues.
  • Expertised in analysis of AWR, ADDM, ASH, STATSPACK reports Using Oracle Enterprise Manager
  • Proactively monitored the performance issues in the database and took corrective and preventive actions as required

Education

B.E : Electrical And Electronics Engineering

Sri Krishna College of Technology
Coimbatore, India
06.2017

Skills

  • Oracle PLSQL

  • Oracle DBA

  • HTML Basics

  • Performance Optimization

  • CSS Basics

  • Performance tuning

Certification

Oracle DBA

Software

Sql developer

Toad

Putty

Winscp

Hp service center

Visual studio

Timeline

Senior Software Engineer

Dun & Bradstreet Technologies
11.2020 - Current

Application Development Analyst

Accenture
04.2017 - 09.2020

B.E : Electrical And Electronics Engineering

Sri Krishna College of Technology

Similar Profiles

  • Dudi Venkata Raghava

    Dudi Venkata RaghavaDudi Venkata Raghava

    Sr. Software Engineer at Dun & Bradstreet TechnologiesSr. Software Engineer at Dun & Bradstreet Technologies

    View Profile
  • Ellyn S. Colwell

    Ellyn S. ColwellEllyn S. Colwell

    AVP Business Development at Dun & BradstreetAVP Business Development at Dun & Bradstreet

    View Profile
  • JOHN GOULA Jr.

    JOHN GOULA Jr.JOHN GOULA Jr.

    ECC Professional - Sr. Technical Support Analyst at Dun & Bradstreet / Ensono CorporationECC Professional - Sr. Technical Support Analyst at Dun & Bradstreet / Ensono Corporation

    View Profile
Priyanka Saravanan Senior software engineer