Job description

Responsibilities

• Executes design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders

• Designing and managing various data model associated with Relational DBs (MS SQL Server, PostgreSQL, Oracle, etc) and NoSQL DBs (Azure Cosmos, MongoDB, Cassandra, etc)

• Ensures database features and capabilities are incorporated into data model designs to optimize performance, security, resiliency and scalability

• 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

• Monitor and perform performance tuning on stored procedures and ETL jobs

• Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders

• Working with other members of the project team to support delivery of additional project components associated with cloud data platform

• Perform problem-solving of application issues and production errors, including high level critical production issues that require immediate attention; participate in an on-call support rotation

• Perform other duties as assigned

Qualifications

• Bachelor’s and/or Master’s degree in Computer Science, Computer Engineering or related field preferred

• 8+ years of overall software development experience required

• 5+ years of overall hands-on experience working with SQL Server (Relational DBs) 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

• Hands-on development experience with NoSQL DBs (MongoDB / Cassandra / Azure Cosmos DB or similar) and/or event-based streaming (kafka, etc) technologies highly desired

• Experience building and scaling distributed, highly available systems in cloud env (Azure / AWS)

• Expertise in understanding complex business needs, analyzing, designing, and developing solutions

• Communication and professional skills and the ability to establish relationships across business units

• Experience working in a Dev/Ops environment with tools such as Microsoft Visual Studio Team Services, Chef, Puppet or Terraform

Pluses:

• Financial technology domain knowledge

• Experience with .NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Java script

• Microsoft Azure Data Engineer or other cloud certifications

Job Type: Full-time

Pay: Up to $180,000.00 per year

Experience level:

• 8 years

Schedule:

• Day shift
• Monday to Friday

Application Question(s):

• Bachelor’s and/or Master’s degree in Computer Science, Computer Engineering or related field preferred
• This is a fulltime position and we are looking for Green Card and US Citizens. Please confirm your visa status.

Experience:

• Lead Data Engineer: 8 years (Preferred)
• OLTP: 1 year (Preferred)
• FinTech companies: 1 year (Preferred)
• software development: 8 years (Preferred)

Work Location: Remote

randomorbitinc.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, randomorbitinc.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, randomorbitinc.com is the ideal place to find your next job.