$100K — $130K *
Purpose, The database developer is responsible for the design and development of database objects and procedural code to support various products for the organization. The database developer also creates programs to populate and maintain the data in the department’s transaction processing and data warehousing systems. This involves the creation of ETL programs along with the supporting stored procedures, functions, triggers, and constraints. The position requires extensive hands-on experience developing database queries, ETL, and associated code in a Microsoft SQL Server environment.
Specific Duties, Activities, and Responsibilities
Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.
Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.
Develop or modify procedures to solve complex database design problems, including performance, scalability, security and integration issues.
Design, develop and maintain SQL Server Reporting Services reports.
Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.
Troubleshooting and tuning complex SQL statements and making recommendations on indexing strategies.
Diagnose and resolve database performance issues. Support of production systems by providing timely fixes.
Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standard best practices.
Analyze business requirements and create/participate in designing solution architecture.
Education or Equivalent, BS in Computer Science or Information Systems
Experience or Equivalent, 8+ years of experience working with Microsoft SQL Server with emphasis on database code, ETL and Reporting Services development.
Knowledge, Skills, and Abilities Requirements
Microsoft SQL Server 2012 and above
Microsoft SQL Server Integration Services (SSIS) 2012 and above
Microsoft SQL Server Reporting Services (SSRS) 2012 and above
Microsoft Visual Studio 2017 and above
Embarcadero ER/Studio is a plus
Any Additional/Important Information
The database developer will additionally be responsible for the following tasks:
Base Salary - $100,000 to $125,000
5+ to 7 years experience
Seniority Level - Mid-Senior
Minimum Education - Bachelor's Degree
Willingness to Travel - Occasionally
Do you have experience with MS SQL 2014 and above experience?
Do you have experience with SSIS and SSRS (Sql server integration services SQL Server reporting services))?
Do you have experience with agile software development process?
Valid through: 7/5/2021