The Database Developer splits time between database development and database administration functions. This role will be working closely with the Software Engineers to create and maintain database objects while ensuring compliance to database best practices. The Database Developer will also be responsible for the performance, integrity and security of developed databases. Additionally, responsible for planning and troubleshooting databases and related web application systems.

Key Areas of Responsibility

Database development

• Play a leadership role in database architecture as well as data management stack decisions
• Streamline database tasks such as: database development, deployments, scripts, and source control of SQL artifacts
• Develop and maintain documentation of the database structures and related dependencies
• Evangelize database best practices within the Software Engineering team

Database administration

• Review all database changes created by software engineering and provide mentorship and positive feedback
• Ensure optimum performance, integrity and security of databases
• Maintenance and development of BLOB storage systems

Skills & Experience

• At least 5-10 years of SQL Server (Postgres, Aurora, and AWS) database development experience
• Practical experience in managing operations and configuration for backend database and related web application systems, including application performance optimization, securing, tuning, audit tracking and reporting
• Experience performing effective database development including design, stored procedures, triggers, UDF
• Experience with the following SQL Server technologies will be considered a plus: SSIS, SSRS, SSAS, SQL Server Replication/Clustering
• Experience managing databases in multiple instance environments such as Development, Testing, Demo and Production

Education

• Bachelor’s degree in computer science or an IT-related discipline