Sr Database Engineer

• 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.

Qualifications

• 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

• AWS Certified CloudOps Engineer - Associate
• AWS Solution Architect Professional
• HashiCorp Terraform Associate
• AWS Certified Security - Specialty
• RDBMS vendor-specific Expert

Company Offered Benefits

Full-time employees are eligible to participate in our employee benefit programs:

• 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.

Physical Demands and Work Environment

The work is generally performed in an office environment. Physical demands include sitting, keyboarding, verbal communication, written communication. Employees are occasionally required to stand; walk; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the functions.

Salary Range for this position: $150,000-$180,000

"Salary ranges provided are for informational purposes only and may vary depending on factors such as experience, qualifications, and geographic location. The final salary offer will be determined based on the candidate's skills and alignment with the role requirements."

This job description may not be inclusive of all assigned duties, responsibilities, or aspects of the job described, and may be amended anytime at the sole discretion of the Employer. Duties and responsibilities are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbents will possess the skills, aptitudes, and abilities to perform each duty proficiently. This document does not create an employment contract, implied or otherwise, other than an “at will” relationship. Effectual Inc. is an EEO employer and does not discriminate on the basis of any protected classification in its hiring, promoting, or any other job-related opportunity.