Shah Jehan Sanai Memon, Database Manager

Shah Jehan Sanai Memon

Database Manager

Media Innovation Pvt. Ltd

Location
Pakistan - Karachi
Education
Master's degree, Software Project Management
Experience
21 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :21 years, 1 Months

Database Manager at Media Innovation Pvt. Ltd
  • Pakistan - Karachi
  • My current job since September 2009

I am responsible to Design and develop, Management space, Security measures, performance tuning and backup plan of Database for Data ware House. I have to coordinate with application development team to assist them in database accessing and resolve their issues related to database ware house. Due to huge database, i have to design pro-active plan to manage database and make sure high availability, database security and best query performance. I am handling simultaneously Oracle 10g and MS SQL 2005 Server. We have running 56 applications in 12 departments, so I have to make sure no performance issue in any applications. I have to design different pro-active plan to database management, performance, security and database up gradation. And much more.

Sr. Database Administrator at Alpha Beta Capital Markets (Private) Limited
  • Pakistan - Karachi
  • October 2008 to July 2009

In Alpha Beta Capital Markets (Pvt) Limited, i have responsibilites to Design, Develop and Maintains database for Online Trading Application System Install and Configure Oracle database version 8i, 9i, 10g, 11g on Windows. Performs ongoing tuning of the database instances. Performance monitoring on Oracle systems Tune database using Oracle Enterprise Manager (OEM).

I also responsible to Implements and enforces security for all of the Databases. Performs database re-organizations and ensure maximum uptime of the database.
Enforces and maintains database constraints to ensure integrity of the database. Troubleshoots with problems regarding the databases, Applications and development tools. Migrate and Upgrade Oracle Database as per requirement. Configure and deploy gateway of Karachi Stock Exchange
Configure and deploy Backoffice application.

In Alpha Beta Capital Market I was main responsible for the Information Technology Department of the Company which involved Designation, Development & Backup & Recovery of Database accordance standard of Oracle and requirements of Financial Securities.

I was also involved in Installation, Configuration and Maintained of Online Trading Application Servers and Support to Clients throughout country.

I was also involved in Installation, Configuration and Maintained of Gateways of Karachi Stock Exchange and Lahore Stock Exchange.

I was also involved in Corresponding with Karachi and Lahore Stock Exchanges, fulfilling requirements of traders to do trading properly.

I was also involved in Development and Deployment of website of company, www.alphabetacm.com.

I was also involved in communication, configuration and maintaining of Internet Connections from different Internet Service Providers.

IT Officer at Invest & Finance Securities Limited
  • Pakistan - Karachi
  • April 2006 to July 2008

In Invest and Finance Securities Limited, I was responsible for Designing & Development of Oracle Database, Installation & Configuration of Online Trading Application Servers, Configuration and installation of Gateways of Karachi Stock Exchange & Lahore Stock Exchange, Backup & Recovery of Database, Installation and Configuration and maintained of Backoffice. Beside this I also had to Development and Deployment of Company Website.

In Invest and Finance Securities Limited I had main responsible for the Information Technology Department of the Company which involved Designation, Development & Backup & Recovery of Database accordance standard of Oracle and requirements of Financial Securities.

I was also involved in Installation, Configuration and Maintained of Online Trading Application Servers and Support to Clients throughout country.

I was also involved in Installation, Configuration and Maintained of Gateways of Karachi Stock Exchange and Lahore Stock Exchange.

I was also involved in Corresponding with Karachi and Lahore Stock Exchanges, fulfilling requirements of traders to do trading properly.

I was also involved in Development and Deployment of website of company, www.investfinance.com.pk.

I was also involved in communication, configuration and maintaining of Internet Connections from different Internet Service Providers.

IT Incharge at Sindh Health & Education Development Society
  • Pakistan - Hyderabad
  • January 2003 to March 2006

I had main responsibity of Database Administration, management, backup and scurity. I had desinged many backup options and work for many years. Such as; RMAN, Standy database server, Logical Dataguard, Physical Dataguard. Beside database administration, took intrest to work on networking appliances, such as network switches, firewall and Active directory.

Education

Master's degree, Software Project Management
  • at FAST-NU
  • June 2010

I have successfully completed degree as Software Project Management from National University of Science & Technology. My final CGPA is 2.58. During my study i manage project of MEDICO SYSTEM. I had 04 students to whom i suprvise and we complete it successfully. I learnt alot from this experience. My team is implementing MEDICO SYSTEM project in a commercial hospital at Karachi. I have attend many coferences and lectures of high profile persons in Software industry.

Diploma, Oracle Database 10g (OCP)
  • at Oracle University
  • February 2009

I have complete Oracle Database 10g Certification.

Bachelor's degree, Computer Science
  • at University of Sindh
  • December 2002

During BCS(Hons.) 04-Years degree, I earn GPA 2.88. During my study I complete my final year project as Pakistan Centerlized Railways Reservation System. I did intership at State Bank of Pakistan, Unilever (Pakistan), Nestle (Pakistan) and MCB commercial Bank.

Diploma, Pre-Medical
  • at S.I.Govt. Degree College
  • July 1998

My Grade is B.

High school or equivalent, Science
  • at S.A.Memon Govt. High School
  • July 1996

We did have GPA System at High School Level. There was Grade System. So, that my GRADE is B.

Specialties & Skills

Installation
Management
Securities
Science
Oracle 7 -11g Databases
MS SQL server 2000-2008 Databases
Crystal Reports

Languages

English
Expert
Urdu
Expert

Memberships

Oratech
  • Oracle Certified Professional
  • August 2005
Oracle
  • Oracle Certified Professional
  • January 2007
Juniper
  • Juniper Networks Certified Internet Associate, ER
  • August 2009
Juniper
  • Juniper Networks Certified Internet Associate, Enterprise Switching
  • August 2009