Lead Data Architect; Oracle

Pay Competitive

Location:

Saint Petersburg, Florida

Employment type:

Full-Time

Job Summary:

As part of the Enterprise Data & Analytics team, this role has primary responsibility for building Enterprise Data solutions by working on enterprise-class data initiatives. The Data Architect will be responsible for designing and building data solutions that are flexible, performant, and scalable. Works closely with Solution Architects to create and modify and/or design patterns for Data Models (Normalized and Dimensional) and ETL Data flows.

Demonstrates subject matter expertise and can integrate domain knowledge with an understanding of overall strategy and impact. Is the primary contact for the most complex or escalated issues and may provide direction, guidance, and mentoring to team members. Applies specialized business knowledge and technical skills to significant deliverables and projects that involve multiple IT departments, business units, and have enterprise impact.

The core team is based out of our headquarters in St. Petersburg, FL; however, we are open to our Denver, CO site as well (Hybrid).

Essential Duties and Responsibilities:

• Designs logical and physical data models and databases to provide applications with efficient access and processing.
• Resolves database performance, capacity, replication, and other distributed data issues.
• Designs jobs for data transfers.
• Participates in application development processes and code reviews for all data-related application activities.
• Analyzes long-term database performance trends to optimize database and application performance.
• Architects cloud data solutions.
• Evaluates cloud applications and services.
• Performs other duties and responsibilities as assigned.

Knowledge, Skills, and Abilities:

Advanced knowledge of the following:

• Experience with products and options:
  Oracle RDBMS, AWS Redshift, Replication solutions (Oracle Data Guard, Oracle Golden Gate, and AWS DMS), Oracle RAC, Oracle Exadata, Oracle Multitenant Architecture, AWS Security.
• Experience with Oracle SQL and PL/SQL development and tuning.
• Cloud database services.
• Scripting and automation using shell scripting and Python.
• Cloud infrastructure.
• Capacity planning and cloud cost optimization.
• Concepts, principles, and practices of database administration and management.
• Cloud and on-premise security systems, procedures, and techniques.
• Data integrity methods and techniques.
• Concepts, practices, and procedures used in the financial services industry.
• Code reviews of database objects.

Skilled in:

• Building low latency Data Integration solutions a plus.
• Prototyping and automating Data Integration Processes.
• Physical Performance Optimization of Oracle Databases.

Ability to:

• Work together with business stakeholders to understand the requirements and convert them into Technical Specifications.
• Assist in defining development guidelines and standards.
• Define, document, and maintain all data definitions, data sources, business meaning, and usage of information.
• Provide technical leadership for the definition and development of test plans and system documentation.
• Troubleshoot existing information systems to identify errors or deficiencies and develop solutions.
• Create a culture of Quality Assurance excellence and strong testing processes.
• Ensure data solution monitoring requirements are provided to the Delivery Management team and are alerted when solutions are not performing as expected.
• Identify and understand issues, problems, and opportunities; compare data from different sources to draw conclusions.
• Clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.
• Use effective approaches for choosing a course of action or developing appropriate solutions; recommend or take action that is consistent with available facts, constraints, and probable consequences.
• Demonstrate a satisfactory level of technical and professional skill or knowledge in position-related areas; remain current with developments and trends in areas of expertise.
• Develop and use…