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.