Database Administrator (DBA)

Direct Manager

  CTO

Report to

PM & CTO

Job Description

The role of DBA is responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining the company products and services database

Job Responsibility

The main job responsibilities are

• Install, upgrade, and manage database applications.
• Installing and upgrading the database server and application tool.
• Allocating system storage and planning storage requirements for the database system.
• Modifying the database structure, as necessary, from information given by application developers and application administrators.
• Performance tuning of database systems.
• Monitoring and optimizing the performance of the database.
• Provide guidance and support to Application Developers.
• Assist with schema design, code review, SQL query tuning.
• Install, tune, implement and upgrade DBMS installations.
• Write and deploy SQL patches.
• Upgrade and improve application schema and data upgrades.
• Proactively and regularly make recommendations for system improvements.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Enrolling users and maintaining system security.
• Controlling and monitoring user access to the database.
• Planning for backup and recovery of database information.
• Maintaining archived data.
• Backing up and restoring databases.
• Contacting database vendor for technical support.
• Managing and monitoring data replication.
• Provide guidance and support to different support levels (L2 and L1), application admins and system admins.
• Prepare database performance reports.
• Ensuring compliance with database vendor license agreement.

Qualification

Associate or Bachelor’s degree in Computer Science, Information Technology, database Administration, or a closely related field, or equivalent experience required

Experience

•  +5 years’ experience as DBA at Mobile operators or banking sector.
•  ORACLE-certified database administrator.
• Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB, IBM Informix).
• Experience in MySQL and PostgreSQL.
• Experience with programming languages such PL/SQL coding.
• Experience in creating and maintaining UNIX shell and Perl scripts.
• Experience with Linux and Windows Server environments.
• Experience with cloud services (AWS, Microsoft Azure) a plus.

Skills

• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
• Command over SQL and PL/SQL.
• Good understanding of data and schema standards and concepts.
• Good understand database design, implementation, troubleshooting and maintenance.
• Understanding of relational and dimensional data modeling.
• Strong command of SQL and SQL server tools.
• PowerShell and Unix shell scripting skills.
• MCSE/MCSA certifications preferred.