Alpha Zeta Systems is a software development company with over 20 years of technological foundation based in Lahore. The company builds mission-critical applications and is now forming a new, dynamic team focused on robust data solutions. They offer an environment that combines decades of experience with exposure to modern technologies, providing a collaborative and growth-oriented workplace for technical professionals.
Table of Contents
Job Title: MySQL Database Administrator & Developer at Alpha Zeta Systems (Pakistan)
Full-Time
📍 Location: Lahore, Pakistan 🇵🇰
Company: Alpha Zeta Systems
Apply nowPosition Overview: MySQL Database Administrator & Developer
Alpha Zeta Systems is seeking a skilled MySQL Database Administrator & Developer to join their new team. This hybrid role is ideal for a professional with 3-12 years of hands-on MySQL experience who excels in both development and administration. You will be responsible for designing, developing, and maintaining database objects (procedures, functions, triggers, schemas), optimizing queries, and ensuring the performance and security of databases that support critical applications. Expertise in JSON data manipulation is a mandatory requirement, highlighting the company’s work with modern, flexible data structures.
Key Responsibilities
The successful candidate will be entrusted with the following core technical duties:
- Database Development & Design: Design, develop, and maintain database schemas, tables, indexes, stored procedures, functions, and triggers. Ensure proper data modeling and normalization.
- Performance Optimization & Support: Work closely with application developers to optimize complex SQL queries, troubleshoot performance issues, and enforce database best practices.
- JSON Data Expertise: Utilize and manipulate JSON data types within MySQL, a critical skill for handling semi-structured data in modern applications.
- Administration & Documentation: Perform core DBA tasks, maintain up-to-date documentation for all database systems and configurations, and implement security best practices.
- Cross-functional Collaboration: Act as the database subject matter expert, supporting both backend and frontend development teams in a fast-paced, agile environment.
Candidate Requirements (Mandatory)
| Requirement Category | Specific Qualification |
|---|---|
| Education | Bachelor’s degree in Computer Science, Information Technology, or a related field. |
| Core Experience | Minimum 3 years of hands-on experience in MySQL development and administration. Proficiency in writing stored procedures, functions, and triggers is essential. |
| Technical Skills | Strong expertise in relational database design, normalization, joins, and foreign key relationships. Experience with JSON data type and JSON manipulation is mandatory. |
| Fundamental Knowledge | Good understanding of data modeling, security best practices, and query optimization. |
| Soft Skills | Excellent analytical, problem-solving, and communication skills. |
Ideal Candidate Profile
The ideal database professional for this role will be:
- A proficient MySQL developer with strong DBA instincts, comfortable writing complex procedures one moment and tuning server performance the next.
- A modern data handler, specifically skilled in working with JSON within MySQL to manage flexible data schemas.
- A collaborative problem-solver who enjoys supporting development teams and optimizing the data layer for application performance.
- Eager to learn and adapt, with an interest in cloud databases and modern DevOps practices, even if direct experience is currently limited.
Nice-to-Have Skills & Perks
- Preferred Exposure: Knowledge of Oracle PL/SQL, cloud databases (AWS RDS, Azure SQL, GCP), and familiarity with CI/CD pipelines and Docker.
- Why Join: Competitive salary, growth opportunities, exposure to modern technologies and cloud infrastructure, and a collaborative, learning-oriented work environment.
Frequently Asked Questions (FAQs)
1. Is this more of a development or an administration role?
This is a true hybrid role. The title “DBA & Developer” and the responsibilities indicate a 70/30 or 60/40 split towards development (writing procedures, designing schemas) with essential administrative duties (optimization, documentation, security). You need to be strong in both areas.
2. How critical is the JSON experience?
It is explicitly stated as a “must.” This indicates the company’s applications heavily utilize JSON columns in MySQL for flexibility (e.g., storing configuration, dynamic attributes). You must be comfortable querying, updating, and manipulating JSON data directly in SQL.
3. What does “mission-critical applications” imply?
It means the databases you will work on support core business operations where downtime or data corruption has serious consequences. This requires a high degree of reliability, attention to detail, and performance tuning skills.
4. Are the “Nice to Have” skills required for application?
No, they are advantageous but not mandatory. They indicate the company’s future direction (cloud, DevOps). Showing willingness to learn these areas can strengthen your application.
How to Apply
If you are a MySQL expert with strong development skills, mandatory JSON experience, and a passion for building reliable data systems, Alpha Zeta Systems encourages you to apply.
Submit your application via the official listing:
👉 Apply for MySQL DBA & Developer Position
Build and optimize the data backbone for mission-critical software in Lahore, Pakistan 🇵🇰.