Principal NoSQL Database Engineer - Resource Consulting Services
Oakland, CA 94501
About the Job
Role: Principal NoSQL Database Engineer
Location: Remote
Duration: 6+ month
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
Skills/Experience:
Pluses:
Location: Remote
Duration: 6+ month
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 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.
Skills/Experience:
- 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
- Bachelors 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 in handling structured and semi-structured data forms like JSON/XML and normalization of data structures
- Experience working in a Dev/Ops environment with tools such as Azure Dev Ops, Microsoft Visual Studio Team Services, Chef, Puppet or Terraform.
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
Source : Resource Consulting Services