Developer Resume Mainframe Development Resume

Database Developer Resume Samples

Williams,

 Contact No : 1234567891
E-mail : williams@gmail.com
Present Address : Chennai


CAREER OBJECTIVES
  • 4.7+ Years of working experience in IBM iSeries/AS400 System Engineer (L2), looking forward for a good opportunity to enhance my skills.
  • Having part time work experience with Oracle-SQL Database.
EDUCATION
Course (Stream)/ Examination
Institution/University/School
Year of Passing
Performance
B.E. in Computer Science & Engineering College Name-Location 2011 75%
HSC School Name-Location 2007 77%
SSLC School Name-Location

2005

80%

WORK EXPERIENCE
1) AS400 Technical Consultant

Company Name-Location – January 2017 to Present

Responsibilities:

  • Monitoring CPU and ASP utilization, software & hardware, disk status, Subsystem status.
  • Experience with working on DB2/400 and SQL/400 queries.
  • Monitoring all the subsystems, Batch jobs, Interactive jobs, output queues & job queues.
  • Handling Backup’s, working with libraries.
  • Inserting and Removing Tapes in Tape drives.
  • Creating user profiles and providing authorities in AS400 as well as MMS Application.
  • Working and troubleshooting application issues and giving details to customers.
  • Giving Special authorities and adding group profile for the users as per request.
  • Monitoring iCluster replication tool.
  • Working with MMS JDA retail products for cloud and support customers.
  • Basic working knowledge on RPGLE and CL program.
  • Working with Physical Files, logical files, data members, objects and libraries.
  • Monitoring and administrating EOD jobs.

Tools Involved:

  • Backup and Recovery Media Service(BRMS)
  • Salesforce ticketing tool.
  • Icluster replication tool.
  • ROBOT job scheduler.
  • BMC remedy tool.
2) Sr.Database Developer (DB2/400 )

Company Name-Location – 2016

Responsibilities:

  • Experience on work management.
  • Handling all kind of H/w and S/w alerts. Coordinating with IBM to FIX the issues.
  • Handling different kind of messages and coordinating with team.
  • Giving authority to the objects as per user request.
  • Work with JOBQ, OUTQ, Spooled Files, MSGQ.
  • Checking daily logs, System status, network connection, Messages, health check-up in fifteen AS400 LPARS.
  • Monitoring third party email server called E-Mail Server (RJS).
  • Experience in fetching data from database files using WRKQRY.
  • Basic knowledge on HMC & OPS-Consoles.

Tools Involved:

  • Backup and Recovery Media Service(BRMS)
  • ITSM ticketing tool
SKILLS
  • DATABASE (3 years)
  • DB2 (1 year)
  • ISERIES (1 year)
  • REMEDY (1 year)
  • SQL (1 year)
ADDITIONAL INFORMATION
  • Operating systems OS/400(IBM i) V5R4, V7R1, V7R2 and Windows XP/07/08
  • Hardware IBM iSeries(AS/400) 520, 570, 41A, 42A, E4B & E4C
  • AS400 Tools BRMS, ISeries Navigator
  • Ticketing tools ITSM Remedy and Sales force
  • Database Oracle-SQL, MS Access, DB2/400
  • Microsoft tools MS Office
  • Web Development HTML, Photoshop
  • Programming Language RPGLE Basics, CL, Dot Net and Core Java.

 


 Database Developer Resume Samples 2


CAREER SUMMARY:

Oracle PL/SQL Developer, with 3+ years of hands on experience in application development. Extensive experience in IT industry, Involved with full project life cycle, Complete Software Development Life Cycle (SDLC)

  • Extensive knowledge in Analysis, Design, Development, Testing and Deployment of Oracle Database Management.
  • Experienced in database design, writing Stored Procedures, Packages, Functions, Triggers.
  • Good Exposure in using SQL Functions, SET Operators.
  • Experienced in Writing SQL using joins, sub queries and correlated sub queries.
  • Good Experience in Dynamic SQL and Constraints.
  • Extensive experience in using Cursors and Ref-cursors for processing of data.
  • Experience in to Use SQL*Loader to load bulk data from various flat files.
  • Proficient in developing and programming in PL/ SQL.
  • Experience in designing errors and Exception Handling procedures to identify, record and report errors.
  • Proficient in using tools such as SQL*Plus, SQL Developer.
  • Familiarity with Agile development methodologies.
  • Proficient in relational databases like DB2, ORACLE and Strong working knowledge in writing SQL queries and DB2 Stored Procedures.
  • Good interpersonal skills, committed, result oriented hard working with a quest and deal to learn new Technologies.
  • Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
EDUCATIONAL QUALIFICATIONS
Course (Stream)/ Examination
Institution/University/School
Year of Passing
Performance
Bachelor in Computer Applications Sri Venkateshwara College of Engg. 2014 90%
HSC St.Gaberiel’s Higher Secondary School – Chennai, Tamil Nadu 2010 84%
SSLC A.E.M High School – Chennai, Tamil Nadu

2008

80%

SKILLS
  • DATABASE (3 years)
  • DB2 (1 year)
  • ISERIES (1 year)
  • REMEDY (1 year)
  • SQL (1 year)
PROFESSIONAL EXPERIENCE
1) Developer

Company Name, Location – October 2015 to March 2016

Description:

Universal addressing allows for 10 lines of address data. However, if all lines were populated, this would typically be too long of an address to fit on correspondence. The System has three-line elimination routines based on the country code of the address that will eliminate address lines in order of least importance until the address provided fits for the given correspondence.

Job Summary:

I have been involved in

Understating and Analysing the requirements.
Implementing the required code changes in the System.
Involved in preparation of LLD, HLD as per the quality standards.
Preparing Unit test plan and unit test results document.
Status reporting and debugging of the programs.
Interacting with other supporting team like DBA, Production services team.
Creating stored procedures for Updates/Retrieves the data from database.

ADDITIONAL INFORMATION
  • Operating Systems: WINDOWS FAMILY
  • Programming Languages: SQL, PL/SQL, UNIX.
  • Database: Oracle 10g/11g, DB2.
  • Tools & Utilities: SQL Developer, SQL Loader.
DECLARATION:

I hereby affirm that the information provided above is true and correct to the Best of my knowledge and belief. On my part I shall be self-motivated and try to achieve the organizational goals through conduct.