Senior Data Architect and Data Engineer
Send a job offer directly to this candidate
Proven leader in Information Technology with 31+ years of experience in data architecture, data engineering, data migration, and database/application programming. Known for being self-motivated, a creative problem-solver, and a valued contributor. Skilled in mentoring and driving high-level projects to success.
Cloud & Database Technologies:
- AWS Cloud Services: Hands-on experience in leveraging AWS services for cloud architecture, including S3 for storage integration, AWS PrivateLink for secure communication, and infrastructure management using AWS CLI. AWS Certified Solution Architect – Associate.
- Snowflake: Expertise in Snowflake Cloud Database administration, RBAC (Role-Based Access Control), performance tuning, and seamless integration with various data sources like S3 and Kafka. Skilled in data modeling, data ingestion, and data transformation. Skilled in SnowSQL, SnowPipe, and Snowflake Task.
- Oracle RDBMS: Extensive experience in Oracle versions 10g, 11g, and 12c. Skilled in database design, PL/SQL development, partitioning, high availability solutions (RAC), and complex stored procedures. Skilled in SQL performance tuning.
- PostgreSQL & Presto: Solid understanding of relational databases and query performance optimization with hands-on experience in Presto and PostgreSQL for big data analytics.
Data Integration & ETL Tools:
- Informatica PowerCenter: 20+ years of experience as a PowerCenter Administrator, including installations, upgrades, and troubleshooting. Extensive hands-on experience with ETL design, development, and automation for complex data pipelines.
- IDMC/IICS (Informatica Intelligent Cloud Services): Managed the modernization of on-premise PowerCenter assets to the cloud-based IDMC platform, including agent configuration, task orchestration, and hybrid cloud integration.
- Data Quality & Governance: Skilled in ensuring data integrity and governance using tools such as Informatica Data Quality (IDQ) and Enterprise Data Catalog (EDC).
Data Modeling & Governance:
- Dimensional Data Warehousing (Kimball Methodology): Designed star-schema and snowflake schema models for enterprise data warehouses, ensuring optimal data organization for efficient reporting and analytics.
- Erwin Data Modeler: Extensive use of Erwin for relational database modeling, schema design, and logical/physical data modeling. Created detailed documentation and data dictionaries for enterprise data systems.
- Data Lakes & Operational Data Stores (ODS): Experience in architecting data lakes and ODS using Snowflake, S3, and Oracle for both structured and unstructured data sources.
Programming Languages & Automation:
- SQL & PL/SQL: 25+ years of experience with SQL and PL/SQL for data extraction, transformation, and performance tuning. Developed advanced stored procedures, triggers, and functions to handle complex data processing.
- Python: Proficiency in Python scripting for automation, data manipulation, and integration tasks, including JSON data processing and API integration.
- UNIX/Linux Shell Scripting: Expertise in creating and managing shell scripts (bash, ksh) for system administration, automation of batch jobs, and orchestration of data pipelines.
Automation & Workload Orchestration:
- IBM Tivoli Workload Scheduler (TWS/IWS): 25+ years of experience with TWS for automating, scheduling, and monitoring batch jobs. Expertise in IWS CLI, Dynamic Workload Console, and custom job orchestration for enterprise-level environments.
- Task Automation: Built numerous automated solutions for batch processing, including file ingestion, ETL workflows, and microservice data transactions using Kafka and Snowflake.
- SQL Performance Tuning: In-depth expertise in tuning complex SQL queries and database optimization using Oracle's wait-event-based tuning methodology and various performance diagnostic tools.
- Database Performance Optimization: Specialized in diagnosing and resolving bottlenecks in high-volume databases, enhancing query performance and ensuring seamless data operations.
- Data Warehousing & Business Intelligence: Experience in building large-scale data warehouses and BI solutions using tools like Informatica, Oracle, and Snowflake to support advanced reporting and analytics.
AWS Certified Solutions Architect - Associate
Python Institute Certified Associate Programmer
Bachelor of Science in Computer Information Systems from DeVry Institute of Technology, Columbus, Ohio, graduated Summa Cum Laude with 3.9 GPA
