What are the responsibilities and job description for the Senior DBA - MySQL/MariaDB/Percona and MongoDB - 12+Yrs position at KTek Resourcing?
Hello ,
My name is Rajat, and I am a Technical Recruiter at K-Tek Resourcing. We are searching for professionals for the below business requirements for one of our clients.
Role- Senior DBA
Location -Englewood, NJ
Job Description:
- Strong understanding on installation, configuration, patching, supporting, and upgrading MySQL/MariaDB/Percona and MongoDB, Redis and PostgreSQL databases on Linux machines.
- Strong Database Design, and performance tuning skills.
- Experience on AWS cloud, deploying and managing MySQL, MongoDB, Redis, and PostgreSQL database clusters both on-prem and AWS EC2 instances and AWS Aurora
- Designs, documents, implements, and monitors backup of database and other database protection or high availability solutions such as replication, synchronization, and clustering.
- Experience with replication and clustering technologies for MySQL like GTID, Galera , XtraDB/InnoDB cluster, Mongo ReplicaSet, Redis
- Experience monitoring solutions like Percona toolkit, Prometheus, Zabbix and Grafana
- Experience in enforcing standards for user account, group, and database security and configuration for all production databases and non-production databases
- Experience with heterogenous and/or homogenous migration of database: MySQL to AWS Aurora, Oracle to MySQL etc
- Should be good with MySQL Queries, Stored procedures and functions
- Experience with configuration management tools like Ansible, and CloudFormation would be an added advantage.
- Ability to take full ownership of availability and security of production data.
- Good exposure to at least one scripting language: shell scripts, python, Perl
- Have written moderately complex Linux/Unix shell scripts utilizing built-in shell variables, regular expressions, conditional expressions, functions etc.
- Strong Communication skills (verbal and written) with an ability to work in a highly collaborative, multi-country/time zone environment.
- Good organizational skills with the ability to track and prioritize numerous tasks.
Responsibilities
- Complete support for all aspects (Implementation, Support, Development, Maintenance and Monitoring) of the MySQL, MongoDB and Redis databases both on-premise and on AWS cloud )
- Implementation and maintenance of MariaDB/MySQL, MongoDB and Redis Database systems, clusters and replication.
- Implement various monitoring solutions like Prometheus, Grafana, Monyog etc for Database Monitoring
- Develop and maintain SQL queries, Stored Procedures, Functions etc for various application needs
- Provide ongoing technical support, problem investigation and resolution for database systems.
- Develop and maintain Monitoring scripts(shell scripts) , ansible scripts & Alerting criteria for database systems.
- Develop and maintain scripts(shell scripts) for Database Backup and Recovery.
- Develop/maintain system implementation documents, knowledge base, service reports and operational procedures.
- Improve operations by conducting systems analysis; and recommending changes in processes and procedures.
- Evaluates tools and processes to Improve Database Management and Operation.
