Sr. SQL Developer

Charles Alan Ltd. - Manhattan, NY (30+ days ago)


Sr. Database Developer

There is an urgent hire for Sr. Database Developer who will design, develop, implement and support a global data warehouse.

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 PL/SQL, shell scripting and advanced SQL developments
  • Identify opportunities to fine-tune and optimize SQL queries/views and PL/SQL programs
  • 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

EXPERIENCE REQUIRED:

  • Demonstrated experience working on the design, implementation, and deployment of large, complex software projects. (5+ Years)
  • High Level of expertise with Oracle 12c, and PL/SQL programming. (5+ Years)
  • Familiarity with Python, Perl or other shell scripting languages. (3+ Years)
  • Advanced proficiency with Oracle SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, distributed transactions) and Oracle SQL Performance/Tuning
  • Advanced proficiency with PL/SQL Packages/Functions/Procedures programming and debugging, Oracle Collection and Object Types
  • Experience with Oracle Data Pump, SQL*Loader and external tables framework
  • Experience of working with large volumes of data
  • Good understanding of Oracle 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
  • Plus : Expertise in full stack J2EE technologies, Servlets, Angular 2.0, Spring 4.0, HTML 5, XML, JSON, JQuery, JDBC, CSS (Bootstrap), JXLS, IText

Charles Alan is a global consulting firm providing services to leading financial services organizations.

Job Type: Full-time

Salary: $120,000.00 to $150,000.00 /year

Experience:

  • Perl: 3 years (Required)
  • Python: 3 years (Required)
  • SQL: 5 years (Required)
  • Data Modelling: 3 years (Required)
  • Oracle 12c: 5 years (Required)

Education:

  • Bachelor's (Required)

Location:

  • New York, NY (Required)

Work authorization:

  • United States (Required)