Senior Engineer, Database Engineering

The Impact: This is an excellent opportunity to join Enterprise Solutions as we transform and harmonize our infrastructure into a unified place while also developing your skills and furthering your career as we plan to power the markets of the future.

Whats in it for you: This is the place to hold your existing Database, Infrastructure, and DevOps skills while having the chance to become exposed to fresh and divergent technologies (e.g. AWS/ Snowflake/ Terraforms/Python)

Responsibilities:

The DBA will maintain and optimize SQL Server 2016/2019/2022, Oracle 12c/19c, Postgres 14/15/16 and MySQL databases hosted in AWS environments such as Amazon RDS, Amazon EC2, and Amazon Aurora. The role requires expertise in database performance tuning, security, cloud-based best practices and ensure continuous availability The DBA will collaborate closely with developers, system administrators, and Devops teams to ensure efficient database integration with business applications.

Production Stability and Reliability

• Own the stability, performance and availability of all production database environments.
• Lead incident resolution, root cause analysis and prevention strategies.
• Define and enforce database operational standards, guardrails and best practices.

Database Management & Maintenance

• Administer and maintain SQL Server, Oracle, PostgreSQL, MySQL databases hosted on Amazon RDS and Amazon EC2.
• Perform database installations, patching, and upgrades on AWS infrastructure.
• Configure and manage multi-AZ deployments, Read Replicas, AOAG, and Data Guard to ensure high availability.
• Manage SQL Server Always On configurations for improved failover and availability.
• Implement database partitioning, compression, and indexing strategies for performance optimization.

Performance Engineering

• Conduct deep performance analysis at the system, query and indexing levels.
• Recommend and implement architectural improvements for scalability
• Guide application teams in schema and query optimization.

Backup & Recovery

• Design and implement automated backup strategies using AWS Backup and RDS Automated Snapshots for SQL Server.
• Use Oracle RMAN for Oracle database backups and recovery.
• Develop and test disaster recovery plans using AWS DMS and Cloud Endure.

Monitoring & Alerting

• Configure proactive alerts for performance issues, storage limits, and availability risks using CloudWatch and AWS SNS.

• Collaboration & Documentation
• Collaborate with developers, cloud architects, and DevOps teams to integrate database changes into CI/CD pipelines.
• Document database architectures, configurations, backup strategies, and recovery plans.

Automation & Innovation

• Drive automation of operational dba tasks using PowerShell, Python, AWS CLI or similar tools.

• Evaluate and implement new database technologies, monitoring solutions and optimization tools.

Tools & Technologies

• Oracle Enterprise Manager (OEM), SQL Developer, TOAD
• Shell scripting, PowerShell, PL/SQL, PG/SQL
• Git, Jenkins, Terraform, Ansible, CloudFormation
• Goldengate, AOAG, DMS, Data guard

What Were Looking For:

• Oracle Certified Associate (OCP)
• Microsoft Certified: Database Administrator
• MySQL Certified: Database Administrators
• PostgreSQL Certified: Database Administrators
• AWS Certified Solutions Architect
• 10+ years of experience as DBA