- Design, develop, and maintain efficient database solutions using SQL Server, SSIS (SQL Server Integration Services), or other ETL tools.
- Create and manage ETL processes to extract, transform, and load data from multiple sources into databases or data warehouses.
- Develop stored procedures, views, functions, and triggers to support application development.
- Optimize database performance by tuning queries, indexes, and other database components.
- Collaborate with data architects, business analysts, and other teams to ensure that business needs are met through data solutions.
- Create and schedule SSIS packages to automate data workflows.
- Troubleshoot and resolve database performance, data integrity, and data quality issues.
- Ensure proper documentation of database architecture, ETL processes, and reporting requirements.
- Maintain data security and compliance standards, ensuring data privacy regulations are adhered to.
- Implement and maintain database backup, recovery, and disaster recovery strategies.
Skills and Qualifications:
- Strong knowledge of SQL, including the ability to write complex queries, stored procedures, and triggers.
- Experience with SSIS or any other ETL tool (e.g., Informatica, Talend, Pentaho).
- Expertise in creating and optimizing ETL workflows, automating data loads, and transforming large datasets.
- Experience with database management systems (e.g., SQL Server, Oracle, MySQL).
- Knowledge of data modeling and database design concepts.
- Familiarity with data warehousing concepts and best practices.
- Experience with performance tuning and query optimization.
- Strong problem-solving skills and ability to debug complex database issues.
- Understanding of version control systems and Agile development methodologies.
- Experience with cloud-based ETL tools or cloud data platforms (Azure Data Factory, AWS Glue, etc.) is a plus.
Skills Required
Sql, Sql Developer