Back
India   India   Developer   Resourcetree -

PL-SQL Developer - Performance Tuning (4-6 yrs) Chennai (DevOps) | Developer in Technology Job at 1

Resourcetree

This listing was posted on hirist.

PL-SQL Developer - Performance Tuning (4-6 yrs) Chennai (DevOps)

Share
Tools
Location:
Chennai
Description:

Primary Skills : SQL / PL SQL,SQL/TSQLSecondary Skills : Database AdministrationRole Responsibility :1. Executes design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders.2. Architecting and managing various data model associated with Relational DBs (MS SQL Server, Oracle, etc.) and optionally NoSQL DBs (Azure Cosmos, MongoDB, Cassandra, etc.).3. Design, implementation and maintenance of database solutions, management of data access, and resolving database performance, capacity, and security issues.4. Perform problem-solving of application issues and production errors, including high level critical production issues that require immediate attention.5. Design and code a high volume of SQL queries, stored procedures, and maintenance of packages.Role Requirement :1. Proficient in basic and advanced SQL programming concepts (Procedures, Analytical functions etc.).2. Knowledgeable in Shell / PowerShell scripting.3. Knowledgeable in relational databases, nonrelational databases, data streams, and file stores.4. Knowledgeable in performance tuning and optimization.5. Experience in Data Profiling and Data validation.6. Experience in requirements gathering and documentation processes and performing unit testing.7. Understanding and Implementing QA and various testing process in the project.8. Sound aptitude, outstanding logical reasoning, and analytical skills.9. Willingness to learn and take initiatives.10. Ability to adapt to fast-paced Agile environment.Additional Requirement :1. Design, develop, and maintain PL/SQL stored procedures, functions, triggers, and packages to support various business applications and processes.2. Implement advanced PL/SQL programming techniques such as dynamic SQL, bulk processing, and exception handling to enhance application performance and reliability.3. Proficiency in Oracle Database technologies, including PL/SQL, SQL, and Oracle Database Management tools.4. Collaborate with business analysts, software engineers, and data architects to analyze requirements, design database solutions, and implement data models.5. Optimize SQL queries, indexes, and database objects to improve query performance and overall system efficiency.6. Implement and enforce data governance policies, data security measures, and compliance standards to ensure data integrity and confidentiality.7. Solid understanding of relational database concepts, data modeling, and database optimization techniques.8. Oracle certifications (e.g., Oracle Certified Professional) are a plus (ref:hirist.tech)
Education/experience:
2 To 5 Years
Company:
Resourcetree
Posted:
April 30 on hirist
Share
Tools
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to hirist
Important Safety Tips
  • Always meet the employer in person.
  • Avoid sharing sensitive personal and financial information.
  • Avoid employment offers that require a deposit or investment.

To learn more, visit the Safety Center or click here to report this listing.

More About this Listing: PL-SQL Developer - Performance Tuning (4-6 yrs) Chennai (DevOps)
PL-SQL Developer - Performance Tuning (4-6 yrs) Chennai (DevOps) is a Technology Developer Job at Resourcetree located in India. Find other listings like PL-SQL Developer - Performance Tuning (4-6 yrs) Chennai (DevOps) by searching Oodle for Technology Developer Jobs.