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.
