logo

View all jobs

Associate Database Administrator (03 Positions)

Lahore, Pakistan

Job Description:

  • Installation, configuration and upgrading of Informix & 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

We are looking for

  • BSCS / MSCS
  • Fresh to 2 years of experience

Skills:

  • experience as a DBA on Unix-based (Linux/Solaris) systems
  • Strong knowledge of Unix Operating System internals
  • Good understanding of Informix & 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 Informix & MySQL backups and recovery scenarios
  • Excellent skills in shell scripts writing
  • Skills in informix Open Admin tool and MySQL Enterprise Monitor will be a plus
  • A good knowledge of Informix & MySQL security management
  • Excellent query writing skills
  • Good Knowledge and experience in database migration
  • Should have sound communication skills with management, development teams, vendors, systems administrators and other related service providers
  • Working knowledge in Linux/Solaris environments
  • Excellent Analytical skills

Job Location:

  • Lahore, Pakistan
Powered by