Enterprise Architect - Database

$103,500 - $159,000/Yr

Metropolitan St. Louis Sewer District - St. Louis, MO

posted 3 months ago

Full-time - Mid Level
St. Louis, MO
Heavy and Civil Engineering Construction

About the position

The Database Enterprise Architect is a pivotal role within the Metropolitan St. Louis Sewer District, tasked with ensuring the availability, performance, security, and lifecycle management of the District's databases, which include Oracle and MS SQL Server, both on-premise and cloud-based. This position is not only about maintaining the current database systems but also involves providing strategic technology guidance and developing comprehensive three to five-year technology roadmaps that align with the District's Strategic Business Operating Plan initiatives. The role offers a hybrid work schedule, allowing for flexibility in work arrangements. In this capacity, the Database Enterprise Architect will manage and direct the Database team, focusing on optimizing day-to-day processes necessary for effective database infrastructure management. This includes establishing and implementing database standards and operational procedures that ensure data confidentiality, integrity, and availability. The architect will devise strategies for capacity management, demand forecasting, application performance analysis, system tuning, and database infrastructure monitoring, as well as backup and restore capabilities. Additionally, the architect will lead the Database team in lifecycle management of the database infrastructure and technology, developing and implementing strategies that support the District's disaster recovery plan's Recovery Point Objective (RPO) and Recovery Time Objective (RTO). Collaboration is key in this role, as the architect will work closely with existing application engineering support and development teams to discuss solutions and implement complex design solutions. The architect will also assist in designing multi-phased cloud data strategies and develop scalable data ingestion frameworks to establish a Master Data Management infrastructure for customer and asset datasets. The role requires a strong foundation in both technical and managerial skills, as the architect will collaborate with Infrastructure and Application architects to develop technology roadmaps and provide consultation and support for enterprise projects, working closely with Business System Program managers.

Responsibilities

  • Manage and direct the Database team in optimizing day-to-day process activities for database infrastructure management.
  • Establish and implement database standards and operational procedures for data confidentiality, integrity, and availability.
  • Devise strategies for capacity management, demand forecasting, application performance analysis, system tuning, and database monitoring.
  • Lead the Database team in lifecycle management of the database infrastructure and technology.
  • Develop and implement strategies to support the District's disaster recovery plan's RPO and RTO objectives.
  • Collaborate with Information Governance to manage Data Privacy.
  • Work with application engineering support teams on complex design solutions.
  • Assist in designing multi-phased cloud data strategies and implementation roadmaps.
  • Design and develop scalable data ingestion frameworks for Master Data Management.

Requirements

  • Bachelor's Degree in Information Systems, Business, or related field.
  • Eight years of senior-level experience in database systems design, analysis, and management.
  • Experience with Oracle Enterprise Business Systems (cloud and on-prem).
  • Knowledge of Oracle EBS 12.x, Oracle Cloud ERP, Oracle RDBMS 12.x and 19.x, and Oracle applications environment.
  • Extensive knowledge of relational databases, business intelligence, decision support tools, and data modeling.
  • Thorough knowledge of planning, managing, and implementing software projects.

Nice-to-haves

  • Master's Degree in Information Technology.
  • Oracle Certified Professional or Microsoft Azure certification or AWS Certified Associate or Solution Architect certification.
  • Knowledge of application programming languages (Java, .Net, etc.).
  • Knowledge of the Systems Development Lifecycle (SDLC) methodology.
  • Ability to manage multiple projects simultaneously in a technical leadership role.
  • Experience in resolving conflict between team members.
  • Ability to mentor less experienced team members.

Benefits

  • Hybrid work schedule available.
  • Opportunities for professional development and training.
  • Comprehensive health insurance options.
  • Retirement savings plan with employer matching contributions.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service