Location
Winston Salem, NC | United States
Job description
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 is a plus
- Knowledge of AWS or cloud is a plus
- Knowledge of Azure DevOps is a plus
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
Success factors/job competencies: - Ability to design and implement quality solutions
- Resourceful when working independently
- Effectively interact with other disciplines to complete assigned tasks
- Timely and accurate completion of assigned tasks and project deadlines
- Available to work outside of normal working hours and be on-call when needed
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
Job tags
Salary