Skip to main content

Database Developer

Technology
KTek Resourcing
Houston, United States1 month ago
Service contract

Job description

Role: Database Developer

Location: Houston, TX (Hybrid).

Who are we looking for?

We are looking for 8 Years of database development experience should have min 6 years of relevant experience. Strong SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.

Technical Skills:

  • Looking for 8 Years of database development experience and should have min 6 years of relevant experience
  • Strong PLSQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.
  • Expertise in using Oracle Performance tuning concepts with Oracle hints and EXPLAIN PLAN tool
  • Strong experience using SQL and PL/SQL features like Built In Functions, Analytical Functions, Cursors, Cursor variables, Native dynamic SQL, bulk binding techniques and Packages/Procedures/Functions wherever applicable to process data in an efficient manner
  • Strong understanding of Data Warehousing and Extraction Transformation Loading (ETL)
  • Sound understanding of RDBMS (Oracle)
  • Should have used Oracle SQL Loader/External File Utilities to load files
  • Strong experience using Python or Perl
  • Good to have experience with Snowflake cloud data platform including Snowflake utilities like SnowSQL, SnowPipe, data loading within cloud (AWS or Azure)- Mandatory.
  • Exposure in Investment Management (Evaluation, Cash Flow, Projections, Analytics)
  • Strong written and oral communication skills
  • Excellent problem-solving and quantitative skills
  • Demonstrated ability to work as part of a team.
  • Investment Management experience in the past
Keywords
monthsOfExperience: 96Oracle DatabaseCursorPl / sqlPythonPerlSqlAWSPl/sql

Interested in this role?