my itForte - Job Detail

 
MSBI Developer
Job ID IT JOBS#206
Location: Gurgaon, India
Required Skills:
Founded in 1987 and listed on NASDAQ, our client is headquartered in the USA and has an annual turnover of over USD 2+ Billion. They are a leading provider of technology solutions for small, medium, enterprises throughout the North America, Europe and Asia. Their comprehensive expertise and proven experience in advanced technologies and consulting & implementation services makes them the preferred partner for many global MNC customers.

As a Senior SQL Developer your focus will be SQL query development, optimization, and the best practices for database development:. 

Key Responsibilities and Qualifications/Skills

- Help write and optimize in-application SQL statements
- Ensure performance, security, and availability of databases
- Prepare documentations and specifications
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage, and optimize and tweak as necessary
- Collaborate with other team members and stakeholders
- Relational Database and SQL Language
- Extraction, Transformation and Loading (ETL) (Microsoft SSIS)
- Data Warehouse / Solution Design
- Dimensional Modeling
- Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
- Report Development (Microsoft SSRS)
- Skilled at optimizing large complicated SQL statements
- Capable of configuring popular database engines and orchestrating clusters as necessary
- Ability to plan resource requirements from high level specifications
- Capable of troubleshooting common database issues
- Familiar with tools that can aid with profiling server resource usage and optimizing it

Location: Gurgaon, India

Job Type: Full Time & Permanent