Oracle Database Administrator - Insight Global

Position: Senior Oracle Database Architect

Duration: 12-18 months

Location: Charlotte, NC 28202

Job Description: Insight Global is seeking a Senior Oracle Database Architect to join one of our largest financial clients. Senior Oracle Database developer will be joining the Broker Dealer Regulatory Reporting Technology team. The Function is set up to replace legacy systems and processes with efficient technology stack, end-to-end automation of the daily report generation process and data sourcing from approved data source (ADS) thereby enabling the firm to calculate the accurate amounts and report the activity to SEC, FINRA.

Broker Dealer Regulatory Reporting Technology will be working on automating the FOCUS report generation by sourcing the data from Authorized Data Sources and reducing the manual adjustments of data. Recruiting a Database Architect with data warehousing application experience is very critical to meet Project’s tight SLA reporting deadlines as it involves complex problem-solving in the areas of data migration, application programming upgrade, backward compatibility, regression, and user training. Furthermore, an overarching understanding of the bank’s reporting processes and ADS systems is required to meet design and delivery objectives. This role will sit 3x onsite in Uptown Charlotte, NC.

Responsibilities include:

• Design & Develop database solutions & enhancements in automating regulatory report generation process for Broker Dealer business.
• Work across business and technology to create the solution intent and architectural vision for large complex solutions and evolve it based on an emerging backlog.
• Performance tuning of the existing application to enable fast and reliable intraday activities for the end users.
• Active contribution to application lifecycle including maintenance, release management, critical bug fixing and ensure error-free delivery of the software solution.
• Contribute in the creation of the architecture roadmap of defined domains (Business, Application, Data and Technology) in support of BDFRR roadmap for 2025.
• Work with Product Manager/Owner to plan and prioritize technology-focused backlog items for the architecture runway to enable business epics/features and expand into new opportunities.
• Partner well with the Scrum Master, Project Manager, and other Agile team members.

Must Haves

• 7-15 years of hands-on experience in Database development with Oracle 12c/19c
• Efficient SQL (writing code), performance tuning, and debugging skills.
• Good understanding of data warehousing tools such as Informatica with efficient data transformation and processing skills.
• Critical thinking and problem-solving skills and knowledge of Agile Principles.

Nice to Have:

• Good understanding of Job Schedulers like Autosys, Python programming language, and Unix Shell Scripting.
• Previous bank/ regulatory reporting experience

Compensation:

$50/hr to $70/hr.

Exact compensation may vary based on several factors, including skills, experience, and education.

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.