Principal Database Engineer

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 certification

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