Saad Ahmed Pasha
SAMI Pharmaceuticals Pvt Ltd
Karachi,Sindh
18
years of professional experience
1
Certification
Experienced Database Architect with expertise in database design, management, and optimisation across Oracle, Microsoft SQL Server, MySQL, and PostgreSQL. Led implementation of high availability solutions and performance tuning in cloud environments like Amazon RDS and Azure SQL. Utilises industry best practices for security, backup, and recovery, ensuring data integrity and system reliability.
Work history
- Fully responsible for Oracle Database & SQL Server installations, configuration, maintenance, cloning, patching, backups, migrations and performance tuning.
- Responsible for installations, upgrading, migrations, cloning, patching, code movements, shell scripting, backup & recovery, hot (RMAN) / cold (OS) backup configurations, scheduling, proactive health check, OS configuration for Oracle products etc.
- Key interface between TCS and Oracle Corporation, IBM Pakistan for technical support, patch management, hardware configuration, troubleshooting and version control.
Manager DBA
6 Years 5 Months- Developed long-term database strategies aligned with business goals, leading a team of database administrators, and managing departmental budgets.
- Oversaw the design and implementation of scalable, efficient, and secure database architectures.
- Implemented performance tuning strategies, conducted capacity planning, and used advanced monitoring tools to ensure optimal database performance.
- Developed and enforced database security policies
- Created and maintained comprehensive backup and disaster recovery plans, managing data recovery processes to minimize downtime.
- Implemented high availability solutions and managed database replication to ensure data reliability and uptime.
- Developed automation strategies and utilized scripting languages like Python and PowerShell to streamline database operations.
- Managed ETL processes and data warehousing projects, selecting appropriate tools for efficient data integration.
- Set up comprehensive monitoring systems and conducted regular health checks and performance audits.
- Led the resolution of complex database issues, conducted root cause analysis, and utilized diagnostic tools effectively.
- Managed database-related projects from planning to execution, ensuring timely delivery and risk management.
- Maintained effective communication with stakeholders, ensured comprehensive technical documentation, and developed training programs for staff.
- Stayed current with emerging database technologies and trends, promoted innovation, and engaged with professional communities.
- Key Responsibilities
Senior Database Administrator
6 Months- Current environment is ORACLE 10g/11g/12c versions, running on HP server, Including Habib Oil Mill (HOM), MCR (Pizza hut and Burger King), SATCOMM and Habib Masala Databases with offsite Standby DBs'.
- Application tools are APEX, Oracle ORDS, ORACLE Application Server, tableau Server, and Oracle BI.
- Responsible to maintain and configure every DB with optimum performance.
- Designed and developed DR plan and implementation of Oracle Data guard to ensure smooth failover under catastrophic conditions.
- Designed and implemented DB access level / security.
- Installed, configured, upgraded to latest patch set level software and met all services levels agreements of availability and performance.
- Installed, configured Enterprise Manager Grid Control 11g R2, installed and configured agent on Linux, Windows Servers, and Oracle applications tiers for monitoring, alerting and recording vital performance metrics.
- Created and established heterogeneous DB Link configuration to replicate and manipulate data to different databases.
- Making and implementing Backup strategy and procedures.
- Perform Database normalization according to RDBMS techniques.
- Performed activities includes programming of procedures, triggers, and rules, as well as creation of table spaces, data files, tables, views, privileges, roles, and indexes etc.
- Key Responsibilities
Senior Database Administrator
6 Years 4 Months- Administration and Implementation of Mirroring and Log Shipping of Production Databases to Resilient Servers and DR Site.
- Proactive analysis of databases for index fragmentation / missing indexes statistics and planning / reorganizing / rebuilding indexes for performance improvement of OLTP Databases.
- Database performance analysis using Profiler and Database Tuning Advisor and third party tools.
- Database archiving strategy planning / implementation process, script and automation for PCI complaint databases, both Oracle 10g/11g SQL Server 200x and MYSQL Databases.
- DR Planning, implementation and periodic testing / administration, backups / restore automated maintenance plans / procedure of databases implemented on Oracle.
- Maintaining Audit Logs of encrypted databases for both successful / failed access events.
- Implementation and administration of Business Information Reporting Data Warehouse, used for MIS reporting (between Oracle and SQL Server platforms using SSIS Packages), development and implementation of code changes.
- Business Information Reporting databases regular updates from Production Server using SSIS packages and Replication, between SQL Server and Oracle.
- Databases upgrade / migration from SQL Server 7/2000 to Microsoft SQL Server 2005 / 2008 /2012 R2 and then Oracle 10g configuring system as per new RDBMS environment.
- Support Applications / Development and QA teams with database related issues and build release.
- Tuning of Bulk Load processes to improve the performance.
- Provided 24x7 Oracle DBA& SQL Server support to three technical and functional teams comprising 45+ developers / consultants and managing 250+ database server around the Globe
- Key Responsibilities
Assistant Database Administrator
1 Year 5 Months- Backup Monitoring and testing of production & testing environment.
- Health checking of all the databases in company.
- Working on Data guard.
- Merging of Databases of Company Area Office in Head Office.
- Working on Application Server 10g Bug.
- Performance Tuning of SQL Queries.
- Performance Monitoring of All Databases.
- Monitoring of RMAN Backup.
- Migration of Fox Pro Database to Oracle 10g.
- Working on Red Hat Linux.
- Working on Application Server 10g Configuration & Installation.
- Key Responsibilities
Trainee Database Administrator
6 MonthsCustomer Support Executive
1 YearSkills
Database Management Systems (DBMS)
Oracle database tools
Microsoft SQL tools
Database Design and Architecture
Database installation
Performance tuning
Backup and Recovery
High availability
Oracle RMAN (Recovery Manager)
Oracle Data Guard
SQL Server Management Studio (SSMS) for backups
Database monitoring tools
Monitoring and Maintenance
Security Management
Problem resolution
Cloud databases
Open-source databases
IBM: DB2
Veeam Backup & Replication
ManageEngine Applications Manager
Windows server management
Linux server management
Strategic Planning and Leadership
Project Management
Industry trends
Windows server management
Linux server management
Education
Bachelor of Science - Computer Science
Certification
Oracle 11g: Introduction to SQL (1Z0-051), Oracle 11g: Administration I & II (1Z0-052 & 1Z0-053), RISE With SAP S/4HANA Cloud
Timeline
Manager DBA
SAMI Pharmaceuticals Pvt Ltd
2020.04 - 2026.09Read More
Senior Database Administrator
Habib Oil Mills
2019.09 - 2020.03Read More
Senior Database Administrator
TCS Private Limited
2013.05 - 2019.09Read More
Assistant Database Administrator
Lucky Cement Limited
2011.12 - 2013.05Read More
Trainee Database Administrator
TechAccess
2011.06 - 2011.12Read More
Customer Support Executive
TRG
2009.01 - 2010.01Read More
Usman Institute of Technology
Bachelor of Science from Computer Science
Read More