Database Administrator

About the job
Job Description: Senior Database Architect

Project Overview:

We are seeking a Senior Database Architect to lead the optimization, restructuring, and documentation of an existing database architecture. The role involves tackling performance bottlenecks, optimizing query performance, improving resource consumption, and ensuring efficient data management and scalability. The project includes refining database design, integrating data solutions, and aligning with business goals.

Role: Senior Database Architect

Location: Sector F, DHA Phase 1 Islamabad / Remote/Remote

Type: Full-Time / Contract

Responsibilities

Analyze, split, and optimize the existing database architecture for improved performance and scalability.
Create ER diagrams and detailed documentation for the database structure.
Identify and resolve performance bottlenecks, especially in high-computation statistical queries.
Optimize query performance for SELECT, INSERT, UPDATE, and DELETE operations.
Manage and enhance Master-Master replication with dedicated slave servers for SQL dumps.
Improve read/write operations to handle high-volume transactions efficiently.
Implement and refine data archiving and anonymization strategies.
Oversee and maintain a multi-zone Cassandra cluster with client and data nodes.
Ensure database scalability, reliability, and failover strategies to minimize downtime.
Optimize server resources, including CPU, RAM, and storage, for better performance.
Collaborate with development teams to align database improvements with application refactoring.
Implement monitoring tools to track and report on database performance.
Lead database migration efforts and architecture refactoring for efficiency and scalability.
Requirements

10+ years of experience in database architecture and optimization.
5+ years of hands-on experience with MariaDB and 3+ years with Cassandra.
Expertise in database performance tuning, indexing, and query optimization.
Strong knowledge of Master-Master replication, failover strategies, and high-availability architectures.
Experience in large-scale data processing, handling millions of transactions per hour.
Proficiency in schema design, ER diagrams, and database documentation.
Strong experience in SQL and NoSQL databases, especially MariaDB and Cassandra clusters.
Knowledge of data archiving, anonymization strategies, and retention policies.
Familiarity with database monitoring tools, performance reporting, and alerting mechanisms.
Hands-on experience with cloud-based database solutions and large-scale distributed systems.
Ability to collaborate with development teams for application refactoring and optimization.
Strong problem-solving and troubleshooting skills for complex database issues.