POSITION DESCRIPTION
The Database Developer is responsible for all activities required to provide a reliable, robust, and secure production environment for application databases. This will be a hands-on position involved in development tasks, day-to-day production issues, performance analysis, and other activities. These solutions are multi-terabyte databases implemented primarily using Microsoft SQL Server Enterprise Edition (2019, 2017 and 2016) and utilize enterprise features such as table partitioning.
PRIMARY RESPONSIBILITIES
- Develop, implement and maintain database environments to meet SLAs (Service Level Agreements)
- Participate in gathering business requirements, analysis of source systems and helping to define underlying data sources and transformation requirements
- Perform work with very large marketing databases (VLDB’s)
- Active hands-on member of development, support and maintenance teams
- Perform resource and performance analysis and planning
- Evaluate and minimize risk to database and applications
- Load data into a data warehouse and assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities
- Provide technical assistance and serves as a resource to internal and external technology staff
Required Skills
- Bachelor's degree from a four-year college or university, or equivalent technical training
- 3-5 years of development experience with Microsoft SQL Server
- Experience with Microsoft SQL Server 2019, 2017 or 2016
- Database configuration, performance and support in a production environment
- Excellent communication skills (oral/written)
- Excellent interpersonal skills
- Ability to work effectively in a team situation with application developers and other database personnel
- Ability to work independently to resolve moderately-complex issues
- Demonstrates strong problem solving abilities
- Identifies production problems and proposes resolutions
- Experience in Performance Tuning and Optimization using native monitoring and troubleshooting tools
- Establish and maintain multiple database environments including Development, Test, and Production
PLUSES
- SSIS/SSRS/SSAS development
- Experience with Snowflake, BigQuery, or Redshift
- Professional experience with ETL and process automation
- Knowledge in database partitioning
- Certification in Microsoft SQL Server
RRD IS AN EEO/AA INCLUDING VETS AND DISABLED EMPLOYER
Required Experience