11+ Microsoft SQL Server DBA Jobs in Hyderabad | Microsoft SQL Server DBA Job openings in Hyderabad
Apply to 11+ Microsoft SQL Server DBA Jobs in Hyderabad on CutShort.io. Explore the latest Microsoft SQL Server DBA Job opportunities across top companies like Google, Amazon & Adobe.
Job Description:
Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:
- Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
- Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
- Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
- SQL Query tuning and performance tuning.
- Develop/migrate existing scripts to SSIS.
- Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
- Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
- Importing and exporting the data from different sources using tools, writing required scripts.
- Works closely with other members of the team to accomplish the projects.
- Assists project teams to design and develop core business components utilizing industry-accepted analysis and design standards.
- Provides and/or assists with, project management and project leadership.
- Create and maintain documentation for all the projects.
- Working with NOSQL databases (Mostly on MongoDB) .
PRIMARY SKILLS:
TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.
SECONDARY SKILLS:
Database Administration
REQUIRED SKILLS:
- 3+ years of professional experience in working with MSSQL Server 2008 and above.
- 3+ years of professional experience in writing TSQL scripts.
- Thorough experience in SQL query tuning and performance tuning.
- Experience in developing and maintaining SSIS packages.
- Experience in working with NoSQL databases. MongoDB would be preferable.
- Fluent knowledge of MSSQL server DBA.
- Should be a good team player and should possess good attitude and work ethics.
- Should possess excellent communication and written skills.
PREFERRED SKILLS:
- MSSQL DBA.
- SSIS.
- NOSQL, MongoDB
Python
MongoDB5+ years of experience designing, developing, validating, and automating ETL processes 3+ years of experience traditional ETL tools such as Visual Studio, SQL Server Management Studio, SSIS, SSAS and SSRS 2+ years of experience with cloud technologies and platforms, such as: Kubernetes, Spark, Kafka, Azure Data Factory, Snowflake, ML Flow, Databricks, Airflow or similar Must have experience with designing and implementing data access layers Must be an expert with SQL/T-SQL and Python Must have experience in Kafka Define and implement data models with various database technologies like MongoDB, CosmosDB, Neo4j, MariaDB and SQL Serve Ingest and publish data from sources and to destinations via an API Exposure to ETL/ELT with using Kafka or Azure Event Hubs with Spark or Databricks is a plus Exposure to healthcare technologies and integrations for FHIR API, HL7 or other HIE protocols is a plus
Skills Required :
Designing, Developing, ETL, Visual Studio, Python, Spark, Kubernetes, Kafka, Azure Data Factory, SQL Server, Airflow, Databricks, T-SQL, MongoDB, CosmosDB, Snowflake, SSIS, SSAS, SSRS, FHIR API, HL7, HIE Protocols
Amazon Web Services (AWS)Sr IT Administrator
Experience - 4 - 5 yrs
Location- Hyderabad - Hybrid
Mandatory skills : AWS , VMware,trouble shooting, SQL , Problem solving
Responsibilities:
Diagnose and troubleshoot technical issues - Windows
Upgrade the network infrastructure - Windows
Install servers (VMWare and Dell Servers),devices and firewalls(Sonicwall)
Monitor the performance of servers, software and hardware
Ensure the smooth deployment of new applications and SQL DB changes(Manual,Script and CICD) on Windows Environment
Update technical documentation.
Requirements and skills:
Solid understanding of LAN/WAN and Hybrid networks
Good problem-solving and communication skills
Good experience on AD,DNS,MS SQL Server,IIS, VMware and AWS
Hand on experience on Migation of servers(File, AD and Application servers)
Good experience on AWS and VMWare ESXi networks (Miagtion, upgade, and troubleshooting)
Knowledge of security techniques.
Should have worked in complex projects
All the experience is expected in Windows Domain only. Not Linux or Unix.
Working knowledge in AWS is also mandatory.
We need people with good exposure and good attitude and willingness to work in a team.
JD:
Location Pan India
Experience: 8 to 15Yrs
Must have skills
- "Senior" is defined as 8+ years of IT experience, and a minimum of 5+ years in Digital experience
- Minimum 3 years of hands-on experience with Informatica Cloud Data Quality (CDQ) toolset,
- Strong SQL Skills.
Nice have skills
- Knowledge of Informatica AXON Data Governance
- Familiarity of Enterprise Data Catalog
- Familiarity Cloud Data Governance and Catalog (CDGC).
JavaRequired Skills
- Experience in developing business solutions using Salesforce Commerce Cloud (Demandware).
- Good knowledge of SFCC / Demandware Script, Java OOP/Node.js.
- Expertise in RESTful web services, Ajax-driven client applications, and includes Advanced JavaScript architectures.
- Good experience in SFRA
- Strong background of World Wide Web Consortium (W3C), accessibility guidelines, model view controller (MVC), agile development, and tools.
- Experience in using Pipelines, JS controllers, ISML templates and real-time data exchange using web services.
- Hands-on experience of integrating custom services into SFCC. Good exposure of payment, tax, and operation management suite (OMS) integrations.
- Good understanding of Business Manager and configuring jobs.
- Strong SQL knowledge.
- Exposure to technical reports and understanding of Demandware limitations, such as quotas.
- Proficient in Demandware foundational concepts with good knowledge of SiteGenesis, UX Studio, content assets or slots, and Demandware Catalog.
- SFCC certifications would be preferred.
- Excellent written and verbal communication skills.
- Motivated to complete tasks independently.
- Candidates ready to join sooner will be preferred.
Job Description
Job Responsibilities
-
Design and implement robust database solutions including
-
Security, backup and recovery
-
Performance, scalability, monitoring and tuning,
-
Data management and capacity planning,
-
Planning, and implementing failover between database instances.
-
-
Create data architecture strategies for each subject area of the enterprise data model.
-
Communicate plans, status and issues to higher management levels.
-
Collaborate with the business, architects and other IT organizations to plan a data strategy, sharing important information related to database concerns and constrains
-
Produce all project data architecture deliverables..
-
Create and maintain a corporate repository of all data architecture artifacts.
Skills Required:
-
Understanding of data analysis, business principles, and operations
-
Software architecture and design Network design and implementation
-
Data visualization, data migration and data modelling
-
Relational database management systems
-
DBMS software, including SQL Server
-
Database and cloud computing design, architectures and data lakes
-
Information management and data processing on multiple platforms
-
Agile methodologies and enterprise resource planning implementation
-
Demonstrate database technical functionality, such as performance tuning, backup and recovery, monitoring.
-
Excellent skills with advanced features such as database encryption, replication, partitioning, etc.
-
Strong problem solving, organizational and communication skill.
Java
jQuery- 4+ yrs of experience having strong fundamentals on Windchill Customization & Configurations, Reporting Framework Customization, Workflow Customization , Customer handling
- Strong Customization background around Form Processors, Validator, data utilities, Form Controllers etc.
- Strong Programming skills in Java/J2EE technologies – JavaScript, GWT, JQuerry, XMLs, JSPs, SQL etc.
- Deep Knowledge in Windchill architecture
- Experience in atleast one full lifecycle PLM implementation with Windchill.
- Should have strong coding skills in Windchill development and Customization, ThingWorx Navigate Development (Mandatory), Thing Worx Architecture Configurations Mashup creation, ThingWorx and Windchill Upgrade
- Should have Build and Configuration management (Mandatory) - HPQC \JIRA\Azure\SVN\GITHUB \ Ant
- Knowledge & Experience in Build and Release process
- Having worked on custom upgrade will be a plus.
- Understanding of application s development environment, Database, data management and infrastructure capabilities and constraints. Understanding of Database administration, Database design and performance Tuning
- Follow Quality processes for tasks with appropriate reviews. Participate in sharing knowledge within the team.
Essential Duties and Responsibilities
Include the following, other duties that may be assigned:
Lead the Requirement Discovery Calls.
Defining the Vision
Managing & Scoping the Product Backlog
Providing solutions to solving the Assortment, Availability, Merchandizing, and Supply Chain Problems in Retail Space
Working on various metrics for Retail Industry KPIs and assessing the performance of a retail business
Work with Data Engineers on giving in-depth knowledge of the Business Requirements.
Understanding the business purpose of the story and defining and analyzing possible alternative ways of satisfying the business purpose of the story
Estimation of Level of Efforts(LOE) and Deployment Timelines.
Accountable for ensuring advanced analytics and data science outcomes are continually improved such that product and service offerings stay aligned with changing business needs and strategic objectives
Performing line management of product teams operating within an AGILE methodology
Collaborating closely with Business Owners and users to define product roadmaps, epics, features and user stories
Working with team members to take shared responsibility for the overall efforts that the team has committed to
Taking responsibility for the quality data solutions that developers produce
Interacting with Stake holders (Internal & External) as necessary to clarify requirements and agree on priorities
Review project team solution designs to ensure technical alignment & consistency against predefined target architecture and established standards
Work in partnership with third party suppliers to formulate and execute delivery of customer-focused Product & Services
Assist in developing standards for data ingestion, data access layers, application and integration of selected SaaS platforms and Data Science solutions as key components of the overall solution architecture
First Level of the Analysis of the Data Issues.
Understand End-End Flow of the application technically and functionally to enable oneself to be an eventual Product Owner.
Build and maintain architecture, design, and metadata documentation
Desired Qualifications:
Bachelor’s or Master’s in Data or Computer Science or equivalent technical field
Experience in retail industry is must
Lead the Requirement Discovery Calls.
Defining the Vision
Managing & Scoping the Product Backlog
Experience in solving business problems i.e. Assortment, Availability, Merchandizing, and Supply Chain
Providing solutions to solving the Availability, Merchandizing, and Supply Chain Problems in Retail Space
Working on various metrics for Retail Industry KPI’s and assessing the performance of a retail business
8-10 years of Overall IT Experience.
>5 years of Retail Business experience. Experience in Cloud Technologies is a plus
>2 years’ experience managing stakeholder relationships including influencing & negotiating outcomes
Experience in writing SQL and Complex SQL Queries is a Big Plus
About Us:
Prolifics Corporation Limited is a Global Technology Solutions Provider with presence across North America (USA and Canada), Europe (UK and Germany), Middle East & Asia. In India, we have off shore development centres: 3 in Hyderabad & 1 in Pune.
For more than 40 years, Prolifics has transformed enterprises of all sizes including over 100 Fortune 1000 companies by solving their complex IT challenges. Our clients include Fortune 50 and Fortune 100 companies across a broad range of industries including Financial Services, Insurance, Government, Healthcare, Telecommunications, Manufacturing and Retail. We rank consistently in Dream Companies to Work For and Dream Employer of the Year ranking from World HRD Congress, ranked 7 in 2019.
We encourage you to visit us on www.prolifics.com or follow us on Twitter, LinkedIn, Facebook, YouTube and other social media to know more about us.
Amazon Web Services (AWS) Taking ownership of customer issues reported and seeing problems through to
resolution
Understand, interpret, reproduce, and diagnose issues reported by the customers.
Researching, troubleshooting and identifying solutions to resolve product issues
Should be able to handle voice calls, emails and online web sessions with the
customer as part of technical troubleshooting
Should exhibit patience and empathy while working with customer with an aim to
drive positive customer experience
Following standard procedures for proper escalation of unresolved issues to the
appropriate internal teams
Following standard procedures for submitting tickets to the engineering team for
further investigation of unresolved issues
Contributing actively towards knowledge base articles
Adherence to strict SLA’s
Ready to work in early morning, general and afternoon shifts, including weekends, on
rotation basis
Should demonstrate an aptitude and appetite for learning newer technologies while
expanding on the core knowledge
Primary skills:
1-3;3-8 years of relevant experience.
Strong technical knowledge on:
Cloud Technologies – AWS, Azure etc.
Databases – SQL, Oracle, MySQL etc.
Operating Systems – Linux, Windows etc.
Networking – Basic networking concepts and troubleshooting
Programming knowledge – Java, Python (Desirable, not a must has) o Prior experience
with REST and SOAP calls.
Excellent communication skills – English written and verbal
HTTP technology and principles, including REST and SOAP principles (Required)
JSON & XML Data formats (required)
Javascript Regular Expression (Good to have)
Good understanding of networking protocols and applications (TCP/IP, proxies, load
balancing, firewalls, etc.) (Required)
Working knowledge of database technologies and SQL (Required)
In-depth familiarity of Linux (Required) (advanced user; sysadmin experience a bonus,
but not required)
Strong analytical and logical reasoning for technical troubleshooting
Ability to collaborate with cross-functional teams – Dev, QA, Infrastructure teams etc.
Should be a team player who keeps team’s success before individual achievements
Knowledge on data integration (Informatica/ Mulesoft))
Minimum 4 to 14 Years OTM Technical / Functional experience
- Must have functional and techno-functional experience in OTM implementation and/or have supported projects dealing with these systems, and/or have worked on OTM Cloud
- Must have strong technical and functional knowledge of the latest OTM Application
- Must have knowledge of preparing mapping document to interface OTM system with EDI, WMS, order management and finance systems, and be able to translate the functional specifications into design specifications for the Offshore Delivery Centre
- Must have ability to write SQL statements for automation agents and other technical topics
- Hands on experience on JSPX/XSL will be additional advantage.
- Experience in end-to-end OTM life cycle/implementations/up-gradation and OTM architecture will be preferred
Datametica is looking for talented Big Query engineers
Total Experience - 2+ yrs.
Notice Period – 0 - 30 days
Work Location – Pune, Hyderabad
Job Description:
- Sound understanding of Google Cloud Platform Should have worked on Big Query, Workflow, or Composer
- Experience in migrating to GCP and integration projects on large-scale environments ETL technical design, development, and support
- Good SQL skills and Unix Scripting Programming experience with Python, Java, or Spark would be desirable.
- Experience in SOA and services-based data solutions would be advantageous
About the Company:
www.datametica.com
Datametica is amongst one of the world's leading Cloud and Big Data analytics companies.
Datametica was founded in 2013 and has grown at an accelerated pace within a short span of 8 years. We are providing a broad and capable set of services that encompass a vision of success, driven by innovation and value addition that helps organizations in making strategic decisions influencing business growth.
Datametica is the global leader in migrating Legacy Data Warehouses to the Cloud. Datametica moves Data Warehouses to Cloud faster, at a lower cost, and with few errors, even running in parallel with full data validation for months.
Datametica's specialized team of Data Scientists has implemented award-winning analytical models for use cases involving both unstructured and structured data.
Datametica has earned the highest level of partnership with Google, AWS, and Microsoft, which enables Datametica to deliver successful projects for clients across industry verticals at a global level, with teams deployed in the USA, EU, and APAC.
Recognition:
We are gratified to be recognized as a Top 10 Big Data Global Company by CIO story.
If it excites you, please apply.
Follow Cutshort