This is an exciting opportunity for an experienced Senior Database Developer. You will be responsible for developing OTLP database solutions using Microsoft SQL Server. You should have hands-on experience in various domains such as enterprise and cloud database infrastructure design, security, database development, tuning, service delivery, incident tracking, and change management. Your responsibilities will include executing design sessions to gather requirements, architecting and managing various data models associated with relational databases, designing, implementing, and maintaining database solutions, resolving database performance and security issues, writing SQL queries and stored procedures, providing technical documentation, monitoring and tuning performance, designing data movement pipelines, determining business data reporting requirements, participating in on-call support rotation, and performing other assigned duties. To qualify for this role, you should ideally have a Bachelors and/or Masters degree in Computer Science or related field, a minimum of 8 years of software development experience, with at least 5 years focused on data engineering and 2 years on data modeling/DB design. You should have extensive knowledge of SQL Server, expertise in performance tuning, understanding of development methodologies, and strong communication skills. Additional qualifications that would be considered a plus include knowledge in financial technology domain, experience with .NET, MVC, C#, HTML5, CSS3, AJAX, jQuery, IIS, and JavaScript, familiarity with NoSQL and Kafka/Event-Streaming, and Microsoft Azure Data Engineer or other cloud certifications. Personal characteristics that would be beneficial in this role include the ability to build consensus among IT & Business teams, high-energy and positive attitude, inquisitiveness, analytical skills, strategic thinking, proactiveness, self-discipline, attention to detail, flexibility, and adaptability to work with various technologies and business domains.,
This is an exciting opportunity for an experienced Senior Database Developer. You will be responsible for developing OTLP database solutions using Microsoft SQL Server. You should have hands-on experience in various domains such as enterprise and cloud database infrastructure design, security, database development, tuning, service delivery, incident tracking, and change management. You will be responsible for executing design sessions to gather requirements, reviewing and approving design artifacts with stakeholders. Additionally, you will be architecting and managing various data models associated with Relational DBs (MS SQL Server, PostgreSQL, Oracle) and optionally NoSQL DBs (Azure Cosmos, MongoDB, Cassandra). Designing, implementing, and maintaining database solutions, managing data access, resolving database performance, capacity, and security issues are also part of your responsibilities. You will need to perform problem-solving of application issues and production errors, including critical production issues requiring immediate attention. Designing and coding a high volume of SQL queries, stored procedures, and maintaining SSIS packages is crucial. Providing technical documentation as needed, monitoring and performing performance tuning on stored procedures and ETL jobs, designing and implementing performant data movement pipelines, and data migrations are key tasks. Furthermore, you will determine the business needs for data reporting requirements, participate in an on-call support rotation, and provide non-standard work hour support as required. Other duties as assigned should also be performed. Qualifications: - Bachelors and/or Masters degree in Computer Science, Computer Engineering, or related field preferred - 8+ years of overall software development experience required - 5+ years of hands-on experience with a heavy focus on data engineering required - 2+ years of experience focused on data modeling/DB design required - Extensive knowledge of SQL Server including T-SQL, writing complex stored procedures, optimization for performance, and SSIS packages - Strong knowledge and experience in data modeling and relational database design - Demonstrated expertise in performance tuning in various DB environments with large volume and velocity of data - Basic knowledge of SQL administration and monitoring - Strong understanding and experience of development methodologies (Agile and Scrum) - Expertise in understanding complex business needs, analyzing, designing, and developing solutions - Communication and professional skills and the ability to establish relationships across business units Pluses: - Financial technology domain knowledge - Experience with .NET, MVC, C#, HTML5, CSS3, AJAX, jQuery, IIS, and JavaScript - Experience with NoSQL and Kafka/Event-Streaming - Microsoft Azure Data Engineer or other cloud certifications Personal Characteristics: - Ability to build consensus among IT & Business teams and influence changes in behavior and beliefs necessary for a successful data strategy - High-energy, positive, entrepreneurial in spirit while goal-oriented and results-driven - Inquisitive, analytical, a strategic thinker, proactive and solutions-oriented - Self-starter, well-organized and disciplined with high attention to detail - Flexible and adaptable working with various technology and business domains,
Role Overview: As a Senior Database Developer, you will play a crucial role in developing OTLP database solutions using Microsoft SQL Server. Your responsibilities will include executing design sessions to gather requirements and reviewing design artifacts with stakeholders, architecting and managing data models for Relational DBs (MS SQL Server, PostgreSQL, Oracle) and optionally NoSQL DBs (Azure Cosmos, MongoDB, Cassandra), designing, implementing, and maintaining database solutions, managing data access, and resolving database performance, capacity, and security issues. You will also be responsible for problem-solving application issues and production errors, including critical production issues, designing and coding SQL queries, stored procedures, and maintaining SSIS packages, providing technical documentation, monitoring, and performing performance tuning on stored procedures and ETL jobs, designing and implementing data movement pipelines and data migrations, and determining business needs for data reporting requirements and participating in an on-call support rotation. Qualifications Required: - Bachelors and/or Masters degree in Computer Science, Computer Engineering, or related field preferred - 8+ years of overall software development experience - 5+ years of hands-on experience with a focus on data engineering - 2+ years of experience focused on data modeling/DB design - Extensive knowledge of SQL Server, including T-SQL, writing complex stored procedures, optimization for performance, and SSIS packages - Strong knowledge and experience in data modeling and relational database design - Expertise in performance tuning in various DB environments with large volume and velocity of data - Basic knowledge of SQL administration and monitoring - Strong understanding and experience of Agile and Scrum development methodologies - Expertise in understanding complex business needs, analyzing, designing, and developing solutions Additional Details: In addition to the required qualifications, the following would be considered a plus: - Financial technology domain knowledge - Experience with .NET, MVC, C#, HTML5, CSS3, AJAX, jQuery, IIS, and JavaScript - Experience with NoSQL and Kafka/Event-Streaming - Microsoft Azure Data Engineer or other cloud certifications Personal Characteristics: Personal characteristics that are valued for this role include the ability to build consensus among IT & Business teams and influence changes in behavior, high-energy, positive, entrepreneurial spirit while goal-oriented and results-driven, inquisitive, analytical, strategic thinker, proactive, and solutions-oriented, self-starter, well-organized, disciplined with high attention to detail, and flexible and adaptable working with various technology and business domains.,