Linked Oracle database tables into PostgreSQL database using Foreign data wrapper oracle_fdw Database migration from Oracle to PostgreSQL into AWS EC2 and GCP VM using AWS SCT, AWS DMS, Ora2Pg, orafce, ora_migrator, oracle_fdw, bash shell, Python scripts and Coding/ Converting Oracle shared procedures in PL/SQL to PostgreSQL PL/PgSQL Standby setup/configuration of PostgreSQL from In-house Redhat Linux server to AWS cloud and GCP VM. PostgreSQL database (version 9.2.18 till 12) creation/configuration/maintenance into local and AWS cloud storage following Maryland State and agency level policies, rules and security. Highest qualification as Master of Engineering from I.I.T. Worked for clients State of Wisconsin, State of Maryland, Cashedge (Fiserv), Redhat, GE Finance, GE Plastics, Omnitracs, Caterpillar, Retek, Motorola, P&O Nedlloyd, AON, British Home Stores, Standard Chartered Bank and ISBS (Indian Banks)ДЄuthorized to work in USA for any employer. Used other related services in GCP and AWS Oracle Golden Gate (Uni-Directional Oracle to Oracle) Presto Admin (Setup/Configuration, Query Optimization from multiple sources without ETL)Дata Warehouse/Server Admin of Netezza, MariaDB and MarkLogic Snowflake Setup/Configuration/Admin, Batch/Stream data Loading, Unloading into S3/Blob/CS, SnowSQL, SnowPipe, Matillion, snowflake-connector-python, Snowflake-SQLAlchemy, pandas. GCP BigQuery, GCP Dataflow, Cloud Pub/Sub, Data Lake (CS), Cloud Storage, VM, gcloud, gsutil, bq.ДЄWS Redshift, Redshift Spectrum, AWS Glue, Python, Data Lake (S3), VPC, EC2, EBS, EFS, Data Security. BigQuery/PostgreSQL, Oracle -> PostgreSQL/MariaDB, RedShift -> Snowflake) using AWS DMS, AWS SCT, SQL_Mode, SQLines, Ora2PG, Orafce, Ora_Migrator, PostgreSQL FDW of Oracle and BigQuery, Golden Gate, Bash/Python Scripts including Developing/Coding Shared Procedures/Function/ package Bodies from Source to Target Database in PostgreSQL PL/PgSQL, BigQuery UDF.

17+ years of IT experience in Backend Data Architect/DBA, Data Engineer GCP and AWSД¬ertified Snowflake Cloud Analytics ArchitectД¬ertified PostgreSQL Database Administrator

Mariadb json query