Senior Database Administrator

Company: Techaccess Pakistan

𝗛𝗶𝗿𝗶𝗻𝗴: 𝗦𝗲𝗻𝗶𝗼𝗿 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗔𝗱𝗺𝗶𝗻𝗶𝘀𝘁𝗿𝗮𝘁𝗼𝗿 – 𝗘𝗻𝘁𝗲𝗿𝗽𝗿𝗶𝘀𝗲 𝗗𝗕 𝗣𝗹𝗮𝘁𝗳𝗼𝗿𝗺𝘀

📍 Location: Lahore

🕒 Experience: 8-10 Years

𝗝𝗢𝗕 𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡 

Installations & Management

• Install, configure, and maintain databases including Oracle Database, MySQL, MongoDB, IBM Db2, and PostgreSQL.

• Manage database instances across production, staging, and development environments.

• Perform database upgrades, patching, and migrations with minimal downtime.

Performance Monitoring & Optimization

• Monitor database performance and troubleshoot performance issues.

• Analyze slow queries and optimize SQL execution plans.

• Implement indexing strategies, partitioning, and query tuning to enhance performance.

Backup and Recovery

• Design and implement database backup and recovery strategies.

• Perform full, incremental, and point-in-time recovery when required.

• Conduct periodic backup validation and disaster recovery testing.

High Availability & Replication

Configure and manage high availability and replication technologies including:

• Oracle Data Guard

• MySQL Replication / Group Replication

• MongoDB Replica Sets

• PostgreSQL Streaming Replication

• DB2 HADR

Monitor replication status and resolve replication issues to ensure system availability.

Database Security

• Manage database users, roles, and privileges.

• Implement security best practices and data protection policies.

• Monitor unauthorized access and security vulnerabilities.

Database Monitoring & Maintenance

• Monitor database health, disk space, and resource utilization.

• Perform regular maintenance tasks including:

Index rebuilds

Statistics updates

Log management

• Ensure database uptime and availability.

Troubleshooting & Incident Management

• Diagnose and resolve database-related incidents.

• Analyze logs and performance metrics.

• Support application teams in resolving database issues.

𝗘𝗱𝘂𝗰𝗮𝘁𝗶𝗼𝗻: 

Bachelor’s or Master’s degree in Computer Science, Information Technology, Computer Engineering, or a related discipline.

𝗣𝗿𝗲𝗳𝗲𝗿𝗿𝗲𝗱 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 & 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝗧𝗿𝗮𝗶𝗻𝗶𝗻𝗴𝘀

• Oracle Certified Professional (OCP) – Oracle Database Administrator (Required)

• MongoDB Certified DBA Associate

• Oracle MySQL Database Administrator Certification

• IBM Certified Database Administrator – Db2

• Equivalent database administration certifications will also be considered

Apply: careers@techaccesspak.com