Effectual

Senior Database Engineer

Effectual

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $150,000 - $180,000 per year

Job Level

Senior

Tech Stack

Amazon RedshiftAWSCloudDynamoDBMariaDBMongoDBMySQLOraclePostgresSQLVault

About the role

  • Design, install, configure, and maintain cloud-based database environments
  • Monitor database performance and proactively identify and address performance issues
  • Ensure the security of the database environment, including access control and data encryption
  • Develop and implement backup and recovery procedures to ensure the integrity of the database
  • Plan and execute database upgrades and migrations
  • Provide technical support to end-users and troubleshoot issues with the database
  • Automate database maintenance and management tasks where possible
  • Create as-built documentation for database service configurations and options
  • Stay current with emerging trends and technologies in cloud-based database solutions
  • Maintain familiarity with infrastructure as code (IaC) and CI/CD pipeline with respect to cloud database offerings
  • Collaborate with other team members and stakeholders to ensure the database architecture design meets performance and scalability requirements

Requirements

  • 10+ years of experience in the database field
  • Strong proficiency in database management
  • Experience with recent versions of database platform
  • Knowledge of AWS RDS platforms and workarounds to enable adoption
  • Proficient in writing and optimizing SQL statements
  • Knowledge of limitations and advantages of the AWS RDS platforms and workarounds
  • Experience with database replication, high availability, and disaster recovery
  • Knowledge of event scheduler and database features
  • Experience with AWS environment especially the RDS platforms
  • Proficient in GitHub and code versioning
  • Knowledge of Agile methodologies of delivery
  • Ability to plan resource requirements from high level specifications
  • Collaborating with development, cloud operations and infrastructure teams for integration
  • Security practices: encryption at rest/in transit, access control, backups