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 • 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 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.• Monitoring and Performance tuning, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, monitoring CPU usage and Disk I/O activity etc.)• Managing log files related issues and shrinking of log files when necessary.• Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring Logs and checking email alert)• Setup and maintain documentation and standards.• Plan growth and changes (capacity planning).• Work as part of a team and provide 24x7 supports when required. Show less

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 • Multimaster Replication. • Perform daily maintenance routines and… Show more • 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 • Multimaster Replication. • Perform daily maintenance routines and checks and logs. • Monitoring of Database OEM, performance and tuning with different tools.• Experience & supporting 24x7x365 environment. Show less

• 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.• Experience & supporting… Show more • 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.• Experience & supporting 24x7x365 environment. Show less

•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. •Coordinate… Show more •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. •Coordinate multiple Oracle projects by the following project plans and assume the responsibility for them in the area of Database expertise.•Multimaster Replication. Perform daily maintenance routines and checks. •Monitoring of Database OEM, performance and tuning with different tools.•Migration Form and Report deployed on application server 10g using Window and Linux.•Enhance the overall application performance by helping developers write better code.•Maintain daily automated system backups using RMAN.•Install & Remove packages on Solaris.•UNIX shell scripting and Monitoring UNIX environment.•Installation, Implement, configuration and administration thin client (DTU) 100 nodes with Sunray server on UNIX environment.•Add plug-in on firfox and mozilla for run forms and reports on Solaris.•Write dbora script for auto start database on Linux.•Implementation and administration of sunray server on Solaris 10.•Design consistent network-wide file system, storage layouts, and RAID configuration.•Provide solution developer and network team members under Solaris 10.•Provide technical support to the end users related to IT systems.•Managed backups on Solaris systems.•Tune Solaris using different tools.•Monitoring Cluster load balance and Failover on Solaris 10.•Perform on-site and remote technical support. Share all types of knowledge with team members.•Assist in the organization and inventory of all hardware and software resources.•Experience Team leadership & supporting 24x7x365 environment. Show less

•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 •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 developer6i to Developer Suite 10g.•Monitored database performance using STATSPACK in 9i, SQL Trace and Explain plan utilities, identified performance issues and tuned the database.•Provide consultation to improve the performance of long-running queries.•Tune database using Oracle Enterprise Manager (OEM).•Performed cold & hot database backups and recovery using RMAN and taking Logical Backups, Physical and Data Pump.•Experience in database upgrade, migration and transfer from 8i and 9i to oracle 10g.•Support to team members for any database related issue.•Patch installation and upgrades Linux and Shell Scripts (Korn Shell, Bash Shell).•Experience in Team leadership and supporting 24x7x365 environment. Show less

Oracle Database Administrator

Activities and Societies: Search and Development

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