Data Base Programmer/Analyst

Frontier Technologies LLC; Denver (CO); On-site; USD 80,000 - 120,000; Full time

Job summary

Frontier Technologies LLC seeks an experienced Oracle Data Modeler/Designer in Denver, Colorado. The ideal candidate will have more than 15 years of experience, including 5 years specifically in database design and architecture, and utilize Oracle databases to fulfill client needs efficiently.

Familiarity with Erwin and various Oracle versions is also essential. Responsibilities include understanding data requirements and implementing best practices for database management. Candidates should be proficient in Unix shell scripting and have relevant AWS certifications.

Qualifications

• 15+ years of total experience with 5+ years in database design and modeling.
• Strong experience in data modeling for business objects and warehouses.
• Familiar with ETL tools and data transformation processes.

Responsibilities

• Design and build database structures based on user requirements.
• Implement best practices for database design and management.
• Provide support for data extraction and transformation.

Skills

Oracle

Data Modeling

DB2

Java

Oracle application server

SQL

AWS-CSA (Cloud)

Tools

Erwin

Oracle 11g

Oracle 12c

Unix Shell Scripting

Job description

Frontier Technologies LLC is an IT Services and Consulting Company formed in 2002 that specializes in staff augmentation & customized staffing solutions. It provides individualized attention to each of its client’s needs and deploys the utmost quality through the right resources at the right time and for the right cost.

Job Description

Oracle Data Modeler/Designer

Overall 15+ years of experience with at least 5+ years of experience in database design, architecture, and data modeling for business objects, OLTP, ODS, and data marts or data warehouses utilizing Oracle. Working knowledge of Erwin in depth. Working knowledge and experience of Oracle 11g – preferably 12c. Working knowledge and experience of Unix shell scripting. Recommend best practices for database design (conceptual, logical, physical). Understand the data requirements, ETL layer, and tools familiarity with data transformation and extraction.

Qualifications

AWS‑CSA (Cloud), data modeling, DB2, Java, Oracle, Oracle 12c, Oracle application server, OEM, SQL.