Principal Accountabilities :
1. Designing and optimizing MS reporting and Analysis reports ensuring their stability, reliability, and performance.
2. Prepare documentations and specifications
3. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
4. Collaborate with other team members and stakeholders
Routine contact is required with IT managers at all organizational levels and with technology vendors. Within the business, periodic contact is required with executives in charge of the key business units using IT services.
Experience in the following topics will be considered a very strong asset
Strong experience in Database Administration in SQL Server (2014 & later versions)
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
SQL Development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
Experience in BI Tools including (QlikView, QlikSense, etc.)
Bachelor’s Degree in computer science preferred
Has 3+ years of experience in database development and support in MS SQL Server environments
3+ years of experience working as a Functional, Data or Business Analyst
3+ years of experience as an Applications Systems Analyst
Skills / Knowledge :
Solid experience in report Development using tools such as MS Reporting services (2012 & later versions), MS Analysis services (2012 & later versions) and Cube handling, and / or Qlik View / Sense since this will be a major part of the day-to-day work
The ability to develop requirements and create functional and technical specs is an essential requirement