Oracle Database Developer

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. 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.

REQUIRED SKILLS AND EXPERIENCE

• 7-15 years of hands-on experience in Database development with Oracle 12c/19c • Efficient SQL (writing code), 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 SKILLS AND EXPERIENCE

• Previous bank/ regulatory reporting experience

INTERNAL NOTES

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.