Sr. Data Analyst - MS SQL Job
Bengaluru, KA, IN
Yash Technologies
YASH specialists provide information, establish contacts and build bridges between the local decision-makers in German companies and the YASH teams.YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.
At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.
We are looking forward to hire MS SQL Professionals in the following areas :
Responsibilities\Skills:
- DB Design :
- Define and implement database solutions on Azure SQL DB and Azure SQL Server MI, ensuring they meet business requirements and performance goals.
- Should be familiar with different tiers available for Azure SQL Server and Azure SQL DB and should be able to advice the right tier based on the business and performance requirements and cost optimization
- Aware of Latest features available in SQL.
- Knowledge of data modeling concepts and design fundamentals
- Database Development , Maintenance and Optimization:
- Able to write complex Stored Procedures, Create Complex tables while keeping the performance a key consideration.
- Well versed with indexing, partitions, Views, Joins, CTE and other techniques to write high performance queries.
- Aware of Data Caching mechanism and its implementation
- Fine-tune SQL queries for optimal performance, analyze and optimize database performance through indexing, query optimization, and performance monitoring tools
- Identify and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues.
- Advise on best SQL coding practices.
- Integration and Migration:
- Integrate SQL Server solutions in .NET environments (working knowledge of C#, ASP.NET, and SOA with web services).
- Familiarity with a SQL Server Data Warehouse platform, Azure Data Factory, SSRS and SSIS
- SQL Administration : Basic understanding of DB Administration, like managing the Database, backups, File groups, User role and access management , creating linked servers
Qualifications:
- Experience: Minimum 5 years of implementing database systems, with at least 3 years using MS SQL.
- Skills:
- Proficiency in SQL programming concepts, including Common Table Expressions (CTE).
- Data modeling expertise, including understanding of normalized forms.
- Design and development of stored procedures, views, and triggers.
- Integration of SQL Server solutions in .NET environments.
- Problem-Solving: Good analytical and problem-solving skills to address database issues and find efficient solutions.
- Education: Bachelor’s or Master’s degree in Computer Science, Engineering, or related fields.
- Certifications: Relevant certifications such as SQL, MCSA, MCSE, or MCDBA are desirable.
At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.
Our Hyperlearning workplace is grounded upon four principles
- Flexible work arrangements, Free spirit, and emotional positivity
- Agile self-determination, trust, transparency, and open collaboration
- All Support needed for the realization of business goals,
- Stable employment with a great atmosphere and ethical corporate culture
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Azure Computer Science Data warehouse Engineering MS SQL .NET SQL SSIS
Perks/benefits: Career development Flex hours Transparency
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Science Manager jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Junior Data Scientist jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open DevOps-related jobs