Define and maintain conceptual, logical, and physical database models by working with business stakeholders and identifying optimal database specifications. Ensures that database design and system capabilities meet validated user requirements. Work with application development teams designing, developing, and enhancing database schemas, creating database views, helping with query optimization, and figuring out ways to increase application performance. Enhance and recommend solutions / processes for downstream impact analysis associated with data and/or model changes. Support, maintain and enhance applications (when necessary) written with ETL tools such as Informatica, Airflow, Snowflake and additionally support teams using custom ingestion and transformation processes. Collaborate with enterprise stakeholders to implement and adhere to data storage standards and maintain catalogs to facilitate consistent data management practices. Establish data quality metrics and monitoring processes to proactively identify and resolve data quality issues. Work with various IT departments within Schwab to perform preventive and corrective maintenance and incident management measures. Ensure database integrity, availability, and restorability by working with enterprise operational excellence teams. Evaluates the integration of new tools or technologies based on the capabilities of the existing infrastructure. Recommend solutions and help with functional and performance testing needs (mock data, test environments, data refresh processes). Responsible for coordination of planning the installation of operating systems, databases, applications, development upgrades, and new releases. Follow and develop database standards, guidelines, and best practices. Establishes standards, controls, and procedures to ensure data integrity and security. Perform capacity planning and projection for future growth. And finally, be able to work in an Agile Scrum environment
