Company Overview:

Techline Pakistan is a leading AI based IT company aims to deliver superior IT Solutions to top tier domestic and international customers. Currently we are serving our clients in the area of AI, Big Data, Fintech and Block Chain Services around the globe. We take pride in developing alternative finance applications and our own machine-learning-based fraud prediction system to minimise charge backs merchants facing online. With the core objective of serving the planet, we improve the use of technology integrated with human potential. With over 1000 employees across the country, we offer individuals a variety of career development paths that enable them to contribute to our company goals as well as their professional development. Our attractive HR policies and inclusive work environment make us an employer of choice.

Job Overview :

Techline is looking for the Data Base Administrative with 1 Year experience in Data base or Unix-based (Linux/Unix) systems.

Responsibilities and Duties:

• Installation, configuration and upgrading of PGSQL & MySQL Server software and related products.
• Establishes and maintains database backups & recovery policies and procedures.
• Creates new database instances and performs database migration within and across the platforms with minimum down time.
• Maintains the existing database design and takes care of new implementations.- Implements and maintains database security (create and maintain users, assign roles and privileges) as per company's policy.
• Performs query optimization, database performance evaluation and tuning.- Performs database re-organizations as required to assist performance and ensure maximum up-time of the database.
• Performs comprehensive and proactive database monitoring.
• Setup and maintain documentation and standards.
• Provides technical support to application development teams.
• Reviews and assists the impact analysis of any changes made on production databases.
• Works as part of a team and provide 24x7 support.
• Troubleshoots and resolves the problems regarding the databases.
• Performs general technical trouble shooting and gives consultation to development teams.
• interfaces with vendors for technical support.
•  Evaluates new features and products related to database.

Skills & Requirements:

• 1 Year experience as a DBA on Unix-based (Linux/Unix) systems.
• Strong knowledge of Unix Operating System internals.
• Good understanding of PGSQL & MySQL databases, related utilities and tools.
• A good knowledge of physical database design.
• Overall knowledge of SQL, PL/SQL and analytical SQL.
• Strong problem troubleshooting and database monitoring skills.
• Excellent knowledge of PGSQL & MySQL backups and recovery scenarios.
• Excellent skills in shell scripts writing.
• Skills in PGSQL Admin tool and MySQL Enterprise Monitor will be a plus.
• A good knowledge of PGSQL & MySQL security management.
• Excellent query writing skills.
• Good Knowledge and experience in database migration.
• Excellent Analytical skills.
• Working knowledge in Linux/Unix environments.
• Should have sound communication skills with management, development teams, systems administrators  

Perks and Benefits : 

• 25 paid holidays yearly
• Overtime: Single pay rate for overtime
• Bonus: Performance-based as per the evaluation
• Medical and Life Insurance
• Increment: Performance-based increments
• Promotion: Performance-based promotion
• Lunch provided
• EOBI
• Local and International Trips