Senior 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 

-Work within the defined software development lifecycle, following rigorous change control policies 

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