Senior Oracle PL/SQL Developer
Posted Today by Raas Infotek LLC
Negotiable
Undetermined
Hybrid
Remote or Hybrid in Houston, Texas
Summary: We are looking for a Senior Oracle PL/SQL Developer with over 12 years of experience in designing, developing, and optimizing enterprise database applications. The candidate should possess strong skills in Oracle Database, PL/SQL programming, and performance tuning, with a preference for experience in large-scale environments. The role involves collaboration with various teams to ensure effective database solutions and support. The ideal candidate will also mentor junior developers and participate in code reviews.
Key Responsibilities:
- Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, and views.
- Develop and optimize SQL queries for high-performance data processing and reporting.
- Analyze business requirements and translate them into technical database solutions.
- Perform database performance tuning, query optimization, and troubleshooting.
- Develop ETL processes for data extraction, transformation, and loading.
- Work closely with business analysts, application developers, and data architects.
- Support production environments and resolve database-related issues.
- Create and maintain database design documents, technical specifications, and deployment procedures.
- Implement data validation, data quality, and data integrity controls.
- Participate in code reviews and ensure adherence to coding standards and best practices.
- Mentor junior developers and provide technical leadership on database initiatives.
- Collaborate with DevOps and application teams for deployment and release activities.
Key Skills:
- 12+ years of experience in Oracle Database Development.
- Strong expertise in Oracle PL/SQL programming.
- Extensive experience with Stored Procedures, Functions, Packages, Triggers, Views, Cursors, Collections, and Dynamic SQL.
- Strong knowledge of SQL query optimization and performance tuning.
- Experience with Oracle 11g, 12c, 19c, or higher.
- Expertise in indexing strategies, partitioning, and execution plan analysis.
- Experience with ETL/Data Warehousing concepts.
- Strong understanding of database design, normalization, and data modeling.
- Experience in Unix/Linux environments and shell scripting.
- Knowledge of source control tools such as Git, SVN, or Bitbucket.
- Excellent troubleshooting and problem-solving skills.
Salary (Rate): £70,000 yearly
City: Houston
Country: United States
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: Senior
Industry: IT
Job Title: Senior Oracle PL/SQL Developer (12+ Years Experience)
< data-start="163" data-end="179">Job SummaryWe are seeking an experienced Oracle PL/SQL Developer with 12+ years of hands-on experience in designing, developing, optimizing, and supporting enterprise database applications. The ideal candidate should have strong expertise in Oracle Database, PL/SQL programming, performance tuning, data modeling, ETL processes, and database architecture. Experience working in large-scale enterprise environments is highly preferred.
Key Responsibilities
- Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, and views.
- Develop and optimize SQL queries for high-performance data processing and reporting.
- Analyze business requirements and translate them into technical database solutions.
- Perform database performance tuning, query optimization, and troubleshooting.
- Develop ETL processes for data extraction, transformation, and loading.
- Work closely with business analysts, application developers, and data architects.
- Support production environments and resolve database-related issues.
- Create and maintain database design documents, technical specifications, and deployment procedures.
- Implement data validation, data quality, and data integrity controls.
- Participate in code reviews and ensure adherence to coding standards and best practices.
- Mentor junior developers and provide technical leadership on database initiatives.
- Collaborate with DevOps and application teams for deployment and release activities.
Required Skills & Qualifications
- 12+ years of experience in Oracle Database Development.
- Strong expertise in Oracle PL/SQL programming.
- Extensive experience with:
- Stored Procedures
- Functions
- Packages
- Triggers
- Views
- Cursors
- Collections
- Dynamic SQL
- Strong knowledge of SQL query optimization and performance tuning.
- Experience with Oracle 11g, 12c, 19c, or higher.
- Expertise in indexing strategies, partitioning, and execution plan analysis.
- Experience with ETL/Data Warehousing concepts.
- Strong understanding of database design, normalization, and data modeling.
- Experience in Unix/Linux environments and shell scripting.
- Knowledge of source control tools such as Git, SVN, or Bitbucket.
- Excellent troubleshooting and problem-solving skills.
Preferred Qualifications
- Experience with Oracle Data Integrator (ODI), Informatica, or other ETL tools.
- Experience with Oracle GoldenGate or data replication technologies.
- Exposure to cloud platforms such as AWS, Azure, or Oracle Cloud.
- Experience working in Agile/Scrum environments.
- Knowledge of Python or Java for database integration.
- Oracle Certification is a plus.
Nice to Have
- Banking, Healthcare, Insurance, Telecom, or Retail domain experience.
- Experience with reporting tools such as Tableau, Power BI, or Business Objects.
- Exposure to Data Lake and Big Data technologies.
Education
- Bachelor''s or Master''s degree in Computer Science, Information Technology, Engineering, or a related field.
Keywords: Oracle PL/SQL, SQL, Oracle Database, Performance Tuning, Query Optimization, ETL, Data Warehousing, Data Modeling, Indexing, Partitioning, Unix, Shell Scripting, ODI, Informatica, Oracle 19c, Git, Agile, Cloud, Oracle GoldenGate.