W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J38001

  • Specialized Area:

    SQLBI

  • Job Title:

    sql dba

  • Location:

    San Ramon,CA

  • Duration:

    13 Months

  • Domain Exposure:

    IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Hands on experience in postgres SQL and performance tuning

Hands on experience in Greenplum administration.

Design Database Architecture, Data Modeling, Data Structures for Greenplum database in On-premise and on AWS cloud.

Design the overall Virtual Private Cloud VPC environment including server instance, storage instances, subnets, availability zones, etc.,

Design the AWS network architecture including VPN connectivity between regions and subnets.

Support the AWS Business development team to help formulate a strategy to help the adoption of AWS within the focus industry verticals.

Guide customers to ensure success in building and migrating applications, software and services following the principles of the AWS Well-Architected Framework.

Capture and share best-practice knowledge among the AWS solutions architecture community.

End-to-end architecture of a Delivery, including its assembly and integration into the IT architecture principles defined with the client.

Involve in semantic data model design & implementation.

Design and develop S3 Backup and file movement scripts across Buckets.

Involve in S2TM mapping specification documents for each source system.

Design and Develop UDF for complex scenarios

Perform Database Backup/Restore, and DR Planning, Change Management and Monitoring Utilities.

Migrate applications such as Greenplum, HVR, Talend, Horton Works from On-premise to business owned AWS VPC

Configure CloudTrail for AWS services and CloudWatch alarms to enable alerting of AWS Ec2, RDS, EBS and Snapshots

Design and implement AWS RDS Postgres for customers with replication and Multi AZ architecture.

Manages and maintains all production and non-production databases and Greenplum admin.


Apply Now
Equal Opportunity Employer

AUTOMATION TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. AUTOMATION TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will AUTOMATION TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract