The Senior 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 database architecture, design, development tasks, some day-to-day production issues, performance analysis, and other activities that may be necessary. These solutions are multi-terabyte databases implemented primarily using Microsoft SQL Server Enterprise Edition (2012 and 2016) and utilize enterprise features such as table partitioning.
PRIMARY RESPONSIBILITIES
Develop, implement and maintain database environments to meet SLAs (Service Level Agreements)
Lead, participate in gathering business requirements, analysis of source systems, define underlying data sources and transformation requirements, design suitable data model, and develop metadata
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
4+ years of development experience with Microsoft SQL Server
Experience with Microsoft SQL Server 2012, 2014, 2016 or 2017
Database design, 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 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 Big Data (Hadoop, HDFS, Cloudera, MapReduce, Hortonworks, etc.)
Professional experience with ETL
Knowledge in database partitioning
Certification in Microsoft SQL Server
Experience with MariaDB, MySQL, or PostgreSQL
RRD IS AN EEO/AA INCLUDING VETS AND DISABLED EMPLOYER
Required Experience
Bachelor's degree from a four-year college or university, or equivalent technical training
4+ years of development experience with Microsoft SQL Server
Experience with Microsoft SQL Server 2012, 2014, 2016 or 2017
Database design, 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 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 Big Data (Hadoop, HDFS, Cloudera, MapReduce, Hortonworks, etc.)
Professional experience with ETL
Knowledge in database partitioning
Certification in Microsoft SQL Server
Experience with MariaDB, MySQL, or PostgreSQL
RRD IS AN EEO/AA INCLUDING VETS AND DISABLED EMPLOYER