security and report incidents-Administers server configuration, migration, and other implementations-Monitors root cause analysis and resolutions-Manages back-ups and recovery procedures-Creates custom monitoring and maintenance plans-Administers and tests new upgrades and databases-Troubleshoots and resolves database problems-Ensures audit trails are maintained and documented - Perform other duties and projects as assigned Qualifications: · Bachelor's degree in computer science, information technology, computer science, engineering, or related field· Three to four years of My SQL or Maria DB server database experience with database administration experience in a commercial environment or equivalent
work experience· Certification with My SQL (from Oracle) or Maria DB a plus· Proven working experience as a Database administrator· Hands-on experience with database standards and end user applications· Excellent knowledge of data backup, recovery, security, integrity and SQL· Familiarity with database design, documentation and coding· Previous experience with DBA case tools (frontend/backend) and third party tools· Familiarity with programming languages API· Problem solving skills and ability to think algorithmically· Experience in a PCI work environments· Expertise with standard SQL, Triggers, Views, Stored Procedures, and Grants· Understanding of My SQL replication models including statement
based, row based, and GTID replication· Strong Linux server administration skills· Bash scripting and basic programming skills· Able to multitask, prioritize, and manage time efficiently· Accurate and precise attention to detail· Strong written and verbal communication skills· Excellent analytical, quantitative, and organizational skills· Up-to-date on latest industry trends; able to articulate trends and potential clearly and confidently· Good interpersonal skills and communication with all levels of management· Maria DB 10.
x/My SQL 5.7o Database system configurationso Stored Procedures, Triggers and expert in SQL Scriptingo Users/Roles and database securityo Table Partitioningo Indexingo Circular replication/master to master, and GTID is a must· Handling Terabytes of data, 1 billion row tables· Centos/Red Hat in a Cloud or Virtual Environmentso Shell Scriptingo System configuration and tuning· PHP, XML, JSON, Excel· Jasper Server/Jasper Reports· Monitoring: Innotop, Zabbix, Performance Schema EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER
