Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 22nd Dec 2020
Sr. SQL Server DBA
Framingham, MA (Local Only)
Contract to hire
Additional Job Responsibilities Include:
• Provide technical design and architecture guidance for complex enterprise data sources integration.
• Establish and follow data gathering organization and delivering practices.
• Recommended best technical solution options to meet current and future data growth.
• Develop domain expertise to deliver high quality reports and dashboards.
• Provide resource estimates, budgets, timelines and scope of work for different projects.
• Follow industry and standard data governance and privacy policies (including PCI and PII).
• Lead and mentor multiple technical team members.
• Review, analyze, and evaluate business systems and user needs.
• Design and document data flow and schema diagrams.
• Design and develop BI solutions using SQL Server technology stack.
• Develop reports and dashboards using SQL Reporting Services, Excel and SharePoint.
• Work with QA team and end-users to perform testing/validation for release of cubes, new reports, features, and functionality.
• Prepare and continuously refine Executive Level management reports measuring performance of various core metrics.
• Respond to requests from key partners. Generate ad-hoc datasets to identify and solve day to day business issues.
Requirements:
Minimum job skills required to perform this job:
• 8+ Years of Database/Reporting/Business Intelligence Solutions
• Bachelor's Degree in technology or information systems or equivalent work experience.
• Master’s in Computer Science is a plus, any database certificate course/certifications is an added advantage.
• Advanced level of Database Design and Business Intelligence Systems architecture
• Designing large-scale high-performance systems
• Being able to interpret business requirements into functional and then technical requirements
• Understanding of designing workflow/process-based systems
• Ability to write SQL code & stored procedures, performance tuning and optimization.
• Microsoft SQL Server technologies SQL Server database engine, Integration Services (SSIS),Analysis Services (SSAS) and Reporting Services (SSRS).
• Data Modeling principles for relational and Data warehouse design principles (Kimball)
• Data integration from multiple sources such as Oracle, MS-Access and NetSuite.
• SharePoint Foundation Services/SharePoint Performance Point Services
• Advanced level Excel and PowerPivot for Excel
• Experience with Dashboarding and Data visualization tools & technologies (ex: Cognos, Tableau)
• ASP.NET, C# development experience would be helpful
• Retail Operations, Shipping & logistics experience a big plus
• NetSuite/other ERP systems integration preferred
Amar
A - IDC Technologies Inc. | Milpitas, CA
E-:amar@idctechnologies.com
P-:408-668-9228 (Prefer)
L-: https://www.linkedin.com/in/amar-65288155/
W-:http://www.idctechnologies.com