Quadtec Solutions, Inc
Data Architect
Quadtec Solutions, Inc, Washington, District of Columbia, us, 20022
Job DescriptionThe 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
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