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.

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.

• 6 - 10 years’ experience in Oracle EBS (Techno-Functional)
• Experience in implementation, Support, and upgrade projects
• Experience at least in 2 R12.2 upgrade projects.
• Experience in Oracle EBS R12.2.7 or Higher versions of R12.
• Strong knowledge in SQL/PLSQL, Reports, Forms, and workflow. OAF is added advantage.
• At least 40% functional knowledge in SCM and Manufacturing (Modules: PO, OM, INV, WIP, BOM, Quality and Engineering)
• Excellent verbal and written communication 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

Responsibilities:

* 3+ years of Data Engineering Experience - Design, develop, deliver and maintain data infrastructures.

* SQL Specialist – Strong knowledge and Seasoned experience with SQL Queries

* Languages: Python

* Good communicator, shows initiative, works well with stakeholders.

* Experience working closely with Data Analysts and provide the data they need and guide them on the issues.

* Solid ETL experience and Hadoop/Hive/Pyspark/Presto/ SparkSQL

* Solid communication and articulation skills

* Able to handle stakeholders independently with less interventions of reporting manager.

* Develop strategies to solve problems in logical yet creative ways.

* Create custom reports and presentations accompanied by strong data visualization and storytelling

We would be excited if you have:

* Excellent communication and interpersonal skills

* Ability to meet deadlines and manage project delivery

* Excellent report-writing and presentation skills

* Critical thinking and problem-solving capabilities