Datamatics Technologies

Database Designer & Administrator

Datamatics Technologies  •  Karachi, PK (Onsite)  •  2 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

We are seeking an experienced Database Designer & Administrator to design, implement, optimize, and maintain enterprise database environments supporting mission-critical applications and large-scale data platforms. The successful candidate will be responsible for logical and physical database design, performance optimization, database administration, and ensuring compliance with globally recognized database standards and best practices.

The ideal candidate will have extensive experience managing large datasets, optimizing SQL performance, supporting ETL/ELT processes, and administering enterprise database platforms such as Oracle, PostgreSQL, MySQL, or equivalent database technologies.

Key Responsibilities

Database Design

  • Design and develop logical and physical database models based on business and technical requirements.
  • Create efficient database schemas, tables, indexes, views, stored procedures, and relationships.
  • Ensure database designs are scalable, secure, and aligned with enterprise architecture standards.
  • Apply globally recognized database design standards and best practices.

Database Administration

  • Install, configure, administer, and maintain enterprise database environments.
  • Manage database availability, performance, scalability, and reliability.
  • Perform database upgrades, patching, backup, recovery, and disaster recovery planning.
  • Monitor database health and proactively resolve performance and operational issues.

Performance Optimization

  • Analyze and optimize SQL queries, stored procedures, and database workloads.
  • Perform query tuning, indexing strategies, and database performance optimization.
  • Monitor database performance metrics and implement continuous improvements.
  • Troubleshoot database bottlenecks and optimize resource utilization.

ETL/ELT & Data Integration Support

  • Support ETL/ELT processes by optimizing database performance and ensuring efficient data loading.
  • Collaborate with Data Engineers and ETL developers to improve data integration workflows.
  • Ensure data integrity, consistency, and quality throughout database operations.
  • Assist with data migration, transformation, and synchronization activities.

Security & Compliance

  • Implement database security controls, user access management, encryption, and auditing.
  • Ensure compliance with organizational security policies and industry standards.
  • Maintain backup, recovery, and business continuity procedures.
  • Perform regular database health checks and security assessments.

Documentation & Collaboration

  • Maintain database architecture documentation, data models, operational procedures, and configuration records.
  • Collaborate with software developers, data architects, infrastructure teams, and business stakeholders.
  • Provide technical guidance and support for database-related initiatives.
  • Participate in database modernization and continuous improvement projects.

Required Technical Skills

  • Database Design (Logical & Physical Data Modeling)
  • Database Administration
  • SQL Development & Query Optimization
  • Performance Tuning
  • Database Security & Access Management
  • Backup & Recovery
  • Disaster Recovery Planning
  • ETL/ELT Support
  • Data Migration & Integration
  • Database Monitoring & Troubleshooting
  • Large Dataset Management
  • Data Modeling Tools
  • Linux/Windows Server Administration (Preferred)
  • Scripting (Shell, Python, or PowerShell)

Database Technologies

  • Oracle Database
  • PostgreSQL
  • MySQL
  • Microsoft SQL Server (Preferred)
  • MariaDB (Preferred)
  • NoSQL databases (MongoDB, Cassandra, etc.) – Preferred

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field.
  • Minimum 7+ years of experience in database design, database administration, and enterprise data management.
  • Proven experience managing large-scale databases and optimizing SQL performance.
  • Experience supporting ETL/ELT processes and enterprise data integration platforms.
Datamatics Technologies

About Datamatics Technologies

Datamatics Technologies (DMT) was established in Dubai. We specialize in providing onsite and offshore professional services, covering the full spectrum of Data Analytics and Data Science domains.

Our experience of working with diverse industry sectors such as Telecoms, Finance, Government and Manufacturing, across multiple regions enables us to engage and deliver for our clients with confidence.

We can offer our full portfolio of services through resource augmentation, managed services, both on T&M or fixed price financial arrangements. Through our end-to-end managed services offering we enable our clients to cut down costs, increase profitability and focus on value addition to their core business activities.

Our project and delivery management team are certified in Agile, PMI and ITIL to ensure the planning and execution are carried out using industry best practices.

We are working with our clients across Middle East and Africa Region.

Industry
IT & Software
Company Size
51-200 employees
Headquarters
Dubai, AE
Year Founded
2016
Social Media