Umar Iftikhar Email & Phone Number

Lahore, PK

• MySQL 5.7, 8.0 installation, configuration, performance tuning, backup recovery
• Plan and implement the server migrations and upgrade versions editions focusing the business continuity.
• Data Migration and Database Administration including performance and ensure uptime of services for access to end users
• Design and proposing the server health checks to include the major critical operations on daily basis.
• 24/7 core production support and critical operations monitoring

Lahore, Pakistan

• Installation, configuration, upgrading and administration/maintenance of Oracle DBA and related products. Additionally setting up test, development, and production environment.
• Managing user service accounts, proxy accounts, mail operators, users, roles management using various security matrix
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access etc.
• Designing, establish and maintain sound backup and recovery policies and procedures. Automating SQL… Show more
• Designing, establish and maintain sound backup and recovery policies and procedures. Automating SQL agent jobs maintenance plans and using alerts to carryout checks on databases.
• Managing space issues for datafiles, log files etc. periodic purging of log files if necessary.

Faisalabad, Pakistan

• Installation, upgrade, maintenance and administration of Database 10g, 11g and AIX & Linux.
• UNIX shell scripting and Monitoring AIX environment.
• Aix Monitoring, performance, tuning and resource maintains.
• Oracle database & data guard Configuration, backup, restore and EBS Cloning.
• Research, design, build, test, implement, maintain, and support a multiple environment.
• Install rpm and packages

• Installation, upgrade, maintenance and administration of Database 10g & Linux and Solaris
• Installation, Implement, Configuration Sql Server, Oracle Data guard, Grid Control and Application Server 10gR2, Oracle Patching.
• Research, design, build, test, implement, maintain, and support a multiple environment.
• Multimaster Replication streams.
• Perform daily maintenance routines and checks.
• Monitoring of Database OEM, performance and tuning.

• Installation, upgrade, maintenance and administration of Database 9i, 10g and Solaris.
• Installation, Implement, Configuration Oracle Data guard, ASM, Grid Control, RAC and Application Server 10gR2, Oracle Patching.
• Research, design, build, test, implement, maintain, and support a multiple environment.
• Monitored database performance using TKPROF, SQL Trace and Explain plan.
• Comply with policies and procedures as required.
• Excellent knowledge in SQL & PL/SQL.

• Installation, configuration and administration of Oracle 9i, 10g on Windows and Linux.
• Install different software when required like Skype, adobe reader, plugin & etc on Linux.
• Designing, Implementing, development and Maintenance of different Department’s Applications.
• Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, Triggers, functions, Created users, granted privileges and roles.
• All Applications convert and upgrade from… Show more
• All Applications convert and upgrade from developer6i to Developer Suite 10g.

Oracle Database Administrator

Activities and Societies: Search and Development

Bachelor Of Computer Science (Bsc Hons), Data Modeling/Warehousing And Database Administration