Database Developer

What are we looking for in our Database Developer?

The Information Technology team at Russell Tobin & Associates is supporting a top banking association and payments company that has an opening for a Database Developer.

Location: Winston-Salem, NC
Pay Range: $105 - 115k
Type: FTE

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

“Russell Tobin offers eligible employee’s comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), a 401(k)-retirement savings, life & disability insurance, an employee assistance program, identity theft protection, legal support, auto and home insurance, pet insurance, and employee discounts with some preferred vendors.”

#CB
#LI-SS6

Rate/Salary: $105k - 115k