SR DATABASE ENGINEER

Los Angeles, CA
Description

This role will be responsible for supporting multiple applications and data transfers between 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, business continuity, disaster recovery, database design, database development, database tuning, enterprise data storage and backup, service delivery, incident tracking, change management, and general database administration.

Responsibilities

  • Design strategies for database systems as well as set standards for operations, programming and security.

  • Definition and governance of all structured and unstructured physical data models, data entities, supporting artifacts and metadata repositories.

  • Develops physical modeling standards and strategies.

  • Executes design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders.

  • Creates and manages physical models to support Enterprise Data Warehouse domains that include Operational Data Stores, Staging, Integrated EDW, Data Mart, Business, Reference/Master Data and Extract Transform Load (ETL) environments.

  • Ensures physical database features and capabilities are incorporated into data model designs to optimize performance.

  • Designs deliverables that are defined with appropriate database platform and security context.

  • Design and manage models using various Data Modeling tools.

  • Maintains optimal Enterprise Architecture alignment with Solution Architecture, Technical Leads, Business Analysis, Infrastructure, and PMO roles.

  • 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 SSIS packages

  • Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment

  • Provide technical documentation as needed

  • Monitor and perform performance tuning on stored procedures and ETL jobs

  • Monitor and analyze SQL Server production metrics

  • Support complex service impacting issues with little to no supervision

  • Participate in an on-call support rotation and provide non-standard work hour support

  • Trouble shooting and resolving data issues

  • Perform other duties as assigned.

Qualifications

  • Extensive knowledge of SQL Server including the writing of complex stored procedures, functions and SSIS packages as well as basic knowledge of database administration

  • Strong understanding and experience of database development methodologies (Agile and Scrum)

  • Expert level knowledge of SQL administration, engineering, and monitoring tools

  • Demonstrated expertise in performance tuning including both query and server optimization

  • Strong knowledge and experience in data modeling, relational database design, optimization for performance, T-SQL, stored procedures, SSIS packages

  • Expertise in understanding complex business needs, analyzing, designing and developing solutions

  • Advanced knowledge of relational database design, testing and implementation

  • Advanced 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

  • Extensive SQL Server performance tuning and troubleshooting experience

  • Hands-on development experience in SQL Server 2012/2016

  • Experience with SSIS

  • Financial technology domain knowledge would be a plus

  • Experience with .NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Java script would be a plus

  • Computer Science Degree Highly Desired

Job Type: Full-time

Salary: $120,000.00 to $135,000.00 /year

Experience:

  • CSS: 3 years (Preferred)

  • .Net: 3 years (Preferred)

  • AJAX: 3 years (Preferred)

  • Enterprise Software: 3 years (Preferred)

  • SQL: 3 years (Preferred)

  • Tsql Scripting: 3 years (Preferred)

or