Database Developer

8+ years of MS SQL experience and they have to have 4 years of Programing skills (SQL)

If the person has AWS, it’s a plus since they are moving to AWS, Any cloud experience is a plus

Extensive SQL, Design and Development

She would like to see someone who has worked with Large Servers

Extensive Stored Procedures (Must be strong)

Strong SSIS SSRS and T-SQL skills required

SQL Reporting and Database development

Experience trouble shooting SQL Databases

Experience cleaning and purging data

Must have great communication skills

Location : NC

Hybrid Tuesday & Thursday and the candidate can pick what day to come every other week besides Tuesday (a must day)

Salary Range : $105k-$117k base

Bonus Target : 10%

Location : Winston-Salem, NC

of Openings : 1

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 :

• 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
• Bachelor’s degree in Computer Science / Information Technology or equivalent experience

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
30+ days ago