Oracle database developer

  • location: Santa Monica, CA
  • type: Temp to Perm
  • salary: $65 - $75 per hour

job description

Oracle database developer

job summary:
Job Description

Randstad Technologies is looking for a talented Oracle database engineer for a financial services client of ours in Santa Monica. The person would help with product development for our client, which is at the forefront of financial tech innovation.

Responsibilities

  • Design, code, test and maintain database objects like tables, views, packages, functions, procedures, indexes, sequences and triggers in Oracle
  • Design and develop custom ETL or ELT workflows using scheduling automation tools like Tidal
  • Strong knowledge and experience of SQL and PL/SQL programming
  • Strong understanding of Oracle Database fundamentals and features
  • Performance tuning of SQL, analyzing the AWR and advanced SQL, PL/SQL writing skills
  • Integrate data products with java and .net applications
  • Utilize advanced Oracle features and techniques where appropriate to develop robust, reliable and high-performance solutions
  • Translate requirements into technical specifications including the physical and logical data modeling, designing and data flow diagrams
  • Create reliable, performant, scalable architecture and effectively communicate with stake holders and teammates
  • Strong foundation in analyzing the data and business scenarios
  • Create operations and technical documentation for developed systems and applications
  • Maintain awareness of new Oracle features and techniques
  • Participate in and support QA and user-acceptance test procedures and environments
  • Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues
  • Effectively participate in investigation and resolution of production issues
  • Production support requires working on shifts on nights and weekends as dictated by the business requirements
  • Collaborate with diverse teams to deliver on-time
  • Willing to take on-call rotation and occasional weekend work
Technical Qualifications

  • Bachelor's degree in Computer Science or similar major
  • 7+ years of experience developing database applications in PL/SQL using Stored procedures, Packages, Functions and Complex SQL
  • 5+ years of experience of developing applications on Oracle 11g and 12c databases on a Linux or Unix-based platform. Solid knowledge of Linux / Unix operating systems and shell programming is required. Java, Perl, Python, Rexx programming is a plus
  • Sound understanding of development life cycle and version control
  • Experience developing on other RDMS like Microsoft SQL Server is a plus
  • Understanding of SDLC process and tools, agile project management concepts and version control
  • Experience with TIDAL (Cisco) enterprise scheduler or other automation products is preferred
  • Extensive SQL Query tuning using different tools. Clear understanding of query plan
Other Qualifications

  • Excellent problem solving, issue identification, analytical and technical documentation skills
  • Strong interpersonal skills and ability to work well in a team environment
  • Excellent communication skills
  • The person must have the ability to work in a fast-paced business environment
 
location: Santa Monica, California
job type: Contract
salary: $65 - 75 per hour
work hours: 9am to 5pm
education: Bachelors
 
responsibilities:
Responsibilities

  • Design, code, test and maintain database objects like tables, views, packages, functions, procedures, indexes, sequences and triggers in Oracle
  • Design and develop custom ETL or ELT workflows using scheduling automation tools like Tidal
  • strong knowledge and experience of SQL and PL/SQL programming
  • strong understanding of Oracle Database fundamentals and features
  • Performance tuning of SQL, analyzing the AWR and advanced SQL, PL/SQL writing skills
  • Integrate data products with java and .net applications
  • Utilize advanced Oracle features and techniques where appropriate to develop robust, reliable and high-performance solutions
  • Translate requirements into technical specifications including the physical and logical data modelling, designing and data flow diagrams
  • Create reliable, performant, scalable architecture and effectively communicate with stake holders and teammates
  • strong foundation on analyzing the data and business scenarios with attention to detail
  • Create operations and technical documentation for developed systems and applications
  • Maintain awareness of new Oracle features and techniques
  • Participate in and support QA and user-acceptance test procedures and environments
  • Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues
  • Effectively participate in investigation and resolution of production issues
  • Production support requires working on shifts on nights and weekends as dictated by the business requirements
  • Collaborate with diverse teams to deliver on-time
  • Willing to take on-call rotation and occasional weekend work
Qualifications

Knowledge and Experience

  • Bachelor's degree in Computer Science or similar major
  • 7+ years of experience developing database applications in PL/SQL using Stored procedures, Packages, Functions and Complex SQL
  • 5+ years of experience of developing applications on Oracle 11g and 12c databases on a Linux or Unix-based platform. Solid knowledge of Linux / Unix operating systems and shell programming is required. Java, Perl, Python, Rexx programming is a plus
  • Sound understanding of development life cycle and version control
  • Experience developing on other RDMS like Microsoft SQL Server is a plus
  • Understanding of SDLC process and tools, agile project management concepts and version control
  • Experience with TIDAL (Cisco) enterprise scheduler or other automation products is preferred
  • Excellent problem solving, issue identification, analytical and technical documentation skills
  • Extensive SQL Query tuning using different tools. Clear understanding of query plan
  • strong interpersonal skills and ability to work well in a team environment
  • Excellent communication skills
  • The person must have the ability to work in a fast-paced business environment
The essential functions of this role include:

  • working in a smoke free environment
 
qualifications:
  • Experience level: Experienced
  • Minimum 7 years of experience
  • Education: Bachelors
 
skills:
  • Oracle
  • UNIX, Linux and Windows
  • SQL

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Sr Developer

  • location: Santa Monica, CA
  • job type: Permanent
  • salary: $150,000 - $160,000 per year
  • date posted: 3/31/2020

    Sr Java Developer

  • location: Santa Monica, CA
  • job type: Permanent
  • salary: $150,000 - $159,999.94 per year
  • date posted: 3/31/2020

    iOS Developer

  • location: Los Angeles, CA
  • job type: Temp to Perm
  • salary: $65 - $75 per hour
  • date posted: 2/26/2020