Dexian LTD. - Sierra Madre, CA
posted 3 months ago
The Sr T-SQL Developer w/ OLTP position is a remote role focused on designing, modeling, and optimizing OLTP-related database technologies, including both RDBMS and NoSQL systems, to build high-performance applications. This role is not centered on Data Warehousing or Business Intelligence, so candidates should be aware that the primary focus will be on transactional database technologies. As a Senior Database Engineer, you will be responsible for the design and development of various data models associated with relational databases such as MS SQL Server, Azure SQL, and PostgreSQL, as well as NoSQL databases like Cosmos DB and Cassandra. You will ensure that database features and capabilities are effectively incorporated into data model designs to optimize performance, resiliency, and scalability. In this role, you will write and performance-tune complex stored procedures and will need to be familiar with supporting Entity Framework-based application coding concepts. Collaboration with other technology leaders is essential as you will design and develop an enterprise-wide data strategy that encompasses data modeling, data pipelines, and data integrations across various environments and technology stacks. You will also be tasked with developing efficient data movement pipelines using real-time event data streams, such as Apache Kafka and Azure Event Hub. Your responsibilities will include delivering and presenting proofs of concept to project stakeholders and internal technology leaders, as well as developing data architecture and governance models for systems of engagement. You will ensure that data architectural designs are consistent, maintainable, flexible, extensible, and cost-effective. Additionally, you will implement data security and privacy standards, including role-based security, encryption, tokenization, and obfuscation. Problem-solving application issues and production errors, especially high-level critical production issues, will also be part of your duties. You will work with other technology leaders to set database standards and best practices for designing and architecting cloud-based data and reporting applications.