Description

Skill requirements:

 

  • Solid understanding of database design principals
  • Minimum 5 year experience with PostgreSQL 8.3, 8.4, 9.0
  • Good understanding of query execution plans
  • Good SQL scripts skill including SPs, PSQL scripting
  • Good performance tuning skills
  • Ability to proactively identify, troubleshoot and resolve live database systems issues.
  • Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
  • Experience in replication, is a plus
  • Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments
  • Expertise in Oracle Backup & Recovery.  
  • Experience in Database Cloning or Refresh.
  • Analyze requirements from developers and architects for data loads/migrations, and build PL/SQL procedures to satisfy requests
  • Mentor team members on DBA tasks and new technologies
  • Manage the database portion of application releases.
  • Process knowledge on Incident Management & Change management
  • Good verbal and written communication skills
  • Be flexible and willing to work in shifts.
  • Problem-solving skills
  • Ability to thrive in a fast-paced, deadline-sensitive environment

MYSQL DBA

               JD

  • 6 to 9 years of experience on MySQL database administration.
  • Good Expertise in MySQL internals, configuration, and replication strategies and upgradation/Migration is MANDATORY

ü Experience migrating between database technologies, especially integrating with third-party replication systems such as Tungsten.

ü Working experience in migrating MySQL Fabric Replication Shards to NDB Cluster 7.4 is MANDATORY

ü Working experience in NDB Clusters is MANDATORY

  • Should understand MySQL development.
  • Expertise in upgrading and migrating databases to Cloud
  • Hands on experience on Performance Tuning and Query Optimization.
  • Should have good understanding on Indexing, Partitions, and different storage engines available under MySQL.
  • Hands on experience in setting up replication and different configuration parameters available in MySQL.
  • Good exposure working with Linux/Unix environment.
  • Capable of supporting and implementing technology projects as the primary DBA in support of business initiatives
  • Provide 24x7 production support.
  • Ability to create and maintain positive and professional business relationships with both internal associates and external customers
  • Excellent written and verbal communication

Education

Any Graduate