Logo
Resource Logistics

Senior DBA

Resource Logistics, Englewood, New Jersey, us, 07631

Save Job

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.