Oracle Database Developer

Position: Senior Oracle Database Developer

Compensation: 55-70/hr (commensurate with level of experience)

Duration: 12-18 months with potential extension/conversion

Location: Hybrid (3 days onsite) in Charlotte, NC

Interview Process: 2 rounds- 30 minute phone call first round. 2nd round in person onsite

Job Description: Insight Global is seeking a Senior Oracle Database Developer to join one of our largest financial clients. The Senior Oracle Database Developer will be joining the Broker Dealer Regulatory Reporting Technology team.

Broker Dealer Regulatory Reporting Technology 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) there by 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 developer 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 for meeting design and delivery objectives.

Responsibilities include:
• Design and Develop database solutions enhancements in automating regulatory report generation process for Broker Dealer business.
• 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.
• Communicate effectively to obtain agreement between business partners and escalate items, when needed, to ensure execution activities remain on track.
• Troubleshoot problems in Production and lower environments

Partner well with the Scrum Master, Project Manager, and other Agile team members.

Required Skills:
• 7+ years of hands-on experience in Database architecture and development with Oracle 12c/19c
• Efficiency in SQL, performance tuning and debugging skills
• Strong understanding of data warehousing tools such as Informatica with efficient data transformation and processing skills.
• Good understanding of Job Schedulers like Autosys, Python programming language and Unix Shell Scripting.
• Knowledge of Agile Principles.

Nice to Have:
• Previous Investment banking/ regulatory reporting experience