Database Administrator

CloudCard; Lahore; On-site; PKR 800,000 - 1,200,000; Full time

Job summary

A leading tech company in Lahore is seeking a Database Administrator with 2 to 4 years of experience. The ideal candidate will have a strong background in Postgres and MySQL, keen problem-solving abilities, and a Bachelor's degree in computer science. As part of the team, you will be responsible for maintaining database integrity, optimizing performance, and implementing security measures. The role offers opportunities for growth and is integral to the company's data management practices.

Qualifications

• 2 - 4 years of experience with Postgres & MySQL.
• Good understanding of joins and indexes.
• Experience with programming languages such as PL/SQL coding.
• Working knowledge of WAL management and server configuration parameters.

Responsibilities

• Provide first-level support and maintain database environment.
• Create shell scripts and SQL scripts for administration.
• Setup and test backup and recovery processes.
• Monitor and analyze database activity.
• Enforce security measures to protect data.
• Collaborate with developers to resolve issues.

Skills

Postgres

MySQL

PL/SQL coding

Database design

Problem-solving skills

Attention to detail

Communication skills

Education

Bachelor’s degree in computer science or related field

Tools

AWS EC2

AWS RDS

Job description

Job brief

We are looking for a 2 – 4 years experienced Database Administrator to join our team! As a Database Administrator at our company, you will be responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining our company's databases and troubleshooting of databases.

Responsibilities

• Provide first-level Support and maintain Postgres. MySQL database environment
• Create shell scripts and SQL scripts for database administration
• Provide appropriate resources and skill sets to support the DBA functions for the Applications as required
• Setup, maintain and test backup and recovery processes of databases
• Propose database changes to ease monitoring and administrative effort
• Document and implement changes to databases via proper Change Management methodology
• Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements
• Apply new patches and versions when required
• Participate in situation management of incidents related to database operations
• Be proactive in performance tuning and optimization to help improve database efficiency
• Excellent problem solver with strong attention to detail
• Enforce security measures to protect company data
• Performs database testing to ensure performance is met and compares with expected results
• Identifies gaps in scripts and procedures
• Work with Database developers and application developers to identify and resolve issues impacting production
• Assist with schema design, code review, SQL query tuning
• Collate, prepare and present statistical information for internal and external use
• Minimize database downtime and manage parameters to provide fast query responses
• Determine, enforce and document database policies, procedures and standards
• Perform tests and evaluations regularly to ensure data security, privacy and integrity

Requirements:

• Bachelor’s degree in computer science or a related information technology field
• 2 - 4 years of experience with programming languages such as PL/SQL coding
• Easily design and implement a business process into functional and efficient code
• Implement and manage company data management practices and policies
• 2 - 4 years of experience with Postgres & MySQL
• Good understanding of joins and indexes
• Good understanding of database design, schema standards, implementation, troubleshooting and maintenance
• AWS EC2 & RDS experience is desirablebut not mandatory.
• Working knowledge of WAL management, Auto and manual vacuuming, Server configuration parameters, transactions and locks management.
• ISO 27001 and PCI knowledge would be beneficial
• Critical thinking and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills