Sr Database Engineer

Effectual is a company focused on cloud solutions, and they are seeking a Sr Database Engineer to manage and maintain their database environments. The role involves designing, deploying, and optimizing database solutions, ensuring data security, and providing technical support while collaborating with various teams.

Responsibilities:

• 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
• 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
• Experience with risk management, conflict resolution and strategic planning
• AWS Certified CloudOps Engineer - Associate
• AWS Solution Architect Professional
• HashiCorp Terraform Associate
• AWS Certified Security - Specialty
• RDBMS vendor-specific Expert