Job description

Required Skills

• Strong software engineering skills with deep hands-on programming experience in database programming and design using SQL, PL/SQL using Oracle 19c or better (5-7 years)

· In-Depth knowledge of database concepts and hands-on experience in:

• Oracle SQL

• Oracle PL/SQL

• Database Objects

• Database design and development

• Full life-cycle development experience working in data centric applications such as data warehouse, data mart, operational data store, etc. ecosystem including data modelling through final solution.

• Ability to perform analysis of performance bottlenecks, propose options, and implement performance tuning recommendations for Oracle database queries/code and batch processes.

• ETL Design and Development: Informatica and/or DataStage

· Monitoring performance, troubleshoot and tuning ETL processes as appropriate

· Developing ETL workflows for periodic data loads from source to target databases

· Applying ETL principles and practices, and ability to implement complex solutions to problems

· Designing and building scalable ETL solutions.

· Skilled at ideation, design, and deployment of ETL solutions

· Full life-cycle development experience working in data centric applications such as data warehouse, data mart, operational data store, etc. ecosystem including data modeling, ETL, etc.

• Experience working in an Agile team

• Strong written and oral communicator who can work with minimum supervision. Must be able to clearly and succinctly articulate progress, issues, solutions, plans, results, and success

• Ability to provide technical leadership to initiatives and teams.

Desired Skills

• Experience in financial services industry, especially with Bank of America, is a plus.

• Exposure to CI/CD tools like Jenkins, Maven etc.

• Advanced understanding of SQL, PL/SQL stored procedures, triggers, partitions, primary keys, different indexes, views

• In-Depth knowledge of database concepts and hands-on experience in:

• Linux/Unix shell scripting

• Debugging and modifying existing application

• Installing configuration of applications and maintaining environments

• Toad

• Batch scheduling software such as Autosys

• Jira

• Python

• SQL*Loader

• External Tables and Directories

• Data Modelling

• Data Dictionary

• Common Packages such as UTL File, DBMS_OUTPUT

• Oracle Enterprise Manager (OEM)

• Demonstrated ability to analyze and determine the feasibility of leveraging the Oracle Enterprise Manager solution as the centralized proactive maintenance solution for Oracle database processes, i.e., report on performance and provide metrics.

• Experience with dimensional data models and data model tools such as Toad Data Modeler and/or Power Designer

• Experience in BigData (Hadoop) and Exadata is a plus

• Planning skills -- ability to think ahead and be proactive

• Ability to build strong relationships with people of all levels of the organization and influence to bring about positive change

• Positive "can do" attitude

• Continuous improvement mindset

• Ability to encourage and accept feedback from all stakeholders with an open mind and take appropriate actions to follow up

• Voracious learner

• Intellectually curious

• Self-motivated

Job Type: Contract

Pay: Up to $70.00 per hour

Experience level:

• 10 years
• 11+ years

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Plano, TX 75024: Reliably commute or planning to relocate before starting work (Required)

Experience:

• Oracle: 9 years (Preferred)
• SQL: 10 years (Preferred)
• Data warehouse: 8 years (Preferred)
• PL/SQL: 8 years (Preferred)

Work Location: In person

seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.