Database Administrator

Job Description

Analyzing the Organization's Data Needs:

• Identify data sources, understand the information needs of end users, and convert them into technical requirements for data warehouse design.

Designing Data Models:

• Design analytical data models (such as star and snowflake models) to structure data in multidimensional formats and optimize access to it.

Implementing ETL Processes:

• Design and develop ETL processes to transfer data from various sources, cleanse, normalize, and load into the data warehouse.
• Support and maintain the data warehouse:
• Monitor data health, update tables, and ensure stable and fast system performance.

Performance Tuning:

• Review and improve the efficiency of database queries and structures to increase data retrieval speed.
• Investigate database problems.

Technical Documentation:

• Prepare and maintain documentation related to data structures, data flow maps, ETL processes, and design standards.

Data Quality and Integrity Assurance:

• Implement data quality controls, review discrepancies, and develop solutions to maintain the accuracy and integrity of stored data.

Cross-Functional Collaboration:

• Communicate with data analytics, business intelligence, developers, and project managers to align technical and business goals.

BI and Analytics Project Support:

• Provide appropriate data structures for reporting, predictive analytics, and other data-driven applications.

Use Modern Tools and Technologies:

• Implement new technologies in the data warehouse, such as Cloud Data Warehouse, Metadata Management Tools, and modern ETL tools.