Database Automation Engineer - Remote, Eastern Time

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

Job Summary

As a Database Automation Engineer you will be responsible for designing, developing, testing, and implementing software solutions that automate database processes and systems. You will use your passion for data management and your strong understanding of database systems to deliver reliable database infrastructure and stack that follow the well architected framework and best practices. You will also use various tools and technologies to enable database automation through Continuous Integration/Continuous Delivery (CI/CD) pipelines and help advance our DevOps and IaC journey.

*This is a Hybrid (twice a week) role in our Raleigh office, we are also open to remote candidates that can work East Coast hours.

Responsibilities

• Automates database processes and systems with infrastructure-as-code and DevSecOps platforms and practices.

• Expert in database design, development, and administration for various database software products (e.g., Microsoft SQL Server, Snowflake, Cosmos DB, MySQL, MongoDB, Azure SQL, Azure SQL managed Instance, Oracle etc.).

• Proficient in programming languages (e.g., SQL, Python, Java, C#), ETL tools, and data modeling techniques for database automation.

• Experienced with version control systems, automation tools and frameworks (e.g., GitHub, terraform, ansible, Selenium, Jenkins, GitHub Actions etc.) for database development and deployment.

• Creative and problem-solving skills to find innovative solutions for automation challenges and optimize database performance and security.

• Develop and maintain Database technology architecture to ensure it aligns with business objectives.

• Attention to detail and quality assurance skills to ensure the reliability and performance of automation systems and prevent data loss or corruption.

• Communication and collaboration skills to work effectively with clients, stakeholders, and team members across different teams and projects.

• Designs the technology strategy and solution recommendations for modern infrastructure engineering to support the development teams and business needs. Builds prototypes and educates the teams on new database technologies and services to accelerate their adoption.

• Being an architect/senior automation engineer, works closely with the engineering, and SRE teams to combine software and systems engineering to build and run cloud-native, DevOps delivered, highly scalable and fault tolerant systems and services using database automation.

• Design and maintain Database disaster recovery and business continuity plans to minimize downtime.

• Create and maintain comprehensive documentation of database infrastructure, automation, and best practices.

• Works with the operations team to automate repetitive tasks and harness monitoring and predictive alerting opportunities. Identifies key measures and ensures adequate actionable metrics for database availability and performance.

• Works towards the overall goals and objectives of the business. Determines the functionality required to meet those needs and manages resources accordingly.

• Develops and maintains database automation with SQL, Python, Java, C#, Terraform, etc. Ensures database modules are consistent and reusable across Arch, contributes to database design and engineering efforts and outputs across Arch globally. Builds automation to streamline database processes, improve data quality, and drive adoption of automation across the organization.

• Automate database provisioning, configuration, backup, and recovery.

• Use database monitoring and testing tools to automate database performance analysis, tuning, and troubleshooting.

• Use database security tools to automate database encryption, authentication, authorization, auditing, and compliance.

• Designs and manages the database tools, pipeline, automation, and IaC scripts and continuously monitors the industry landscape to improve and expand to further data quality and delivery team autonomy.

• Supports database-centric culture evaluating, recommending, prototyping, and engineering cloud database services, maintaining guidance and standards catalog for same, with an eye toward data security and performance optimization.

• Stays updated on new technologies, seeking opportunities to improve database and application performance and security, increasing data availability, and reducing operating costs. Plans