Career Mentors, LLC

Career Mentors, LLC

Oracle PL/SQL Developer

Jersey City, New Jersey, United States

Sponsorship not specified$60k-$70kDetected 138 days ago
PythonBashCode ReviewGitSQLSnowflakeCI/CDLinuxData AnalysisData EngineeringStatisticsManual TestingCommunicationCollaborationProblem Solving

About the role

  • The ideal candidate will have strong expertise in Oracle SQL/PLSQL development, database performance tuning, ETL pipelines, and Unix shell scripting, along with experience working in an Agile environment.

Responsibilities

  • Analyze existing business processes and implement Oracle-centric optimizations and automation.
  • Gather and document functional, non-functional, and technical requirements.
  • Perform data analysis and profiling to identify data quality issues.
  • Design and implement logical and physical data models, including Oracle schema design.
  • Develop and maintain complex PL/SQL packages, procedures, functions, and triggers.
  • Support application testing, data validation, and troubleshooting for Oracle and Vertica database processes.
  • Document end-to-end workflows, database procedures, and operational runbooks.
  • Collaborate with development teams to design test cases, debug issues, and maintain high data quality.
  • Support Agile development processes, including story refinement, requirement elaboration, and estimation.
  • Develop and maintain CI/CD pipelines and industry best practices for Oracle development.

Nice to have

  • Jersey City, NJ / Addison, TX (Nearby candidates preferred) 💼
  • Strong experience with PL/SQL packages, procedures, functions, triggers, and bulk processing.
  • Hands-on experience with Unix shell scripting (critical skill).
  • Experience working with job schedulers (Autosys preferred) to automate database processes.
  • Strong understanding of dimensional modeling, including star and snowflake schemas, facts, and dimensions.
  • Expertise in Oracle performance tuning using explain plans, indexing strategies, statistics, hints, and SQL optimization techniques.
  • Strong problem-solving, analytical, and communication skills.
  • Experience working in Agile development environments.

Skills

  • Experience integrating heterogeneous databases such as Oracle and MS SQL Server.

Compensation

  • $60k-$70k

Equal opportunity

  • TopTechTalent.ai believes that all persons are entitled to equal employment opportunities.
  • TopTechTalent.ai recruits, hires, trains, promotes, disciplines and provides other conditions of employment without regard to a person's race, color, ethnicity, religion, gender, gender identity, or expression, age, national origin, citizenship status, disability, veteran's status, sexual orientation, marital status or other classifications protected under law or Company policy.
  • This includes providing reasonable accommodation for team members' disabilities or religious beliefs and practices.
  • The government requires TopTechTalent.ai to maintain information on those who seek employment with the company, including their race and sex.

Visa & Work Authorization

  • ut regard to a person's race, color, ethnicity, religion, gender, gender identity, or expression, age, national origin, citizenship status, disability, veteran's status, sexual orientation, marital status or other classi
Apply directly at Career Mentors, LLC →Create a free account for alerts like thisView Career Mentors, LLC immigration profile

This listing is sourced directly from Career Mentors, LLC's careers page and normalized into a canonical job model.