SQL DBA - Consultant (GGN) (Job Code : J39493A)  

 Job Summary
Share this job on Facebook  Share this job on Twitter  Share this job on Linked In
 
Experience:
4.00 - 7.00  Years 
 
Location:
Gurgaon
 
Designation:
SQL DBA - Consultant (GGN)
 
Degree:
BE-Comp/IT
 
Educational Level:
Graduate/Bachelors
 
Stream of Study:
 
Industrial Type:
IT-Software/Software Services
 
Functional Area:
IT Software - Other
 
Key Skills:
SQL
 
Job Post Date:
2018-05-15 12:30:22  
 
 

 Company Description
 
Our Client in India is one of the leading providers of risk, financial services and business advisory, internal audit, corporate governance, and tax and regulatory services.

Our Client was established in India in September 1993, and has rapidly built a significant competitive presence in the country. The firm operates from its offices in Mumbai, Pune, Delhi, Kolkata, Chennai, Bangalore, Hyderabad , Kochi, Chandigarh and Ahmedabad, and offers its clients a full range of services, including financial and business advisory, tax and regulatory.

Our client has their client base of over 2700 companies. Their global approach to service delivery helps provide value-added services to clients. The firm serves leading information technology companies and has a strong presence in the financial services sector in India while serving a number of market leaders in other industry segments.
 

 Job Description
 
Job Description:


· 5 years of database experience
· Experience in working with very large tables and datasets
· Expertise in T-SQL creating stored procedures, functions, views, and advanced queries
· Strong ability to navigate through and optimize existing stored procedures
· Knowledge of database design principles, index management, integrity checks, data analytics, and statistics
· Demonstrated ability in performance tuning, query optimization using
SQL Server native tools (DTA, Profiler, and System Stored Procs, DMV`s, DMF`s).
· Experience in code migration, database change management and data
management
· Experience in SQL 2012/2014/2016
· Familiar with .net, XML, APIs
· Experience with multiple reporting tools (SSRS, RDLC)
· Experience with MS SQL Server Analysis Services (SSAS) is a plus
· C# .net, SQL, RDLC, is a plus
· Experience with Visual Studio in creating tabular models is a plus
· Proficient with the DAX language is a plus
· Proficient with pivot tables
· Familiar with data warehousing / data mining
· A plus to be able to use Performance Monitor to measure efficiency and bottlenecks when processing SSAS tabular models
· Familiarity with BIDS Helper and compression strategies is a plus
· Understanding of Active Directory / Network user groups for security
· Understanding of XMLA code
· Familiar with Team Foundation Server (TFS)