Mitsubishi - Tampa, FL
posted 2 months ago
The Bank is seeking an experienced Data Platform Engineer with SQL Server/Oracle Database administration skills and a strong background in hybrid cloud hosting. The ideal candidate will have a deep understanding of SQL Server and Oracle administration coupled with expertise in AWS services, particularly AWS RDS SQL Server and DMS. Proficiency in infrastructure as code tools like Terraform, scripting languages such as Python, Bash, PowerShell, and experience with serverless computing using AWS Lambda functions are essential for success in this role. In this position, you will be responsible for designing, deploying, and managing SQL Server and Oracle databases both on-premises and in AWS RDS, ensuring optimal performance, availability, and scalability. You will collaborate with cross-functional teams to architect and implement hybrid cloud database solutions aligned with business requirements. Additionally, you will develop and maintain infrastructure as code using Python, Bash, Ansible, PowerShell, and Terraform to automate the provisioning and configuration of a hybrid cloud database environment. Your role will also involve migrating on-premises databases to AWS using DMS, DMS CDC, and developing custom CDC scripts. You will monitor and maintain the health, performance, and security of a hybrid cloud database environment, implementing cost optimization strategies and ensuring efficient utilization of database resources. Your responsibilities will include performing database migrations, upgrades, and patching activities with minimal downtime and risk, as well as implementing and managing database backups, replication, and disaster recovery strategies to ensure data integrity and availability. Continuous improvement of database infrastructure and architecture to support evolving business needs and best practices will also be a key focus. Automation and scripting will play a significant role in your daily tasks, as you will utilize Python, Bash, Ansible, PowerShell, and Terraform scripting to automate database administration tasks, streamline processes, and enhance operational efficiency. You will also be responsible for automating the configuration and management of database security policies, access controls, and encryption in compliance with industry standards and regulations. Collaborating with DevOps teams to integrate database deployments into CI/CD pipelines and automate release processes will be essential to ensure all automation is robust, reusable, and adheres to industry standards. Finally, you will implement and enforce security best practices for Data Platforms in a hybrid cloud environment, ensuring compliance with relevant regulations and internal policies through proper configuration and auditing. Documentation of database configurations, procedures, and best practices for knowledge sharing and team collaboration will be part of your responsibilities, along with providing support and troubleshooting assistance to other team members and stakeholders to resolve database-related issues, performance bottlenecks, and scalability challenges in hybrid cloud environments.