Infrastructure

Sr. Database Administrator

Direct Placement

Brooksource

Apply Now

<< Return to Search Results

Sr. Database Administrator (DBA)

Overview:

Our client, an industry leading national foodservice distributor, is building a concept datastore in Google Cloud Platform (GCP) called the ICDS (integrated consumption data store). This is a place where systems will come for “cross schema” or “cross database” data. Traditionally, this might be thought of as an operational data store. Additionally, our client is in the process of implementing of SAP S/4 Hana, and several legacy data migrations are underway.

             Working together with software developers, data engineers, infrastructure peers, architects and service providers, the DBA maintains stable and secure platforms for data persistence and replication through IaC provisioning practices and monitoring solutions. The successful candidate will play a significant role in the growth and maintenance of pipelines feeding our data lake primarily from SAP HANA, Oracle, and SQL Server sources.

 

Responsibilities:

  • Develops and maintains infrastructure code to install, configure, upgrade and patch database software
    • Designs, implements, maintains and troubleshoots data replication pipelines
    • The physical product is targeted for the Google Cloud Platform and the initial physical components will be in Cloud SQL – likely PostgreSQL but possibly MySQL
    • Work with Development teams to analyze data and ensure consistency with Data Architecture Standards.
    • Leverage DevOps automation tools as we would seek to automate everything around the datastores. Our legacy environment uses Puppet today and the cloud side uses Terraform.
    • Build some services around these datastores so the candidates should also have Python development experience and possibly GCP PubSub (messaging queue).
    • Data structure design is also highly valued, so an understanding of relational and NoSQL data object design is necessary.
    • Replicate Data (using Qlik replicate) out of SAP S/4 Hana database, into the GCP-hosted Data Lake and on-premise Oracle Database/SQL Server.
    • Interface with various technical teams including core data application team and database/ data services teams, as well as third-party managed services consultants (utilized for ongoing support).
    • Although DevOps and cloud experience is important, must be comfortable supporting legacy databases and legacy applications.

Must Haves:

 

1.        5+ years’ experience working with Oracle Database and SQL Server.

·      Previous experience as an Oracle DBA, or similar DBA role is highly preferred.

·      Must have background extracting large amount of data, run complex queries, and move large amounts of data.

2.      Must have experience working in a DevOps environment and experience working with automation tools such as Puppet.

·      Strong Python Development/Scripting experience.

·      In this role, python will be used to build services around the datastore, and used for data provisioning.

3.      Strong experience working with Qlik Replicate (Data Replication tool)

·      Experience building and replicating tables and creating tasks is strongly preferred.

Nice to haves:

·      Experience working in a cloud environment and understanding the architectural concepts of migrating from on-prem servers to cloud.

·      Google Cloud (GCP) is strongly preferred, but AWS or Azure are also sufficient.

·      SAP S/4 Hana Experience

Strongly Preferred:

         Experience working in an Agile environment. Experience working in a SAFe Agile environment is a bonus

         Experience supporting legacy applications and databases in an enterprise environment.

         Experience working in a DevOps environment and experience working with automation tools such as Puppet.

         Experience working with Data Replication tools. DBA’s will work hands-on with these tools, but we need this Architect to understand the tools and processes.

o  Attunity is utilized in this role, but other tools such as Oracle Golden Gate, etc. are sufficient.

o  Experience building and replicating tables and creating tasks is strongly preferred

         Python Development/Scripting experience.

o  In this role, python will be used to build services around the datastore, and used for data provisioning

         Experience working with Terraform.

         Strong experience working with SQL Servers.

         Experience working in a Google Cloud Platform (GCP) environment.

         Previous experience as part of an SAP (S/4 Hana) implementation.

  •          Previous experience working in a Linux environment. 

About Brooksource:

At Brooksource, our business is people. Relationships are at the center of everything we do. A successful partnership is only as strong as the relationship built. For 18 years, Brooksource has established and maintained relationships with our clients, consultants and internal employees in an effort to create an unparalleled experience. We’re your trusted partner for delivering on technology initiatives through a variety of resourcing solutions. We provide technology solutions ranging from contingent labor to managed services, along with our niche consulting programs Elevate and Project Patriot which address workforce talent gaps. With 25 major hubs around the nation and growing, Brooksource is working to redefine what to expect from an IT Services provider.  

Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.

Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.

JO-2209-128627

Apply Now

Tagged as: Yes