SQL SSIS Server Developer

Job Description

Job Description

• SQL Server and SSRS, 9 yrs. of Experience
• Designing databases and ensuring their stability, reliability, and performance.
• Design, create, and implement database systems based on the end user's requirements.
• Improve application's performances.
• Prepare documentations for database applications.
• Develop database schemas, tables and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Test databases and perform bug fixes.
• Develop best practices for database design and development activities
• Prepare design for all metadata for data warehouse according to various ETL processes.
• Perform troubleshoot on all ETL processes and resolve issues effectively.
• Develop both physical and logical data models.
• Prepare designs for database systems and recommend improvements for performance.
• Maintain and develop various database scripts and tools to facilitate automation process.
• Develop various ETL processes and prepare OLAP cubes.
• Provide support to all data warehouse initiatives.
• Design various ETL processes and perform tests on data.
• Define meta data standards for the data warehouse
• Monitor processes and develop plans to capture and access all metadata.
• Evaluate all proposals requests and assist to improve structure of data warehouse.