Database Automation Specialist

Job Summary

As a Database Automation Specialist, 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.

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 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.
• Builds and strengthens relationships and partnerships with corporate database leads and teams.
• Develops plans, document reference architectures and provides management oversight of implementing new database technologies using automation tools and techniques without service disruptions. Promotes resilient and low/no-downtime database infrastructure. Formulates and proposes long-term plans to build, maintain, and improve database automation systems.

Education and Experience

• Experience with Azure and AWS cloud platforms for database automation, such as provisioning, configuring, scaling, and securing databases using cloud services and tools.
• Experience with relevant technologies for database automation, including infrastructure automation and configuration tooling, Kubernetes environments (AKS/EKS) for deploying and managing database containers, shared GitHub Actions libraries for database development and deployment workflows, and scripting (PowerShell, Bash, Python, YAML, etc.) for automating database tasks and processes.
• Experience with DevOps (CI/CT/CD) tools for database automation, such as GitHub Actions, JFrog Artifactory, Sonar Cloud, Argo CD and Harness for continuous integration, testing, delivery, and deployment of database changes.
• Extensive knowledge of technology solutions for database automation, including concepts, practices, methods, and techniques in engineering public cloud databases, networks, Windows/Linux operating systems, and IT tools (monitoring, logging, alerting, Service Now, etc.) for managing and optimizing database performance and availability.
• Exposure to Containerization (AKS, EKS, OpenShift) and Serverless technologies for database automation, such as using Docker, Kubernetes, Azure Functions, AWS Lambda, etc. to create and run scalable and resilient database applications without managing servers or infrastructure.
• Strategic problem-solving, analytical, and decision-making ability for database automation, such as identifying automation opportunities and challenges, designing, and implementing database automation solutions, and evaluating and improving database automation outcomes.
• Demonstrated experience in Architecting and/or engineering large-scale highly resilient database systems using automation tools and techniques.
• Demonstrated ability to translate business needs into long-term database automation strategies that align with the organizational goals and objectives.
• Experience with engineering security technologies for private and public cloud databases using automation tools and techniques, such as encrypting data at rest and in transit, authenticating and authorizing users and applications, auditing database activities and compliance.
• Bachelor's degree in computer science, Computer Engineering, Information Systems, or related field, or 10 years equivalent work experience across database and software engineering roles.
• Excellent oral and written communication skills with the ability to communicate database concepts to a technical and non-technical audience.
• Exceptional Customer and End User Experience focus for database services and applications.
• Demonstrated ability to establish relationships and build rapport to influence colleagues at all levels, uncover database issues, and identify needs.
• Knowledge of disaster recovery best practices for databases, including planning and testing backup and restore procedures.
• Experience with continuous (blue/green) deployment and canary tests for database changes and migrations.
• Experience working in a hybrid on/offshore model for database development and administration.

Environment and/or Physical Factors

• Ability to travel to Arch Office 1-2 times in a year for Summits/Team Gatherings/Workshops