What are the responsibilities and job description for the SQL Developer position at innovitusa?
Key Responsibilities
- Design, develop, and maintain SQL databases and database objects (tables, views, indexes, stored procedures).
- Write and optimize complex SQL queries for data extraction, reporting, and analysis.
- Develop and manage stored procedures, functions, triggers, and scripts.
- Perform database performance tuning and query optimization.
- Ensure data integrity, security, and consistency across systems.
- Collaborate with developers, analysts, and business teams to understand data requirements.
- Troubleshoot and resolve database-related issues.
- Perform data migration, transformation, and integration (ETL processes).
- Maintain proper documentation of database structures and processes.
- Strong knowledge of SQL (Structured Query Language)
- Experience with databases such as:
- Microsoft SQL Server
- MySQL
- Oracle Database
- PostgreSQL
- Understanding of database design, normalization, and indexing
- Experience with ETL tools (e.g., SSIS)
- Knowledge of performance tuning and query optimization
- Familiarity with reporting tools (e.g., Power BI, Tableau)
- Bachelor’s degree in Computer Science, IT, or related field
- 2 years of experience as an SQL Developer or similar role
- Experience in data warehousing concepts
- Knowledge of cloud databases (Azure, AWS, etc.)