Oracle SQL DBA

Job Title : Application Programmer V_ Database

Location : Hybrid role: 3 Days Onsite. - 90% local candidates only. - Addison, TX

Duration : Only W2 - 12 months

Rate: $62 to $68/hr on W2

Job Description :

Need: Very strong on Data warehouse please Avoid OLAP and OLTP candidates here

Interview rounds: 2roounds 1 Webex and 2-In-person

Max Experience 12 to 15 Years

Working Hours: 9:00 AM to 6:00 PM CST.

Required Skills:

Requirements include

10 years of experience (in the financial industry) working experience in Data Warehousing environments with very large amounts of data.
Review the E2E ETL process and apply critical performance tuning skills to optimize the Oracle ETL process and real time operational services;
Candidates must possess advanced problem-solving skills, analyzing complex data and ability to connect dots to understand data across different systems and multiple claims products, able to work multiple projects assignments concurrently, willingness to self-learn and ability to communicate verbally effectively and concisely and in written/presentable format.
Candidates must work well in a supportive and transparent team environment, while having the ability to research and resolve issues independently.
Candidates must have good communication skills and the ability to engage multiple business analysts and developers/dev leads and influence teams across Claims technology and the business.
Required Skills
Primary: Oracle SQL / PLSQL
Secondary: Data Warehousing
Tertiary: ETL Data Frameworks

Sr. Oracle developer with 12 years hands on skills to provide effective data design solutions in Data Warehousing environment with very large amounts of data.
Advanced Oracle PL/SQL with DBA experience (10 years) with ability to identify areas needing performance improvement, studying Oracle execution/query plans, Oracle AWR reports and apply skills in identifying problematic areas and fine tune the queries/tables and indexes optimizations,
Be able to design the conceptual, logical and physical data models necessary to support the data requirements in Data warehouse environments,
Working experience building high performance ETL Data Frameworks with error handling and scalability.
Strong working experience in database partitions, indexes, CDC, purging, data virtualizations,.
Strong analytics and communication skills including ability to drive diverse group towards common goals and clearly articulate both problems and proposed solutions
Ability to balance need to deliver multiple concurrent projects while maintaining architectural standards
3 years working Experience in Agile/Scrum delivery models
Unix scripting experience.
Creates documentation for all activities and work with project solution team in design of application and code developed.
Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value. Challenges data and information integrity. .
Strong data analysis skills
Preferred Skills
Experience in data visualization tools like Tableau (preferred), Power BI, ...
Experience/Exposure in in Python, Hadoop, and Gen AI/ML
Financial Services/Banking industry experience a plus