Main Content

Careers

Database Development Specialist

Position: Database Development Specialist
Reports To: Director, Distributed Systems Development
Location: Dallas TX or Winston-Salem, NC

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 2014, 2016 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
  • Knowledge of IBM DB2
  • Knowledge of AWS or cloud
  • Knowledge of Azure DevOps
 

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

Physical Demands and Work Environment:

Work is generally sedentary in nature, but may require standing and walking. The working environment is generally favorable. Lighting and temperature are adequate, and there are no hazardous or unpleasant conditions caused by noise, dust, etc. Work is generally performed within an office environment, with standard office equipment available.

TCH places paramount importance on the health and safety of its employees, and, as such, we are taking all necessary steps to protect our workforce. Because this position may require business travel and/or working in close contact with colleagues and other third parties, TCH is requiring that the employee hired into this role present proof that they are fully vaccinated against COVID-19 during their first week of employment.

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