Browse
Employers / Recruiters
Negotiable
Full-time
Continue
By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.
 Interview: Phone and F2F
Rate: 600- 650 Per day
Client is Banking

Description:

Job Description:
Financial client looking for a Senior Application DBA with expertise in PL/SQL Development to work on a Risk Aggregation platform providing a global view of all market risk of the firm. Loads exceeding 4 billion rows a day from 30 plus systems feed a 200TB Oracle database.

Job Duties:
  • Perform the architectural review of current state and provide a road map and implementation plan for the next generation architecture.
  • Analyze and enumerating possible architectures and the evaluation of the future state.
  • Redesign the ETL workflow of the risk fact table to achieve a performance improvement
  • Improving data extraction rates on the new Linux platform.
  • Design and develop the event driven automation of Data Readiness.
  • Extend the readiness functionality with JMS messaging from within the database.
  • Partitioning strategy and development of all database housekeeping facilities. Including creating, compressing and dropping partitions, data retention, and maintenance of statistics.

Required Skills/Background:
  • 8+ years of Application DBA experience (5+ of it in the financial industry)
  • Market Risk environment experience
  • Oracle RAC
  • PL/SQL programming expertise
  • Some Data warehousing experience is required
    • ETL/ELT/EDLT
    • Data Modeling
    • Partitioning
    • Indexing
  • Oracle Advanced Analytics
  • Ability to analyze and improve queries
  • Data Partitioning
  • Oracle Data Dictionary
  • Worked on Data Quality Control/Data Lineage
  • Linux
  • Scripting (K-Shell)
  • Java JMS
  • Very Large Data Base (VLDB)

Last updated on May 31, 2016

See more

More jobs at ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo

Analyze All

More jobs like this

Analyze All
Developed by Blake and Linh in the US and Vietnam.
We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord
Changelog
🚀 LaunchpadNov 27
Create a site and sell services based on your resume.
🔥 Job search dashboardNov 13
Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.
🫡 Cover letter instructionsSep 27
New Studio settings give you control over AI output.
✨ Cover Letter StudioAug 9
Automatically generate cover letters for any job.
🎯 Suggested filtersAug 6
Copilot suggests additional filters above the results.
⚡️ Quick applicationsAug 2
Apply to jobs using info from your resume. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.
🧠 Job AnalysisJul 12
Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status