PL-SQL Lead

2 days ago

Chennai, Tamil Nadu, India Resourcetree Full time

Primary Skills : SQL / PL SQL,SQL/TSQL

Secondary Skills : Database Administration

Role Description :

Database Engineer will be responsible for designing, implementing, maintaining and optimizing database solutions that meet performance, scalability, and reliability requirements within the data engineering project.

Role 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 fastpaced 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)

  • PL/SQL Developer

    2 weeks ago

    Chennai, Tamil Nadu, India Antal International Full time

    Job DescriptionOur client is a leading specialty e-retailer offering consumer products, vacations and online education services through an easy and convenient payment plan. Their customers love them because they make paying for their purchases stress- and hassle-free. The automatic payments help customers to avoid penalty fees and ballooning interest...

  • PL/SQL Developer

    2 weeks ago

    Chennai, Tamil Nadu, India Antal International Full time

    Job Description Our client is a leading specialty e-retailer offering consumer products, vacations and online education services through an easy and convenient payment plan. Their customers love them because they make paying for their purchases stress- and hassle-free. The automatic payments help customers to avoid penalty fees and ballooning interest...

  • Nsp Oracle Pl SQL

    2 weeks ago

    Chennai, Tamil Nadu, India Incedo Full time

    Company OverviewIncedo is a US-based consulting, data science and technology services firm with over 2,500 people helping clients from our six offices across US and India. We help our clients achieve competitive advantage through end-to-end digital transformation. Our uniqueness lies in bringing together strong engineering, data science, and design...

  • SQL Lead

    2 weeks ago

    Chennai, Tamil Nadu, India ProConnxt Full time

    Job Title: SQL Server Developer Ref ID: # Location: Chennai Employment Type: Full-Time Experience: 5 years Qualification: Degree in Computer Science or Information Technology Company Overview: Mylapay is a leading fintech company at the forefront of innovation in the payment domain. We are committed to delivering cutting-edge financial solutions that empower...

  • Team Lead

    2 weeks ago

    Chennai, Tamil Nadu, India Sanmina Full time

    Job Description Programmer/Analyst 4 Duties of Position:Design and develop functions, Triggers, Views, Cursors in Oracle according to the Project requirementUnderstand the project requirement and develop design specificationWrite clear code and prepare coding documentationAnalyze and troubleshoot system issues in a timely mannerDevelop Oracle reports,...

  • SQL Lead

    2 weeks ago

    Chennai, Tamil Nadu, India ProConnxt Full time

    JobTitle: SQL Server Developer Ref ID:# Location:Chennai Employment Type:FullTime Experience: 5 years Qualification: Degree inComputer Science or Information Technology CompanyOverview: Mylapay is a leading fintech company at the forefront ofinnovation in the payment domain. We are committed to deliveringcuttingedge financial solutions that empower...

  • SQL Lead

    2 weeks ago

    Chennai, Tamil Nadu, India ProConnxt Full time

    Job Title: SQL Server DeveloperLocation: ChennaiEmployment Type: Full-TimeExperience: 5 yearsQualification: Degree in Computer Science or Information TechnologyCompany Overview: Mylapay is a prominent fintech organization paving the way for innovation in the payment sector. We are dedicated to providing state-of-the-art financial solutions that empower...

  • Java Technical Lead Newt Globa

    2 weeks ago

    Chennai, Tamil Nadu, India Nityo Infotech Full time

    Java , Oracle , SQL , AWS , Advantage , Application , Azure , Cloud , Experiences , Framework , Hibernate , India , Java , Location , Microservices , ONE , Oracle , PAN , Positions , PostgreSQL , Primary , SQL , Salary , Server , Spring , Spring Framework , Version , WebLogic , WebSphere , PL SQL Experience Required Years Industry Type IT ...

  • Java Technical Lead Newt Globa

    2 weeks ago

    Chennai, Tamil Nadu, India Nityo Infotech Full time

    Java , Oracle , SQL , AWS , Advantage , Application , Azure , Cloud , Experiences , Framework , Hibernate , India , Java , Location , Microservices , ONE , Oracle , PAN , Positions , PostgreSQL , Primary , SQL , Salary , Server , Spring , Spring Framework , Version , WebLogic , WebSphere , PL SQLExperience Required 10 YearsIndustry TypeITEmployment...

  • Technical Lead

    2 weeks ago

    Chennai, Tamil Nadu, India EducoHire Full time

    Net Back end Development Technical Lead needed in an IT firm in Chennai.(Immediate Joining)- Proficiency with web application lifecycle and front-end, back-end frameworks in .NET framework 4.5Advanced TSQL or PL/SQL database development skills in Microsoft SQL Server (2012/2016 and above) or Oracle 11G/12C/19CHands-on experience in database design,...

  • Lead System Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India Tiger Analytics Full time

    Job DescriptionShould have 7+ years of experience, with previous experience in Production support Projects,Prior experience of Supporting Mobile applications will be an added advantageFlexible to work in 24X7 shiftsFlexible to work from office 3-5days work weekAbility to analyze system logs, error messages, and other data to identify patterns and trends and...

  • Team Lead

    2 weeks ago

    Chennai, Tamil Nadu, India Sanmina Full time

    Job DescriptionProgrammer/Analyst 4Duties of Position:Design and develop functions, Triggers, Views, Cursors in Oracle according to the Project requirementUnderstand the project requirement and develop design specificationWrite clear code and prepare coding documentationAnalyze and troubleshoot system issues in a timely mannerDevelop Oracle reports, database...

  • Lead AbInitio Developer

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Lead AbInitio Developer - CREQ179624 Description Job Description:Responsibilities: 6+ years IT experience and exposure to tools ETL/Data warehousing technology (Experience in Ab Initio technologies including, but not limited to Ab Initio graph development, EME, Co-Op, BRE, Continuous flow)Understanding of architecture and design across all systemsContribute...

  • Hiring For Full stack Lead Angular 11

    5 days ago

    Chennai, Tamil Nadu, India timesjobs Full time

    ## ### Hiring For Full stack Lead Angular 11: Full stack Lead Angular 11Desired Profile Skills: Java Full stack, Java 8, Spring MVC, Spring Boot, Micro services, Hibernet, JS frameworks Angular 8 & above, React JS, MEAN stack, Relational (PL-SQL/Oracle/SQL Server) and NOSQL databases, Design Patterns, Kafka, CI-CD pipeline using Jenkins, Kubernetes,...

  • Lead Software Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Lead Software Engineer - CREQ186152 DescriptionJob Description:Responsibilities:Analyze and identify process and tooling improvementsLiaise with global business, support and development teamsManage stakeholder expectations. Provide comprehensive and timely projects updates to Technology and Business stakeholdersDesign and own the Change Management...

  • Lead/Senior Java Developer

    2 weeks ago

    Chennai, Tamil Nadu, India Sourceone Staffing Solutions Full time

    Job Description :We are currently seeking a Java lead to spearhead Spring / Quarkus based Rest API development. The ideal candidate must possess practical experience with cloud environments to deploy applications, manage database access, and be well-versed in writing SQL / PL SQL.Responsibilities : Understanding the development life cycle. Conducting...

  • Abinitio - Lead

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Abinitio - Lead - CREQ185650 DescriptionJob Description:Responsibilities:Analyze and identify process and tooling improvementsLiaise with global business, support and development teamsManage stakeholder expectations. Provide comprehensive and timely projects updates to Technology and Business stakeholdersDesign and own the Change Management processProvide...

  • Technical Lead Informatica Power Center

    2 weeks ago

    Chennai, Tamil Nadu, India PeopleLogic Full time

    Desired Competencies:MustHave(Ideally should not bemore than 35) Informatica Unix Shell scripting and OracleDatabase GoodtoHave Sql PL/SQL Maestro scheduler Responsibility 1 Understandrequirements and come up with Technical Specs & Low LevelDesign for development.2 Develop and modify informaticamappings and workflows based on the technical...

  • Lead Software Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Lead Software Engineer - CREQ186152 Description Job Description: Responsibilities: Analyze and identify process and tooling improvements Liaise with global business, support and development teams Manage stakeholder expectations. Provide comprehensive and timely projects updates to Technology and Business stakeholders Design and own the Change...

  • Technical Lead Informatica Power Center

    2 weeks ago

    Chennai, Tamil Nadu, India PeopleLogic Full time

    Desired Competencies:MustHave(Ideally should not bemore than 35)Informatica Unix Shell scripting and OracleDatabaseGoodtoHaveSql PL/SQL Maestro schedulerResponsibility1 Understandrequirements and come up with Technical Specs & Low LevelDesign for development.2 Develop and modify informaticamappings and workflows based on the technical specifications andunit...