Job Description
The Data Architect will be responsible for:
Database Design and Development:
- Design and implement database schemas, tables, views, indexes, and other database objects.
- Develop and optimize SQL queries, stored procedures, and functions for data extraction, transformation, and loading (ETL) processes.
- Create and maintain documentation of database structures and processes.
Data Management and Integration:
- Ensure data integrity, consistency, and accuracy across all database systems.
- Integrate data from various sources, including external databases and APIs.
- Implement data migration and data warehousing solutions as needed.
Performance Tuning and Optimization:
- Monitor and optimize database performance, including query performance tuning and index optimization.
- Troubleshoot and resolve database performance issues and provide recommendations for improvements.
Collaboration and Support:
- Collaborate with data analysts, IT staff, and other stakeholders to understand data requirements and provide database solutions.
- Provide technical support for database-related issues and assist with user training on database functionalities.
Required Qualifications:
- 7+ years of progressive experience in the area of database management.
- Critical understanding of data warehousing and relational database concepts.
- Experience with Oracle Golden Gate, SAP BusinessObjects 4.2, and Microsoft PowerBI.
Preferred Qualifications:
- Experience with Red Hat Linux and Oracle 11G database.
- Experience implementing mobile components.
- Experience with Microsoft Azure Machine Learning, Azure Data Factory, Databricks.
- Experience supporting multiple new product and enhancement releases.
- Relevant certification is preferred.
Education Requirement:
- Bachelor's Degree in relevant field.
Ability to obtain and maintain a Public Trust.
#J-18808-Ljbffr
