Database Engineer

Effectual
Summary
Join us as a Database Engineer and become responsible for managing and maintaining our organization’s database environments, ensuring data is structured, secure, and readily available. Your core role involves designing, deploying, and optimizing database solutions, particularly in cloud environments. You will assess and implement various modern database systems, leverage your SQL expertise, and contribute to performance tuning, troubleshooting, and ongoing database optimization. This position focuses on the technical and administrative aspects of databases, ensuring smooth, secure, and high-performing data operations. You will collaborate with team members and stakeholders to meet performance and scalability requirements. This role is crucial for maintaining the efficiency and security of our data-driven organization.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- 4-7 year’s experience as a Database Administrator, managing or maintaining large-scale databases
- Strong knowledge of database management systems, such as MySQL, Oracle, Microsoft SQL Server
- Proficiency in database administration tools and utilities, including backup and recovery, monitoring and performance tuning
- Familiarity with database security connects and best practices
- Relevant certifications (AWS SysOps Associate, AWS Database Specialty, AWS SysOps Professional)
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
- 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 DBA 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 DBA 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 DBA 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 DBA 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 DBA will submit and respond to vendor support cases (AWS and other)
- Collaborating with other teams: The DBA 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
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)