Database Administrator @ Blackstraw

You will be responsible for accurately and securely developing, using and maintaining databases for a wide range of organizations and applications. Your duties include ensuring that company databases are functional at all times, backing them up in the event of memory loss, and maintaining adherence to a data management policy.

You should have extensive knowledge of the databases under your administration, be the first respondent to database problems that arise, and carry out periodic maintenance and troubleshooting.

Key Requisites :

• 3+ years of experience as a DBA.
• 3+ years of experience in working with PostgreSQL administration.
• Previously worked with multiple teams, vendors.
• Excellent debugging skills and good written and verbal communication.
• Capable of resolving L2 and L3 production issues and RCAs.

Should have Expertise in :

• Database backups, recovery, security.
• SQL development including development in functions, procedures, triggers.
• High availability and replication.
• Performance tuning and query enhancements.
• Linux and shell scripting.
• Database best practices.
• Supporting 10 TB+ sized databases.

Should be familiar with: (Good to have) :

• Basic automation.
• DB and/or OS patching.
• NOSQL querying.
• PostgreSQL plugins/extensions.
• Programming knowledge like python, R or java.
• Database design and/or data modelling.
• ETL tools like but not limited to Talend, Informatica, etc
• Performance testing, load testing and sanity testing from DB perspective.
• AWS, Azure or GCP experience.