Role: Database Developer
Location: Winston Salem, NC
Full time
Hybrid
Position summary:
· This is an enterprise system, 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
Required Skills:
· SQL, SSRS, SSIS components
· Communication Skills a MUST!
· Will work independently
· Interaction with Users & Technology teams
· Must be efficient, meets deadlines
· SSIS, Queries, combination, some bldg. (new projects) lots of maintenance, troubleshooting, manipulation, injecting, cleaning & purging
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