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.
