Rajamata Devi Kotta profile photo 1 on Tal

Rajamata Devi Kotta

Consultant at Deloitte

Krishna

7+ years of work experience

Deloitte
Jun 20261 moPresent

Hyderabad

Deloitte
Jan 20233 yrs 6 mosPresent

Hyderabad, Telangana, India

• Performed regular maintenance tasks on large databases. • Implemented performance tuning techniques to optimize query and database performance. • Developed functions, views, and triggers. • Implemented multithreading in Python scripts to improve data migration efficiency. • Reduced query time from 5 minutes to 20 seconds by implementing performance tuning techniques like indexing and parameter optimization. • Contributed to the end-to-end database architecture and design process, as well as provided support for Postgres DBA. • Assisted in the migration of data from Mongo DB to Postgres DB. • Integrated table inheritance, ensuring consistent constraint maintenance between parent and child tables.
Deloitte
Jan 20221 yr 1 moJan 2023

Hyderabad, Telangana, India

• Handled multiple error while performing data migrations from Oracle to Postgres in Python scripts due to format/encoding issue. • Worked on XML elements and JSON objects. • Developed Functions, Triggers ,Materialized views. • Alter the database parameters to enhance the database performance. • Helped back end team for converting oracle stored procedure to Java method. • Involved in migration of data Oracle LRCSP to Oracle ERP DB.
Accenture
Aug 20192 yrs 7 mosFeb 2022

Jaggayyapeta, Andhra Pradesh, India

We use SSMS Management studio to create tables and all. To write queries for application development based on requirements of client we write joins and subqueries.Perform data extraction based on business requirement by using complex queries with good performance and worked with data modelling. Good with DML, DDL, DCL, DQL, TCL and different types of keys in SQL like Primary key, Surrogate, key, Natural key, Foreign key and Composite key.

Education

Bachelor of Engineering, Electrical, Electronics and Communications Engineering

Amrita Sai Institute of Science & Technology, Amrita Sai Nagar, Paritala (PO), Kanchikacherla (MD), PIN-521180 (CC-AJ)

20154 yrs2019

Join Rajamata and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Rajamata Devi Kotta on Tal

Headline

Consultant at Deloitte

About

As a PostgreSQL developer and data engineer, my role involves utilizing Python scripts for data migration, specifically from source to target databases. The development environment is Visual Studio Code, an open-source platform that runs on both Red Hat and Linux operating systems. Our team prefers not to rely on third-party ERP tools. In addition to data migration, I am responsible for both database administration and development tasks. As a database administrator, my focus is on ensuring the database remains operational without downtime. I am actively involved in addressing production issues promptly. Furthermore, I contribute to query optimization for backend developers. This involves employing techniques such as indexing and parameter optimization based on specific requirements. My responsibilities also extend to query tuning to enhance overall database performance. Overall, my role encompasses a wide range of activities, including maintaining database integrity, addressing production issues, and optimizing queries for efficient performance.

Location

Krishna

Work experience

Consultant at Deloitte, Jun 2026 - Present · 1 mo, Hyderabad

DC ANALYST at Deloitte, Jan 2023 - Present · 3 yrs 6 mos, Hyderabad, Telangana, India, • Performed regular maintenance tasks on large databases. • Implemented performance tuning techniques to optimize query and database performance. • Developed functions, views, and triggers. • Implemented multithreading in Python scripts to improve data migration efficiency. • Reduced query time from 5 minutes to 20 seconds by implementing performance tuning techniques like indexing and parameter optimization. • Contributed to the end-to-end database architecture and design process, as well as provided support for Postgres DBA. • Assisted in the migration of data from Mongo DB to Postgres DB. • Integrated table inheritance, ensuring consistent constraint maintenance between parent and child tables.

Software Engineer Intern at Deloitte, Jan 2022 - Jan 2023 · 1 yr 1 mo, Hyderabad, Telangana, India, • Handled multiple error while performing data migrations from Oracle to Postgres in Python scripts due to format/encoding issue. • Worked on XML elements and JSON objects. • Developed Functions, Triggers ,Materialized views. • Alter the database parameters to enhance the database performance. • Helped back end team for converting oracle stored procedure to Java method. • Involved in migration of data Oracle LRCSP to Oracle ERP DB.

Business process new associate at Accenture, Aug 2019 - Feb 2022 · 2 yrs 7 mos, Jaggayyapeta, Andhra Pradesh, India, We use SSMS Management studio to create tables and all. To write queries for application development based on requirements of client we write joins and subqueries.Perform data extraction based on business requirement by using complex queries with good performance and worked with data modelling. Good with DML, DDL, DCL, DQL, TCL and different types of keys in SQL like Primary key, Surrogate, key, Natural key, Foreign key and Composite key.

Education

Bachelor of Engineering, Electrical, Electronics and Communications Engineering, Amrita Sai Institute of Science & Technology, Amrita Sai Nagar, Paritala (PO), Kanchikacherla (MD), PIN-521180 (CC-AJ)