Westlake, Texas16 days ago
DE developing PL/SQL stored procedures, functions, and packages to encapsulate reusable database logic across multiple applications, and analyzing and optimizing SQL queries, using Explain Plan, AWR reports, SQL Developer, and TOAD in both development and production environments; performing data vault modeling to support historical data tracking and flexible reporting structures, migrate data sources into Snowflake, enable self-service analytics, and reduce report generation times, using Snowflake; and designing Snowpipe processes for continuous data ingestion from external stages using AWS and SQL. DE developing solutions and re-platforming legacy applications to Cloud-based architectures on AWS, to enhance cost efficiency, scalability, and security across development and production environments, using AWS services including Lambda, API Gateway, Amazon S3, Amazon RDS, and CloudFormation to modernize application workflows; and performing DevOps engineering, building CI/CD/Continuous Testing (CT) pipelines to automate application build, packaging, deployment, and testing processes, using Jenkins, UDeploy, and version control systems (Git).