Database Engineer

Role Overview

As a Database Engineer, you will be responsible for developing and optimizing complex SQL queries, stored procedures, functions, and views. You will also design, implement, and maintain SQL Server databases in a dynamic, collaborative team environment.

• Collaborates with clients and/or internal teams to understand user needs; collaborates on initial proposal and design of software to meet these needs.
• Design, implement, and maintain robust SQL Server database systems.
• Develop and optimize complex SQL queries, stored procedures, functions, and views.
• Develops ETL, Data Warehouse, Data Vault, Data Modeling, Big Data, and Data Migration tasks.
• Collaborate with development teams to design efficient data models and ensure seamless integration with applications
• Participate in architectural and design discussions to ensure APIs align with business goals.
• Monitor and optimize database performance by fine-tuning queries, indexing strategies, and resource allocation.
• Work with cross-functional teams to plan and execute database upgrades, migrations, and integrations.
• Provide technical support and troubleshooting for database-related incidents and queries
• Diagnose and resolve database-related issues, ensuring minimal downtime and high availability.
• Implement performance monitoring and alerting systems to proactively manage potential issues.
• Designs data models and database schemas for specific application areas.
• Collaborates with systems analysts, engineers, and programmers to design systems to support required applications.
• Document database architectures, configurations, and processes to ensure maintainability and compliance.
• Performs other related duties as assigned.

Requirements

• Bachelor’s degree in computer science, engineering, or related field required.
• At least five years of experience as a software developer or database engineer required.
• Strong proficiency in SQL and experience with database performance tuning, query optimization, and index management.
• In-depth knowledge of backup and recovery strategies, high availability, and disaster recovery solutions for SQL Server.
• Familiarity with scripting languages (e.g., PowerShell) for automating database tasks.
• Experience working with SQL and writing queries for relational databases.
• Familiarity with relational databases (SQL Server, etc.) and designing efficient queries.
• Experience with data warehousing, ETL processes, or big data technologies.
• Knowledge of additional database platforms and modern data architecture patterns.
• Excellent time management skills with the proven ability to meet deadlines.
• Ability to participate in Agile sprinting and ceremonies.
• Collaborative mindset with a proactive, problem-solving approach.
• Ability to manage complex technical conversations and align cross-functional teams.

Advantageous Experience/Skills:

• Experience with Azure cloud services and platform is preferred.
• Experience with cloud-based database services (e.g., Azure SQL Database) is a plus.

Tech Stack

• Azure
• Cloud
• ETL
• SQL
• Vault