Salman Butt

Senior Database Engineer

iENGINEERING • Tiempo completo

May 2022 - Present • 4 yrs 4 mos

Led full-stack database development and optimization for high-volume, enterprise applications using Oracle (up to 21c), PostgreSQL, and MS SQL Server. Maintained expert-level proficiency in PL/SQL, SQL Loader, and advanced SQL. Architected and governed complex OLTP and Data Warehouse data models across multi-platform environments (Oracle, PostgreSQL, MS SQL Server), reducing reporting query times by 30% through optimized schema design. Drove critical database performance improvements by implementing advanced optimization techniques including Table Partitioning, Index tuning, Query Re-Write, and leveraging Analytical Functions and Materialized Views to manage terabytes of data. Established and enforced data modeling standards (3NF, Dimensional) and best practices for new database projects, ensuring data integrity, scalability, and long-term maintainability. Developed, tested, and peer-reviewed complex PL/SQL packages, stored procedures, and functions to manage core business logic, improving transaction throughput by over 15%. Engineered low-latency data replication solutions using Materialized Views and change data capture (CDC) mechanisms to support distributed environments and offload reporting from production systems. Applied advanced Dynamic SQL and Oracle supplied packages (e.g., DBMS_JOB for scheduling, UTL_FILE for ETL) to build robust, secure, and scalable data ingestion and batch processing solutions. Led end-to-end data migration from on-prem Oracle to Amazon RDS for PostgreSQL using AWS Schema Conversion Tool (SCT) and AWS DMS, enabling minimal downtime and continuous transactional replication. Collaborated with cross-functional teams and mentored junior developers in database best practices, performance tuning, and query optimization to ensure consistent code quality across projects. Oversaw and standardized comprehensive database documentation, and data dictionaries using tools like Dataedo.