Database Engineer II

Roles and Responsibilities:

Database Proficiency: 
MongoDB and MySQL Administration: Demonstrate strong command over MongoDB and MySQL databases, specifically in a Linux environment. This includes installing, configuring, and maintaining these databases for optimal performance.
Data Modeling and Management: 
MongoDB Data Modeling: Develop efficient data models tailored for MongoDB, focusing on data integrity, scalability, and ease of access.
Administration and Troubleshooting: Perform daily administration tasks like monitoring database health, troubleshooting issues, and ensuring data consistency. Proactively identify and resolve bottlenecks to maintain seamless database operations.
Performance Optimization: 
Query Tuning and Index Optimization: Tune MongoDB queries and optimize indexes to improve database performance, reduce latency, and handle large volumes of data effectively.
Performance Optimization: Implement strategies for overall database performance improvement, including fine-tuning MongoDB's configuration settings and system parameters.
Replication, Migration, and Upgradation: 
Replication: Set up and maintain MongoDB replica sets for high availability and data redundancy.
Migration and Upgrades: Plan and execute database migrations, including schema upgrades, with minimal downtime. Ensure smooth transitions while migrating databases across environments or upgrading to new versions.
Backup and Recovery Strategy: 
Backup and Recovery Solutions: Design, test, and implement robust backup and recovery strategies. Regularly verify backups to ensure data integrity and reliability.
Disaster Recovery: Develop and test disaster recovery plans to ensure data is protected and recoverable in case of a system failure.
Cloud Platform Familiarity: 
AWS and Azure: Maintain a basic understanding of cloud environments like AWS and Azure, focusing on deploying, managing, and scaling databases on these platforms.
High-Availability Solutions: Leverage cloud-native solutions for high availability, including managed services, load balancing, and failover setups.
Database Configuration and Maintenance: 
Configuration Management: Install and configure databases according to best practices, and maintain database configurations for security, performance, and reliability.
Upgrades: Perform regular database upgrades to ensure compatibility with newer features and security patches.
Scripting and Automation: 
Shell Scripting or Python: Use shell scripts or Python to automate routine database tasks, including backups, monitoring, and reporting. This enhances efficiency and reduces the need for manual intervention.
Adaptability and Task Management: 
Managing Multiple Priorities: Effectively manage multiple projects and tasks within a fast-paced environment, prioritizing based on urgency and impact.
Primary Skills:

Database Experience: Over 5 years of hands-on experience in database management, specializing in MongoDB and MySQL administration.
Cloud-Computing: Strong foundational knowledge of AWS and Azure, with experience leveraging these platforms for database hosting and scaling.
Additional Database Knowledge: Familiarity with other NoSQL databases like Redis or Elasticsearch is beneficial, adding versatility in managing different data types and structures.
PostgreSQL Basics: Basic knowledge of PostgreSQL (PSQL) is an advantage, as it demonstrates familiarity with relational database concepts beyond MySQL.

This role emphasizes a strong background in MongoDB and MySQL administration, performance tuning, backup and recovery strategy, and familiarity with cloud platforms. The candidate must be adaptable, have good time-management skills, and be capable of using scripting for automation.