Vimerse Infotech - Pennington, NJ

posted about 2 months ago

Full-time
Pennington, NJ
Professional, Scientific, and Technical Services

About the position

The Database Developer position is a critical role within our organization, focusing on the development and optimization of database systems primarily using Oracle and SQL Server technologies. The successful candidate will be responsible for modeling databases, ensuring performance optimization, and troubleshooting SQL code. This role requires a deep understanding of relational database modeling and hands-on experience with Oracle SQL and PL/SQL development, particularly in 11g and 12c environments. The current environment utilizes Oracle 19c, and familiarity with this version is advantageous. In this position, you will analyze user requirements and translate them into database requirements, implementing these in database code. You will be tasked with creating and maintaining SQL queries and routines, working with complex data models, and producing intricate reports. Your ability to optimize, tune, and troubleshoot SQL code will be essential to ensure the efficiency and reliability of our database systems. This role is hybrid, based in either Pennington, NJ, or Pittsburgh, PA, and is expected to last between 6 to 12 months on a contract basis. As part of a fast-growing IT company, you will join a team of well-trained professionals dedicated to innovation and reliability. Our mission is to provide a professional support system to our clients, aligning with their core business activities to ensure cost-effectiveness and optimal resource utilization while adapting to dynamic market conditions. We pride ourselves on being an equal opportunity employer, committed to diversity and inclusion in the workplace.

Responsibilities

  • Model databases and ensure performance optimization.
  • Analyze user requirements and translate them into database requirements.
  • Implement database code based on user requirements.
  • Create and maintain SQL queries and routines.
  • Work with complex data models and object-relational database mapping.
  • Produce complex reports based on database queries.
  • Optimize, tune, and troubleshoot SQL code.
  • Write packages and procedures in Oracle SQL and PL/SQL.

Requirements

  • 5-10 years of database development experience across Oracle and SQL Server.
  • Full understanding of relational database modeling.
  • Strong hands-on experience in Oracle SQL and PL/SQL development in 11g and 12c environments.
  • Experience with the latest Oracle database technologies, including 19c.
  • Ability to analyze user requirements and implement them in database code.
  • Knowledge in writing packages and procedures.

Nice-to-haves

  • Experience with SQL Server databases.
  • Familiarity with database performance tuning and optimization techniques.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service