JOB DESCRIPTION
Summary
This is an exciting opportunity for an experienced Senior Database Developer. This role will be responsible for developing OTLP database solutions using Microsoft SQL Server.
The successful candidate will have hands-on experience in a multitude of domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, database design, database development, database tuning, service delivery, incident tracking, and change management.
Responsibilities
- Executes design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders
- Architecting and managing various data model associated with Relational DBs (MS SQL Server, PostgreSQL, Oracle, etc.) and optionally NoSQL DBs (Azure Cosmos, MongoDB, Cassandra, etc.)
- Design, implementation and maintenance of database solutions, management of data access, and resolving database performance, capacity, and security issues
- Perform problem-solving of application issues and production errors, including high level critical production issues that require immediate attention
- Design and code a high volume of SQL queries, stored procedures, and maintenance of SSIS packages
- Provide technical documentation as needed
- Monitor and perform performance tuning on stored procedures and ETL jobs
- Designing and implementing performant data movement pipelines; and data migrations
- Perform problem-solving of application issues and production errors, including high level critical production issues that require immediate attention
- Determine the business needs for data reporting requirements
- Participate in an on-call support rotation and provide non-standard work hour support
- Perform other duties as assigned
Qualifications
- Bachelor’s and/or Master’s 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 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, the writing of 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 Java script
- 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 the changes in behavior and beliefs necessary to drive 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