Sr. SQL Developer in Heredia at TradeStation

Date Posted: 11/9/2019

Job Snapshot

  • Employee Type:
  • Location:
  • Job Type:
  • Experience:
    At least 5 year(s)
  • Date Posted:

Job Description

Sr. SQL Developer
Heredia, Costa Rica

TradeStation is an on-line brokerage firm seeking to level the playing field for self-directed investors and traders, empowering them to claim their individual financial edge.  At TradeStation, we're continuously pushing the boundaries of what's possible, encouraging out-of-the-box thinking and relentless search for innovation.  We offer a collaborative and flexible work environment, competitive salaries, comprehensive benefits and an a generous PTO policy.

The Senior SQL Developer is responsible for the database design, data modeling, data transmission and distribution. The applicant must have strong knowledge and experience in database and data warehouse development, administration, integration and implantation.  Query optimization, performance tuning and storage allocation skills are also required.  The candidate is expected to make technical recommendations to business solutions.  A strong technical background with a wide degree of technical proficiency, creativity and latitude is expected.  Experience with Scrum and Agile development is a plus.
  • Logical design of new next generation databases
  • Perform query optimization, performance tuning and table partitioning
  • Assist and support DBA to troubleshoot various database and system issues from night batch processing to live trading activities
  • Ensure a secure and sound backend system to support the order execution system

  • Ability to convert business requirements into working, efficient, scalable, logical and physical data models and highly performant OLTP solutions
  • Ability to create stored procedures, functions, tables, views, indexes
  • Ability to troubleshoot complex T-SQL code (stored procedures and functions) for: incorrect results and/or slow performance
  • Ability to study existing data models and recommend areas of improvement
  • Ability to analyze large volumes of data to decipher patterns, trends, anomalies, outliers etc.
  • Ability to refactor code and conduct code reviews
  • Basic knowledge of PowerShell (if not currently familiar then willing to study and gain proficiency quickly)
  • Proficiency with recent versions of SQL Server and its features, SSMS, Visual Studio SSDT / database projects, SSIS, SSRS
  • Working knowledge of production support tools: extended events, profiler, database management views
  • Knowledge of database security: logins, users, roles, permissions, certificates, TDE, symmetric keys, encryption/decryption
  • Proficient with backups, restores, recovery models
  • Comfortable with source control: Git or other major platform
  • Willing to take full ownership of deliverables from conception to production implementation and support
  • Willing to work with other teams, departments, executives to deliver solutions that work for the company
  • Mentor and assist junior developers and those with expertise in areas other than databases on database design and development, performance tuning
  • Willing to change direction and switch context at very short notice
  • Proficient at working with co-workers in the same office or at remote offices collaborating over online tools
  • Excellent troubleshooting and problem resolution skills

  • 5+ years of experience with SQL Server database design and development
  • Bachelor’s Degree in Computer Science or related technical degree