Database Automation Engineer - Raleigh, United States - Arch Capital Group

Arch Capital Group Raleigh, United States

2 weeks ago

Full time

Description

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.

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

Raleigh-US, Hybrid, Twice-a-week in office

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

Automation Engineer

1 week ago

Search Masters, Inc. Raleigh, United States

Responsible for handling commissioning, start-up and programming of automated systems in-house · Will troubleshoot electrical, PLC and other industrial automation in a manufacturing environment · Will design, install, program and commission small to medium size automation control ...
Automation Engineer

3 weeks ago

LHH Raleigh, United States

A rapidly growing leader in the specialty materials manufacturing space is looking to add a strong Automation and Process Controls Engineer to lead their on-site engineering team in Durham · This an incredibly opportunity for an adaptable, hands-on electrical engineer who is loo ...
Automation Engineer

1 week ago

Veeva Systems Raleigh, United States

Veeva Systems is a mission-driven organization and pioneer in industry cloud, helping life sciences companies bring therapies to patients faster. As one of the fastest-growing SaaS companies in history, we surpassed $2B in revenue in our last fiscal year with extensive growth pot ...
Automation Engineer

4 weeks ago

Automationtechies Raleigh, United States

Job Description · Job DescriptionGreat opportunity to work on exciting automation projects with a company that pays bonus and overtime You will be designing, programming, and servicing automated controls systems for a variety of industrial clients. Mostly local travel · Responsib ...
Senior Automation engineer

1 week ago

V-Soft Consulting Raleigh, United States Contract

Senior Automation Engineer · Primary Location: Raleigh, North Carolina · V-Soft Consulting is currently hiring for a Senior Automation Engineer for our premier client in Raleigh, North Carolina. · Knowledge and Skills»hands-on Automation support to the release and Application de ...
Automation Engineer

1 day ago

Cynet Systems Raleigh, United States

Job Description: minimum of 5 years of experience in information systems application development with a demonstrated concentration of experience in Software Quality Assurance methods, techniques, and tools. · Hands-on experience with UFT for Functional test automation, framework ...
Automation Engineer

1 week ago

Search Masters, Inc Raleigh, United States

Job Description · Job DescriptionCompany Description · $100 million dollar company · Long tenured employees · World leader in its industry · Job Description · Responsible for handling commissioning, start-up and programming of automated systems in-house · Will troubleshoot electr ...
Cypress Automation Engineer

3 weeks ago

Vlink Raleigh, United States

Job Title:Cypress Automation Engineer · Location:Raleigh, North Carolina, United States · Duration:Long Term · About VLink: · Started in 2006 and headquartered in Connecticut, VLink is one of the fastest growing digital technology services and consulting companies. Since its in ...
Automation Design Engineer

2 weeks ago

TRS Staffing Raleigh, United States

Title: Electrical Design Engineer (Automation) · Location: Raleigh, NC or Greenville, SC · Status of hire: Full time, direct hire · Pay: $90k - $150k · *Relocation Assistance Offered* · Responsibilities: · Develop and review specifications, including design criteria · Participate ...
Process Automation Engineer

12 hours ago

Wood plc Raleigh, United States

Job Description · Wood is currently recruiting for a mid-level Automation Technical Professional Life Sciences - Mid Level with a strong background in Distributed Control Systems (DCS) to be based in Greenville, SC or Research Triangle Park NC area. · Wood Systems Integration, ...
Sr. Automation Engineer

4 weeks ago

Automationtechies Raleigh, United States

Job Description · Job DescriptionEnjoy the flexibility of this hybrid Senior Automation Engineer position You will be designing, programming, and servicing automated controls systems for a variety of industrial clients in the Raleigh, NC area. · *** For this position you would n ...
Windows Automation Engineer

3 weeks ago

TEKsystems Raleigh, United States

Top Skills' Details · 1 = Bachelor's degree and a minimum 10 years of experience. Additional experience may be substituted for degree. · 2 = SME-level accountability for a specific technology and backup/secondary responsibility for another technology. · 3 = Experience supporting ...
Windows Automation Engineer

3 weeks ago

NetSource, Inc. Raleigh, United States

ONLY LOCAL CANDIDATES TO RALEIGH, NC SEND YOUR RESUME. ALL OTHER RESUMES WILL BE REJECTED. · Please note that this is a 4 month contract position. · This position is an on-site position located in Raleigh, NC. Resources may be allowed remote hybrid work but must be willing to re ...
Senior Automation engineer

12 hours ago

V-Soft Consulting Group Raleigh, United States

Senior Automation Engineer · Primary Location: Raleigh, North Carolina · V-Soft Consulting is currently hiring for a Senior Automation Engineer for our premier client in Raleigh, North Carolina. · Knowledge and Skills" hands-on Automation support to the release and Applicatio ...
Senior Control and Automation Engineer

2 weeks ago

Burnham RNG Raleigh, United States

Senior Control and Automation Engineer – Burnham RNG · Burnham RNG () is a wastewater and agricultural waste-to-renewable natural gas (RNG) provider that helps communities profitably reduce treatment & disposal costs, improve environmental outcomes and re-use energy, water, and n ...
Senior Automation engineer

2 weeks ago

Serigor Inc Raleigh, United States

Job Title: · Senior Automation engineer (HYBRID) · Location: · Durham NC · Duration: · 12+ Months · Job Description: · The client requires the assistance of a Senior Automation engineer to help automate and improve the build, deploy and operation of client Applications. · ...
Automation Engineer Control

23 hours ago

Siemens Energy Raleigh, United States

About the Role · Location · United States of America · North Carolina · Raleigh · Company · Siemens Energy, Inc. · Organization · Grid Technologies · Business Unit · Grid Solutions · Full / Part time · Full-time · Experience Level · Mid-level Professional · A Snaps ...
Windows Automation Engineer

4 weeks ago

Logistics Integration Solutions (LIS) Raleigh, United States

LIS is a leading Technology Company specializing in IT Consulting, Staffing and Enterprise Solutions. We offer a flexible and friendly work environment that enables career growth and opportunities. · Our organization is looking for an experienced Windows Automation Engineer for a ...
Senior Automation Engineer

2 weeks ago

Rose International Raleigh, United States

Date Posted: 04/26/2024 · Hiring Organization: Rose International · Position Number: · Job Title: Senior Automation engineer · Job Location: Raleigh, NC, USA, 27699 · Work Model: Hybrid · Employment Type: Temporary · Estimated Duration (In months): 13 · Min Hourly ...
Senior Automation Engineer

2 weeks ago

Cynet Systems Raleigh, United States

Job Description: The primary role is to lead the Automation effort of infrastructure provisioning, build, and deploy activities for the client. · This position must demonstrate a solid understanding of AWS infrastructure and software release life cycle. · This position will be ...