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)
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.
3D 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. 3D 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 3D 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
© 2011-2018, 3D Technologies LLC. All Rights Reserved