Database Administrator (DBA)

Translation Empire Ltd; Rawalpindi Cantonment; On-site; PKR 892,800 - 1,339,200; Full time

Job summary

A leading technology firm is seeking a skilled Database Administrator to ensure the performance, integrity, and security of databases. Responsibilities include installing and maintaining databases, optimizing security, and creating reports and dashboards. Candidates should possess strong SQL skills, a related degree, and 3-5 years of experience in database administration. The ideal candidate will also have knowledge of cloud services and various database technologies. This role is based in Rawalpindi Cantonment, Pakistan.

Qualifications

• 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.

Responsibilities

• Install and maintain the performance of databases.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Create and manage database reports and dashboards.
• Minimize database downtime and manage parameters for fast query responses.

Skills

Strong command of SQL and SQL server tools

Advanced knowledge of database security

Understanding of relational and dimensional data modeling

Strong mathematical and statistical knowledge

Excellent written and verbal communication skills

Impeccable attention to detail

Education

Bachelor’s degree in computer science or a related field

Three to five years of experience in database administration

Tools

MS SQL

MySQL

PostgreSQL

Oracle

MongoDB

AWS

Microsoft Azure

Job description

Overview

Responsibilities 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