JOB DESCRIPTION
This role will be responsible for developing OTLP database solutions for both internal and client facing applications.
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.
- Design and manage models using various data modeling tools.
- Ensures physical database features and capabilities are incorporated into data model designs to optimize performance.
- Design, implementation and maintenance of database solutions, management of data access, and resolving database performance and capacity issues.
- Develop, implement, administrate, and maintain policies and procedures for ensuring the security and integrity of our databases.
- 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 maintain SSIS packages.
- Provide technical documentation as needed.
- Monitor and perform performance tuning on stored procedures and ETL jobs.
- Analyze SQL Server production metrics.
- Participate in an on-call support rotation and provide non-standard work hour support.
Skills/Experience:
- Hands-on development experience in SQL Server 2012/2016.
- Extensive knowledge of SQL Server including T-SQL, the writing of complex stored procedures, optimization for performance, and SSIS packages.
- Experience with .NET, MVC, C# and test-driven-development approach is a must have
- Strong knowledge and experience in data modeling and relational database design.
- Demonstrated expertise in performance tuning.
- 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.
- Ability to participate in an on-call support rotation and provide non-standard work hour support.
- Financial technology domain knowledge would be a plus.
- Experience with HTML5 CSS3 AJAX jQuery IIS and Java script would be a plus.
- Computer Science degree highly desired.