23 Aug
|
Spait Infotech
|
Canada
23 Aug
Spait Infotech
Canada
Key Responsibilities
- Develop, maintain, and optimize complex SQL queries, stored procedures, functions, and views.
- Design and maintain database tables, indexes, and other database objects.
- Analyze data and troubleshoot database and SQL-related issues.
- Improve query performance and database efficiency.
- Work with business and technical teams to understand data requirements.
- Perform data validation, reconciliation, and quality checks.
- Support data integration and ETL processes where required.
- Identify and resolve data inconsistencies and database performance issues.
- Participate in database development, testing, deployment, and production support.
- Create and maintain technical documentation related to databases and SQL processes.
- Follow database security, development,
and coding best practices.
Required Skills
- Strong proficiency in
SQL
.
- Experience with
Microsoft SQL Server / MySQL / PostgreSQL / Oracle
.
- Strong knowledge of joins, subqueries, CTEs, window functions, views, and stored procedures.
- Experience with query optimization and performance tuning.
- Good understanding of relational database concepts and database design.
- Experience with data analysis and troubleshooting.
- Knowledge of ETL/data integration concepts.
- Solid analytical and problem-solving skills.
- Good communication and collaboration skills.
📌 SQL Developer (Canada)
🏢 Spait Infotech
📍 Canada