Senior DBA

Apply Now

Company: VDart

Location: Englewood, NJ 07631

Description:

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.

Similar Jobs