Dexian DISYS
Sr T-SQL Developer w/ OLTP (remote)
Dexian DISYS, Sierra Madre, California, us, 91025
Job details
Posted:
14 August 2024Location:
Sierra Madre, CA 91024Job type:
PermanentReference:
932621Job description
W-2 ONLYPosition: T-SQL Developer w/ OLTP experienceLocation: REMOTE (work PST Hours)Duration: Contract with possibility of going permYour primary area of responsibility will be focused on designing, modeling and
optimizing OLTP related database technologies (RDMBS and NoSQL) to build performant applications.
Note: This is NOT a Data Warehouse (or BI/Analytics/ML&AI) focused role so please keep this in mind before applying.As a Sr Database Engineer, you can look forward to:Design and development of various data models associated with Relational DBs (MS SQL Server, Azure SQL, PostgreSQL, or similar) and NoSQL DBs (Cosmos DB, Cassandra, Dynamo DB or similar).Ensuring database features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.Writing and performance tuning complex stored procedures and familiarity in supporting Entity Framework based application coding concepts.Working closely with other technology leaders to design and develop enterprise-wide data strategy for data modeling, data pipelines, and data integrations across various environments and technology stacks.Developing performant data movement pipelines using real-time event data streams (Apache Kafka, Azure Event Hub, AWS Kinesis, Azure Databricks etc.).Delivering and presenting proofs of concept to key technology components to project stakeholders and internal technology leaders.Developing the data architecture and governance models for systems of engagement and provides 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.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.Work with other technology leaders on setting database standards and best practices for designing and architecting cloud-based data and reporting applications.You might be the right match for this role if you:Have a proven track record in implementing next-gen cloud data solutions and transformation data pipelines for large scale organizations with primary focus around mission critical
OLTP related database technologies (RDMBS and NoSQL) . You have deep technical skills in a variety of data-related technologies that will contribute to developing and delivering early proofs of concept and production implementation with a cloud-first mindset. You have hands-on experience working with high transaction processing customers facing applications that process millions of transactions daily.Required Skills:Minimum 6 years of overall software development experience.Minimum 4 years of hands-on experience in database engineering (RDMBS and NoSQL).Bachelors degree in Computer science, Computer Engineering or related field.Experience with RDMBS (primarily MS SQL Server); proficiency with advanced SQL concepts (T-SQL, PL/SQL, etc.) that processes millions of transactions daily with very high processing rates to support mission critical databases.Good understanding of SQL engine internals to help design and tune databases to get the optimal performance.Development experience with NoSQL DBs (Cassandra, Cosmos DB, Dynamo DB or similar); and associated data modeling.Experience in designing, developing, and deploying cloud-based solutions which leverage cloud provided platforms (Azure / AWS).Knowledge of data structures and algorithms and excellent programming skills (.NET, C#, Python and/or Java).Demonstrated expertise in performance tuning in various DB environments with large volume and velocity of data.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.Understanding of OLTP and OLAP applications.Nice to Have:Experience with ETL tools such as Informatica, ADF or SSIS is a plus.Financial technology domain knowledge.Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit
https://dexian.com/
to learn more.Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
#J-18808-Ljbffr
Posted:
14 August 2024Location:
Sierra Madre, CA 91024Job type:
PermanentReference:
932621Job description
W-2 ONLYPosition: T-SQL Developer w/ OLTP experienceLocation: REMOTE (work PST Hours)Duration: Contract with possibility of going permYour primary area of responsibility will be focused on designing, modeling and
optimizing OLTP related database technologies (RDMBS and NoSQL) to build performant applications.
Note: This is NOT a Data Warehouse (or BI/Analytics/ML&AI) focused role so please keep this in mind before applying.As a Sr Database Engineer, you can look forward to:Design and development of various data models associated with Relational DBs (MS SQL Server, Azure SQL, PostgreSQL, or similar) and NoSQL DBs (Cosmos DB, Cassandra, Dynamo DB or similar).Ensuring database features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.Writing and performance tuning complex stored procedures and familiarity in supporting Entity Framework based application coding concepts.Working closely with other technology leaders to design and develop enterprise-wide data strategy for data modeling, data pipelines, and data integrations across various environments and technology stacks.Developing performant data movement pipelines using real-time event data streams (Apache Kafka, Azure Event Hub, AWS Kinesis, Azure Databricks etc.).Delivering and presenting proofs of concept to key technology components to project stakeholders and internal technology leaders.Developing the data architecture and governance models for systems of engagement and provides 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.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.Work with other technology leaders on setting database standards and best practices for designing and architecting cloud-based data and reporting applications.You might be the right match for this role if you:Have a proven track record in implementing next-gen cloud data solutions and transformation data pipelines for large scale organizations with primary focus around mission critical
OLTP related database technologies (RDMBS and NoSQL) . You have deep technical skills in a variety of data-related technologies that will contribute to developing and delivering early proofs of concept and production implementation with a cloud-first mindset. You have hands-on experience working with high transaction processing customers facing applications that process millions of transactions daily.Required Skills:Minimum 6 years of overall software development experience.Minimum 4 years of hands-on experience in database engineering (RDMBS and NoSQL).Bachelors degree in Computer science, Computer Engineering or related field.Experience with RDMBS (primarily MS SQL Server); proficiency with advanced SQL concepts (T-SQL, PL/SQL, etc.) that processes millions of transactions daily with very high processing rates to support mission critical databases.Good understanding of SQL engine internals to help design and tune databases to get the optimal performance.Development experience with NoSQL DBs (Cassandra, Cosmos DB, Dynamo DB or similar); and associated data modeling.Experience in designing, developing, and deploying cloud-based solutions which leverage cloud provided platforms (Azure / AWS).Knowledge of data structures and algorithms and excellent programming skills (.NET, C#, Python and/or Java).Demonstrated expertise in performance tuning in various DB environments with large volume and velocity of data.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.Understanding of OLTP and OLAP applications.Nice to Have:Experience with ETL tools such as Informatica, ADF or SSIS is a plus.Financial technology domain knowledge.Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit
https://dexian.com/
to learn more.Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
#J-18808-Ljbffr