
Senior Database Engineer
Effectual
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $150,000 - $180,000 per year
Job Level
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.
- Supporting rigorous project governance and execution achieved through:
- Meeting with team members daily to review progress.
- Submitting time on assigned projects, daily.
- Supporting project delivery team members by:
- Always operating with transparency
- Being responsive to requests from team members for information
- Communicating working preferences and understanding the working preferences of others to help develop a high-performing team that operates with respect, effectiveness, and efficiency.
- Specific Responsibilities of the DBE
- Designing, implementing, and maintaining databases: The DBE is responsible for designing and implementing the organization's database system, and for ensuring that it is maintained and updated as needed.
- Monitoring and optimizing database performance: The DBE must analyze the database system monitoring to ensure that it is performing optimally. This may include identifying and resolving performance bottlenecks, optimizing compute and storage, and provide guidance on poorly performing queries.
- Ensuring data security and integrity: The DBE must ensure that the organization's data is secure and that access to the database system is properly controlled. This may include implementing security policies and procedures, configuring user access, encryption at rest and in transit, and managing data backups and recovery.
- Providing technical support and vendor escalation: The DBE must provide technical support to end-users of the database system, including troubleshooting issues and providing guidance on how to use the system effectively. The DBE will submit and respond to vendor support cases (AWS and other).
- Collaborating with other teams: The DBE must work closely with other teams, such as development, cloud operations and infrastructure teams, to ensure that the database system is integrated with other systems and is optimized for performance.
Requirements
- 7+ years of experience in the database field including cloud database systems.
- Expert level proficiency in database management.
- Experience with recent versions of database platform.
- Understanding of database underlying storage and configuration.
- Experience with three or more database RDBMS platforms.
- Lead database migration projects.
- Experience with database replication, high availability, and disaster recovery.
- Experience with AWS environment especially the RDS platforms.
- Proficient in writing and optimizing SQL statements.
- Knowledge of database features, such as its event scheduler
- Ability to plan resource requirements from high level specifications.
- Knowledge of limitations and advantages of the AWS RDS platforms and workarounds to enable their adoption and common use.
- Expert in use of code versioning tools such as GitHub.
- Expert knowledge of Agile methodologies of delivery.
- Experience leadership and team management,
- Eperience with risk management, conflict resolution and strategic planning
Benefits
- Medical, dental, and vision health insurances,
- Short term disability, long term disability and life insurances,
- 401k with Company match
- Paid time off (PTO) (120 hours PTO that accrue over one year)
- Paid time off for major holidays (14 days per year)
- These and any other employee benefit offerings are subject to management’s discretion and may change at any time.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
cloud database environmentsdatabase managementSQL optimizationdatabase migrationdatabase replicationhigh availabilitydisaster recoverydatabase performance monitoringdata encryptionbackup and recovery procedures
Soft Skills
team managementleadershipconflict resolutionstrategic planningcommunicationtransparencyresponsivenesscollaborationproblem-solvingproject governance