TTI of USA
Job Description
Responsible for determining systems requirements for new or modified database application programs, creates the system specifications and is responsible for the development, testing and implementation of efficient, cost-effective application solutions. Will receive general direction from the Manager, work closely with business analysts to identify and specify complex business requirements and processes. May co-ordinate the activities of the section with the client area and other IT sections (e.g., database, operations, technical support).
Required Skills/Experience:
5-10 years of DB development experience across Oracle and SQL Server space Full understanding of relational database modelling Strong hands-on experience in in Oracle SQL and PL/SQL development in 11g and 12c environments Analyze user requirements and translate into database requirements and implement in database code Knowledge in writing packages/procedures Assist the development team in the design, development, testing, tuning and implementation of database applications Create and maintain SQL queries and routines, work with complex data models and object relational database mapping, producing complex reports Need to be able to optimize, tune and troubleshoot SQL code Good understanding of Server performance troubleshooting
Preferred Skills/Experience:
ETL nice to have (Extract-translate-load) Hands-on experience for PL/SQL batches, stored procedures, and database triggers creation and maintenance
Additional Information:
Duration: 7-month contract opportunity Work Model: Hybrid position that can sit out of Pennington, NJ, Pittsburgh, PA or Lake Mary, FL Rate Range: $80-85/hr. W2 (based on experience)
#J-18808-Ljbffr
Responsible for determining systems requirements for new or modified database application programs, creates the system specifications and is responsible for the development, testing and implementation of efficient, cost-effective application solutions. Will receive general direction from the Manager, work closely with business analysts to identify and specify complex business requirements and processes. May co-ordinate the activities of the section with the client area and other IT sections (e.g., database, operations, technical support).
Required Skills/Experience:
5-10 years of DB development experience across Oracle and SQL Server space Full understanding of relational database modelling Strong hands-on experience in in Oracle SQL and PL/SQL development in 11g and 12c environments Analyze user requirements and translate into database requirements and implement in database code Knowledge in writing packages/procedures Assist the development team in the design, development, testing, tuning and implementation of database applications Create and maintain SQL queries and routines, work with complex data models and object relational database mapping, producing complex reports Need to be able to optimize, tune and troubleshoot SQL code Good understanding of Server performance troubleshooting
Preferred Skills/Experience:
ETL nice to have (Extract-translate-load) Hands-on experience for PL/SQL batches, stored procedures, and database triggers creation and maintenance
Additional Information:
Duration: 7-month contract opportunity Work Model: Hybrid position that can sit out of Pennington, NJ, Pittsburgh, PA or Lake Mary, FL Rate Range: $80-85/hr. W2 (based on experience)
#J-18808-Ljbffr