AgreeYa Solutions
Remote- Principal Database Engineer
AgreeYa Solutions, San Francisco, California, United States, 94199
Job Title: Principal Database Engineer (NoSQL)
Location: Remote
Type: Contract
Summary
This is an exciting opportunity for an experienced senior developer of large-scale data solutions. You will join a team delivering a transformative next-gen cloud hosted data platform.
The ideal candidate will have a proven track record in implementing NoSQL data stores, real-time event data streaming and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of technologies to play an important role in developing and delivering early proofs of concept and production implementation requiring high TPS (1000+ transactions/second). The successful candidate will have hands-on experience in a multitude of data domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, database design, database development, database tuning, service delivery, incident tracking, and change management.
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 pipeline. 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
Qualifications
Bachelors and/or Masters 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 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
Qualifications
Bachelors and/or Masters 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
Pluses : Financial technology domain knowledge Knowledge of SQL Server including T-SQL, the writing of complex stored procedures, optimization for performance, and SSIS packages Experience with .NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Java script Microsoft Azure Data Engineer or other cloud certifications
About AgreeYa: AgreeYa is a global systems integrator delivering a competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,800+ professionals across offices. AgreeYa works with 550+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public Sector, Pharma & Biotech, Retail, Client, and others. Please visit us at www.agreeya.com for more information.
Equal Opportunity: AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website at www.agreeya.com/career-culture to learn about our Career & Culture. AgreeYa Solutions - Software | Solutions | Services AgreeYa Solutions, a leading global provider of Software, Solutions, & Services for SME & Fortune 100 organizations. Explore more.
Summary
This is an exciting opportunity for an experienced senior developer of large-scale data solutions. You will join a team delivering a transformative next-gen cloud hosted data platform.
The ideal candidate will have a proven track record in implementing NoSQL data stores, real-time event data streaming and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of technologies to play an important role in developing and delivering early proofs of concept and production implementation requiring high TPS (1000+ transactions/second). The successful candidate will have hands-on experience in a multitude of data domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, database design, database development, database tuning, service delivery, incident tracking, and change management.
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 pipeline. 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
Qualifications
Bachelors and/or Masters 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 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
Qualifications
Bachelors and/or Masters 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
Pluses : Financial technology domain knowledge Knowledge of SQL Server including T-SQL, the writing of complex stored procedures, optimization for performance, and SSIS packages Experience with .NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Java script Microsoft Azure Data Engineer or other cloud certifications
About AgreeYa: AgreeYa is a global systems integrator delivering a competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,800+ professionals across offices. AgreeYa works with 550+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public Sector, Pharma & Biotech, Retail, Client, and others. Please visit us at www.agreeya.com for more information.
Equal Opportunity: AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website at www.agreeya.com/career-culture to learn about our Career & Culture. AgreeYa Solutions - Software | Solutions | Services AgreeYa Solutions, a leading global provider of Software, Solutions, & Services for SME & Fortune 100 organizations. Explore more.