Sr. Database Developer

RESPONSIBILITIES:

 

Interact with business stakeholders to provide solutions addressing business data analytic requirements 

Work with SQL and other database access tools and methods to address business or technical requirements 

Design, implement and support data movement solutions across multiple platforms and data sources (Database tables/views and external files) using custom code and ETL tools and frameworks 

Conduct Shell scripting and advanced SQL developments 

Identify opportunities to fine-tune and optimize SQL queries/views 

Become proficient in the data model and data structures to be able to efficiently respond to business queries and requests 

Provide ongoing maintenance and support of database schemas and views 

Conduct root cause analysis and resolve production problems and data issues 

 

EXPERIENCE REQUIRED:

• Demonstrated experience working on the design, implementation, and deployment of large, complex software projects. 
• High Level of expertise with Oracle Database, PL/SQL programming and ASE Sybase,. 
• Familiarity with Python, Perl or other shell scripting languages.  
• Advanced proficiency with SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions) and SQL Performance/Tuning 
• Advanced proficiency with Packages/Functions/Procedures programming and debugging.
• Financial Industry Experience
• Experience of working with large volumes of data 
• Good understanding of Database Architecture 
• Solid understanding of relational and dimensional data models 
• Experience with business intelligence reporting tools, data integration tools , and metadata repository processes and tools 
• Full Software Development Lifecycle, including requirements identification, design, and task estimation.
• Ability to understand sophisticated mathematical and financial concepts
• Experience working on financial data model and orders/trade Flows
• Self-starter with proven ability and initiative to learn and research new concepts, ideas, and technologies quickly 
• Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills 
• Ability to take responsibility and work independently in a high-pressure, time critical environment.