58 applicants

Company

AgreeYa Solutions · 1 day ago

Remote- Principal Database Engineer (NoSQL)

United States

Contract

Remote

Lead/Staff

$120/hr - $120/hr

12+ years exp

Maximize your interview chances

Consumer ElectronicsInformation Technology

Growth Opportunities

H1B Sponsor Likely

Insider Connection @AgreeYa Solutions

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Architecting and managing various OLTP application data models associated primarily with NoSQL DBs (Cosmos DB) and additionally Relational DBs (Azure SQL, MS SQL Server or similar)

Ensuring database features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability (with millions of active accounts transacting with very high TPS)

Architecting and designing enterprise-wide data strategy for data modeling, data pipelines, and data integrations across various environments and technology stacks

Designing and implementing performant data movement pipelines using real-time event data streams (Apache Kafka, Azure Event Hub, AWS Kinesis, etc)

Defining and documenting enterprise-wide database standards, patterns & best practice for larger scale adoption for accelerated delivery around data domains

Bringing thought leadership through understanding the key business objectives and strategically providing data integration solutions to support various data domains.

Clear understanding of Entity Framework concepts and database design supporting microservices architecture development patterns

Ensuring data security and privacy standards are implemented, including- role-based security, encryption, tokenization, and obfuscation.

Performing problem-solving of application issues and production errors, including high-level critical production issues that require immediate attention.

Developing the data architecture and governance models for systems of engagement and providing the framework for integrating source systems with the transactional databases and/or data warehouses; Ensuring data architectural designs are consistent, maintainable, flexible, extensible, and cost-effective.

Leading and mentoring a team of data engineers by setting standards and best practices for designing and architecting cloud-based data and reporting applications

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

NoSQL DatabasesCosmos DBData ModelingApache KafkaAzure Event HubMS SQL ServerAzure SQLSQL ConceptsCloud EnvironmentsDev/Ops ToolsStructured DataSemi-Structured DataJSON/XML Handling.NETMVCC#HTML5CSS3AJAXJQueryIISJavaScriptData GovernanceData SecurityFinancial Technology KnowledgeMicrosoft Azure Data Engineer Certification

Required

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

12+ years of overall software development experience required (with heavy focus on database centric development)

4+ years of hands-on development experience with combination of NoSQL DBs (Cosmos DB, MongoDB / Cassandra or similar)

1+ year of hands-on development experience with Azure Cosmos DB

2+ years of hands-on development experience with event based streaming technologies (Apache Kafka / Azure Event Hub or similar)

Strong knowledge and experience in data modeling & design with relational and NoSQL DBs

Experience with RDMBS (primarily MS SQL Server and Azure SQL); proficiency with advanced SQL concepts (T-SQL, PL/SQL, etc.) that process millions of transactions daily with very high processing rates to support mission-critical databases.

Advanced understanding of SQL engine internals to help design and tune databases to get the optimal performance.

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

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

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

Experience in handling structured and semi-structured data forms like JSON/XML and normalization of data structures.

Databricks: 8 years (Required)

OLTP application data models: 5 years (Required)

NoSQL Databases/ Cosmos Database: 5 years (Required)

.NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Java script: 5 years (Required)

Preferred

Financial technology domain knowledge

Knowledge of SQL Server including T-SQL, the writing of complex stored procedures, optimization for performance, and SSIS packages

Microsoft Azure Data Engineer or other cloud certifications

Benefits

Dental insurance

Health insurance

Vision insurance

Company

AgreeYa Solutions

Glassdoor

4.3

AgreeYa Solutions is a global provider of software, solutions, and services

Founded in 1999

Folsom, California, USA

1,001-5,000 employees

http://www.agreeya.com/

H1B Sponsorship

AgreeYa Solutions has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (33)

2022 (67)

2021 (70)

2020 (115)