| |
|
| Year of birth |  | 1982 |
Current Location/Address |
| City or Town | | 130 A, Church Road, Manor Park, East Ham, London - E12 6hL |
| Country | | UK |
Permanent/Home Location/Address |
| State | | London |
| Country | | UK |
Languages |
| Primary Language | | Fluency |
| English | | Read, write and speak fluently |
Nationalities |
| Nationality By Birth | | INDIA |
| | |
Experience Classification |
| Job Function | | Years Experience |
| Database Administration | | 5 |
| Server Consultant | | 5 |
| Systems Administrator | | 5 |
| Help Desk/Support | | 4 |
| Server Consultant | | 4 |
Qualifications |
| Highest Qualifications | | Masters |
| Qualification | Subject | Establishment/Country | Year |
| Masters or Higher | Computer science | India | 2004 |
| Degree | Bachelor of computer applications | India | 2002 |
Other Qualifications, Memberships, Certification
IBM Advanced Certified Database Administrator – DB2 UDB V8 - 704
IBM Certified Database Administrator – DB2 UDB V8 - 701
IBM Certified Database Administrator – DB2 UDB V9.1 - 731
IBM Certified AIX Administrator – 190 - V5 Basics
Redhat Linux Certified Engineer – RHCE & Redhat Certified Technician - RHCT
|
Computer Skills and Software Used |
Skill Set:-
RDBMS DB2 UDB V8, V9, V9.5, V9.7, Oracle 9i & 10g
Linux Server settings RAID, LVM, SSH, NFS, DNS, Apache, NIS, DHCP,
Sendmail, FTP, Samba & Linux Shell Scripting
Programming Languages SQL, PL/SQL, SQL-PL, C, C++, Java and Shell
Programming
Operating Systems Redhat Linux 3.0/4.0/5.0,SUSE/Open Suse Linux,
Fedora Linux, AIX 5.x, HP, Solaris
Windows 95/98/NT/2002/2003
Tools/GUI/Utilities DB2 Control Center, Design Studio, Oracle
Designer, Toad, Advanced Query Tool, Oracle
DBCA, Oracle EM
|
Work Locations |
| Are you willing to move or relocate? | |
| Yes - I will relocate internationally | |
Availability |
| Start Immediately? | | Available Now |
| Earliest Start Date | | Given 1 weeks notice |
Ideal Next Job |
| Seeking a challenging and rewarding position that will utilize my skills & experience |
Required Salary & Conditions |
| Best in industry |
Employment History |
| Total Years of Work Experience: | | 6 |
| Commenced Full Time Work: | | 2004 |
| Name | | IBM |
| Job Title: | | Db2 Technical Analyst |
Summary |
I have 5+ years of extensive experience in managing data storage server DB2, Oracle on Linux, Unix systems. Currently working with IBM DB2 Linux, Unix, Windows worldwide product development, service, onsite and remote advanced support team as DB2 Advanced Technical Analyst. Current job role involves system hardware, storage, operating system and database planning, installation and configuration, database design, implementation, data management, DB2 DPF, HADR, data warehouse handling, loading and extracting data, backup and restore, performance monitoring and tuning, high availability, disaster recovery, db2 optimizer, query re-write/tuning, developing runstat strategies for complex queries, index tuning, migration, housekeeping, Linux and Unix server administration, OS up-gradation, OS tuning, maintenance, in-depth storage systems analysis, health checkups, systems replication, problem determination and trouble shooting, handling 24/7 down systems calls (remote and onsite), researching and implementing new business strategies, training clients.
I also have excellent skills and experience in Oracle database (9i and 10g)/ Application server 10g (3-Tier) systems capacity planning, installation, configuration, designing, creating and managing database objects, user management, backup and recovery, RMAN, loading and extracting data, scheduling jobs, database migration, replication, application deployment, performance tuning, developing backup and restore strategies, documentation, training clients, understanding market and developing new strategies, researching and trouble shooting.
Strengths:-
- Excellent Listening, speaking and writing English communication skills.
- Proven expertise in handling RDBMS on all Linux/Unix & Windows platforms.
- Proven expertise in Linux system administration, server management.
- Proven expertise in observe/identify, research, evaluating and problem solving.
- Proven expertise in client/customer handling and team collaboration.
- Certified in Database technologies, Linux, AIX and PL/SQL.
- Analytical mind, work well under pressure with minimal supervision.
- Pro-active attitude.
- Encouraging innovation, motivate and guide people.
- Career oriented, sincere and hardworking.
|
Work Experience |
Professional Profile:-
5+ years of extensive experience that includes supporting and administrating large volume production and development database storage systems DB2, Oracle on all LINUX, UNIX and Windows platforms.
Currently working with IBM Software Group (Information Management) as DB2 LINUX, UNIX, Windows Advanced Technical Analyst.
Expert in DB2 UDB V8/V9/V9.5 non-partitioned instance, DB2 Partitioned DPF/EEE (multiple logical and multiple physical) Data warehouse, DB2 HADR & DB2 Clients Planning, Installation, Configuration, Design, Administration, Maintenance, Performance tuning, Integrating with other products, Reproduce the problems in lab machines, Research and trouble shoot on all Linux, Unix and Windows platforms.
Excellent knowledge in Oracle database, Oracle Application server (3-Tier) systems capacity planning, installation, configuration, designing, creating and managing database objects, user management, backup and Recovery(RMAN), jobs, migration, replication, forms and reports deployment, performance tuning and trouble shooting.
Expert in Linux installation, server configuration, administration & troubleshooting.
Expert in handling all database objects (tables, views, indexes, constraints, MQT, MDC). Managing data storage (processor, memory, disk, database partition group, buffer pool, tablespace (DMS/SMS), table Partitioning, partition key, partition map and cluster indexes). Maintaining data (reorg, reorgchk, runstats, rebind, export, import, load, db2move, db2dart, db2inspect and automatic maintenance routines).
Expert in handling backup, restore & recovery (Online, Offline, Incremental, delta backup) on non-partitioned/partitioned (DB2 DPF/EEE), data warehouse and HADR systems. Using TSM, backup and restore tuning, db2ckbkp, db2adutl, scheduling, dropped table recovery, Cloning/replication (redirected restore and db2relocatedb).
Expert in data storage performance/ SQL query tuning (hardware, OS/DB2 memory, instance /database config: parameters, STMM, instance/database/application and shared memory, db snapshots). Query tuning (using explain tables, db2batch, exfmt, visual explain utility, db2look, understanding the query access path, db2advis,runstat, using column group statistics, index design tuning, system catalogs, and workload management).
Expert in operating system/network administration, performance tuning and trouble shoot (login issues, memory leak, ulimit, fsck, vmstat, iostat, top/topas, netstat, ps, ipcs/ipcrm, svmon, procmon, filemon, tcp wrappers, iptables, using debugging tools dbx / gdb, collecting and analysing stack, trap/core dumps.
Expert in configuring and administrating RAID, LVM, Telnet, SSH, NFS, DNS, Apache, NIS, DHCP, Sendmail, FTP, Samba, Iptables and virtual machines.
Expert in using and analyzing db2diag.log, process stack traces, system logs, db2trc, CLI traces, JDBC traces, db2pd, db2look, db2xprt etc.
Expert in handling hardware/ OS/ database/ application crashes, hangs, dead locks, latches, corruptions (data page and index), index/ data rebuilding and tuning.
Expert in Database migration DB2 UDB V8 to V 9/ V9.5 and fixpacks upgrading.
Good knowledge in handling stored procedures, functions and triggers.
|
Comments/ Hobbies/ Interests etc: |
Excellent Listening, speaking and writing English communication skills.
Proven expertise in handling RDBMS on all Linux/Unix & Windows platforms.
Proven expertise in Linux system administration and server management.
Proven expertise in observe/identify, research, evaluating and problem solving.
Proven expertise in client/customer handling and team collaboration.
Analytical mind, work well under pressure with minimal supervision.
Pro-active attitude.
Encouraging innovation, motivate and guide people.
Career oriented, sincere and hardworking.
|
-- End of CV/Resume --
|