Sr. DB2 DBA on Unix Sample Resume Format in Word Free Download -->

Sr. DB2 DBA on Unix Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download


ELINA  NOKHODIAN
Louisville, KY / 502-963-9876

elina.nokhodian@yahoo.com                                                      

SUMMARY

Over 15 years of diverse database administration (DBA) experience on various platforms like DB2 UDB ESE V8.2/V9.5-V9.7/AIX/Linux EE&EEE, DB2 Z/OS Mainframe DB2 V1.2 – V9.1, strong experience in transforming Logical Data Model(LDM) to Physical Data Model (PDM)  as apply to DB2  OLTP or Dimensional data warehouse (DW) environment, including access path analysis , server (DPF) and range partitioning , Denormalization , Multi-Dimensional Clustering (MDC) , Materialized Query Table (MQT), SQL / Application Tuning, Trigger, UDF and Store Procedure.   
  • Extensive experience in installation of DB2 V8/V9.5, BMC, CA, Quest software and DB2 third party tools like SmartDBA, Quest Central on AIX / EEE, HADR, TSM, CATALOG Manager, Change Manager, APPTUNE, BUFFER POOL, DASD Manager, MAINVIEW on Z/OS(OS/390), as well as experience with DB2 Utilities (JCL, ISPF, TSO, REXX, FILEAID), daily working closely with the application team on problem solving of Microstrategy and ETL  performance and tuning. 
  • Keeping up with the latest changes in DB2  Z/OS V10 & DB2 LUW V9.7.3 DBMS, also have experience with Oracle and Informix databases.
  • Working knowledge of Java language,XML, ERwin and ER/Studio data modeling tools.


PROFESSIONAL EXPERIENCE

Yum Brands, Contract, Louisville, KY                                                               Oct 12,2010July 29, 2011
Sr. DB2 DBA on Unix/AIX
  • Contract Sr. DB2 DBA to help support DB2 UDB for Unix environment.  Major responsibilities will include,  upgrading UDB instances from 8.2  UDB/5.3  AIX to 9.7 LUW/6.1 AIX
·       Assisting upgrading IBM’s Websphere Portal product
·       Researching and planning for the upgrading IBM’s Tivoli product
·       Performing day-to-day DBA support activities, supporting PeopleSoft application
·       Performance monitoring and tuning
LACERA, Contract, Pasadena, CA                                                          Feb 8,2010Sep 2, 2010
Sr. DB2 DBA on Z/OS V7.1-V9.1 & Linux/AIX
• Database Administrator focusing primarily on the creation of Data Warehouse(DW) on Linux DB2 LUW V9.7  and maintenance,  performance & tuning of enterprise databases in Z/OS DB2/V7-V9.1 Environments.
Responsible for various database administration tasks in the development, QA and production environments:
  - Modify and implement database designs from logical to physical data model
  - Create and implement database backup and recovery strategies
  - Analyze and tune SQL statements, stored procedures, and database configuration parameters using various tools.


Apria HealthCare, Inc, full-time, Lake Forest, CA                                            Sep 2008 - Oct 31, 2009
Lead DB2 DBA on Unix/AIX
·         General DBA activities supporting over 60  instances and databases in different versions and platforms (7.2,8.2,9.1 & 9.5)  on Window and Unix/AIX, daily executing DBA requests in Data Warehouse (DW) , OLTP  and Contentment Management (CM) production environments and migration DB2 LUW from V8  to  V9.5.
·         Responsibilities include physical design, access path analysis, export/import & Load utility, Unix shell scripting, SQL / Application performance and tuning , 24x7 on call production support and day-to-day monitoring, TSM Backup/Recovery using Quest Central , Optim, Data Studio, DB2TOP,TOPAS and Quest Spotlight tools to monitor and improve performance.


American Express, Contract through Manpower Staffing, Scottsdale, AZ                   Nov 2005-July 2008
Sr. DB2 UDB "LUW" DBA
  • General DBA activities, executing daily DBA requests on Data Warehousing (DW) DB2 UDB ESE V8.2/AIX environment, AIX production support responsibilities included physical database design, access path analysis, export/import & Load utility, Unix shell scripts, SQL / Application performance tuning, 24x7 on call DBA support of databases with over 3-5 TB of data.   A bit of work was involved with DBA support on Z/OS mainframe using BMC tools.
  • The main application "Reward and Rebate/an in-house databank auditing system" running on Unix/AIX, DB2/UDB 8.2 with 24 & 32 nodes, duties included the day to day monitoring & performance tuning using Quest Central, DB2TOP & Quest Spotlight tools to monitor and improve performance.

TRX Data Services , Contract, Tyson Corner, VA                                                          Oct 2004 - June 2005
Sr. DB2/UDB DBA
  • Responsibilities include general DBA activities, executing daily DBA requests in Data Warehousing (DW) and DB2 UDB ESE V8.2/AIX environment.
  • Implementing physical design, access plan analysis, Export, Import/Load utility, UNIX shells scripts, SQL / application performance tuning and on call DBA support.
  • Environment about 10-15 TB overall, lots of databases and each about 300GB to 1.5 Terabytes. Main applications GDR and CCRS running on EE partition P650 8 processors using FASTT700 Controller connected to 28 racks (14 hard disks each rack); using RAID 1 & 5. OS AIX 4.2 and 4.3, DB2/UDB 8.2.
  • Used Suse 8 Linux and DB2/UDB 8.2 for Microstrategy Meta database (10GB) and BMC's SMARTdba and UDB Control Center tools for performance and tuning of MSTR report and SQL statements.

BMC Software, Austin Texas, full-time                                                                        04/1999 - 6/2003
DB2 DBA/QA      
  • Responsible for installation , testing and integration testing of SQL EXPLORER with other BMC's administrative and tuning products like CATALOG Manager, CHANGE Manager, APPTUNE, BUFFER POOL, DASD Manager, MAINVIEW and creating all testing database's objects , test plans and test cases on UDBV8/AIX , Z/OS & MVS DB2/CICS (V5 thruV8) environments
  • Testing included access path analysis, Optimizer strategies, Isolation levels, Bind PRAMs/Locks/ Concurrency, Buffer Pool, DRDA, Store procedure, Trigger, UDF/UDT, monitoring in real-time, Static and Dynamic SQL usage, I/O, GETPAGES usage... Also analyzed Plans, Packages, DBRMs, Host Variable Mismatch to check the validity of the test results and suggested displayed rules.

Nissan Corp, Smyrna TN, Consultant                                                                           10/1997 - 3/1999
Database Administrator (DBA)
  • Responsible for physical implementation, performance tuning and space sizing requirements of Warranty System.
  • Environment DB2 V5 OS/390 MVS  & CICS, Databases (TEST, QA, PROD) over 180 tables ranging from very small to over 3800 million rows.
  • For database administration and performance monitoring we used BMC's administrative tools and Candle's Omegamon online tool. Also supported application group (a team of 7 programmers) in SQL and application tuning during the development phase.

Compaq Corp Houston, TX, Consultant                                                                                   02/1996 - 9/1997

  • Provided FORTRAN enhancements and daily production support on HP/Image Database, a legacy Order Entry System.
  • Prototyped an Intranet application development, a client server application using Microsoft Frontpage97, VBasic, StarVison a Middleware software, OracleV7/PC , Microsoft Excel and ODBC connectivity.

GTE Data Services Inc., Full-time, Tampa, FL                                                                02/1989 - 11/1995
DBA/Database Analyst
  • Performed traditional Database functions such as conversion of logical data model to physical design, database maintenance, access path analysis and application tuning, administered Security/View and Backups, Recoveries and Reorg on MVS/DB2, Oracle/VAX, Unix/Informix databases and Teradata/MVS environment.



International Paper Corp, Full-time, Memphis, TN                                                        07/1987 - 2/1989
Sr. Programmer Analyst
  • Provided application support for Image database/HP-1000, VAX/DBMS Network Database, performed physical database design and schema conversion from Hierarchical Image database/HP-1000 to VAX/RDBMS Network Database on VAX/VMS 8350.

University of Houston, TX, Full-Time                                                                      02/1981 - 5/1987
Systems Analyst
  • Worked on conversion of student account receivable from Honeywell file system and Hewlett Packard Image database to Oracle relational database on VAX/780 using FORTRAN, Decnet and Ethernet LAN environment. Managed and operated
  • Honeywell Level/6 and set up remote batch job entry and procedures to run remote software on Honeywell Level/6000 using point to point communication line. First couple of years started as computer operator & student consultant, provided all operations support in multiple platform hardware environments including PDP 11/60, HP-1000, HP-2000, HP-3000, HP3000-S44, IBM-5525, VAX/750, VAX/780, and VAX/785. Assisted students trouble shooting their programming errors, and provided training on educational software packages.


EDUCATION

·         University of Houston, TX
Bachelor of Science Degree in Computer Science




Download Resume Format 

0 comments:

Post a Comment

Resumes By Categories

1-5 Years Experienced CV 10-15 Years Experienced CV 10th Standard 12th Standard CV 15-20 Years Experienced CV 20-25 Years Experienced CV 30+ Years Experienced CV 5-10 Years Experienced CV Accounts CV Aeronautical CV Automobile Engineer B Com CV B Pharma CV B.Tech CV BA CV BA Philosophy CV Banking CV BBA CV BBM CV BCA CV BDS CV Beautiful CV Bio Technology CV BMS CV BPO Call Center CV BSC CV BSC IT CV Business Analyst CV CA CV Cashier CV CEO CV CFA CV Chemical CV Civil Engineering CV CMA CV Commercial CV Cook CV Cover Letter for Resume CS CV D Pharma CV Diploma CV Doctor CV draff Economist CV Electrical CV Electronics CV Engineer CV Fashion Designer CV Films CV Finance CV Foreign Resume Format Fresher CV GM CV Hotel Management Housekeeping CV HR CV ICWAI CV Import Export CV Industrial Engineering CV Instrumentation CV Insurance CV IT CV ITI CV journalist CV LLB CV M Com CV M Pharma CV M Phil CV M Sc Computer Science CV M Tech CV M.Tech MA CV Manager CV Marketing CV Mass Communication CV MBA CV MBA Event Management MBA Finance MBA Hospitality CV MBA HR CV MBA IB cv MBA Marketing MBA Production MBA Quality MBA SCM CV MBA System MCA CV Mechanical CV Medical Representative CV Mining CV MMS CV MS CV MSC CV Over 25 Years Experienced CV Paint Technology CV Pharmacy CV Phd CV Philosophy CV Project Manager CV Psychology CV Purchase CV Quality Engineer Real Estate CV SAP ABAP CV SAP Basis SAP BI CV SAP BO CV SAP CRM CV SAP CV SAP FICO CV SAP HR CV SAP MM CV SAP PP CV SAP SD CV SAP Security Six Sigma CV Special Resume System Administrator CV Teacher CV Textile CV Treasury CV USA Resume Web Designer CV