Database Administrator Expert (SQL Server, PostgreSQL)

3 Lý do để gia nhập công ty

• Tech savvy working environment
• Attractive benefits
• Training and developing opportunities

Mô tả công việc

• Database Administration:
  - Design, implement, and maintain complex database systems (e.g., Oracle, MySQL, PostgreSQL).
  - Ensure high levels of performance, availability, and security of databases.
  - Perform regular database maintenance, backups, and disaster recovery planning.
  - Monitor database performance, implement changes, and apply new patches and versions when required.
  - Manage database security and permissions.
• ETL Development:
  - Design, develop, and optimize ETL processes to extract, transform, and load data from various sources into data warehouses.
  - Analysts to understand data requirements and translate them into robust ETL workflows.
  - Ensure data integrity, quality, and consistency across different data sources and destinations.
  - Implement best practices for ETL process design, development, and deployment.
• Performance Tuning and Optimization:
  - Analyze and resolve database performance issues.
  - Optimize SQL queries and ETL processes for efficiency and speed.
  - Implement indexing, partitioning, and other optimization techniques to enhance database performance.
  - Documentation and Compliance:
  - Create and maintain detailed documentation of database configurations, ETL processes, and data workflows.
  - Ensure compliance with data governance and security policies.
  - Implement and enforce data privacy and security measures.
  - Monitor database performance, implement changes, and apply new patches and versions when required.
  - Manage database security and permissions.
• ETL Development:
  - Design, develop, and optimize ETL processes to extract, transform, and load data from various sources into data warehouses.
  - Analysts to understand data requirements and translate them into robust ETL workflows.
  - Ensure data integrity, quality, and consistency across different data sources and destinations.
  - Implement best practices for ETL process design, development, and deployment.
• Performance Tuning and Optimization:
  - Analyze and resolve database performance issues.
  - Optimize SQL queries and ETL processes for efficiency and speed.
  - Implement indexing, partitioning, and other optimization techniques to enhance database performance.
  - Documentation and Compliance:
  - Create and maintain detailed documentation of database configurations, ETL processes, and data workflows.
  - Ensure compliance with data governance and security policies.
  - Implement and enforce data privacy and security measures.

Yêu cầu công việc

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience in database administration and ETL development.
• Expert knowledge of relational database management systems (RDBMS) such as Oracle, MySQL, PostgreSQL.
• Proficiency in ETL tools and frameworks (e.g., PDI, AWS Glue, Apache Airflow).
• Hands-on experience with scripting languages (e.g., Python).
• Strong SQL skills and experience with performance tuning and optimization.
• Experience with data warehousing concepts, design, and implementation.
• Familiarity with data modeling tools and techniques.
• Experience with cloud-based databases and ETL solutions (e.g., AWS RDS, Azure SQL, Google BigQuery).
• Strong problem-solving skills and attention to detail.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team in a fast-paced environment.

Tại sao bạn sẽ yêu thích làm việc tại đây

See yourselves in a new light

In essence of joining our company, you will be given the scope to seize every opportunity and helped to acquire specific competencies you’ll need to succeed either you wish to go wide or go deep. Our company prides ourselves on our underpinned principle of nurturing people in not only HR policies but also in our culture. We value innovations and we need people to work on initiatives and carry on our business vision of operating excellence and market leadership.

Alongside with these, we believe our staff members deserve a good working condition, so that in addition to social health insurance you will be accessible to health and accident insurance and will be eligible to join in team building every year. We also value your efforts; for this reason, we give you both financial and non-financial rewards such as: KPI bonus, Best Initiatives, Best performer or Best manager of the year, etc.

Company's Benefits

• Financial support:
  • Probation with full salary
  • Lunch allowance
  • Wedding support
  • Family funeral support
  • 13th month salary + KPIs bonus
  • Performance rewards and awards
• Healthcare Insurance
• Events and activities:
  • Christmas
  • Year End party
  • Team Building
  • Family Day
  • Sport Day