Main Content

Distributed Systems Development Database Developer

Position: Distributed Systems Development Database Developer
Reports To: VP, Distributed Systems Development
Location: Dallas TX

Position Summary:

This is an enterprise systems, distributed development position where the primary responsibilities of the SQL development team include: architecture and design of a multi-terabyte SQL environment with emphasis upon security, high availability, optimization, performance, tuning, and automation.

Qualifications Required:

  • Bachelor’s degree in Computer Science /Information Technology or equivalent experience
  • 8+ years of Microsoft SQL experience with at least 4 years of operational experience in an enterprise database environment and 4 years of programing experience
  • Experience with MS SQL Server 2012, 2014 or newer
  • Detail oriented with excellent organizational, follow-up, and analytical skills
  • Excellent Verbal and written communication skills
  • Experience with Microsoft Visual Basic and/or Microsoft C#/.NET with preference being within ETL packages

Qualifications Desired:

  • Worked extensively with complex SSIS, SSRS, and T-SQL projects
  • Experience in database architecture design with preference in multi-terabyte SQL databases of 8 TB or larger
  • Worked with T-SQL, coding against million row tables
  • Experience with ODS, data warehousing and partitioned tables
  • Experience with a scripting language – with preference in PowerShell
  • Ability to think tactically and logically, identify significant success factors and execute them effectively
  • Knowledgeable of SSL Certificates
  • Experience with fail-over and High Availability (HA) Groups
  • Knowledge of SQL Security – Physical, logical, encryption, authentication, roles, auditing, & logging

Essential Functions and Responsibilities:

  • Design, develop, and maintain large scale SQL Server Database structures
  • Design, develop, and maintain T-SQL code
  • Stored Procedures, functions and views
  • Design, develop, and maintain Business Intelligence SSIS  projects
  • SSIS Project Deployment Preference
  • Design, develop, and maintain SQL Reporting with SSRS
  • Design, develop, and maintain Production troubleshooting scripts for other internal groups
  • Design, develop, and maintain automation and deployment tools for the Operational DBAs
  • PowerShell Preference
  • Be a technical and research resource for the Operational DBAs
  • Creation and maintenance of Database servers within Development Environment
  • Work with other internal groups, 3rd party groups, and external customers to design needed solutions
  • Provide support to QC (Quality Control)  and Operational DBAs on releases of code
  • Manage code and database objects with source control tool such as TFS
  • Ability to write efficient, well performing code
  • Ability to do query performance tuning in a SQL Server environment

Performance Standards:

  • Complete assigned development projects and tasks on time and with high quality
  • Ability to quickly troubleshoot issues and provide fixes
  • Contribute to development standards and assist with evaluation of others’ work
  • Maintain the risk-averse organizational culture in coding standards and practices
  • Continuing education to maintain and improve developer skillset

Apply Below*:

  • A letter of interest describing your experience and interest in the position
  • Your resume
  • Names and contact information of three references, or three letters of reference

* Please submit a single application per position.

Submit Your Resume