Database Administrator

Location

Indiana | United States

Job description

ACT-UAW Local 7902
the union for NYU adjuncts and New School part-time faculty,
student workers, and health service employees

Database Administrator

Based in New York City, NY
(remote work possible)

Title: Database Administrator
Location: New York, NY (remote work possible)
Status: Part-Time, 13 hours/week
Duration: 1-year renewable contract

ACT-UAW Local 7902, the union for NYU adjuncts and New School part-time faculty, student workers, and health service employees, is seeking a Database Administrator to join our team. Formed in 2002, our union has been at the forefront of organizing contingent instructors and student workers in higher ed. We are seeking to hire a Database Administrator to maintain and expand a newly developed database system, which will undergird the Local’s efforts to win fair working conditions, build a more equitable higher education system, and fight for social justice in our community and beyond.

ACT-UAW 7902 recently partnered with another UAW Local to develop its own instance of a custom software-driven data system to keep track of information needed for organizing and contract enforcement. This system involves multiple code bases , including full stack web applications, data engineering workflows, and downstream surfacing of data in services like Google Sheets. This system is actively developed and changes on a near-weekly basis to support organizing with existing and new tools.

The system will continue to be improved and expanded by the partner local, but as it grows and evolves, Local 7902 requires a Developer to help contribute to developing the system’s codebase, adapt our local instance to new versions and deal with breaking changes, manage deployment pipelines, and maintain and develop the parts of our local instance that require complex knowledge, like localized applications and complex systems of database views.

As this system is complex and has growing needs, a major part of this position will include learning new technologies and data team needs, particularly through self-directed learning. ACT-UAW Local 7902 is seeking applicants who are excited to work together with the team to make plans to learn new tools and frameworks and put those skills to practical use.

Responsibilities

• Writing SQL queries and maintaining data pipelines
• Using low-code app development tools like Tooljet to quickly create bespoke internal tools to support specific workflows
• Providing substantial support to workflows currently using Google Sheets and the Google Sheets API
• Conducting exploratory analyses of large data sets
• Designing new pipelines for a growing number of new data sources
• Maintaining and improving a full-stack web application (TypeScript), including SQL database migrations.
• Assisting in maintaining and deploying related services in AuthN/AuthZ, reverse proxies, and docker
• Document systems and workflows, and provide training to others in the local

Requirements:

• UAW member in good standing for at least 6 months
• Strong motivation to protect and expand the rights of academic employees
• A strong ability to learn independently. This position will require learning new tools and frameworks, and a good candidate will be able to work with the team to identify resources and time needed to learn them, (preferably) in self-guided ways.
• A commitment to learning the domain-specific concepts and workflows used throughout ACT-UAW Local 7902
• The ability to communicate and work with people across diverse disciplines, linguistic backgrounds, workplaces, and identities, as well as the ability to foster empowering and equitable group dynamics.
• Strong attention to detail, time management skills, and ability to work both independently and as part of a collaborative group.

Preferred Qualifications

• Proficiency with shell and common command line skills.
• Strong familiarity with relational databases, including schema management, design, and an ability to become proficient in permissions management
• Intermediate SQL proficiency, with an ability to quickly ramp up to an advanced level in Postgres
• Strong data analytics proficiency, ability to use tools such as Python and SQL to conduct conceptually difficult analyses of messy data sets
• Strong Python skills, with experience writing utilities with real world uses
• Full stack web development skills, including Node, Typescript, React (with React Router and Hooks), HTML, and CSS.
• An understanding of best practice concepts in software development, including object-oriented paradigms, agile development methodologies, and clean architecture principles
• An understanding of good security practices

This position will be primarily remote.

Women and people of color are strongly encouraged to apply.

Terms of employment: 1-year renewable contract. $46.29 hourly rate. This position is represented by UAW Staff United (USU).

To Apply:
Interested applicants should submit a résumé/CV and 1-page cover letter to [email protected]. Applications will be reviewed on a rolling basis. Deadline to apply: March 20, 2024.

WHEN APPLYING: Be sure to indicate that you saw this information at .

Job tags

Salary