Senior SQL Developer - Financial Applications - job id 33216


Your Way To Work™

Senior SQL Developer - Financial Applications

$160,000 F/T Employee

Downtown, NYC (FINANCIAL DISTRICT)



How to Apply

logo

George Konetsky


logo

(646) 876-9562


logo

(212) 616-4800 ext-180




A F/T position at company that owns and operates regulated exchanges and marketplaces..

Pay Options: F/T Employee.

Contact George Konetsky. call (646)876-9562 / (212)616-4800 ext.180 or email george@sans.com with the Job Code GK33216 or Click the Apply Now button ().

Location: Downtown.

Skills required for the position: MICROSOFT SQL SERVER, Database Development, T-SQL, STORED PROCEDURES.


Detailed Info:

Senior SQL Developer to develop, maintain and support the Index Systems built predominately on Microsoft SQL.

  • Will work with subject matter experts on database and data access patterns for the team.

  • Work closely with DBAs on any design or performance optimizations.

  • Aid in the design of the system working closely with track leads and the lead architect.

  • This includes developing technical specifications, design, coding and testing new features.

  • Provide on-call support as part of a team rotation. Triage, diagnose and remediate production issues that impact client file deliveries.

Development/Computing Environment:

7 + years working knowledge of Microsoft SQL Server 2008/2012 or newer versions.

  • Design, code and maintain new and existing complex T-SQL stored procedures, triggers and functions.

  • Experience with financial data (Reference Data, Pricing, Market Data) is a plus.

  • Experience automating data Import/Extraction using SQL Server tools; SSIS, BCP, bulk insert.

  • Experience with Analysis Services.

  • Create standards and best practices for database design and development.

  • Participates in application design and development process with developers.

  • Experience in database design, development, implementation and methodologies for Data warehouses and OLTP business systems.

  • Create T-SQL scripts to perform complex queries and complex data manipulations. Analyze troubleshoot and remediate data integrity issues.

  • Manage physical database design, implementation and performance tuning using query execution plans and index/data usage.

  • Assists in pre and post-implementation continuous improvement efforts in enhancing performance and helps developers to create and/or performance tune database queries.

  • Monitor systems; proactively manage and maintain configurations to insure performance and availability.

  • Monitor system for slowest queries and provide regular reports to the development teams. Experience analyzing hardware, software, network ecosystems to optimize database server performance including use of partitions and file layouts on disks.

  • Experience with use of dynamic management views to improve database performance. Experience resolving locking, dead lock issues.

The position offers competitive compensation package.


Job Id: 33216