Database Developer

KTek Resourcing; Houston (TX); On-site; USD 100,000 - 140,000; Full time

Job summary

KTek Resourcing is seeking an experienced database developer to join our clients team in the Houston area. You will design and optimize Oracle database objects, implement PL/SQL code, and support ETL processes with performance tuning and data loading tasks.

Candidates should have 8+ years of database development, strong SQL/PLSQL, Snowflake experience, and familiarity with cloud data loading (AWS or Azure). Excellent communication and teamwork are essential for this role.

Qualifications

• 8+ years of database development experience.
• Strong PL/SQL experience with Tables, Stored Procedures, DDL/DML, Views, Indexes, Cursors, Functions, and user-defined types.
• Expertise in Oracle performance tuning with hints and EXPLAIN PLAN.
• Proficient in SQL/PLSQL features, including analytical functions and bulk binding.
• Solid understanding of Data Warehousing and ETL concepts.
• Experience with Oracle in a data-rich environment (RDBMS).
• Experience with loading files via Oracle SQL Loader/External File Utilities.
• Proficiency in Python or Perl.
• Nice-to-have Snowflake cloud data platform experience (SnowSQL, SnowPipe, Snowflake data loading).
• Exposure to Investment Management analytics and cash flow projections.

Skills

Database development

PL/SQL

SQL

Python

ETL concepts

Oracle performance tuning

Analytical skills

Team collaboration

Investment management exposure

Tools

Snowflake

SnowSQL

SnowPipe

Oracle SQL Loader

Job description

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