Database Manager

As a member of the core engineering team, the candidate will be responsible for designing, developing, and supporting the next generation of Visual ICT’s Internet Services.
Duties:
· The Database Developer is responsible for developing database applications on a Linux environment
· This individual will participate in all activities related to database administration in production, QA and development environments
· Work with technical and business staff for requirements
· Conduct high level and detailed design based on requirements
· Develop database code (SQL, MySQL stored procedures, and shell scripting)
· Perform unit test and work with QA for integration test
· Provide help and guidelines to application developers and business staff on database applications
· Participate in database maintenance work (database health monitoring, backup and restore, table and index maintenance, trouble shooting and recovery)
Qualifications:
· Between 3-5 years of MySQL 5.0 and 5.1 Administration and Development experience
· MySQL installation and configuration experience
· Experience with MySQL Replication configuration and administration
· Previous experience in PHP, Java, Python is a plus
· Understanding of relational databases and data warehousing, including logical and physical models, data integrity and referential integrity, database transaction, isolation levels and locking, database I/O, backup and restore, security
· Expertise in database development, especially in MySQL stored routines (stored procedures, functions and triggers)
· Experience in performance tuning (SQL optimization, indexing optimization, storage engine optimization and schema optimization)
Competence in trouble shooting and debugging (database locking, unexpected result sets and mismatched data in tables, slow queries and so on)