Pronix - Charlotte, NC
posted 28 days ago
Full-time - Senior
Charlotte, NC
Professional, Scientific, and Technical Services
About the position
The Senior Oracle Database Architect will be responsible for designing and developing database solutions to enhance the automation of regulatory report generation processes for the Broker Dealer business. This role involves performance tuning of existing applications, contributing to the application lifecycle, and ensuring effective communication with business partners to keep execution activities on track.
Responsibilities
- 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
Requirements
- Hands-on experience in Database architecture and development with Oracle 12c/19c with efficient SQL, performance tuning and debugging skills
- Good 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
- A good technical aptitude with an ability to take direction and lead as and when necessary
- An ability to contribute constructively in open discussions and being able to work with competing ideas to achieve project success with approved ideas
- Critical thinking and problem-solving skills
- Knowledge of Agile principles
Nice-to-haves
- Domain knowledge of Investment Banking/Regulatory reporting
