Database Administrator

Roles and responsibilities

The Database Expert will be responsible for the design, implementation, and maintenance of the database systems for an eInvoicing Central Data Platform (CDP). This role involves ensuring the integrity, performance, security, and scalability of the database architecture. The ideal candidate will have extensive experience with database technologies, data modeling, and optimization techniques to support high-volume data processing and reporting needs.

Skills

• Proficiency with database management systems such as SQL Server, Oracle, MySQL, or PostgreSQL.
• Experience with cloud-based database services such as AWS RDS, Azure SQL Database, or Google Cloud SQL.
• Strong understanding of data warehousing principles and experience with BI tools.
• Knowledge of data privacy standards and cybersecurity best practices.
• Experience with data modeling tools and techniques.
• Excellent problem-solving skills and the ability to work in a fast-paced environment.
• Strong communication and collaboration skills to effectively interact with various stakeholders.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Oracle Database Certification) are a plus.

Minimum Requirements

Educational Qualifications and Certifications: Bachelor's degree in Computer Science, Information Technology, or a related field.
Work Experience: Minimum of 5 years of experience in database administration, design, and development.

Desired Candidate Profile

• Database Design and Architecture:

  • Designing Databases: Creating well-structured databases based on business requirements and data models (e.g., relational, NoSQL).
  • Normalization: Ensuring data integrity by organizing databases to reduce redundancy and dependency (normalization).
  • Schema Design: Designing tables, views, indexes, and relationships for efficient data storage and retrieval.
  • Data Modeling: Using tools like ER (Entity-Relationship) diagrams to create logical and physical models of databases.

• Database Implementation:

  • Database Installation and Configuration: Installing and configuring database management systems (DBMS) like MySQL, SQL Server, Oracle, PostgreSQL, MongoDB, or others.
  • Data Migration: Overseeing the migration of data from legacy systems to new databases or between different DBMS platforms.
  • Data Integration: Implementing methods for integrating data across different systems and applications, such as ETL (Extract, Transform, Load) processes.

• Performance Tuning and Optimization:

  • Query Optimization: Identifying and optimizing slow-running queries by creating efficient indexes, optimizing joins, or rewriting SQL statements.
  • Database Indexing: Implementing and optimizing database indexing to improve data retrieval times and query performance.
  • Database Scaling: Implementing techniques for scaling databases to handle growing amounts of data and increasing user load (e.g., partitioning, sharding).
  • Caching Strategies: Using caching mechanisms (e.g., Redis, Memcached) to reduce load on databases and improve performance.

• Backup and Recovery:

  • Data Backup Strategies: Designing and implementing backup solutions to ensure data is regularly backed up and can be restored when needed.
  • Disaster Recovery Plans: Creating disaster recovery plans to recover data in case of failures or corruption (e.g., using point-in-time recovery).
  • Automated Backups: Automating backup processes to ensure consistency and regularity.

• Database Security:

  • Data Encryption: Ensuring sensitive data is encrypted both at rest and in transit to protect it from unauthorized access.
  • Access Control: Implementing role-based access control (RBAC) and user authentication mechanisms to ensure that only authorized users can access specific data.
  • Compliance: Ensuring that databases comply with industry standards and regulations, such as GDPR, HIPAA, or PCI-DSS, regarding data privacy and protection.
  • Auditing and Monitoring: Setting up database activity monitoring to detect and respond to potential security threats, breaches, or performance issues.