Compunnel Inc.

Oracle SQL/PLSQL Developer (Mexico Based role)

Mexico

3 days ago
Save Job

Summary

We are looking for a 7+ years of experienced Oracle SQL/PLSQL Developer to join our dynamic team. The ideal candidate will have hands-on experience in developing, optimizing, and maintaining complex SQL queries, writing PL/SQL procedures and functions, and working with Oracle databases to deliver high-quality solutions. You will collaborate with cross-functional teams to understand business requirements and implement database solutions that support the organization's goals.


Technical Skills:

  • Strong experience with Oracle SQL and PL/SQL development.
  • Proficiency in writing complex SQL queries and stored procedures.
  • Experience with Oracle database versions (e.g., 12c, 19c).
  • Knowledge of database performance tuning, query optimization, and indexing.
  • Familiarity with Oracle tools like SQL*Plus, SQL Developer, TOAD, or similar.
  • Experience working with Oracle's built-in functions and packages.
  • Understanding of relational database design and normalization.
  • Familiarity with version control systems such as Git or SVN.
  • Strong problem-solving skills and attention to detail.
  • Ability to work both independently and as part of a team.
  • Excellent communication skills, both written and verbal.
  • Experience working with Gitlab, GitHub

Process Skills:

  • Knowledge of agile delivery model, process, and Agile/Scrum Methodologies
  • Knowledge of agile standards, methods, and procedures
  • Having exposure on Telecom Domain added advantage.


Responsibilities:

  • Design, develop, test, and deploy Oracle SQL and PL/SQL queries, procedures, functions, and packages.
  • Write complex queries for data extraction, manipulation, and reporting.
  • Optimize SQL queries for performance and scalability.
  • Perform database tuning to ensure optimal performance of SQL queries and PL/SQL code.
  • Analyze and debug PL/SQL procedures, triggers, and functions to resolve issues.
  • Work closely with application developers and business analysts to design and implement database solutions.
  • Maintain database objects such as tables, views, indexes, and triggers.
  • Ensure data integrity and accuracy through validation rules, constraints, and triggers.
  • Create and maintain documentation for database schemas, queries, and stored procedures.
  • Participate in code reviews and ensure best practices are followed.
  • Implement security measures to safeguard sensitive data and ensure compliance.
  • Troubleshoot and resolve database-related issues.
  • Provide support for database-related aspects of system migrations, upgrades, and enhancements.

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job