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.