Responsible for the overall database system (S4 HANA and Oracle Database and ThoughtSpot platform) ensuring the efficient and secure management of all database systems, enabling reliable data storage, retrieval, and processing to support the organization's business operations
- Design the database(s) and ThoughtSpot platform architecture, including data models, tables, and indexes in order to meet business requirements with an optimized database design.
- Manage the implementation of any/all database(s), ensuring proper installation, configuration, and integration with other systems through collaboration with technical teams to ensure smooth data migration and application deployment.
- Responsible for optimizing the performance of any/all database(s) through analyzing and fine-tuning database configuration, monitoring performance metrics, and identifying and resolving bottlenecks to ensure optimal system performance.
- Ensure database(s) adheres to security best practices and compliance and governance requirements through effective and compliant access controls, encryption, and data masking techniques to protect sensitive information.
- Troubleshoots database-related issues, performs regular maintenance tasks such as backup and recovery, and applies patches and upgrades to keep the database environment up to date and stable.
- Collaborate with cross-functional teams, including developers, data analysts, and infrastructure teams, to address database-related requirements and resolve issues.
- Maintain current and complete documentation of the database architecture, configurations, and processes for future reference.
- Support and oversee report or analysis creation to meet business requirements which can include identification and analysis of data from various sources, design report or analysis layouts, and effective use of ThoughtSpot platform functionalities to generate insightful and visually appealing analysis to identify trends, patterns, and insights that can be used to drive business decisions. Effectively leverage the capabilities to identify data sources, apply filters, and perform calculations to derive meaningful insights from the available data.
- Ensure effective visualization and dashboarding using ThoughtSpot's intuitive interface (appropriate charts, graphs, and other visual elements to facilitate decision making and actionable insights, making it easy for users to understand and interpret the information presented).
- Responsible for organization and team continuous learning and staying updated with the latest advancements in S4 HANA.
- Present progress reports, offer alternatives and/or solutions to address feedback or schedule (timeframe) risks.
- Perform other duties and projects as assigned.