Job Requirements
3 - 5 years of experience
Minimum Bachelor’s Degree
Skills
Data Migration
MySQL
MariaDB
PostgreSQL
Data Engineering
SQL
Python
Relational Databases
Statistical Data Analysis
Microsoft SQL Server
Data Analytics
Power BI
Job benefits
Free food & beverages
Overflowing pantry or meal allowances, offering free food at work helps with company morale
Workstation assistance
Laptop or desktop? We don’t mind! As long as you’re happy with the tool to help you!
Vacation & Leaves
You can take as many vacations, sick, personal, or mental health days as you need, so long as your manager approves your time off
This job post is managed by
MEDA TECHNOLOGY
Last active 4 minutes ago
Job description for Database Administrator (Middle - Senior Level) at Meda
**Job Description & Responsibilities:**
- Design and implement an optimal database schema for storing and efficiently querying large volumes of statistical data.
- Select and implement the appropriate database technology (e.g., SQL Server, PostgreSQL) considering factors like scalability and data security.
- Define tables, columns, relationships, and constraints within the database to ensure data integrity and efficient retrieval.
- Set up robust access controls and security measures to protect sensitive data within the database.
- Load data into the database from various sources (e.g., CSV files, APIs, other databases) using ETL processes.
- Clean, transform, and format data to ensure accuracy, consistency, and suitability for statistical analysis.
- Manage database backups and recovery procedures to guarantee data availability and minimize downtime in case of system failures.
- Perform database optimization techniques to improve query performance and ensure efficient data retrieval for statistic applications.
- Build and maintain views, stored procedures, and functions to simplify complex data analysis tasks within the statistic applications.
- Provide secure data access to user application through API or direct database connection.
- Collaborate with the related team to troubleshoot and debug data quality and access issues.
- Document the database structure, ETL processes, and data governance procedures for clear understanding and future maintenance.
**Minimum Qualifications:**
- Bachelor's degree in Computer Science, Information Technology, or Mathematics.
- At least 3 years of experience as a Database Administrator or related role.
- Proven experience in designing and implementing secure and scalable database structures.
- In-depth understanding of SQL and the ability to write complex queries for data retrieval and manipulation.
- Experience with ETL tools and data integration techniques.
- Working knowledge of statistical applications like Power BI or similar data visualization tools.
- Excellent communication and interpersonal skills for collaboration with data analysts and application developers.
- Ability to work independently and manage multiple tasks effectively while meeting deadlines.
Interview process
- Logic Test
- Wawancara Teknis / Non-Teknis
- Negosiasi
- Done
Glints Safety Tips
Don't provide your bank or credit card details when applying for jobs. Legitimate employers and hiring managers do not require an application fee or expect you to pay for training.
Learn More