Agentis Careers

MySQL DBA

We are seeking a MySQL Database/Systems Admin to join our software engineering team. Our system consists of a high volume data warehouse in a hosted environment. Candidate must have experience with high availability systems and data warehousing.

    Major Responsibilities:
  • Query optimizations
  • Database Monitoring and tuning
  • Database Backup
    Occasional Duties:
  • Installations and upgrades of database SW and schema
  • Database Security
  • Troubleshooting
    Essential Skills/Qualifications:
  • 5+ years of MySQL DBA experience in the following areas:
  • Experience with MySQL 5.0 and later database administration in a 24×7 highly available production environment.
  • Experience in creating data warehouses, including data extracts, summary tables, de-normalization, etc.
  • Working with PHP engineers on database design and query optimization
  • Designing and managing tables, indexes, stored procedures, partitions, events and their logs, etc.
  • Installing, configuring and upgrading MySQL database, in Linux environment.
  • Experience with working on High availability and High throughput Production environments and troubleshooting.
  • Experience with event scheduling, triggers, stored procedures
  • Hands-on experience with replication and clustering
  • Linux scripting and cron

Experienced PHP Application Developer

  • Analyze business requirements and translate into technical requirements as well as anticipate future requirements
  • Design, evaluate, enhance, test, troubleshoot, and maintain object oriented applications in PHP
  • Provide input on design and direction of existing applications and new systems
    Required Skills:
  • to 5 Years experience developing custom production-level PHP 5 applications with MySQL in a LAMP environment
  • Experience in data analysis and data visitations
  • Strong object oriented PHP coding and debugging skills
  • Experience with Zend Framework
  • MySQL, Relational database design and queries
  • Portfolio and code samples showing work that demonstrates strong OOP PHP programming skills
  • HTML/XHTML
  • CSS
  • Javascript
  • Front end AND back end, well balanced
  • Strong written and verbal communication skills
    Additional Experience:
  • AJAX Javascript components and/or jQuery
  • XML
  • Tableless layout design & Cross Browser/Platform Coding
  • Subversion
  • Graphic design and user-interface skills
  • Understanding of basic networking concepts
  • Linux command line and/or server administration experience