Praveenkumar Pk
Pl Sql Developer and Sqldeveloper @Tata Consultancy Services
Signup · Get unlimited contacts
WORK HISTORY
Pl Sql Developer and Sqldeveloper @Tata Consultancy Services
Hyderabad, IN
o Developed and optimized SQL queries to retrieve and manipulate data for various applications, resulting in improved performance and reduced response times.o Designed and implemented complex stored procedures, triggers, and packages to support business logic and data integrity requirements.o Collaborated with cross-functional teams to design and implement efficient database schemas, ensuring data consistency and security.o Conducted thorough performance tuning of SQL queries and PL/SQL code, reducing query execution time.o Assisted in data migration projects, successfully transferring data while ensuring data accuracy and minimal downtime.o Participated in code reviews, provided constructive feedback, and contributed to the continuous improvement of coding standards.o Assisted senior developers in writing and debugging SQL queries and PL/SQL scripts for data extraction and transformation.o Supported database administrators in monitoring and maintaining database systems, including backups and recovery processes.o Participated in the design of a database schema for a new application, contributing to data modeling and normalization efforts.
EDUCATION
Indian Institute of Information Technology, Tiruchirappalli
Bachelor of Technology - BTech
ABOUT PRAVEENKUMAR PK
Having 3+ years of Total IT (Information Technology) experience in Development and Implementation of My SQL, PL/SQL Programming and having some knowledge on Unix shell script.* Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Ref Cursors, Packages, Indexes and Exceptions.* Pleasant experience in query performance tuning.* Ability in Application Development using Oracle 11g/12C, PL/SQL, Oracle SQL developer, My SQL Work Bench, AWS (Amazon Web Services) EC2 Session Manager Plugin, Grid Gain database dbvear.* Good Working Knowledge of advanced concepts of PL/SQL.* Hands on Experience in Creation of Views and Materialized Views.* Good knowledge on Dynamic SQL.Involved in Analysis, Designing and Creating the Database Objects.* Experience in Query Optimization and Performance Tuning.* Having Good Analytical, Programming and Problem-Solving Skills* Having sound knowledge in writing Complex Queries.* Willingness to take on added responsibilities to meet team goals.* Updated old code bases to modern development standards, improving functionality.* Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.* Discussed issues with team members to supply resolution and apply best practices.* Participated in software field testing to verify performance of developed projects.* Documented technical workflows and knowledge to educate newly hired employees. Coordinated with project management on database development timelines.* Introduced agile methodologies and development best practices to division to enhance product development.* Writing SQL queries in Oracle, MySQL, Dbeaver, AWS EC2 session manger plugin for developing as per client requirement.* Developing SQL queries to migrate the data from Oracle to MySQL and from MySQL to Grid Gain by using AWS console and Gathr ETL tool.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.