We are looking for Senior Database Administrator with deep expertise - mainly in PostgreSQL
(but also some in mongo,redis,SQLite,mysql,etc), experience within AWS/RDS/selfhosted environments.
The vision is a very senior role -
our use case is large dbs, complex/interdependent systems, and multitasked between many db related projects
so not to micromanage and handhold for individual tasks, but to leverage experience
and bring wizdom and to lead the whole team in this area.

Key responsibilities:
- design, implement, and maintain PostgreSQL databases (self-hosted and RDS) -
- support multiple envs and teams
- monitor database performance and proactively identify and resolve issues
- optimize queries and database schema for performance and scalability
- upgrade planning and execution
- dbschema changes, db splits, migrations, improvements
- collaborate with devs/ QA / DevOps / data /oth

The point-of-sale (POS) solution consists of devices deployed at our customers locations that interact with cloud-based services. With over 30,000 customers across the US, our company seeks a dedicated resource focused design, configuration, scalability, and performance tuning of the Postgres RDS instances that are core to our cloud infrastructure.

Responsibilities:
Move large database to new AWS account
Split database into acorn and regular ops.
Further splitting by function, as needed, including choosing alternative dbs
Performance evaluation of current db
Review/coord with devs about errors/warnings in logs
Continuing performance monitoring/tuning/optimization
Improve existing queries
Perform reviews of new queries
Manage users/roles/permissions/access
Create a Load Testing framework
Schema review/design/management/change management

Responsibilities:
Provide professional guidance and support for new and ongoing projects in complex IT environments.
Plan, install, manage, and maintain large-scale MSSQL databases.
Perform upgrades, backups, restores, and overall database maintenance.
Work closely with development teams, infrastructure engineers, system administrators, and project managers.
Opportunity to get hands-on experience with cutting-edge Big Data technologies such as ElasticSearch, MongoDB, and PostgreSQL.