Serve as the primary point of contact for advanced level troubleshooting issues, and perform hands-‐on Database/Systems administration as required.
Automate regular Database/OS administrative work with other support teams and ensure they are functioning correctly.
Plan and executes tests of fault tolerance capabilities, including backup/recovery, replication, failover, and disaster recovery.
Write documentation, including data standards, procedures, and data dictionary definitions.
Work with Systems and Development teams on designs, SQL performance optimization, and perform on-‐call support by providing responses to high priority requests for assistance by Operations teams and provide after hours and weekend support as needed.
Work with application developers to evolve the database architecture and design and will participate in the creation and refinement of staging & production database instances.
3+ years of working experience in Database Administration/Engineering (MySQL) on Production Environment, supporting complex, highly available OLTP databases.
Production level experience with NOSQL solutions (Mongo and Cassandra preferred).
Well‐versed in HA strategies including database replication, failover clustering, database mirroring and Log Shipping.
Well versed with creating and implementing full-‐proof DR plans – including Backup and Recovery.
Well versed in database server performance monitoring and storage performance optimization.
Experienced in tuning database server configurations, queries, and indexes.
A good understanding of the Operating System concepts, mainly Linux and Windows.
Proficiency in any of the scripting language (e.g. Python /PHP/Perl/ Ruby .. and SQL)
Working experience on Amazon Web Services or Azure.
Deep understanding of the software development lifecycle (SDLC).
Able to respond to on-call (24/7 rotating shifts) incidents and be available for inquiries from staff, management and vendors. Provide technical assistance and support.