| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Hamzi Intezar
Address: Jersey City, New Jersey, Street Address , USA Phone: PHONE NUMBER AVAILABLE
Email: EMAIL AVAILABLE
Summary
As a seasoned database architect with over 10 years of experience, I specialize in advanced SQL, database
design, and administration, creating scalable and resilient solutions for diverse business needs. My
expertise extends to cloud database services like AWS RDS and Azure SQL, where I have successfully
implemented robust architectures that improve performance and reliability. I excel in developing efficient
ETL processes and data warehousing systems, leveraging BI tools like Power BI and Tableau to transform
complex datasets into actionable insights. With a strong foundation in NoSQL technologies and modern
infrastructure management using Docker and Kubernetes, I integrate DevOps practices to streamline
database operations. My commitment to continuous learning ensures I stay at the forefront of trends like
big data and real-time processing, consistently delivering value through innovative solutions.
Skills
SQL, PL/SQL, T-SQL: Proficient in writing and optimizing complex SQL queries, stored procedures, and
functions to manage and manipulate data effectively.
Database Design & Architectural Planning: Expertise in designing scalable and efficient database
architectures that align with business requirements and ensure data integrity.
Data Modeling & Schema Design: Skilled in creating conceptual, logical, and physical data models,
ensuring well-structured and normalized database schemas.
Performance Tuning & Query Optimization: Adept at identifying performance bottlenecks,
optimizing queries, and implementing indexing strategies for improved database efficiency.
ETL Development & Data Integration: Experienced in developing ETL processes to extract, transform,
and load data from various sources, ensuring seamless data integration.
Database Administration & Security: Proficient in database management, user access control, and
implementing security measures to protect sensitive data.
Cloud Database Services: Experienced in deploying, managing, and optimizing cloud-based databases
on platforms like AWS RDS, Azure SQL Database, and Google Cloud SQL.
Data Warehousing & Business Intelligence: Expertise in designing data warehouses and developing
BI solutions for comprehensive data analysis and reporting.
Big Data Technologies: Skilled in using Hadoop and Spark to process and analyze large datasets,
enabling data-driven decision-making.
Real-Time Data Processing: Knowledgeable in real-time data processing technologies such as
Apache Kafka and Apache Storm.
Version Control Systems: Experienced in using Git and SVN for version control and collaborative
development.
Work Experience
Arbisoft | Senior Data Solutions Architect
01/11/2020 Present
Configured and managed cloud database instances across AWS RDS, Azure SQL Database, and
Google CloudSQL, optimizing performance, security, and scalability for enterprise-level
applications.
Automated cloud database operations using infrastructure as code tools like AWS
CloudFormation and Azure Resource Manager, boosting operational efficiency and reducing
manual intervention by 30%.
Engineered real-time data processing solutions integrating Kafka with Spark Streaming, enabling
immediate insights and actions on streaming data.
Architected and deployed data warehousing environments in Redshift and Snowflake, leveraging
MPP architecture to accelerate complex queries on petabyte-scale datasets.
Optimized data warehousing solutions, reducing storage costs by 20% and improving query
performance through data lifecycle policies and materialized views.
Designed and developed BI solutions with Power BI and Tableau, creating interactive dashboards
that provide real-time business insights and support data-driven decision-making.
Integrated machine learning models within BI platforms, enhancing dashboards with predictive
analytics capabilities.
Leveraged Entity Framework and Hibernate ORM to streamline database interactions, improving
application maintainability and aligning with object-oriented principles.
Tuned NoSQL databases in MongoDB and Cassandra for high-throughput applications,
implementing sharing and replication for optimal performance and scalability.
Developed data governance frameworks, ensuring data integrity, accuracy, and regulatory
compliance across all database and data warehousing solutions.
Systems Limited | ETL Specialist & Data Warehouse Engineer
03/18/2016 06/29/2019
Designed and optimized intricate ETL pipelines using SSIS and Informatica, integrating data from
SQL databases, NoSQL stores, and cloud repositories, ensuring consistent and accessible data
across the organization.
Implemented advanced data transformation logic to clean, normalize, and enrich datasets,
enhancing the accuracy and reliability of data analytics.
Configured ETL processes for parallel execution and batch processing, reducing data latency by
40% and improving throughput for time-sensitive analytics.
Structured data in star and snowflake schemas to enhance query performance, supporting
complex analytical queries in BI tools.
Utilized dimensional modeling to represent business processes, enabling intuitive data access and
analysis for end-users.
Deployed scalable data warehouse solutions with high availability and disaster
recovery capabilities, using replication and backup strategies.
Integrated NoSQL databases like MongoDB and Cassandra for high-throughput and flexible
data schemas, supporting real-time analytics and large-scale web applications.
Conducted performance tuning of NoSQL databases, optimizing indexes and query patterns to
meet the demands of high-velocity data workloads.
Collaborated with data scientists and analysts to build a robust data infrastructure that
supports advanced analytics, machine learning models, and data visualization projects.
Automated data warehouse and ETL pipeline deployments using CI/CD practices,
improving reliability and accelerating data delivery to business units.
Agile Tech Solutions | Database developer
02/19/2013 07/18/2016
Engineered and optimized database schemas for complex business applications, ensuring data
consistency and reducing redundancy.
Crafted and tuned SQL queries to enhance performance on large datasets, improving
efficiency for both transactional processing and analytical reporting.
Implemented stored procedures and functions to streamline business logic, reducing
application- layer complexity and boosting data processing efficiency.
Established robust security protocols, including encryption and role-based access control,
to protect data from unauthorized access.
Automated routine database maintenance tasks using PowerShell and Bash,
improving operational efficiency and minimizing downtime.
EDUCATION
Bachelor of Science: Computer Science
University: Virtual University
|
