11+ Microsoft SQL Server DBA Jobs in Hyderabad | Microsoft SQL Server DBA Job openings in Hyderabad

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

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.

Snowflake SRE JD

Your Role Accountabilities

• Primarily responsible for administrating Snowflake environments on AWS
• Identify, tune, and fix the performance issues on priority.
• Diagnose and troubleshoot Snowflake related errors and work with team to raise support tickets, follow ups and help to resolve them.
• Implement security, roles, users and privileges using the best practices.
• Provide database/objects recovery as need on basis.
• Design, identify and implement high performing and highly available data warehouse solutions.
• Create database, schema, tables, views, data sharing
• Create Snowflake utilization and capacity/cost plans, identifies, and provide solution for abnormalities.
• Proactively identify, design, and implement process improvements like automating manual processes
• Stay up-to-date with the latest features and best practices in Snowflake administration
• Follow existing database runbooks, create and maintain new runbooks for new and improved processes
• Provide 24X7 On-call support by participating in rotation schedule.

Qualifications & Experiences

• Bachelor's degree in computer science, information systems, or information technology.
• 10+ years of experience as a database administrator.
• Minimum 5+ years of hands-on administration experience, from setting up the Snowflake environments to successfully administering it (AWS preferred)
• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting, Python etc.
• Some experience with AWS with knowledge of S3, EC2, VPC, IAM, Security, Networking etc.
• Ability and experience with the development of processes and procedures to standardize Database configuration
• Extensive experience with implementation and maintenance of Disaster Recovery and High availability.
• Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious.
• Ability to provide technical documentation and project plans for technical staff members.
• Excellent communication, presentation, and customer relationship skills.
• Excellent organizational and time management skills to handle multiple tasks simultaneously
• Ability to provide 24/7 support.

ABOUT THE ROLE

We are looking for young dynamic individuals in the role of Operation and product support, who will be part of our Support Team in Hyderabad. The job will need a fair amount of technical knowledge about Web SaaS portals.

Job Responsibilities:

• Attend inquiries and resolve product or service problems by clarifying the customer's complaint via, email, online chat, helpDesk etc.
• Provide appropriate solutions and alternatives within the time limits and follow up to ensure resolution. Suggest or inform customers about the best practices. Identify and assess customers’ needs to achieve satisfaction by going the extra mile to engage customers.
• A certain degree of creativity, latitude, and problem- solving is required
• Coordinate with cross-functional teams to achieve the
• highest level of customer satisfaction.
• Streamline and expedite operational tasks, including inbound and outbound marketing.
• Follow communication procedures, guidelines, and policies.

REQUIREMENTS

• Experience of 1 year in customer service role handling customer support/technical queries.
• Excellent oral and written communication and people interaction skills.
• Hands-on experience with ticketing software like Freshdesk/Freshchat.
• Good analytical skills with active listening and attention to detail.
• Ability to multi-task, prioritize and manage time effectively.
• Work independently and own the raised matter till closure.
• Work experience in SAAS companies is an added advantage 

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.

Key Responsibilities:

 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

 The engineer should be available to work in the late evening shift (4pm - 1am) if required.

Primary skills:

 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)

Requirements:

·  UIPath certification

·  Proficient in UI Path Platform, Test Manage, Test Suite, with 6+ years of Experience on Test Automation

·  Hands-on experience in building automated scripts using Low-Code No-Code Platform (UIpath)

·  Experience on Testing SOAP or REST API

·  Experience building data driven tests and frameworks for Web, Windows, and Micro services.

·  Understanding of test methodologies (regression, functional, unit, integration, code coverage, performance, etc.)

·  Experience building data driven tests and frameworks for Web, Windows, and Micro services.

·  Designing and developing test automation frameworks and understanding of test automation design patterns and software testing principles.

·  Familiarity with Relational Databases and SQL

·  Bachelor's degree in computer science, engineering or related field

·  Minimum of 7 years of experience in software testing and test automation

·  Minimum of 5 years of experience in UIPath test automation

·  Strong knowledge of test automation frameworks and tools

·  Experience with continuous integration and continuous delivery (CI/CD) pipelines

·  Ability to analyze and debug complex issues

·  Excellent problem-solving skills

·  Strong communication skills and ability to work collaboratively in a team environment

·  Knowledge of agile methodologies

 Flexibility

Need to be flexible with respect to working times, provide two hours overlap with IST (Central Time) and UK time on an ongoing basis.

If you are passionate about test automation and have experience with UIPath, we encourage you to apply for this exciting opportunity. We offer a competitive salary, excellent benefits, and opportunities for growth and development.

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.

• Experience on using Mendix Developer Studio for designing and developing Web-based
  applications
  Knowledge of web services
  Knowledge of export & importing data
  Knowledge of debugging the web services & microflows
  Understanding Data models and SQL Query Building
  Build applications using Schema Domain Entity Design, User Interface Development for
  Desktop, Tablet and Mobile devices
  Knowledge of building Microflows and Nanoflows and using Containers
  Understanding Data models and SQL Query Building
  Strong customer intrfacing and conflict resolution skills

JD – Attached Sample Profile for Reference

1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have
1) Experience in SAP BO / Crystal report /SSRS/ Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another