We provide IT Staff Augmentation Services!

Database Administrator Resume

5.00/5 (Submit Your Rating)
Hire Now

Summary

Overall 11 years experience in IT field. In that 8 years of experience as a DB2 UDB DBA under various platforms. Specialized in DB2 UDB RDBMS (Ver 8.x/7.x), DB2 UDB Database Administration and DBA utilities. Strong experiences in supporting multiple production and development databases under Linux and Windows environments.

Around 3 years experiences in Unix / Windows system and network administration.

Certifications

  • IBM Certified Database Associate – DB2 UDB V8.1 Family
  • IBM Certified Database Administrator – DB2 UDB V8.1 Family

Technical Skills

RDBMS : DB2 UDB ESE, EEE & EE (9.x,8.x/7.x), OS/390, Oracle(8i,9i), MS Access
ERP : SAP Basis (Netweaver)
Warehouse : SAP BI
Platforms : Linux (Red Hat), Sun Solaris, AIX 5.x, Windows 98/NT/2000
DBA Utilities : DB2 Performance Expert, DB2 Query Patroller, Quest foglight, Quest
central, ERWIN, DB2 Migration Toolkits.
Data Access Tech : ODBC, JDBC, DBI, DB2 Connect(8.x/7.x)
Scripting Languages : Shell Scripts (PERL, C/K/Bourne Shell), Awk, Sed
Web Technologies : HTML, JavaScript
Networking : TCP/IP, Client - Server Technology
GUI Tools : Visual Basic (6.0), JDK(1.4))

Professional Training

  • “Red Hat Linux(Enterprise Edition 3.0) System & Network Administration”
PROFESSIONAL EXPERIENCE

NOV 2004 – Till Date Confidential(for State of Maryland)
MD, USA
Role : Sr. Database Administrator

Responsibilities :

  • Giving full support for production application database and data warehouse including responsible for interface batch scripts on production server.
  • Successfully completed Migration and Upgrades from DB2 UDB 7.2 to 8.2 on AIX machines.
  • Maintaining around 15 databases for various stages of applications in development site.
  • Giving full support to development by writing stored procedures, UDFs and triggers, designing tablespaces, databases.Installation, Configuration, Application Tuning, Data modelling, Data Warehouse, Fault tolerance, Security and Disaster Recovery planning on AIX 5.3 and Windows NT/2000.
  • Analyze and apply the DB2 fix packs in development and production
  • Technical support for DB2 UDB database issues DB2 UDB Instances.
  • Instance Creation on AIX and Windows platforms.
  • Frequently move the database from AIX to windows by using the utility DB2MOVE
  • Creation of Database, tablespaces and database objects in production and development environment.
  • Performance Tuning of SQL by explaining the queries, also tuning of Database Servers.
  • Implemented backup and export database backups along with dynamic recovery/restore script.
  • Utilized the following utilities: Export/Import/Load, Backup/Restore/Roll forward, DB2look, DB2dart, Rergchk/Reorg/Runstats, and Snapshot/Event monitoring.
  • Developed automated shell scripts for interface between database running on OS/390 and database running on AIX.
  • Developed and implemented shell scripts for various performance tuning purposes.

Jun 2004 – NOV 2004 Confidential
VA, USA
Role : Database Administrator

Responsibilities :

  • Supporting to development by writing stored procedures, UDFs designing tablespaces, databases.
  • Creating instances and databases on Windows 2000 and Sun Solaris machines.
  • Implemented Disaster Recovery Strategy.
  • By using Erwin tool designing database model of both logical and physical.
  • By using DB2 tools like LOAD, EXPORT moving data from one database to another database.
  • Moving database from UNIX system to Windows system by using DB2 MOVE utility.
  • Automated the Startup/Shutdown of DB2UDB EE instances.
  • Automated a script to monitor the table space utilization, which pages the DBA if it is more than 80% full.
  • Developed a UDB health script to monitor the health status.
  • Developed scripts for Level 2 support staff members to do basic database administration tasks.
  • Automated the process of log rotation for all the DB2UDB instances. This customized algorithm scans through the diagnostic log file of each database server and maintains 30 days worth of log.
  • Developed a bourne shell script to monitor the db2diag.log file every 30 minutes, which then email to DBA.

July 1998 – March 2004 Confidential
Bangalore, India
Role : System and Database administrator

Responsibilities:

  • Administering DB2 database system for using ERP application developed by third party Software Company.
  • Developed shell script for taking database backup.
  • Monitoring the database size and resource usage and restoring backup for various development team.
  • Responsible for network and Active Directory administration, implementation, testing and troubleshooting of hardware and software pertaining to the enterprise LAN and WAN.
  • Maintaining Windows and Linux system and developing shell scripts for normal administration purposes.
  • Installed operating systems on various machines.
  • Coordinated between user and vendor and troubleshooting.
  • Maintained peer-to-peer local area network.
  • Developed and implemented security plan.
  • Developing new application on Visual Basic using Oracle Database
  • Adding new facilities into an existing applications by writing programs in foxpro.
  • Gathering information from various departments to develop new system and applications.
  • Creating cost for new systems and estimating them.
  • Interact with system vendor for annual maintenance of organization’s systems.
  • Maintaining web pages on web server and maintaining mail server of the organization.

Education

Bachelor of computer science

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship