Sr Database Engineer

Job Title:

Location:

Duration:

Qualifications:

• Master/bachelor’s degree in computer science, or STEM (Science, Technology, Engineering, Math) majors, or related experience

• 8+ years of database and software development experience, including Data platform design, development, and Microservice architecture

• Development experience of Snowflake Data cloud

• Expert-level knowledge of SQL, TSQL, performance tuning, Query Plans, and Query Plan optimization for TSQL.

• Advance-level knowledge of developing complex Data Warehouses

• Advance-level knowledge of developing solutions using C#, and REST API.

• Demonstrated experience in working with at least one scripting language such as PowerShell, Perl, Python, Ruby, etc. with the intent to automate manual tasks (monitoring, deployments, testing, etc.)

• Knowledge of SQL Server 2012-2019

• Strong technical and communication skills.

Desire and ability to work as part of a team with minimal supervision in a results-oriented, fast-paced, dynamic environment.

• Experience in managing and developing SQL Server, BI Suite, database custom tools using SQL Server Data Tools/Visual Studio 2015-2019 IDE’s.

Preferred:

o Advance-level knowledge of developing data pipeline using Apache Kafka

o Database architecture and designing experience.

o Travel industry experience; or Ecommerce experience with CRM or online sales.

o PowerShell scripting knowledge.

o Advance level knowledge in automation test creation.

o Experience/Knowledge integrating new technologies (e.g., Hadoop) with traditional RDBMS

o Experience/Knowledge in the Hadoop ecosystem: Spark, Kafka, Hive, HiveQL, Map Reduce, Yarn, HDFS, etc.

n

• Work effectively with team and product owners to define & clarify requirements, perform detailed analysis, and develop robust & maintainable solutions meeting business requirements

• Analyze, plan, develop, deploy, and manage a large scalable distributed system.

• Design, develop, and maintain Azure data pipeline for data processing including normalization and transformation.

• Build and support Microservice and Stateless architecture

• Understand and apply the advanced principles of entity-relationship model design, good data typing practices, index management, data management, and data security.

• Write a reliable and maintainable code at each layer of the product development.

• Research and prototype new product & database features, design, and architecture ahead of mainstream development.

• Proactively initiate & contribute to system improvements and innovations.

• Provide support to troubleshoot and resolve technical & performance issues in a production environment.

• Review designs, code, and test plans of other developers and provide recommendations for improvement or optimizations

• Follow defined software development lifecycle best practices.

• Work effectively with management and members to clarify needs and priorities.

• Miscellaneous duties as assigned.

Job Types: Full-time, Contract

Experience level:

• 10 years

Experience:

• Snowflake: 5 years (Required)
• Database Engineer: 5 years (Required)
• Python: 5 years (Required)
• SQL: 10 years (Required)
• T-SQL: 5 years (Preferred)
• Kafka: 3 years (Preferred)

Work Location: In person