"Alerted.org

Job Description

Role Overview

We are seeking an experienced Oracle PL/SQL Engineer to join our development team. The successful candidate will be responsible for designing, developing, and optimizing complex PL/SQL code, including packages, procedures, functions, and triggers, to support enterprise-scale applications. This role requires strong expertise in Oracle database development, performance tuning, and integration with front-end applications and microservices. The ideal candidate will work collaboratively with architects, application developers, QA, and product owners to deliver reliable and scalable database solutions.

Key Responsibilities

• Design, develop, and maintain PL/SQL packages, procedures, functions, and triggers in Oracle Database.

• Write efficient, maintainable, and scalable SQL queries to support application functionality.

• Perform database performance tuning, query optimization, and troubleshooting of slow-running SQL.

• Collaborate with application developers to integrate database logic with Java-based microservices, APIs, and front-end applications.

• Develop and maintain data models, ensuring proper database design and normalization.

• Support the design and implementation of ETL processes for data integration between systems.

• Ensure data integrity, consistency, and security across all database operations.

• Work with messaging systems (e.g., RabbitMQ, Kafka) to design and manage asynchronous data processing where applicable.

• Collaborate with solution architects to align database structures with application design.

• Partner with QA engineers to define testing strategies for stored procedures and database logic.

• Support DevOps and CI/CD pipelines by automating database deployments and migrations.

• Provide production support by investigating and resolving database issues, including root cause analysis and preventive measures.

• Document technical solutions, database structures, and best practices.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

-5-7+ years of professional experience as an Oracle PL/SQL Developer/Engineer.

-Expertise in PL/SQL development, including packages, procedures, functions, triggers, and views.

-Strong proficiency in SQL performance tuning and execution plan analysis.

-Hands-on experience with Oracle 12c/19c or later versions.

-Deep understanding of query optimization, and index strategy.

-Proficiency in debugging performance issues in high-throughput environments.

-Experience with database design for large-scale systems (50 TB)

-Experience with database integration in microservices and API-driven architecture.

-Knowledge of JSON handling and its use in Oracle for API integrations.

-Strong analytical and problem-solving skills.

-Excellent communication skills and ability to work cross-functionally with architects, developers, QA, and product owners. -Familiarity with DevOps practices and supporting .database deployments in CI/CD pipelines.

-Familiarity with messaging systems (RabbitMQ, Kafka) and their interaction with databases.

-Good understanding of data modeling concepts, database design, and normalization.