Role Overview :
We are looking for an experienced Database Administrator (DBA) with strong expertise in MySQL and PostgreSQL to manage, maintain, and optimize our database systems. The role requires hands-on experience in performance tuning, replication, troubleshooting, and ensuring high availability of production environments.
Responsibilities :
- Administer, manage, and tune MySQL and PostgreSQL databases for optimal performance.
- Maintain and troubleshoot production database server issues.
- Configure and manage clustering, replication, and partitioning.
- Design, manage, and optimize indexing, stored procedures, triggers, and views.
- Write and optimize complex SQL statements.
- Manage database replications, archiving, and RDS.
- Ensure compliance with information legislation such as the Data Protection Act.
- Troubleshoot and resolve issues in a Linux environment.
Required Skills : Must-Have Skills :
Proven experience with MySQL and PostgreSQL.Strong knowledge of structured query language (SQL), Unix, and DBMS.Expertise in database replication, partitioning, and performance tuning.Excellent problem-solving skills and ability to think algorithmically.Strong written and verbal communication skills.Nice-to-Have Skills :
Experience with Oracle and SQL Server.Exposure to NoSQL databases.Familiarity with cloud services (AWS, GCP, Microsoft Azure).Familiarity with On-Prem Databases.Experience :
Min 4 yearsAbout Us :
PureLogics is a full services technology company with having presence in the USA, UAE, and in Lahore. Over the past 18+ years, we have matured from a narrowly-focused five-person team to a well-established technology hub with around employees. We're CMMI Level 2 and ISO Certified company and highly acclaimed AWS consulting partners.
The success of our business mainly lies in building a team of A-players, who work together and build together, and who crave perfection in everything they produce for our elite clients. We offer the opportunity to young and enthusiastic individuals that are eager to take on tough challenges under our mentorship toward a bright future.
What are we offering?
Health InsuranceProvident FundAnnual Paid LeavesCompensation PlansPaid Certifications & TrainingCar Finance ProgramBike Finance ProgramChild Education ProgramTwo Annual TripsStars Of the Month RewardsQuarterly MeetupsReferral BonusesBirthday & Eid GiftsJ-18808-Ljbffr