Highlights:

Skills:Oracle Apps DBA, Oracle Core DBA, System Administrator

Sr. FSE 10-2012 - current
SS8, Milpitas, CA, CA United States
Being FSE my responsibility includes new solution deployment, maintenance of existing system and emergency maintenance, our company solution consists of more than 15 racks that include more than 50 servers. AS FSE I take care of Database and system Administration/Maintenance/Installation/upgrades and patching the system.
Operating System Solaris, Solaris, Veritas Cluster for Solaris Linux RDBMS Oracle, Mysql, Rainstore Recently upgrade our company solution at Etisalat UAE, that consists of 1 central site at Abu Dhabi and around 15 remote sites in different emirates around the country, Upgrade includes: Installation of new equipment in Racks Installation of operating system (Solaris and Linux) Installation of Software application Installation of database management system Installation and configuration of EBS Configuration of IBM V7000 file server Configuration of IBM SAN DS3524 Configuration of Central site Configuration of Remote site Installation, Configuration and UAT (User Acceptance Test) was successfully completed as per pre-decided timeline (4 months) Install a new Central site with our company solution at AT&T in CA, USA Installation includes: Installation of new equipment in Racks Installation of operating system (Solaris) Installation of Software application Installation of database management system Configuration of Central site Installation, Configuration and UAT (User Acceptance Test) was successfully completed as per pre-decided timeline (1 month)--
Remote DBA 02-2010 - 06-2010
Imnunar Inc, Imunar, Inc. 4115 Blackhawk Circle, Suite 100, United States
Imunar have a global presence and serve clients in more than 8 countries in a variety of industries. We focus on what we can do best, streaming the IT services area so you can focus on your core business. Being DBA my primary responsibility is to keep up and running oracle standalone databases and 1 with data guard configuration with maximum performance mode; and more than 16 Ms Sql server DB hosted at client premises in USA. All monitory & maintenance work was done remotely; highlights of my daily routine is as under;
• Check alert log for modification and error in databases. • Check the listener log of the databases. • Notification Monitoring of Database Backup. • Monitoring of Server’s through Nagios • Working on documentation of knowledge base frequently error. • Check the Table spaces, Redo Logs status & sizes of all databases. • Identify performance bottlenecks; use pro-active maintenance strategy. • Involve in capacity and resource planning. • Check mount point of all the database servers;--
Sr. DBA 11-2009 - 10-2012
AKSA-SDS, Islamabad, Capital Pakistan
Being a DBA my primary responsibility is to keep all databases (Oracle & MS SQL Server) up & running; 90% of database are running in 24*7 production environment; AKSA is also providing solution development consultancy to well-known telecom operators in Pakistan like TELENOR, UFONE, MOBILINK, Vodafone ; few responsibilities & work done are as follows.
• Upgraded Oracle Real Application Cluster (RAC) 10g to 11g • Installation of Database such as Oracle 9i, 10g and 11g on Solaris , Linux and Windows • Installation of EBS 11i & R12 (single/multi node) for Linux and Windows. • Maintaining of Oracle Apps11i and Apps 12 (single/multi node) on Linux and Windows • Analysis of statistics & preparing recommendations Database reorganization for better performance • Interact with Functional consultants to schedule the concurrent request, changing the schedule of specific requests to reduce the load on the system at peak times to keep the system healthy. • Database Cloning from RAC to RAC and RAC to Non-RAC Environments • System administration functions like creating users, creating responsibilities and menus • Monitor database and identify performance bottlenecks and tune database as needed • Database designing, creation and customization • Implemented backup strategy (hot as well as cold) for Production and Other Databases using RMAN. • Collect database performance statistics periodically • Considering future growth, reorganization of database and space management of database as per needed • Analyze tables and schemas, rebuilding indexes, generation of jar files/forms and reports through adadmin • Coordinate with Oracle support for logging Service Requests • Shell Script writing to take backup and generate different DBA reports; • Deploy oracle DR site (Data guard). • Design solution for the client according to their business requirement within the available resources • Checking of night backup and archiving reports on daily basis. • Manage client’s change request (CR) and complete it according to SDLC standards. • Take special care of Indexes, row chaining & migration for the fast query response. • Migrate Sql Server 2000 database to Oracle 10g • Lead projects related to any database (Oracle, MS Sql Server, My Sql etc) • Meeting with clients to analyze new and existing system. • Define and Implemented Maintenance PLAN for MS SQL Server to keep database healthy • Work with software development & other teams on database logical design; capacity planning; resource requirement for the application.--
DBA 10-2003 - 11-2009
Quicklink Communication Pvt Ltd, Islamabad, Capital Pakistan
Industry: Telecom
Quicklink Communication is providing Internet over Satellite on all bands in major part of the World, Calling facility all over the world over internet.
• Create, schedule db maintenance tasks, such as tables / indexes analysis, index rebuild; • Implemented backup & recovery strategy, • Work with developer to maintain and develop new database applications; to diagnose database related application problems. • Identify performance bottlenecks; use pro-active maintenance strategy. • Involve in capacity and resource planning. • Perform database administration tasks; installations, builds, upgrades, object sizing, object creation, hot backups, cold backups, import / export data pump. • Responsible of VOIP operation in Pakistan and outside Pakistan • Manage VOIP Soft Switch from last 6 years • Offer all kind of services using VOIP technology, Calling Card, PC2Phone Calling Card, International DID Numbers, general traffic routing on different protocols sip / h323. • Hands on experience on different VOIP equipments; like QUINTUM , POLYCOM , Vonage etc • Deploy Asterisk solution with different configuration as per client requirement.--
Sr. Developer / DBA 03-1997 - 09-2003
Dancom Pakistan Pvt Ltd, Islamabad, Capital Pakistan
Industry: Telecom
Dancom provides card pay phone; calling card; Fax over IP; Internet Services in the Country.
• Team Lead of development team for application development for the company. • 24*7 database support Oracle 8i-9i databases for Solaris. • Responsible of keeping all databases up and running with zero downtime. • Manage 5 remote databases hosted in 5 different cities (Islamabad/Karachi/Lahore/Peshawar/Multan) for 3 years. • System Administration of Sun Solaris • Create, schedule db maintenance tasks, such as tables / indexes analysis, index rebuild; • Implemented backup & recovery strategy, • Identify performance bottlenecks; use pro-active maintenance strategy. • Involve in capacity and resource planning. • Perform database administration tasks; installations, builds, upgrades, object sizing, object creation, hot backups, cold backups, import / export data pump. SOFTWARE PROJECTS: Designed several software for the company during my stay, a brief introduction is as under. Accounting Software: Develop 5 versions in 6 years for the company; 2 versions were developed in Fox-pro and VFP rest of 3 versions were developed using Developer 2000 and Oracle 8i. Fax – Over IP Billing System: It was designed and implemented for the billing system of unique service launched in 2000 Pre-paid & Post-paid ISP Billing: This software was designed in year 2000 first of its kind at starting age of internet on dialup. Sales & Inventory Module: As name of these modules described; it was customized module to manage the sale and keep track of our inventory according to company policy.--

PBTE 04-1992 - 09-1994
Khushab, , Pakistan
Degree: High School Or Below
Major:Commerce
Diploma in Commerce (D-Com)

Ehsan ul Haq