Database Administrator Virtual Volunteer Job in CrowdDoing

Save to Favorites

Recruiting Organization: M4A FOUNDATION - CROWDDOING

Virtual Volunteer Job for Database Administrator

Use your talent for a good cause.

Project :Medicinal Foods for Stress, Sleep and Anxiety

Overview

CrowdDoing is a global virtual collaboration to research medicinal foods for stress, sleep and anxiety. Our project has the goal of advancing integration across fields of research and to build medicinal foods literacy in the population.

Medicinal Foods for Stress, Sleep and Anxiety is recruiting a Volunteering Database Administrator for Medicinal Foods, CrowdDoing. We're helping to build medicinal foods literacy and citizen science of foods & herbs for Stress, Sleep and Anxiety.

This position will be responsible for creating and maintaining the company database and applications. The Database Administrator will act as a gatekeeper for data and database-related issues and will be responsible for resolving and reviewing all database-related problems. Strengths in technical experience and the ability to interface with all levels of users, an excellent teamwork mindset are crucial to success.

Essential Functions

The DB Administrator shall monitor, review, assess, analyze, maintain, and configure, test, report, and document database conditions to ensure availability, effective change management, and successful database development.

Assist with managing and maintaining clearance reciprocity systems

Managing database access

Developing simulations and exercises to test readiness responses and communication channels;

Responding to user requests for assistance in database integration and development;

Developing new databases, as required, and updating existing databases.

Able to pick the right database / cloud application to create and maintain data.

Conduct regular system tuning, performance monitoring, maintenance, and backups to ensure optimal performance

Ensure database connectivity from applications and devices is reliable and free of errors

Perform troubleshooting actions when database problems arise

Interface with various teams to create appropriate access to read / write into db.

Create reports and fulfill custom requests for users. Perform regular security updates

Design and maintain database redundancy while working to minimize database downtime and service interruptions

Virtual catch up meeting every week with the team

Comfortable working in a startup phase non-profit organization

Experience and Requirements

Required Knowledge / Skills / Abilities:

3+ years of relevant experience in Database Administration and supporting database systems

2+ years working knowledge of data backup, recovery, security, integrity and Structured Query Language (SQL).

Solid understanding of SQL best practices

Strong database maintenance capabilities, including with enterprise database systems

Experience with database administration in cloud environments

In-depth knowledge of database and query tuning techniques

Administering MS SQL Instances and Databases ,routine maintenance, backups, restores, performance tuning, security best-practices (logins/users/permissions.)

Familiarity with database encryption (TDE.)

Expert T-SQL skills, good understanding of relational data design

Working knowledge of stored procedures, triggers, agent jobs, Integration Services and Reporting Services development

Extensive experience with ETL processes

Excellent technical diagnostic abilities database failure investigation, reproduction, resolution

Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization.

Hands-on experience with database backup and recovery, performance tuning, and high-availability solutions.

Amazon Web Services experience, particularly RDS, Redshift, DynamoDB, and Aurora.

Strong prioritization and time management skills are a must

Minimum volunteer hours expected: 7 hrs / week

Attention to detail, diligence, and punctuality in order to accurately document database status

Ability to effectively establish and execute strategic and critical task priorities to demonstrate problem-solving skills, and to think algorithmic

Education and Certifications

Bachelor degree in Computer Science or related field or an Associate degree in Computer Science or related field with relevant work experience

MCSA: SQL Server certification and / or AWS certification is welcome but not required

PostgreSQL or Any DBA certification is preferred

Note:Please provide your resume,linkedin profile link while applying for this Virtual Volunteer/Non paid job.

Stipend ProvidedFalse

Training ProvidedFalse

Housing AvailableFalse

Language/Cultral Support AvailableFalse

Wheelchair AccessibleFalse

Fee RequiredFalse

Fee Amount: None

This opportunity is recurring