Database Administrator

As Database Administrator, the candidate will administer and maintain our new CRM data warehouse database on AWS environment and current fundraising Oracle database on-premise. The Database Administrator will provide technical support on integration tools (Dell Boomi) and reporting tools (Salesforce Einstein) as well as test and coordinate modifications to the systems, troubleshoot problems, ensuring high availability and optimum performance of the systems.

Oracle specific responsibilities:

• Plan and execute database backup and recovery;
• Improve and maintain database to include rollout and upgrades;
• Monitor the performance of databases for our fundraising application and data warehouse in development and production environments;
• Ensure 24/7 availability, performance, backup, recovery and security of the databases;
• Proactively monitor the database systems to ensure secure services with minimum downtime;
• Perform database environment cloning;
• Trouble shoot system issues and establish call bridges with appropriate personnel to ensure the databases restored to proper operating condition and all efforts are documented from start to closure;

AWS specific responsibilities:

• Creating database instance, designing schema, PL/SQL & SQL development; modifying database structure; Archiving and updating data;
• Importing data into PostgreSQL on Amazon RDS;
• Automating recurring or deprecating redundant database tasks;
• Maintaining database integrity, availability, and restorability;
• Generating needed ad-hoc reports and data files using PostgreSQL or third-party tool;
• Performing Common Management Tasks for PostgreSQL environment;
• Managing PostgreSQL Database Access;
• Proactive performance tuning and database parameter configuration; database cache management;
• Providing on-call support which can require analysis and trouble-shoot of complex issues;
• Additional duties, as assigned.

In addition, the Database Administrator will provide technical assistance within different environments and projects, Examples include assisting in setting up integrations between systems using Dell Boomi, creating and updating datasets for reporting tool Einstein Analytics, and various data hygiene projects.

Qualified candidates will have a minimum of three (3) years of database administrator experience, excellent analytical abilities, strong technical troubleshooting and root cause analysis skills. In addition, qualified candidates will possess:

• Experience with multiple database platforms;
• Experience in UNIX (Sun SPARC Solaris), Red Hat Linux and/or Oracle Unbreakable, and UNIX shell scripting;
• Expertise in Oracle 11g database implementation and administration;
• Knowledge of cloud solution environments, preferably Amazon Web Services (EC2, EBS, S3, etc.);
• Knowledge of SalesForce Sales Cloud, Service Cloud, NPSP data systems are a plus.

Candidates with experience in large data sets, and/or a nonprofit setting are preferred, as well as candidates possessing a distinct desire to continue to learn and work with other modern technologies in a fast-paced culture.