Job Description
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.
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 is a plus
Knowledge of AWS or cloud is a plus
Knowledge of Azure DevOps is a plus