Database Administrator

As a MongoDB Atlas Database Administrator, you will be responsible for deploying, managing, and optimizing our MongoDB Atlas databases in a production setting. You will ensure high availability, performance, and security compliance while collaborating with various teams to drive database-related projects and improvements. You will help in standardizing Database Administration including the operating model, practices, procedures, and technologies.

Must-Have Skills/Competencies:

● The candidate is expected to be aware and experienced with both relational and non-relational databases in terms of both an architectural point of view as well as with development.

● Should have good hands-on experience with MySQL/MongoDB Server. Should have participated in architectural design of the same along with developmental work using the same.

● Set up, configure, and maintain MongoDB Atlas clusters. Implement and manage sharding, replica sets, and data distribution strategies.

● Analyze database performance metrics and implement optimization strategies for query performance, indexing, and data access patterns. Conduct periodic audits to ensure databases are operating efficiently.

● Implement and maintain security best practices and compliance requirements, including GDPR, COPPA, and FERPA. Manage encryption, user access control, and data masking techniques as needed.

● The candidate should also be well aware and hands-on in terms of various maintenance work for the same including managing logs, backups, restores, and cleanups of the DB during its Ops time

● Should be aware of all database maintenance Practices.

● Develop and implement comprehensive backup and recovery plans. Regularly test disaster recovery strategies to ensure data integrity and availability.

● Must be able to contribute during the design phase of high availability - high scalability cloud-based products.

● Collaborate with development teams to design efficient, scalable data models. Conduct regular audits of schemas and advise on best practices for data organization.

● Must have experience in Performance Auditing, Optimizing / Tuning, Monitoring, and Troubleshooting all plate forms (on-prem and cloud).

● Use built-in Atlas monitoring tools, AWS CloudWatch, Prometheus, and Grafana to monitor database health and performance. Respond to incidents, troubleshoot issues, and implement long-term solutions to prevent recurrence.

● Implementation experience with other backup strategies based on RPO and RTO requirements

● Automate routine database maintenance tasks using Python and other scripting languages. Develop scripts to assist with data migrations, schema changes, and monitoring.

● Work closely with DevOps and development teams for CI/CD integration and cloud infrastructure management. Participate in cross-functional team meetings and contribute to project planning and execution.

● Define, track, and maintain standard baselines and configuration sets of all managed and/or monitored database instances and servers and implement industry best practices about the following:

○ Resource allocation and monitoring

○ Performance problem identification and resolution assistance

○ High availability - Clustering, replication (master-master, master-slave, multi-slaves, etc.), and load balancing

○ Data security and recovery

○ Data and Database Health Practices

○ Patch management, and System capacity planning.

○ Develop and maintain storage strategies, establishing system documentation and database recovery processing.

○ Identify and initiate resolutions to user problems associated with database performance and database capacity, utilizing best practices to maximize uptime and server utilization.

○ Support web application development, with a focus on helping the team interact with the database most efficiently and productively as possible

○ Review and deploy the database components for new versions of web applications/products to test and production environments using release management practices.

○ Partner with the DBA team to provide support during non-business hours, bi-weekly on-call rotation for support

○ Responsible for DR tests regularly

○ Help with Data Center migration and migrating on-premise DB servers to the public cloud

○ Good to have awareness and hands-on knowledge of Redis, Postgres implementations, and applications.

○ Good to have experience in Automation Powershell, TSQL Coding, or any other automation languages such as c# or .Net scripting with minimal supervision or support existing applications created by other folks.

Nice to Have Skills/Competencies:

● 8+ years of experience in database infrastructure services including planning and Designing experience in MS SQL Server/MySQL/MongoDB/PostgreSQL.

● Strong knowledge of Database Architecture and RDBMS fundamentals.

● Cloud experience with GCP and/or Amazon platform and/or Azure

● Strong interpersonal, analytic, and technical troubleshooting skills mandatory

● Strong verbal and written communication skills are absolutely essential.

● Demonstrated ability to be flexible in technology, with strong demonstrated experience in adapting to different technologies.

● Able to effectively communicate and collaborate with server, storage, and network infrastructure teams

● Post-secondary education in database infrastructure or equivalent.

● Ability to manage multiple projects and priorities