Database Administrator/Developer
Job Summary:
The Database Administrator/Developer is responsible for including but limited to proactive production support of multiple MariaDB database instances, along with application development efforts in a team-centered environment.
Job Responsibility:
- Monitors databases for proper performance
- Manages/Estimates storage for all applications
- Manages 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 MySQL or MariaDB server database experience with database administration experience in a commercial environment or equivalent work experience
- Certification with MySQL (from Oracle) or MariaDB 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 MySQL 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
- MariaDB 10.x/MySQL 5.7
- Database system configurations
- Stored Procedures, Triggers and expert in SQL Scripting
- Users/Roles and database security
- Table Partitioning
- Indexing
- Circular replication/master to master, and GTID is a must
- Handling Terabytes of data, 1 billion row tables
- Centos/RedHat in a Cloud or Virtual Environments
- Shell Scripting
- System configuration and tuning
- PHP, XML, JSON, Excel
- JasperServer/JasperReports
- Monitoring: Innotop, Zabbix, Performance Schema