Database Administrator (DBA)

Translation Empire; Saddar; On-site; PKR 1,800,000 - 3,000,000; Full time

Job summary

Translation Empire is seeking a Database Administrator to safeguard performance, integrity, and security of databases. You will plan, develop, and troubleshoot databases while transforming data for reporting and migrations.

Responsibilities include installing and maintaining databases, optimizing security, creating dashboards, data warehouses, and ensuring minimal downtime with robust backups. Ideal candidates have strong SQL, security, modeling, and analytics skills.

Qualifications

• Strong SQL knowledge and SQL Server tools.
• Advanced security, backup/recovery, and performance monitoring.

Responsibilities

• Install and maintain database performance.
• Develop and enforce database security standards.
• Create and manage database reports, visualizations, and dashboards.
• Create and manage data warehouses for custom reports via APIs like Power BI, Holistics, Metabase, Mode Analytics.
• Guarantee data storage security and optimality.
• Manage database access and uptime to minimize downtime.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Use high-speed recovery techniques and backups.
• Diagnose and troubleshoot database errors/queries.
• Recommend and adopt emerging database technologies.
• Create automation for recurring database tasks.

Skills

SQL

Database security

Backup & recovery

Performance monitoring

Windows Server

Linux

Data modeling

Reporting dashboards

Communication

Education

Bachelor's degree in Computer Science

Tools

MS SQL Server

MySQL

PostgreSQL

Oracle

MongoDB

Power BI

Holistics

Metabase

Mode Analytics

Job description

Responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues. Also transform the data for various reporting and migration needs.

Responsibilities:

• Install and maintain the performance of databases.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Create and manage database reports, visualizations, and dashboards.
• Create and manage data warehouses for custom reports via third party APIs like Power BI, Holistics, Metabase, Mode Analytics
• Must guarantee that data is stored securely and optimally
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Use high-speed transaction recovery techniques and backup data
• Minimize database downtime and manage parameters to provide fast query responses
• Diagnose and troubleshoot database errors/queries.
• Recommend and implement emerging database technologies.
• Create automation for repeating database tasks.

Database Administrator Qualifications/Skills:

• Strong command of SQL and SQL server tools
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Understanding of relational and dimensional data modeling
• Strong mathematical and statistical knowledge
• Excellent written and verbal communication skills
• Impeccable attention to detail

Education and Experience Requirements:

• Bachelor’s degree in computer science or a related field
• Three to five years of experience in database administration, information technology, database architecture, or a related field
• Proven working experience as a Database Administrator
• Hands-on experience with database standards and end user applications
• Excellent knowledge of data backup, recovery, security, integrity and SQL
• Familiarity with database design, documentation and coding
• Experience with Windows(required) and Linux(optional) Server environments
• Extensive experience with database technologies (MS SQL required) - (MySQL, PostgreSQL Oracle, MongoDB optional)
• Experience with cloud services (AWS, Microsoft Azure) a plus