Freelance DBA
odesk.com
Total years of experience :22 years, 3 Months
https://www.odesk.com/users/~0100b96c4336a999b2
Designed multiple applications for various customers from over the world
Provide consultancy to write and review SQL Codes
Responsible for leading DBAs and development team.
Responsible for system architecture, design and code reviews.
Monitoring of the DBs and applications components
Assisting the Applications Manager in business projects and involving cross functional teams.
Develops and maintains operational and system level documentation
Writing Database/Unix scripts for automation of regular tasks
Responsible for leading application development teams.
Executing the project for modifying of Express (Terminal Management System).
Assisting the Project Manager in business projects and involving cross functional teams.
Ensuring round the clock-year round operation of core terminal applications and Oracle Database.
Responsible for ensuring the backups, integrity, and performance of all Oracle Databases.
Improving on EDI interfaces with shipping lines and customers and other stake holders
Carried out administration and tuning of Oracle Databases including Core Banking (Symbols), Oracle Financials, HRMS, Treasury, AML, KYC, Siebel, and Knowledge Manager (warehouse).
Administrated Oracle Application Server for business applications.
Maintained database and application backups such as RMAN, Export Data Pump, and Cold Backup with proper logs.
Responsible for deployment of business application in UAT and production environments.
Provided round the clock, year round support for business applications.
Maintained DR Site for core banking applications.
Prepared development, UAT, and production environment for new and existing business applications
Major Tasks I have completed
• Deploy Electronic Account Statement thru AIX Script to create customers account statement A/c. No. wise in PDF format and send email.
• Real Time Apply of Redo Log Files synchronization to Standby Database for zero % data loss in case of disaster
• Implement Oracle HRMS i-Recruitment module in Production, Faysal Bank is the first bank in Pakistan.
• Train Regional Administrators (Lahore, Islamabad, and Karachi) to monitor Database thru Oracle Enterprise Manager.
• Implement CVS (Version Control System) for In-House developed applications.
Responsible for administration and tuning of Oracle DB and carried out backup and restore.
Assisted Application Administrator in managing different databases and applications.
Developed complex modules to match the present Express (Terminal Management Software) by Navis Corp. (USA) System.
Communicated with NAVIS for resolving issues and discussing new requirements.
Prepared statistics and created new reports as per user requests.
Provided round the clock, year round support to users on JF Shipping and Accounts System developed in AS-400.
Communicated with NYK Singapore office for system related issues.
Provided technical support and troubleshooting to LAN network hardware and software.
Installed McAfee, Windows Server 2003, and Lotus Notes client.
Deputed as Analyst Programmer to Qasim International Container Terminal (DP World), Karachi
Design new module as per User./Terminal requirement to fit in Express (Terminal Management System)
Supporting EXPRESS/SPARCS users
Communicate with NAVIS in case of any problem or discussing new requirements.
Preparing statistics and creating new reports as per user requests.
Responsibilities
• Administrating & Tuning Oracle DB
• Backup & Restore
• Supporting EXPRESS/SPARCS users
• Communicate with NAVIS in case of any problem or discussing new requirements.
• Preparing statistics and creating new reports as per user requests.
• Following up with our clients (shipping lines) for any requirements related to the system.
Assisted Application Manager in managing different databases and applications.
Provided round the clock-year round support to users on Express (Terminal Management System).
Supervised the entire Express (Terminal Management System).
Ensured proper backups, security, and documentation for Express related applications.
Studied and trained other Software team member on Terminal Management System and KICTL business processes.
Deputed as Software Developer / DBA Karachi International Container Terminal Ltd.
Provided round the clock-year round Express (Terminal Management System) Support.
Developed complex modules to match the present Express (Terminal Management System) by Navis Corp. (USA) System as a Software team member.
Implemented and supported Oracle Discoverer for Express.
Responsible for implementation and support of CARe (Customs Administrative Reforms) Project in KICTL.
Coordinated with Pakistan Customs during CARe project.
Developed new modules in HR and Payroll.
Carried out Database Administration.
Implement data models and database design for Sales, Purchase, Inventory Control and General Ledger
Development of MIS reports
Implement backup plans for database and applications
Development of different projects as a team member.
Coordination with clients during project development.
As a member of this software house I was involved in development and designing of new systems and provide 24*7 days technical support for applications on client sites.
Passed Masters in Computers & Information Technology with 3 GPA.
Diploma in Oracle Developer/DBA
One Year Dimploma in Computer Science
Passed Bachelor of Commerce with 58%.
Passed Intermediate Pre-Engineering with "B" Grade.