- 5-8 years of exp in SQL Server and SSRS
- 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.
Mandatory Skills:
- SQL Server and SSRS, SSIS
Good to have skills:
- SQL Server Performance tuning