Database Automation Solutions Architect

We are seeking an experienced Database Automation Solutions Architect to join our team at Arch Capital Group.

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

• Automate 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 for timely delivery of new and updated technology to support database design, development, and administration, through Automation.
• Provides guidance to engineering and operations teams on enabling and managing end to end availability and performance of mission critical databases using automation tools and techniques.
• Builde