- Database performance tuning and troubleshooting.
- Configure and manage backups using database-specific backup technologies.
- Building complex queries, analyzing data and BI Reports Prepare corporate data for reporting and analysis using relational database and OLAP technologies.
- Documenting the systems you help build.
- Translate user requirements for reporting and analysis into data warehouse deliverables.
- Develop and implement data auditing strategies and processes to ensure data accuracy and integrity.
- Support operation and expansion of data warehouse and reporting environment.
- Manage multiple projects in a fast-paced environment
- Monitor performance and reliability of load processes
- Learn, maintain and enhance the existing database framework and data modeling processes.
- Create and administer error and system maintenance logs and reporting.
- Data validation, auditing, and balancing
Requirements
- Experience to monitor and tune SQL DB and DWH performance,
- Implement backup and recovery procedures,
- Administer SQL DB and DWH access and security.
- Familiar with relational and none relational DBs/repositories concepts and structures.
- Strong working experience with SQL database management Server
- Excellent organizational and documentation skills.
- Excellent functional, analytical, interpersonal and communication skills.
- BS degree or higher in Computer Engineering/Computer Science
- Self-learner