James Bennett Email & Phone Number

Austin, Tx, Us

* Design and implement scalable data pipelines using AWS services such as Glue, Redshift, S3, Lambda, Athena* Wrote Python and PySpark script, and advanced SQL script for ETL* Designed interactive and dynamic dashboards using Tableau, and Power BI tovisualize complex data sets and KPIs effectively* Extensively used DBT for data transformation, migrated our legacy datatransformation process from Core Python to DBT env.* Integrated machine learning models into data processing pipelines to enhanceanalytics and predictive capabilities.* Utilized Python libraries like Boto3, Pandas while working with S3,EC2, Lambda,Glue, RDS

Taylor, Tx, Us

* Optimized SQL queries, cutting execution time by up to 50% during the upgrade.* Managed Linux Cluster environment and wrote shell scripts to automate the database refresh process * Dev/Test Database refresh, automation of refresh process writing shell script

* Used Airflow to build and orchestrate data pipelines * Introduced DBT to our ETL system to transform the data and built the DBT modules* Developed and maintained data pipelines ingesting data from various sourceslike S3 buckets, third-party Rest APIs, SQL, and Salesforce data.* Developed Rest APIs and deployed into Kubernetes* Managed and Maintained Snowflake and Postgres Databases* Dockered Python, DBT, APIs and deployed them to Docker host and Kubernetes

* Used AWS Lambda, Dynamodb, Snowflake, RDS, S3, Pandas, Python* Built DevOps pipeline on AWS using Github, Jenkins, Ansible, Docker, Kubernetes* Designed and implemented data models for data warehouse and data marts* Developed and maintained ETL/ELT data pipelines on AWS

* Support and maintenance of 200+ Oracle databases of different environments e.g. production, test, development, data guard* Implementing the migration of Databases from Linux to Unix, and Unix to Linux* Converting a single instance database to Oracle 11g RAC and migrating database from NON-ASM to ASM* Cloned/Refreshed/Restored Oracle Databases for development and testing* Creating scripts for the automation of repetitive processes and scheduled these on the HP Server automation such as adding auto datafile, kill session, compilation ...* Utilizing the Real Application Testing (RAT) before critical database change (migrate, upgrade, major patch and deployment) * Installed, configured, implemented Oracle Enterprise Manager (OEM) 12c for all production and test environments to monitor * Created a lot of Linux/Unix shell and PL/SQL scripts for Proactive monitoring of Oracle Databases in order to eliminate downtime * Deep understanding of Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.* Maintaining Exadata including health check, patching, disk replacement, upgrades* Installed and configured integrated/classic GoldenGate for data replication* Resolved all sorts of GoldenGate abend/latency issues* Planned and completed disaster recovery and Switch Over testing for databases* Installed, configured, implemented PostgreSQL / SQL Server / Cassandra database* Setup PostgreSQL for High Availability and Replication with Hot Standby* Involved in taking backups using Oracle RMAN and VERITAS Net backup * Planned and implemented a backup strategy of both Oracle and PostgreSQL* Implemented alert monitoring for CPU usage, disk space, contention, high events, top SQL, GoldenGate abend, GoldenGate lag, I/O contention, memory usage

* Wrote Advanced queries, PL/SQL packages, functions, triggers, SQL scripts, views* Developed ETL scripts to load data from multiple sources into the Data Warehouseand analyzed, cleaned, transformed, and loaded data using ODI* Used Erwin for Logical and Physical database modeling of the warehouse

* Created internal tools using Python, SQL* Used the Python to extract data from CSV, JSON, EXCEL* Analyzed, designed, and developed client applications using Oracle Forms and Report

Istanbul, Tr

* Created internal tools using Python, SQL* Used the Python to extract data from CSV, JSON, EXCEL* Analyzed, designed, and developed client applications using Oracle Forms and Report