We provide IT Staff Augmentation Services!

Technical Systems Analyst Resume

2.00/5 (Submit Your Rating)

Raleigh, NC

Hire Now

Objective: Continue my IT career focusing on database tuning, design and administration.

Experience: Worked extensively as a DBA on AIX (10+ years). Some of the tasks included mentoring, recommending software, installs, data replication, HADR, scripting, monitoring, tuning and working with multiple teams like storage and UNIX. Also worked on AIX administration and programming in C/C++ and Perl few years back.

Certifications: IBM Certified UDB DBA (versions 7.2 and 8.2)

Skills: DB2, AIX, Linux, Windows, Ksh, Perl, C/C++

Education: M.S. (EE)

Summary of experience:

  • Delegated duties and mentored people.
  • Recommended products and suggested resources needed for new projects.
  • Interaction with business, development, storage (SAN), UNIX and other teams as and when needed.
  • Install and configuration (V5.0 - 9.5)
  • Involved in physical design taking performance and ease of maintenance into account.
  • Worked on HADR setup
  • Setting up TSM backups.
  • Reorgs, runstats and backups on a scheduled basis.
  • Troubleshooting and performance tuning.
  • Setup and maintain replication.
  • Scripts for routine maintenance.
  • Use of Load, Import, export, backup, db2move and restore utilities.
  • Developed custom scripts for auditing.
  • Used snapshot monitoring, event monitoring in addition to SQL explain, index advisor.
  • Opening PMRs with IBM

Non DB experience:
UNIX Admin, C/C++ coding, Perl scripting and MQ …

Confidential, Raleigh, NC Aug 2007 onwards 
Lead Production, Dev, Test UDB DBA (ESE) / Technical Systems Analyst

Hardware: p570; OS: AIX 5.3; Databases: DB2UDB v8.2 and v9.5 64 bit; Other: Ksh

Role:

  • Lead DBA / TSA for Branch teller, sales & service and reporting applications.
  • Delegated duties and mentored people.
  • Recommended products and suggested resources needed for new projects.
  • Troubleshooting, tuning, backup/recovery strategies, TSM backups, log mirroring.
  • Interacted with business, UNIX, Storage and Performance teams.
  • Involved in setting up groundworks monitoring.
  • SAN replication was used.
  • Designed and implemented projects to purge data, move data to reporting server via daily scripts and worked to automate jobs through Zeke.

Confidential Jul 2004 - Aug 2007
Sr. Production UDB DBA (ESE)

Hardware: p690; OS: AIX 5.2, Windows; Databases: UDBv8.2; Other: SQL Replication.

Role:

  • Worked as a senior DBA and supported eBiz applications.
  • Set up multiple real time bidirectional and user copy replication
  • Performance tuning, troubleshooting.
  • TSM / Veritas backups, Backup/Recovery strategies
  • HACMP, HADR setup.
  • Extensive use of export, import, load, move, backup/restore utilities.
  • Auditing using DB2Cops tool for security purposes.

Confidential, RTP, NC Oct 2002- May 2004
Development / Test DBA & AIX Admin

Hardware: p690; OS: AIX 5.1; Windows 2000; Databases: DB2 UDB v7.2 & 8.1; Other: SQL Replication

Role:

  • Involved in maintaining the shop IBM site.
  • Regular database maintenance, performance tuning and troubleshooting
  • Supported JDBC applications.
  • In addition to backup, restore and load utilities, tools like export, import, explain and advisor was extensively used.
  • Setting up TSM backups.
  • Monitoring through Tivoli.

Confidential, Ann Arbor, MI Jul 2002 - Sep 2002
Development DB2 DBA & AIX Admin

Hardware:RS/6000 (F50s & M80s); OS: AIX 4.3.3; Databases: DB2 v5.2 & 7.2; Other: Ksh, Perl

Role:

  • Involved in migrating web applications to DB2 v7.2 (fix 5), WAS 4.1 & MQ 5
  • Regular DB maintenance
  • Performance & troubleshooting.
  • Redesigned the physical DB by changing some of the tablespaces from SMS to DMS
  • Performed redirected restores.
  • Wrote triggers and user defined functions.

Confidential, Research Triangle Park, NC Jan 2002 - May 2002 
Development UNIX Admin & DBA

Hardware: RS/6000 (H 50s & H 70s); OS: AIX 4.3.3; Databases: UDB v7.2; Web: IHS (1.3.19.1)

Role:

  • A new release of IBM PC website. Installed DB2, IHS and lot of other software.
  • AIX monitoring, troubleshooting and use of SMITTY.
  • Helping developers with C compiler issues.
  • Instance creation and configuration.
  • DB2 backup/restores, tuning, troubleshooting.
  • Setting up users and groups at OS and DB level.
  • Redirected restores and use of db2move utility.

Confidential, Research Triangle Park, NC Jun 2001 – Dec 2001
Developer / Infrastructure

Hardware: PC, RS/6000 (J30, F50, H50); OS: Win2K, AIX 4.3.3; Databases: UDB 7.2; Misc: Ksh, SQL, Perl, HIS

Role:

  • The project involved developing a Java tool which updated and inserted data into a
    • UDB database. The second part involved publishing documents on the web.
  • Infrastructure setup, installing OS and software on the Risc servers. Was also involved
    • in activities like adding disk to the rack mounted system.
  • Maintaining the UDB databases by helping other DBAs (Physical design, troubleshooting,
    • monitoring).
  • Migrated v5.2 to v7.2. Performed instance updates, data move and redirected restore.
  • Involved in lot of SQL programming, Perl & Ksh scripting.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship