Programmer - T-SQL (Fairfield, IA)
Cambridge Investment Research - Fairfield, IA

This job posting is no longer available on Indeed. Find similar jobs: Programmer jobs - Cambridge Investment Research jobs

Cambridge Investment Research, Inc., a national leader as a securities broker/dealer, has an opening for a full time T-SQL Programmer. This position will participate with the department’s mission including implementing improved reliability, availability and security; major functional enhancements to application software; daily operational support; as well a technical re-design to migrate to SQL Server 2005 and .NET.

The T-SQL Programmer will provide key technical skills in support of our database administration, including:

  • Data modeling for new and existing distributed and replicated SQL Server databases; administration of enterprise data dictionary
  • Design, implement and monitor optimal backup strategies for each database to achieve maximum required data protection
  • Design, implement and maintain business logic that is implemented as stored procedures, views, user-defined functions and triggers
  • Design, implement and maintain Crystal Reports for use with VB6 and ASP.NET applications
  • Perform unit testing; participate in peer code reviews and design reviews
  • Administer database configuration controls for development, test, demo and production environments
  • Monitor and report on SQL Server database performance, backups, security, errors; validate database restore procedures; provide emergency system restore support
  • Design and implement automated data ETL processes
  • Perform ad hoc queries per user requests
  • Identify data integrity issues; convert data to more normalized and structured models
  • Participate in a server team project to implement database server clustering and failover
  • Provide coordination and programming leadership for other database designers and programmers

Job Requirements:

  • BSCS or equivalent experience
  • 4+ years of related experience

Why Cambridge? At Cambridge, you control the journey by joining a growing, fast-paced company that will help you build a career beyond your expectations. You will be more than just a number at Cambridge - just ask our employees! We were recognized as a Best of Iowa Business 2010 for supporting work-life balance.

  • Company Values – Commitment, Integrity, Flexibility and Kindness
  • Technical innovation – be part of a company that recognizes the critical importance of technology to our success and promote technical innovation as part of our leadership position in our industry
  • Excel at your strengths - Be part of a mature Scrum/Agile team approach to software development that allows you to excel at what you do best
  • Mentoring & Development - Advance your career through our technical mentoring program that is personalized to your goals, and an extensive in-house training program to develop your professional skills
  • Stability – join a stable privately-owned company in business for 30 years, nationally recognized in its industry with an 18-member executive team averaging 20 years industry experience and no reduction in workforce in over 10 years
  • Location – located in a dynamic community recognized as one of the Iowa Great Places featuring abundant recreation, sustainable living, and an entrepreneurial spirit uniquely found amongst the corn fields of southeastern Iowa.
  • Benefits include - Medical, Dental, 401(K), Short and Long term disability, Paid Holidays (including your birthday) and away time, LEED certified building, Wellness Benefit, Casual Dress Attire, Half-Mile Walking Trail, Dry Cleaning Services, Carpooling benefit, Volunteer paid time off, Onsite Massage Therapy, Financial Planning Classes

Indeed - 12 months ago - save job
About this company
6 reviews
Cambridge Investment Research, Inc. (Cambridge), is an independent, privately controlled broker-dealer with over $65 billion assets under...