We provide IT Staff Augmentation Services!

Database Administrator (dba) Resume

SUMMARY:

  • Over Ten years of experience in administration, implementation, maintenance and support of Business Applications using Relational Databases, Graphical User interfaces using DB2 UDB 7/8.1/9.1/9.5/9.7 , Oracle 8.0/8i UNIX and Windows NT.
  • Experience providing DB2 UDB database administrator (DBA) support on AIX/Sun Solaris/LINUX.
  • Extensive expertise in understanding DB2 UDB Database systems and experience in functional and technical issues.
  • Enforcing Data integrity using integrity constraints & database triggers related with data model.
  • Experience in Performance Tuning, Space Management and Planning Backup & Recovery Strategies.
  • Experience in UDB DB2 Database Administration operated by multiple users and multiple databases.
  • Experience in application performance and tuning.
  • Configured users to Catalog the development and test database and helped them use DB2 UDB command Center.
  • Preformed multiple installations and upgrades of DB2 in production systems.
  • Experience in implementing and maintaining 24 * 7 production environments on UDB DB2 EE databases with HADR
  • Setup and tested the HA on production systems.
  • Performing day - to-day data base administration maintenance tasks.
  • Good experience in IBM PMR process.
  • Excellent in problem solving and logical, analytical, verbal, written skills.

SKILLS:

Operating Systems: UNIX (AIX, Linux, Sun Solaris), Windows XP/NT

Languages: SQL, PL/SQL, UNIX Shell Programming

RDBMS: DB2 UDB 7/8.1/9.1/9.5/9.7 , Oracle 8.x/8i

Case Tools: Designer/2000, ERWIN

Front Ends: Command Line Processor, Command CenterDeveloper/2000 (Forms 4.5/5.0, Reports 2.5/3.0)

Version Control Tools: PVCS, Rational Clear Case, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator (DBA)

Responsibilities:

  • Providing support to System Administrator (SA) in database installation, instance creation, instance upgrade, version migration and HADR.
  • Database object creation & alteration (tables, indexes, views, stored procedures, functions etc.)
  • Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
  • Database performance tuning and troubleshooting & fixing problems faced by application developer.
  • Query tuning for the problematic queries sent by application developer or identified during database monitoring.
  • Exploring the use of Multi Dimensional Clustering (MDC) & Materialized Query table to enhance the system performance if required.
  • Database monitoring (free space in tablespaces, event monitor outputs, security audit reports, performance reports etc.).
  • Database backup & recovery (offline & online backups, Full, Incremental & Delta Incremental).
  • Database cloning using redirected restores.
  • Developing tools using shell/AWK scripts to automate various database administration jobs.
  • Performing database security review (for the databases created & maintained by other DBA).
  • 24X7 on-call support to troubleshoot issues with the Production.

Environment: UDB DB2 V9.7 with Fix pack 4, UNIX-Sun Solaris / AIX / Linux, K Shell, Quest Central

Confidential

DB2 DBA

Responsibilities:

  • Provided highly technical expertise and support in the use of database technology to support the application.
  • Identified and corrected data functions that are slow or expensive in terms of system resources.
  • Developed queries to isolate, correct or eliminate redundant or bad data.
  • Ensured that data integrity, security, and recoverability are built into the application.
  • Experience with enterprise backup and recovery strategies.
  • Creating primary database storage structures (tablespaces etc.).
  • Creating primary objects (tables, views, indexes etc.).
  • Collecting database resource & CPU utilization in busy hours & idle hours and doing maintenance through reorganizing, collecting statistics and rebinding of packages.
  • Modifying the database structure, as necessary, after collecting information from application developers and based on statistics gathered.
  • Enrolling users and maintaining system security, controlling and monitoring user access to the database.
  • Configuring high availability & disaster recovery.
  • Monitoring and optimizing the performance of the database, tuning database performance.
  • Backing up and restoring the database, bringing database from no archive to archive mode, maintaining archived data on tape.
  • Stand-by database management, log shipping and applying, DR drills to ensure smooth working of standby database in event of disaster, switch-over.
  • Data maintenance through import, export & load.
  • Handling database related production issues.
  • Coordinating with application team to smoothen their efforts.

Environment: UDB DB2 V9.5, UNIX-Sun Solaris / AIX / Linux, K Shell, Quest Central

Confidential

Database Administrator (DBA)

Responsibilities:

  • Provided highly technical expertise and support in the use of database technology to support the application.
  • Developed logical and physical data base models.
  • Good understanding of DB2 internal architecture.
  • Identified and corrected data functions that are slow or expensive in terms of system resources.
  • Developed queries to isolate, correct or eliminate redundant or bad data.
  • Ensured that data integrity, security, and recoverability are built into the application.
  • Experience with enterprise backup and recovery strategies.
  • Creating primary database storage structures (tablespaces etc.).
  • Creating primary objects (tables, views, indexes etc.).
  • Collecting database resource & CPU utilization in busy hours & idle hours and doing maintenance through reorganizing, collecting statistics and rebinding of packages.
  • Modifying the database structure, as necessary, after collecting information from application developers and based on statistics gathered.
  • Enrolling users and maintaining system security, controlling and monitoring user access to the database.
  • Configuring high availability & disaster recovery.
  • Monitoring and optimizing the performance of the database, tuning database performance.
  • Backing up and restoring the database, bringing database from no archive to archive mode, maintaining archived data on tape.
  • Stand-by database management, log shipping and applying, DR drills to ensure smooth working of standby database in event of disaster, switch-over.
  • Data maintenance through import, export & load.
  • Handling database related production issues.
  • Coordinating with application team to smoothen their efforts.

Environment: UDB DB2 V9.5, UNIX-Sun Solaris / AIX / Linux, K Shell, Quest Central

Confidential

Database Administrator (DBA)

Responsibilities:

  • Supported 5 TB DB2 UDB databases on Version 9.1.6 in both OLTP and DW environments.
  • Providing support to System Administration (SA) in database installation, instance creation, instance upgrade and version migration.
  • Design, analysis and creation of new databases (analysis about number of database partitions, available memory, database size, database & database manager configuration options).
  • Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
  • Database performance tuning and troubleshooting, resolving database issues for the dev support.
  • Responsible for creating databases and objects such as table-spaces, tables, primary keys, indexes etc.
  • Supported Data Migration for Frontier databases. Maintained referential integrity and referential constrains, using both EXPORT and IMPORT for data move to Frontier Servers.
  • Query tuning for the problematic queries sent by application developer or identified during database monitoring.
  • Database monitoring (free space in tablespaces, event monitor outputs, security audit reports, performance reports etc.).
  • Database backup & recovery (offline & online backups, Full, Incremental & Delta Incremental) High Availability Disaster recovery (HADR).
  • Database cloning using redirected restores.
  • Perform capacity planning and analysis and implement required changes on the database server.
  • Analyze application SQL for performance improvement opportunities and work with DB2 support on problems and questions.
  • 24*7 Support for availability of Mission Critical Databases.

Environment: UDB DB2 V8.2 with Fix Pack 11, UDB DB2 V9.1 with Fix Pack 2a, Windows NT, UNIX-Sun Solaris / AIX / Linux, K shell, Quest Central

Confidential

Database Administrator (DBA)

Responsibilities:

  • Administered UDB databases on SUN SOLARIS machines.
  • Involved in database and schema set up, users and groups creation, permissions and privilege granting on database objects and setting up of a Release strategy.
  • Involved in creation of tablespaces, tables, indexes, views, stored procedures and configuration of database manager and individual databases.
  • Strategized data security guidelines under Sox Compliance.
  • Threshold checks on tablespaces, transaction log monitoring, disk space monitoring, archival of transaction logs and db2diag.log.
  • Involved in configuration of database and instance level parameters.
  • Analyzed snapshot information on buffer pools, locks, applications and SQL statements.
  • Work with application development team to design Frontier and re-engineer existing
  • Applications
  • Maintained referential integrity and referential constraints, using both LOAD and IMPORT to load data into the new tables.
  • Used Reorgchk, Reorg, Runstats database maintenance utilities.
  • Installed fix packs and security updates.
  • Used DB2 utilities like db2move, db2look to help expedite the migration process.
  • Involved in taking online and offline backups of the Database.
  • Report weekly database activities using db2audit.
  • Performed capacity analysis, planning and benchmark testing.
  • Supported application developers in planning and preparation, and backup and recovery of data
  • Provide 24X7 on-call support to troubleshoot issues with the Production schedule

Environment: UDB DB2 V8.1, Erwin, Windows NT, UNIX-Sun Solaris / AIX / Linux, K shell.

Confidential

Database Administrator (DBA)

Responsibilities:

  • Provided Administrative support to UDB databases on SUN SOLARIS machines.
  • Created the database and configured the clients and gave necessary Privileges on database.
  • Co-ordinate with dev team in supporting application releases and changes.
  • Automated daily maintenance process using shell scripts.
  • Used DB2LOOK to extract the DDLs.
  • Setup and implement data Backup and Recovery procedure.
  • Experience in performing the Redirect Restore.
  • Worked with Erwin 4.0 in designing the layouts as per the requirements.
  • Performed SQL tuning at the application and database level.
  • Table space Monitoring and growth Management.
  • Written database monitor shell scripts.
  • Addressed Time-outs, Deadlocks and other database related issues.
  • Used the Explain Tables to find out the timerons of each query executed.
  • Used DB2ADVIS in creating the Indexes.
  • Provided the application support in resolving the issues related to Database.

Environment: UDB DB2 V8, Erwin, Windows NT, UNIX-Sun Solaris / AIX / Linux, K shell.

Confidential

Database Administrator (DBA)

Responsibilities:

  • Import/export of tables from UDB databases.
  • Work with application development team in supporting application releases and changes.
  • Extensively used Load utility to load data into the new tables.
  • Used DB2LOOK to extract the DDLs.
  • Maintained the replication between UDB databases.
  • SQL and system monitoring and tuning, re-writing SQL’s.
  • Data/ Object Migrations.
  • Setup and implement Data Backup and Recovery procedure.
  • Addressed Time-outs, Deadlocks and other database related issues.
  • Applications support.
  • Creating EXPLAIN tables and running the visual explain utility on SQL statements.
  • Look at the APPLYTRAIL to debug the problems of UDB replication.
  • Configured the cronjobs entries to continuously monitor replication APPLYTRAIL.
  • Performed SQL tuning at the application and database level.
  • Created the test data for the Testing teams, Development teams and created environments for multiple testing teams (Manual/Auto/Functional/Performance).
  • Prepared data management procedures and performed data validation.
  • Performing data quality control checks and organizing data into database.
  • Supported application developers in planning, preparation, and backup and recovery of data.
  • Performed database activities on daily basis and resolved day to day issues pertaining to the database.
  • Provided resolution and escalation of issues (where required).

Environment: UDB DB2 V8, Humming Bird, Rapid SQL, Erwin, Windows NT, UNIX-AIX, K Shell

Confidential

Database Administrator (DBA)

Responsibilities:

  • Set up the UDB servers on AIX and SUN machines.
  • Set up the replication between the UDB databases to send the data to the corporate data warehouse.
  • Installed and configured Oracle 8 Server on Windows NT.
  • Created the database and configured the clients; Created users, roles and gave necessary Privileges on database.
  • Database design, Table design, Table indexing.
  • Involved in writing PL/SQL Stored Procedures, Functions, Database Triggers and Packages.
  • Data loading using SQL*Loader.
  • Import/export of tables from UDB and ORACLE databases.
  • Table space Monitoring and Management.
  • Worked with Erwin 4.0 in designing the layouts as per the requirements.
  • Involved in design and implementing backup and recovery strategy.
  • Performed SQL tuning at the application and database level.
  • Auditing the Database.
  • Solved Net8 Problems using Net8 Configuration assistant.
  • Maintenance and documentation of software.
  • Written database monitor shell scripts for UDB.
  • Taken snapshots at different levels of the database to check the query performance and ran explains for query tuning.

Environment: UDB DB2 V7.x, DATA JOINER, Oracle8i (SQL*PLUS, PL/SQL), Windows NT, UNIX

Confidential

Database Administrator (DBA)

Responsibilities:

  • Developing and Implementation of Modules.
  • Created Stored Procedures, Functions and Triggers using PL/SQL.
  • Involved in the design and creation of Tree Walk structured Queries.
  • Created triggers that would audit changes made by the users.
  • Tuned complex SQL statements and debugged PL/SQL packages.
  • Designed and developed a front end GUI for the system using Developer/2000.
  • Performed tuning on stored procedures.
  • Developed the test cases for testing the technical design of the package

Environment: Oracle-8.0 (sql, pl/sql), Developer/2000(Forms 5.0, Reports 3.0), Compaq Alpha Server, UNIX Shell Programming, and WINDOWS - NT SERVER

Hire Now