Senior Database Developer

Responsibilities

• Interact with business stakeholders to provide solutions that address business data analytics requirements.
• Work with SQL and other database access tools and methods to meet business or technical needs.
• 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/frameworks.
• Conduct shell scripting and advanced SQL development.
• Identify opportunities to fine-tune and optimize SQL queries and views.
• Become proficient in the data model and data structures to efficiently respond to business queries and requests.
• Provide ongoing maintenance and support for database schemas and views.
• Conduct root-cause analysis and resolve production problems and data issues.
• Work within the defined software development lifecycle, following established change-control policies.

Qualifications

• 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 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 experience, including requirements identification, design, and task estimation.
• Ability to understand sophisticated mathematical and financial concepts.
• Experience working on financial data models 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.