Previous Job
Previous
Senior Oracle PL/SQL Developer
Ref No.: 20-00108
Category: Experienced Professional
Location: Plano, Texas
Position Type:Contract
Start Date / End Date: 02/03/2020 to 02/26/2021
Genesis10 is currently seeking a Senior Oracle PL/SQL Developer with our client in the financial industry in their Plano, TX location. This is a 12 month + contract position.

Responsibilities:
  • The Database Engineer resource is responsible for developing complex models in a data warehousing environment, involving technical design, development, testing, and migration of Oracle SQL scripts, Java and Infrastructure components into production
  • The resource is expected to participate in BRD review sessions, Design Sessions along with development cycles
  • Be able to enhance the current frameworks and be able to write new frameworks as the need arises
  • Be able to proactively find performance bottlenecks and suggest remedies
  • Be able to manage multiple development, test and production environments
Requirements:
  • To create and debug Oracle code base & have prior experience working on database frameworks
  • Detail-oriented and be accountable for migrations across environments
  • Test and identify data anomalies/data patterns in huge data sets
  • Critical thinking to ensure all assumptions, constraints, behaviors are well thought through – and have good communication skills
  • Prior work experience in data warehouse involving millions of rows transformation
  • Prior Agile development experience with at least 2 to 3 projects done in Agile mode
  • Experience with continuous integration and continuous deployment tools, automated testing tools like Tosca would be advantageous
  • Candidate should be able to fast learner
  • Hands-on Experience in Oracle 11g/12c Development
  • Hands-on experience in Java, J2EE, Multi-Threading experience along with Spring Framework and Angular JavaScript Frameworks
  • Hands-on experience in writing/debugging Oracle procedure, functions and packages, triggers
  • Prior experience in database frameworks and application migration activities
  • Performance tuning to load/manipulate huge datasets daily using ETL frameworks
  • Experience in identifying data anomalies/data patterns in huge data sets to maintain data quality and to resolve production issues (L3 support)
  • Good analytical skills with critical thinking to ensure all assumptions, constraints, behaviors are well thought through – and have good communication skills
  • Experience in working with confidential data elements to provide data security and encryption
  • Hands-on knowledge of table partitioning, analytical functions, regular expressions, VPD, autonomous transactions, dynamic SQL, file read/write
  • Having good knowledge Unix commands and Unix shell scripting to support the application
  • Experience in Linux server build/maintenance to host the large application, storage appliances
  • Knowledge of NDM, SFTP, SSH key pairing
  • Hands-on with Job scheduler like Autosys and source control such as SVN, TFS, etc.
  • Must have executed projects from scratch i.e. starting from requirement gathering to production deployment and handover
  • Must be good in building/adhering to project plans
  • Domain knowledge of Corporate HR/Finance data of financial institution preferable
  • Able to work as a W2 employee of Genesis10 (no Corp-to-Corp)
Desired Skills:
  • Hands-on experience in MarkLogic, MuleSoft Microservices creation, Anypoint Studio, RAML creation and deployment
If you have the described qualifications and are interested in this exciting opportunity, please apply!

About Genesis10:

Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives. If you are a high performing business or IT professional with solid, referenced experience, we want to meet you. Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations. We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement – project after project. To learn more about Genesis10 and to view all our available career opportunities, please visit us at www.genesis10.com. "Genesis10 is an Equal Opportunity Employer, M/F/D/V”