Job Location: Mumbai
Primary Skills: SQL / PL SQL,Data Analysis
Secondary Skills: Data Integration Tool (Any)
Role Description:
Database Engineer will be responsible for developing OTLP database solutions using Microsoft SQL Server.
Role Responsibility:
Executes design sessions to gather requirements, review,
approve, and communicate design artifacts with
stakeholders.
•
Architecting and managing various data model associated
with Relational DBs (MS SQL Server, PostgreSQL, Oracle,
etc.) and optionally NoSQL DBs (Azure Cosmos, MongoDB,
Cassandra, etc.)
•
Design, implementation and maintenance of database
solutions, management of data access, and resolving
database performance, capacity, and security issues
•
Perform problem-solving of application issues and production
errors, including high level critical production issues that
require immediate attention
•
Design and code a high volume of SQL queries, stored
procedures, and maintenance of SSIS packages
•
Role Requirement:
Proficient in basic and advanced SQL programming concepts
(Procedures, Analytical functions etc.)
•
Knowledgeable in Shell / PowerShell scripting •
Knowledgeable in relational databases, nonrelational
databases, data streams, and file stores
•
Knowledgeable in performance tuning and optimization •
Experience in Data Profiling and Data validation •
Experience in requirements gathering and documentation
processes and performing unit testing
•
Understanding and Implementing QA and various testing
process in the project
•
Sound aptitude, outstanding logical reasoning, and analytical
skills
•
Willingness to learn and take initiatives •
Ability to adapt to fast-paced Agile environment •
Additional Requirement:
Extensive knowledge of SQL Server including T-SQL, the writing of complex stored procedures,
optimization for performance, and SSIS packages
•
• Strong knowledge and experience in data modeling and relational database design
Demonstrated expertise in performance tuning in various DB environments with large volume and velocity
of data
•
• Basic knowledge of SQL administration and monitoring
• Strong understanding and experience of development methodologies (Agile and Scrum)
• Expertise in understanding complex business needs, analyzing, designing, and developing solutions
• Communication and professional skills and the ability to establish relationships across business unit
Submit CV To All Data Science Job Consultants Across Bharat For Free
