DevOps with DB Engineer

The Opportunity: 

If you love to design scalable fault-tolerant systems that can run efficiently with high performance and are eager to learn new technologies and develop new skills, then we have a great opportunity to join our customer organization. As a DevOps Engineer IV, you will design, develop & maintain E2E automated provisioning & deployment systems for our customer Logistics solutions. You will also partner with your DevOps engineering team to ensure these automation pipelines are integrated into our standard Organisation CI/CD system. You will also partner with the Solution Automation team collaborating to bring test automation to the deployment automation pipeline. With the variety of environments, platforms, technologies & languages, you must be comfortable working in both Windows & Linux environments, including PowerShell scripting & bash, database administration as well as bare metal virtualization technologies and public cloud environments (GCP, AWS, Azure).

Key Responsibilities:

As DBE Responsibilities 

• Emphasize the database design and development that reduces the complexity in deployment and maintenance. 

• Architect and automate the database continuous integration using SSDT and other automation tools. • Ensure the database architecture doesn’t have any security leaks exposed during deployments • Manage database install, configure, monitor and upgrade towards production and non-production environments. 

• Provide technical guidance for high availability, replication, encryption and disaster recovery solutions. 

• Implement technical support for enterprise monitoring, backup, alerting and security compliance for SQL instances. 

• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues. 

As DevOps Responsibilities 

• Promote and evangelize Infrastructure-as-code (IaC) design thinking everyday 

• Serve as a SME for configuration management tools such as Ansible or Chef 

• Maintain comprehensive understanding of our key cloud components including our Kubernetes clusters & topologies, their service mesh, API gateway, high perf cache, high perf messaging, data services, etc. 

• Maximize selection of portable provisioning and automation tools & frameworks (e.g. Terraform, Packer) 

• Develop/administer source code management policies and build definitions for all supported products and maintain relationships with the associated development teams to pursue continuous improvements for both 

• Design & implement a container first platform maximizing the CI automation to free up developer time 

• Design for minimizing or eliminating product software engineer time spent on implementing cross-cutting concerns such as security, fault tolerance, service scalability and service monitoring 

• Design for portability and containerization, supporting deployment to bare-metal Organisations data center virtualization platforms (Hyper-V) as well as public clouds: Azure, GCP, AWS 

• Bring DevOps technical expertise to a Scrum team of engineers building & supporting our multi-stage, CI/CD hybrid cloud platform 

• Take part in the implementation of a full dev-to-deploy CI/CD, including full commit stage static analysis, security analysis, unit test coverage, automated deployment, post-deploy functional automation testing (BDDbased), performance testing and the automated gate criteria which pushes releases through the pipeline all the way to production staging 

• Partner with the OrganisationTech Services team, collaboratively building our high maturity CI/CD pipeline & container hybrid cloud as we slowly evolve to bringing in the SRE role to operations 

• Serve as an administrator for DevOps-managed tools such as Jenkins, Jira, Confluence and Bitbucket, providing user support as needed and working to reduce future support tasks via improved automation and training 

• Continuously increase knowledge of our systems and solution stacks through active study, research & experimentation, and contribute to team knowledgebase through discussion and documentation

Key Requirements/Experience:

DBE Qualification

• Working experience with one or more flavors of SQL RDBMS administration and scripting DDL and DML

• 5 years of experience into T-SQL, database deployment and database security with MSSQL

• Strong PowerShell scripting knowledge in automating SQL Server related tasks.

• Experience with architectural implementation for High availability and Disaster Recovery requirements for

database instances.

• Experience with developing enterprise solutions to support backup, monitoring, alerting and patching of MSSQL

deployments.

DevOps Qualification

• 10 years’ experience in SysOps, DevOps or equivalent role

• 2 years leading DevOps initiatives

• Familiar with some cross-platform provisioning technologies and IaC tools: Rancher, Terraform, Ansible or

SaltStack and Hyper-V PowerShell Cmdlets

• Experienced with a provisioning config management & provisioning tools such as Chef, Puppet, Ansible & Salt

• Experienced in the setup, configuration, care and support of portable cloud technologies such as API gateways,

Cassandra, Spark, Kafka, Redis, Microsoft SQL Server

• Familiar with containerization (Docker), cloud orchestration (Kubernetes or Swarm), Istio & Helm Charts

• Working experience in Windows and Linux systems, CLI and scripting

• Familiar with build automation in Windows and Linux and familiar with the various build tools (MSBuild, Make),

package managers (NuGet, NPM, Maven) and artifact repositories (Artifactory, Nexus)

• Programming experience with one or more of C#, Go, Python, C , Ruby, shell scripts

• Experience with direct customer contact (tech support, customer service, etc.)

• Highly motivated self-starter with a desire to help others and take action

• Strong written and verbal communication & can translate technical concepts into non-technical terms

• Ability to independently work as a contributing member in a high-paced and focused team

• Ability to multi-task and prioritize tasks with competing deadlines

• Strong problem-solving and analytical skills with the ability to work under pressure

• Ability to socialize ideas and influence decisions without direct authority

• Considers ‘best-practice’ standards, as well as departmental policies and procedures

• Retail and wholesale petroleum industry knowledge & experience preferred