What are the responsibilities and job description for the Mongo DB Admin position at Q1 Technologies, Inc.?
Job Description
Must Have Technical/Functional Skills
- Primary Skill: Mongo DB Admin
- Secondary: Sybase , MYSQL
- Experience: 10 Years
Roles & Responsibilities
- 5-10 Years of Database Administration experience in Multiple Database platforms (MongoDB, MySQL and Sybase).
- MongoDB Administration Install, configure, and maintain MongoDB environments, including replica sets and sharded clusters.
- Monitor system performance and optimize queries, indexes, and schema design to improve throughput.
- Manage backup and restore processes using tools such as mongodump, snapshots, or enterprise backup solutions.
- Implement database security including TLS, auditing, and encryption (client-side Field Level Encryption and at-rest encryption).
- Troubleshoot operational issues including replication lag, failover events, and performance bottlenecks.
- MySQL AdministrationInstall, configure, and tune MySQL databases (InnoDB), ensuring optimal performance and stability.
- Manage replication environments (async/semi-sync), MySQL InnoDB Cluster.
- Perform backups and restores using mysqldump, mysqlpump, Percona XtraBackup, and point-in-time recovery.
- Optimize SQL queries, indexes, and schema design using EXPLAIN plans and monitoring tools.
- Implement strong security practices including user/role management, network hardening, and encryption.