16+ SQL Server Analysis Services (SSAS) Jobs in India
Apply to 16+ SQL Server Analysis Services (SSAS) Jobs on CutShort.io. Find your next job, effortlessly. Browse SQL Server Analysis Services (SSAS) Jobs and apply today!
- Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
- 1+ years in Cloud Database services like AWS Dynamo DB / RDS
- Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
- Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance.
- High availability like clustering, log shipping, mirroring, replication.
- Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.
- Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.
- Establishing backup and recovery or replication plans to minimize data loss and system downtime.
- Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
- Maintaining data integrity and security (manage roles and permissions of database users).
- Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.
- Ensures optimal database performance and availability.
· Creation & maintenance of Databases in AWS.
It's regarding a permanent opening with Data Semantics
Data Semantics
We are Product base company and Microsoft Gold Partner
Data Semantics is an award-winning Data Science company with a vision to empower every organization to harness the full potential of its data assets. In order to achieve this, we provide Artificial Intelligence, Big Data and Data Warehousing solutions to enterprises across the globe. Data Semantics was listed as one of the top 20 Analytics companies by Silicon India 2018 & CIO Review India 2014 as one of the Top 20 BI companies. We are headquartered in Bangalore, India with our offices in 6 global locations including USA United Kingdom, Canada, United Arab Emirates (Dubai Abu Dhabi), and Mumbai. Our mission is to enable our people to learn the art of data management and visualization to help our customers make quick and smart decisions.
Our Services include:
Business Intelligence & Visualization
App and Data Modernization
Low Code Application Development
Artificial Intelligence
Internet of Things
Data Warehouse Modernization
Robotic Process Automation
Advanced Analytics
Our Products:
Sirius – World’s most agile conversational AI platform
Serina
Conversational Analytics
Contactless Attendance Management System
Company URL: https://datasemantics.co
JD:
MSBI
SSAS
SSRS
SSIS
Datawarehousing
SQL
Designation: Senior - DBA
Experience: 6-9 years
CTC: INR 17-20 LPA
Night Allowance: INR 800/Night
Location: Hyderabad,Hybrid
Notice Period: NA
Shift Timing : 6:30 pm to 3:30 am
Openings: 3
Roles and Responsibilities:
As a Senior Database Administrator is responsible for the physical design development
administration and optimization of properly engineered database systems to meet agreed
business and technical requirements.
The candidate will work as part of but not limited to the Onsite/Offsite DBA
group-Administration and management of databases in Dev Stage and Production
environments
Performance tuning of database schema stored procedures etc.
Providing technical input on the setup configuration of database servers and SAN disk
subsystem on all database servers.
Troubleshooting and handling all database related issues and tracking them through to
resolution.
Pro-active monitoring of databases both from a performance and capacity management
perspective.
Performing database maintenance activities such as backup/recovery rebuilding and
reorganizing indexes.
Ensuring that all database releases are properly assessed and measured from a
functionality and performance perspective.
Ensuring that all databases are up to date with the latest service packs patches &
security fixes.
Take ownership and ensure high quality timely delivery of projects on hand.
Collaborate with application/database developers quality assurance and
operations/support staff
Will help manage large high transaction rate SQL Server production
Eligibility:
Bachelors/Master Degree (BE/BTech/MCA/MTect/MS)
6 - 8 years of solid experience in SQL Server 2016/2019 Database administration and
maintenance on Azure and AWS cloud.
Experience handling and managing large SQL Server databases in a real time production
environment with sizes greater than 200+ GB
Experience in troubleshooting and resolving database integrity issues performance
issues blocking/deadlocking issues connectivity issues data replication issues etc.
Experience on Configuration Trouble shoot on SQL Server HA
Ability to detect and troubleshoot database related CPUmemoryI/Odisk space and other
resource contention issues.
Experience with database maintenance activities such as backup/recovery & capacity
monitoring/management and Azure Backup Services.
Experience with HA/Failover technologies such as Clustering SAN Replication Log
shipping & mirroring.
Experience collaborating with development teams on physical database design activities
and performance tuning.
Experience in managing and making software deployments/changes in real time
production environments.
Ability to work on multiple projects at one time with minimal supervision and ensure high
quality timely delivery.
Knowledge on tools like SQL Lite speed SQL Diagnostic Manager App Dynamics.
Strong understanding of Data Warehousing concepts and SQL server Architecture
Certified DBA Proficient in TSQL Proficient in the various Storage technologies such as
ASM SAN NAS RAID Multi patching
Strong analytical and problem solving skills Proactive independent and proven ability to
work under tight target and pressure
Experience working in a highly regulated environment such as a financial services
institutions
Expertise in SSIS SSRS
Skills:
SSIS
SSRS
PythonAbout Us:
Cognitio Analytics is an award-winning, niche service provider that offers digital transformation solutions powered by AI and machine learning. We help clients realize the full potential of their data assets and the investments made in related technologies, be it analytics and big data platforms, digital technologies or your people. Our solutions include Health Analytics powered by Cognitio’s Health Data Factory that drives better care outcomes and higher ROI on care spending. We specialize in providing Data Governance solutions that help effectively use data in a consistent and compliant manner. Additionally, our smart intelligence solutions enable a deeper understanding of operations through the use of data science and advanced solutions like process mining technologies. We have offices in New Jersey and Connecticut in the USA and in Gurgaon in India.
What we're looking for:
- Ability in data modelling, design, build and deploy DW/BI systems for Insurance, Health Care, Banking, etc.
- Performance tuning of ETL process and SQL queries and recommend & implement ETL and query tuning techniques.
- Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.
- Translate business needs into technical specifications, evaluate, and improve existing BI systems.
- Use business intelligence and visualization software (e.g., Tableau, Qlik Sense, Power BI etc.) to empower customers to drive their analytics and reporting
- Develop and update technical documentation for BI systems.
Key Technical Skills:
- Hands on experience in MS SQL Server & MSBI (SSIS/SSRS/SSAS), with understanding of database concepts, star schema, SQL Tuning, OLAP, Databricks, Hadoop, Spark, cloud technologies.
- Experience in designing and building complete ETL / SSIS processes and transforming data for ODS, Staging, and Data Warehouse
- Experience building self-service reporting solutions using business intelligence software (e.g., Tableau, Qlik Sense, Power BI etc.)
.NET
C#- Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
- Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
- Create routines for importing data utilizing XML, CSV and comma delimitate files.
- Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
- Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
- Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
- Extract the data from XML and load it to dimensional model.
- Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
- Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
- Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
- Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
- Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
- Develop T-SQL functions and store procedures to support complex business requirements.
- Create and configure an OLTP replication database for disaster recovery purpose.
- Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.
PostgreSQL SQL Server DBA duties and responsibilities
- Experience in both sql server DBA and DBA developer
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Perform scheduled maintenance and support release deployment activities
• Database programming skills(writing and understanding Procedures , scripts..)
Good to have experience to SSIS,SSAS SSRS or any reporting tools.
OJ Commerce Inc. is a fast-growing retailer serving the US market through OJ Commerce.com and various market places such as Amazon, Walmart, and eBay. OJ Commerce is a privately held, profitable company headquartered in Miami, Florida, USA with a 100% dedicated back-office in Chennai. The workhours are flexible with predominantly India business hours with some overlap with US Eastern Time business hours based on need.
Experience:
4+ relevant experience
Role: Individual Contributor Role.
Location : Chennai - Ekaduthangal (Work From Office)
Skill Sets:
• In-depth knowledge in MS SQL Server and related tools & technologies such as SSIS, SSRS &SSAS
• Exposure to data modelling and ability to develop complex queries & procedures
• Manage and monitor performance, capacity and security of the database
• Continuously improve the performance of the database in alliance with the Database Adminstrator by optimizing jobs, procedures & queries
Desirable Skills:
➢ Candidates with experience in ecommerce / online retail is added value.
➢ Should be comfortable in dealing with senior leadership (internal & external)
➢ Communication Skills – Excellent verbal and written communication skills with ability to explain ideas very clearly.
➢ Self–motivated and flexible, with an ability to work independently.
Traits Expected:
• Ability to work in a fast–paced, dynamic environment with limited resources
• Problem-solver with a desire to solve complex business problems with innovative & cost–effective solutions
• Excellent analytical and problem-solving skills, with out–of–the–box thinking.
Location: Chennai
Experience: 4 years
• Experience in Database Development and Support in MS SQL Server environments.
• Hands-on End to End Database Development encompassing Database Design and Development
working with cross-functional teams.
• Hands-on experience of Transact SQL(T-SQL) utilizing SQL Server 2016 and above.
• Excellent understanding of T-SQL programming
• Hands-on experience in SQL - writing hands on experience in complex stored procedure, function,
triggers
• Sound knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Develop, implement and optimize stored procedures and functions using T-SQL
Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration Provide timely scheduled manage
Job Description.
DB developer
This position is for Oracle Golden Gate developer and DBA position. The Candidate will implement and support Oracle Golden Gate replication components across many databases. Working closely with many application teams and implementing near real time replications with golden gate. Candidate should provide operational support as well.
Roles and responsibilities :
Configure and build Golden Gate Extracts/replicate for multiple databases.
Configure error handling for restart, logging, production support and status reporting in Golden Gate.
Identify and produce documentation of best practices.
Trouble shooting and performance tuning Golden Gate replications.
Implementing necessary monitoring scripts for Golden Gate in UNIX/PERL scripting
Provide Golden Gate solutions :
- Working with Oracle on SRs for critical issues.
- Strong oral and written communication skills along with problem solving skills.
Individual with min experience of over 5+ years on SQL Server
- Good Experience in SQL Server Installation and Configuration
- Backup and Recovery
- Security management
- Troubleshooting & Monitoring
- SSIS/SSRS/SSAS
Job Requirement – Sr. SQL _PBI Developer
- Minimum 6+ years of expertise in SQL Database Development including SQL queries, data structures, stored procedures, index etc.
- Excellent written and verbal communication
- Advanced knowledge and experience in T-SQL coding: query writing, stored procedures, triggers and user-defined functions.
- Advanced knowledge and experience in development and maintenance of SSIS and SSAS (Tabular and Multidimensional)
- Advanced knowledge and experience in creating dashboards and reports using PowerBI
- Advanced knowledge and experience in DAX
- Experience in creating and publishing reports using SSRS
- Experience in writing MDX queries
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Optimize and manage SQL server databases
- Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Flexible, team player, “get-it-done” personality
- Ability to organize and plan work independently
- Ability to work in a rapidly changing environment
- Ability to multi-task and context-switch effectively between different activities and teams
Optional Skills (Good to have):
- Microsoft certification in Azure data engineering
2) Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using MDX/ DAX functions in - Azure Analysis service- or (SSAS)
3) Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries and trouble-shoot cubes SQL and T-SQL. Roles & Responsibilities : 1) "SSAS" OR "Azure Analysis services" Lead Developer with 7+ years of experience in SSAS Azure Data Model Development, SSAS Data model Deployment in Azure, Querying data from SSAS Azure to build Reports.
2) Design and Create SSAS/OLAP/OLTP/Tabular cubes and automate processes for analytical needs.
3) Writing optimized SQL queries for integration with other applications, Maintain data quality and overseeing database security, Partitions and Index.
The ideal candidate is a motivated individual that is excited about making an impact and is ready to operate in a fast-paced environment and can clearly demonstrate a thirst for learning and mastering emerging technologies, processes and tools in the analytics space. This person should take initiative and shouldn't be an order taker. They should enjoy optimizing data models to industry standards.
Key Requirements:
Following skills are not required but are a plus:
Amazon Web Services (AWS)This role is for 1 month where the person will be working from Client site in Paris to understand the system architecture and documenting them. Contract extension for this role will be purely on the performance of individual.
Since the requirement is immediate and critical, we need someone who can join us soon and travel to Paris in December
- Hands on experience handling multiple data sources/datasets
- experience in data/BI architect role
- Expert on SSIS, SSRS, SSAS
- Should have knowledge writing MDX queries
- Technical document preparation
- Should have excellent communication
- Process oriented
- Strong project management
- Should be able to think Out of the Box and provide ideas to have better solutions
- Outstanding team player with positive attitude
Angular (2+)
SASS
Laravel
Follow Cutshort