Jan 2022 – May 2025 · 3 yrs 4 mos · Rawalpindi, Punjab, Pakistan

• Design, develop and maintain complex database systems, including data modeling, schema design, performance tuning, and security using Oracle and SQL Server.
• Develop and maintain database security policies, procedures, and controls to ensure data confidentiality, integrity, and availability.
• Optimize database performance by monitoring and analyzing system metrics, identifying bottlenecks, and implementing solutions to improve query response times and reduce resource usage.
• Create and manage database objects such as tables, views, indexes, and constraints.
• Collaborate with cross-functional teams to develop and implement ETL processes using Talend open studio.
• Develop and maintain procedures, triggers, and functions to automate database tasks , improve and to support business requirements.
• Create and manage database backup and recovery strategies to minimize data loss and downtime in case of system failures.
• Collaborate with other developers, business analysts, and stakeholders to understand and implement database requirements.
• Perform data migrations and ensure data integrity throughout the process.
• Analyze and troubleshoot database-related issues and provide timely solutions.
• Create and maintain technical documentation for databases and ETL processes.
• Create and manage database backup and recovery strategies to minimize data loss and downtime in case of system failures.
• Stay up-to-date with emerging database technologies and industry trends.

Sep 2019 – Jan 2022 · 2 yrs 4 mos · Rawalpindi, Punjab, Pakistan

• Create a secure production infrastructure with multiple resources across
• different platforms.
• Design, and scale infrastructure.
• Architect and build continuous deployment pipelines.
• Create tools to empower developers to manage production infrastructure.
• Upgraded development, UAT & Production environments from SQL Server
• 2008 & 2012 to SQL Server 2014 & 2016.
• Developed & implemented enterprise wise automated maintenance
• infrastructure.
• Automated DBA’s daily tasks like Index rebuild & reorganization, and weekly
• maintenance for statistics updates.
• Installation, configuration, up-gradation and migration of systems.
• Capacity planning for DB Servers, and recommendations for hardware
• upgrade, and change in architecture.
• Managing deployments on development, staging and production
• environments.
• Designed & implemented database backup & recovery SOP for all
• databases, i.e. Production and development.
• Configured and administered Database replication with Mirroring
• Disaster recovery of databases and SQL server

Sep 2019 – Dec 2021 · 2 yrs 3 mos · Rawalpindi, Punjab, Pakistan

Dec 2017 – Sep 2018 · 9 mos · Pakistan

• Design and develop custom web applications using PHP and related technologies.
• Write clean, well-documented, and efficient code that meets industry standards.
• Collaborate with cross-functional teams to understand project requirements and provide technical solutions.
• Test and troubleshoot web applications to ensure they are functioning properly.
• Maintain and update existing web applications as needed.
• Keep up-to-date with new trends and technologies in web development and apply them to current projects.
• Participate in code reviews and provide feedback to improve code quality.
• Optimize web applications for maximum speed and scalability.
• Ensure the security of web applications and implement best practices for data protection.
• Work with database technologies such as MySQL, MSSQL and ORACLE.
• Debug and resolve technical issues related to PHP applications.
• Provide technical guidance and support to other team members as needed.

Sep 2017 – Dec 2017 · 3 mos · islamabad

• i am working as an android developer internee at softappo pvt ltd located in islamabad.i have interest in learning new tools and technologies