Daily hands-on AWS Cloud interaction with technologies including EC2, Redshift, MSK (Kafka), Aurora Postgres & RDS, S3, ECS and ECR, IAM, Athena, Spectrum, Lambda, SNS and SQS. Python application development supporting integrations and deployments using Apache Airflow and Matillion for Redshift. Java application development leveraging Kafka Streams API to support real-time stream processing. Kafka (Apache and Confluent) including Zookeeper, Broker, Schema Registry, Kafka Connect. Work with other technologies including Docker, ELK stack, Grafana and Prometheus, storage formats including Avro, Parquet, JSON, and XML.

‣ Actively engaged and collaborated with business stakeholders and technical leadership to identify, standardize, and operationalize common data entities to support enterprise data initiatives.‣ Modeled flexible data warehouse architectures leveraging Kimball methodologies.‣ Spearheaded project to upgrade enterprise data warehouse from an Oracle 10g to Oracle 11gR2 version.

‣ Created and administered several database platforms including Oracle 10g and 11g, MySQL, and Microsoft SQL Server to support both enterprise and engineering applications.‣ Regularly worked with Oracle Exadata and Database Appliance, BI platforms such as OBIEE and Cognos, F5 and MySQL replication as necessary.

‣ Lead Oracle DBA tasked with adopting and implementing Oracle Real Appilcation Cluster (RAC) on an 11gR2 platform resulting in an annual cost savings of $20,000.‣ Developed ETLs leveraging Microsoft SQL Server Integration Services to surface customer service level agreement metrics.

Primary focus on the development, implementation, and mainteance on ETL repository of solutions for enterprise corporate reporting needs utilizing Microsoft SQL Server Integration Services (SSIS) and SQL Server Management Studio (SSMS). Repository includes solutions for staging, type 1 & 2 slowly changing dimensions, fact loads, lookup caching, and index management.Administered and maintained 3 data warehouse database environments (Development, Certification, Production) on a SQL Server 2008 platform. Duties included deploying solutions for maintaining database statistics, reducing table and index fragmentation, and methods for reducing storage footprint.Actively collaborated with enterprise application teams to understand and ensure on-time delivery of customer master, product master, and employee headcount data for executive reporting.Monitored nightly warehouse production jobs to identify and resolve potential bottlenecks and improve performance.