The Clearing House
Database Developer
The Clearing House, Winston Salem, North Carolina, United States, 27104
Position summary:
This database development position supports transaction processing and analytics for The Clearing House's high-volume payment products (Wire, ACH, etc.). Primary responsibilities include the design, development, and modernization of TCH's core database applications. The position requires significant experience developing high-performing applications on relational and non-relational databases, particularly Microsoft SQL Server. Other key requirements include expertise building scalable and reliable ETL pipelines to integrate batch and real-time data feeds with other systems. The ideal candidate will have extensive experience in Microsoft database development as well as a keen interest in re-engineering existing applications to leverage new technologies, including cloud-based services such as AWS data services.
Qualifications required:Bachelor's degree in Computer Science or equivalent degree or experienceStrong experience in Microsoft SQL database development experience with at least 4 years of operational experience in an enterprise database environment and 4 years of programming experienceExperience with MS SQL Server 2016 or newer, including familiarity with T-SQL, SSIS and SSRSExperience in programming languages, such as .NET, Java, or Python, and scripting such as PowershellExpertise in scalable database performance, including optimizing SQL queries and transactionsFamiliarity with team development, source code management, and CI/CD automationDetail-oriented with excellent organizational, follow-up, and analytical skillsExcellent verbal and written communication skillsEssential functions and responsibilities:
Design, develop, and maintain large scale database applications supporting critical transaction and analytic workloads for the company and our customersDesign, develop, and maintain Business Intelligence applications to support key data-driven functionsCollaborate with developers and database administrators (DBA's) to design data-driven servicesCreate and automate ETL processes and pipelines to deliver data reliably to downstream systemsWork with other internal groups and external customers to design optimal solutionsUse automated development tools to manage source code, versioning, and deploymentsSuccess factors/job competencies:
Ability to design and implement high-quality solutionsEffectively interact with other teams; resourceful when working independentlyTimely and accurate completion of tasks to meet product delivery deadlinesPerformance standards:
Complete development projects on time and with high qualityAbility to quickly troubleshoot issues and provide fixesMaintain a high level of quality in coding standards and development practicesContribute to development standards and assist with evaluation of others' workContinue to improve development skillsets and familiarity with new technologies
This database development position supports transaction processing and analytics for The Clearing House's high-volume payment products (Wire, ACH, etc.). Primary responsibilities include the design, development, and modernization of TCH's core database applications. The position requires significant experience developing high-performing applications on relational and non-relational databases, particularly Microsoft SQL Server. Other key requirements include expertise building scalable and reliable ETL pipelines to integrate batch and real-time data feeds with other systems. The ideal candidate will have extensive experience in Microsoft database development as well as a keen interest in re-engineering existing applications to leverage new technologies, including cloud-based services such as AWS data services.
Qualifications required:Bachelor's degree in Computer Science or equivalent degree or experienceStrong experience in Microsoft SQL database development experience with at least 4 years of operational experience in an enterprise database environment and 4 years of programming experienceExperience with MS SQL Server 2016 or newer, including familiarity with T-SQL, SSIS and SSRSExperience in programming languages, such as .NET, Java, or Python, and scripting such as PowershellExpertise in scalable database performance, including optimizing SQL queries and transactionsFamiliarity with team development, source code management, and CI/CD automationDetail-oriented with excellent organizational, follow-up, and analytical skillsExcellent verbal and written communication skillsEssential functions and responsibilities:
Design, develop, and maintain large scale database applications supporting critical transaction and analytic workloads for the company and our customersDesign, develop, and maintain Business Intelligence applications to support key data-driven functionsCollaborate with developers and database administrators (DBA's) to design data-driven servicesCreate and automate ETL processes and pipelines to deliver data reliably to downstream systemsWork with other internal groups and external customers to design optimal solutionsUse automated development tools to manage source code, versioning, and deploymentsSuccess factors/job competencies:
Ability to design and implement high-quality solutionsEffectively interact with other teams; resourceful when working independentlyTimely and accurate completion of tasks to meet product delivery deadlinesPerformance standards:
Complete development projects on time and with high qualityAbility to quickly troubleshoot issues and provide fixesMaintain a high level of quality in coding standards and development practicesContribute to development standards and assist with evaluation of others' workContinue to improve development skillsets and familiarity with new technologies