What are the responsibilities and job description for the Database Administrator position at Altium Limited?
Overview :
The Database Administrator (DBA) is responsible for the performance, integrity, and security of all Alterman's databases. This role includes planning, development, and troubleshooting, as well as working closely with the IT Service Desk and Business Intelligence and Analytics teams. The DBA ensures data consistency, supports data integration and transformation processes, and provides secure, high-performing access to data systems. The role also involves setting up and managing database integrations, ensuring seamless data flow across different systems.
Essential Functions :
1. 90%
- Manages and maintains database systems, ensuring high levels of performance, availability, and security.
- Designs the structure of databases and schemas, monitors database performance, and implements changes to optimize performance.
- Collaborates with the IT Service Desk team to resolve database-related issues and provide support.
- Works with Business Intelligence and Analytics teams to develop data models, support reporting needs, and optimize data flows.
- Implements, oversees, and manages data integration processes, ensuring accurate and efficient data exchange between systems.
- Uses ETL / ELT processes to integrate data from various sources into Snowflake.
- Develops, implements, and maintains database policies, procedures, and standards, ensuring compliance with industry regulations.
- Identifies, evaluates, and recommends hardware or software technologies to achieve desired database performance.
- May manage user access and security role development.
- May enter and revise data dictionary definitions.
- May merge older databases with current databases.
2. Performs other duties as assigned by management. 10%
Education and Experience :
Skills / Abilitites :
Work Environment :
Physical Demands :
