Service Data

Job Overview

Job Description

Responsibilities:
• Develop stored procedures, functions, packages, triggers, views, CTEs using T-SQL.
• Design logical and physical data models along with collaring, preparing, and presenting statistical information for both internal and external use.
• Ensure database optimization, integrity, consistency, security, and privacy.
• Providing support, guidance and collaborating with Application Developers to implement database design, and review developer’s work to ensure correct implementation.
• Create scripts to build new database objects.
• Perform schema design, code review and SQL query tuning using execution plans and other audit mechanisms to find the bottlenecks in the Query execution.
• Participate in SQL code reviews, write and deploy SQL Objects in production and implement HA/DR using SQL Server Always-on Availability Groups.
• SQL server administration experience, including knowing the basics of running Microsoft SQL Server users, permission, backups, recovery, monitoring, and more.
• Continually evaluate software components and tools for software applications, making recommendations for system improvements as required.
• Work in conjunction with the service layer to resolve issues, evaluate software modules, and develop appropriate specifications.
• Ability to work with a team in an Agile environment you can address bugs with QA, plan schemas with engineering, and respond quickly to other business needs.
• Provide input guidance on the design and implementation of data solutions to team
• Review and evaluate the performance of the development team and of the individuals on the team
• Remain accountable for project deliverables, schedules and quality Serve an interface with IT and business partners on database side of projects
Minimum Requirements:
• 5+ years working as a database developer, database engineer with Microsoft SQL Server as primary DBMS.
• 1+ years of experience in leading database development teams
• Bachelor’s Degree in Engineering or Computer Science.
• Ability to create BI Solutions both (ETL and Reporting).
• Highly organized and self-motivated with the ability to prioritize projects, meet deadlines, and make room for emergencies, as needed.
• Great Communication skills needed to interact with US customers.
• Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.

Good to have:

• Hands-on experience with python pandas and DBMS systems MySQL and Postgres SQL databases is a plus.
• Databricks/Snowflake/Azure/AWS/GCP