DBA Architect

Datamatics Technologies LLC; Lahore; On-site; PKR 2,600,000 - 3,800,000; Full time

Job summary

Datamatics Technologies LLC seeks a DBA Architect in Pakistan to design, administer, and optimize enterprise databases, ensuring availability, security, and performance across SQL Server, Oracle, PostgreSQL, and MySQL environments.

You will lead backup, DR, tuning, security, and capacity planning while collaborating with data teams to drive migration and modernization initiatives.

Qualifications

• 7-10 years of Database Administration and Architecture experience.
• Expertise in SQL Server, Oracle, PostgreSQL or MySQL.
• Hands-on HA/DR, backup & recovery, replication and tuning.
• Experience in monitoring, security and capacity planning.
• Strong SQL and scripting skills (PowerShell, Python, Shell Script).
• Problem solving and troubleshooting abilities.

Responsibilities

• Design, administer, and optimize enterprise database environments.
• Ensure database availability, performance, security, and reliability.
• Manage backup, recovery, and DR solutions.
• Perform database performance tuning and query optimization.
• Implement database security controls and access management.
• Troubleshoot and resolve complex database issues.
• Support database migration, modernization, and integration initiatives.
• Collaborate with Data Architects, Data Engineers, and Application Teams.

Skills

Database Administration

Database Architecture

SQL Server

Oracle

PostgreSQL

MySQL

HA/DR

Backup & Recovery

Replication

Performance Tuning

Monitoring

Security

Capacity Planning

PowerShell

Python

Shell Script

Education

Bachelor's degree in Computer Science / Information Technology

Tools

Informatica IDMC

Microsoft Fabric with Purview

Databricks

Azure

AWS

Job description

DBA Architect

Location: Pakistan
Experience:7 - 10 Years

Responsibilities

• Design, administer, and optimize enterprise database environments.
• Ensure database availability, performance, security, and reliability.
• Manage backup, recovery, and disaster recovery (DR) solutions.
• Perform database performance tuning and query optimization.
• Implement database security controls and access management.
• Troubleshoot and resolve complex database issues.
• Support database migration, modernization, and integration initiatives.
• Collaborate with Data Architects, Data Engineers, and Application Teams.

Required Skills

• 7-10 years of Database Administration and Database Architecture experience.
• Strong expertise in SQL Server, Oracle, PostgreSQL, or MySQL.
• Hands-on experience with HA/DR, backup & recovery, replication, and performance tuning.
• Experience in database monitoring, security, and capacity planning.
• Strong SQL and scripting skills (PowerShell, Python, Shell Script).
• Excellent problem-solving and troubleshooting abilities.

Mandatory Technology Requirement

Candidates must have hands-on experience in at least one of the following:

• Informatica IDMC (Intelligent Data Management Cloud)
• Microsoft Fabric with Purview
• Databricks

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Microsoft, Oracle, Informatica, Azure, or Databricks certifications.
• Experience with cloud platforms (Azure/AWS) is an added advantage.