Data Systems
Resume:
From: "Jobs.ca"
To: "LEO KEDEMM"
Subject: Resume For Position: Sr DBA
Date: Wednesday, May 15, 2002 10:36 AM
KHALEEL M
EMAIL: abp314@r.postjobfree.com
SCARBOROUGH, TORONTO, ONT M1N 1R5, CANADA
Tel : 1-416-***-****
PROFESSIONAL SUMMARY:
Sun Certified Solaris Administrator having 14 years of experience with different flavors of Unix (Solaris, AIX, AT&T and other Solaris like SVR systems,). Working knowledge of installation and configuration of LINUX (Red Hat, Corel and Slackware).
Certified IBM Informix Database Specialist with 3.5 years extensive experience in IBM Informix DBA and Development activities with Multi-Gigabyte databases. Working knowledge of Oracle 8i DBA activities.
Extensive experience in development of EFT and SWIFT Payment systems using C, Informix 4GL, ESQLC, COBOL and Tuxedo for banks. Very strong skills in Unix shell scripting (Korn and Bourne), awk & sed and working knowledge of PERL.
Strong background in technical support including installation, integration, testing, training, documentation, maintenance and 7x24 technical support for EFT and SWIFT Payment systems at banks in Saudi Arabia.
Certified Information Systems Auditor (CISA) from ISACA, USA with a strong background in IT security, audit and control.
Proven analytical, trouble-shooting and team playing skills.
RELEVANT EXPERIENCE:
August 2001
to date: Sun Solaris Instructor/Administrator, Freelancing and at Winnet Systems, Toronto
This assignment consists of teaching UNIX (Solaris) administration and maintenance of Unix machines at Winnet Systems. A brief summary of these activities is furnished below.
Installed and configured Solaris 8 on Sparc and Intel machines along with Solstice, Solaris Management Console etc. Configured and implemented custom jumpstart remote installations for Solaris 8. Upgraded and configured AIX 4.1 and 4.2 on RS6000 machines.
Configured TCP/IP files and implemented a network of Solaris Servers. Configured network name services using local files, DNS, NIS and NIS+. Configured NTP, DHCP, SAMBA and Apache servers and clients.
Managed OBP parameters, initialization scripts and files.
Created concatenated/striped volumes using Solstice Disksuite. Managed disks, disk space, disk configuration, optimization, tuning, quotas etc. Formatted disk partitions and created file systems.
Configured and implemented system logging using syslog features for local loghost as well as remote loghost.
Configured and managed Solaris network security using /etc files like ftpusers, inetd.conf, hosts.equiv, default/login, default/su,. rhosts, .netrc, NIS, NIS+, ACLs, permissions etc. Performed remote connection using TCP/IP utilities like rlogin, telnet, ftp etc
Performed network administration and trouble shooting using ifconfig, ping, snoop, ndd, netstat, traceroute, spray etc. Configured network including net masking, assignment of IP addresses, router configuration, setting up local files mode, assignment of hostnames, etc.
Configured and managed NFS with cache file systems and auto mounting.
Assigned Access Control List permissions to files and directories. Configured devices using devfsadm, /reconfigure, boot r and admintool.
Managed users and groups using useradd, groupadd etc and admintool. Implemented Role-based Access control using roleadd and SMC.
Installed, configured and managed printers and printer queues using lpstat, lpadmin and admintool.
Managed backups and recoveries using tar, cpio, dd, volcopy, ufsdump and ufsretosre.
Performed removable media volume management with vold and rmmount.
Installed packages and patches using pkgadd, patchadd admintool etc.
Performed process control using priocntl, prtstat, pgrep, ps, pkill, jobs, fg, bg etc.
Performed job scheduling using crontab and at.
Managed system auditing using syslog, script, history, whodo, last etc. Performed investigation through analysis of sylog, /vad/adm/messages, sulog, script etc.
Imparted training to Solaris Systems Administration trainees. Prepared documentation and training material for Solaris Administration trainees.
October 1997
to March 2001: Technical Support, Steria (HO: Paris), Riyadh branch
This assignment consisted of production support, Unix Administration (Solaris and AIX) and Informix DBA and Development activities at Steria and at the Saudi banks.
A brief summary of these activities is furnished below.
Installed Solaris 7 and 8 operating systems. Upgraded AIX from 4.1 to 4.2. Installed and configured packages and updates. Installed Created and added raw logical volumes to Informix database chunks. Created and added file systems for applications. Managed disks, volumes and file systems using df, du, smitty, mount, umount etc.
Administered users and groups and file permissions using smitty. Managed file and file system security using chmod, chgrp, umask etc.Monitored and managed processes using iostat, vmstat, monitor, ps, df, grep, top and kill. Defined various environment variables and configured environment files like profile, .profile, init scripts, motd, etc.
Managed data backups, archives, restorations and recoveries using tar, dd, pack, compress and database utilities like dbimport, dbexport, dbload etc. Controlled and monitored printers and print queues using lp, lpstat, lpadmin, lprm and lpsched.
Configured SNA profiles on AIX (RS6000) for on line communication with AS 400 for sending and receiving data buffers between the two systems using APPC / APPN.
Scheduled both admin and application related batch jobs using crontab and at. Developed crontab and ftp scripts on RS6000 for periodic scanning and automatic uploading of data files to AS400 and mainframe systems at banks.
Developed shell scripts using awk and sed for reformatting the data files generated by RS6000 applications to suit the requirements of AS400/mainframe applications and vice versa.
Developed filters for converting Arabic characters from ISO-8859 (Unix) format to Windows format and vice versa without using iconv
Informix DBA and Programming activities for Banks:
Developed, installed, integrated, maintained and supported EFT and SWIFT payment systems using C, Informix 4GL, ESQLC, Tuxedo, awk, sed, embedded SQL and UNIX shell scripts.
Upgraded Informix; created and managed database spaces, chunks, databases, tables, data files, log files and populated tables. Migrated data across machines.
Reorganized the database, fragmented and indexed tables, clustered indexes, changed onconfig parameters, table schemas etc. Added and deleted chunks, started and stopped logging.
Performed Informix configuration, performance monitoring, tuning, reorganization, fragmentation, indexing, clustering, locking, purging/archival, backups, restoration and disaster recovery
Installed and integrated EFT and SWIFT payment systems on Informix / RS6000 platforms. Installed new versions and patches of application systems, database server and maintained version control.
Optimized SQL statements, set/changed lock modes and levels, isolation levels etc and solved shared memory problems using onmode and by planned committing of transactions.
Performed booting, shutdown, backup, recovery, restoration & migration of Informix Online etc using dbexport, dbimport, restart and recovery, adding users, granting privileges, monitoring of chunks and shared memory; used utilities like dbaccess, dbschema, onmonitor, onstat, oncheck, onmode, ontape, oninit, onspaces, onparams etc.
Managed users and privileges, developed audit trails using Stored Procedures and Triggers
Developed a data purge/archival utility using dbload, awk, 4GL and shell scripts for purging, uploading and reclaiming database space basing on predefined retention limits using environment variables.
Rendered customer support, training and maintenance for payment systems. Upgraded, tuned and optimized the above applications as part of maintenance.
Performed data extractions, data conversions and data loading for bank databases.
March 1997
- October 1997: Consultant (ETL Programmer), Citibank, Riyadh
This assignment consisted of developing ETL systems, testing, installing and integrating the same and change management using Continuus. These applications were installed on Sybase / Sun Solaris platform. A summary of these activities is given below.
Designed and developed the SAMA Reporting System and the Balance of Payments Reporting System for Citibank, Riyadh using MF COBOL, Pro Cobol, FPM and Unix shell scripts.
Developed Shell scripts for data validation and menus using Unix shell and Awk.
Developed a number of ETL programs for extraction conversion of data from various sources like Oracle, Sybase and Access databases and COBOL flat files. This data is in turn uploaded to Oracle for generating of statutory reports.
January 1988
- March 1997: Manager (Computer Center), Andhra Bank, India
This assignment consisted of Unix Administration, programming, testing, installation, integration, training, user support, trouble shooting, correspondence and documentation for EDP and MIS applications at controlling offices of a bank.
Installed AT & T Unix on Motorola 68020 and 68030 machines.
Formatted and initialized SMDs created partitions and file systems. Managed disks, volumes and file systems using df, du, newfs, smitty, mkfs, mount etc.
Installed packages, patches and new software using tar, dd and install scripts.
Administered users and groups using adduser and addgroup and direct editing of passwd, groups files. Managed file and file system security using chmod, chgrp, umask, ln, crypt and decrypt and quota.
Handled environment files like profile, .profile, init files, motd etc.
Managed data backups, archives, restoration and recovery using tar, cpio, dd, pack and compress.
Controlled and monitored printers and print queues using lp, lpstat, lpadmin, lprm and lpsched.
Scheduled admin and application related batch jobs using, find, crontab and at.
Monitored and managed processes using ps, df, grep, pgrep, kill and pkill.
Installed Unify RDBMS and configured the server. Created databases, tables, data files, rollback segments, log files and populated tables. Performed configuration of Unify databases, performance monitoring, tuning, reorganization, fragmentation, indexing, clustering, locking, purging/archival, backups, restoration and disaster recovery
Maintained off-site backups and other physical security safeguards.
Developed shell scripts for sys. admin and data validation purposed using Awk and Sed.
EDUCATIONAL QUALIFICATIONS:
2002 - Sun Certified Solaris Administrator, Sun Micro Systems, USA
2000 - Informix Certified Database Specialist, IBM Informix, USA
1999 - CISA (IT Auditor), ISACA, USA
1995 - M.B.A (Finance), A.U College of Management, Waltair, India
TRAININGS:
1996 - EDP Audit Course, Management Advisory Services, Massachusetts, USA
1996 - Oracle RDBMS & DBA, Software Technology Group International, Inc, India
1996 - Data Communications & Networks, Bankers Training College, Reserve Bank of India
1995 - DSS systems in relation to Expert Systems, National Institute of Banking, India
1992 - Structured Systems Analysis & Design, Tata Consultancy Services, India
1990 - Unify RDBMS, HCL Computer Ltd., Madras, India
1988 - Unix & C, Computer Maintenance Corporation ltd., India
1988 - Unix & Unify RDBMS, OMC Computers ltd., India
1987 - Cobol programming, Tata Consultancy Services, India
.
This resume has been sent to you through your account with Jobs.ca, Canada's Job Mounties
Contact this candidate