Umar Iftikhar
Database Manager at E-Processing Systems Pvt. Ltd- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
Topline Score
Bio
Asim Ismail
Umar was very punctual and hardworking database developer. He was able to meet the most complicated tasks assigned to him. I wish him all the best !
Asim Ismail
Umar was very punctual and hardworking database developer. He was able to meet the most complicated tasks assigned to him. I wish him all the best !
Asim Ismail
Umar was very punctual and hardworking database developer. He was able to meet the most complicated tasks assigned to him. I wish him all the best !
Asim Ismail
Umar was very punctual and hardworking database developer. He was able to meet the most complicated tasks assigned to him. I wish him all the best !
Credentials
-
Oracle DBA
-
Experience
-
E-Processing Systems Pvt. Ltd
-
Pakistan
-
Financial Services
-
1 - 100 Employee
-
Database Manager
-
Jan 2021 - Present
• 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 • 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
-
-
-
Systems Limited
-
Pakistan
-
IT Services and IT Consulting
-
700 & Above Employee
-
Sr Advisory Software Engineer (DBA)
-
Apr 2015 - Dec 2020
• 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
-
-
-
Interloop Pvt Ltd
-
India
-
International Trade and Development
-
1 - 100 Employee
-
Senior Database administrator (AIX)
-
Sep 2012 - Apr 2015
• 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
-
-
-
Klash Clothing
-
Retail Apparel and Fashion
-
100 - 200 Employee
-
Database Administrator (Linux)
-
Oct 2010 - Aug 2012
• 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
-
-
-
Sitara Textile Industries Limited
-
Pakistan
-
Textile Manufacturing
-
100 - 200 Employee
-
Database Administrator (Solaris)
-
Sep 2008 - Oct 2010
•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
-
-
-
-
DBA (Under Linux)
-
Dec 2004 - Sep 2008
•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
-
-
Education
-
2008 - 2008
OCP
Oracle Database Administrator -
2001 - 2005
University of the Punjab
bachelor of Computer Science (BSC Hons), Data Modeling/Warehousing and Database Administration
Community
