Job
Description
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,
