Senior DBA

Role- Senior DBA

Location -Englewood Cliffs, 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.