Database Administrator Resume Jersey City, NJ - Hire IT People

SUMMARY:

Seeking a position in a challenging, innovative and team oriented environment, where I can utilize and excel my technical, personal and professional skills towards achievement of organisational goals.
Having 8+ years of DB2 UDB for LUW database administration experience in AIX and LINUX environment with excellent analytical, organisational, planning skills with demonstrated abilities towards achievement of organisational goals.
UNIX (AIX), Linux
UNIX, Linux shell scripting, awk, sed scripting and using them for task automation.
Utilizing system tools such as topas / top / nmon for troubleshooting.
DB2 VERSIONS: v9.5 / v9.7/v10.5
Writing Stored Procedures/Function/trigger and other db objects as per Application req.
DB2 UDB installation and configuration.
DB2 HADR setup and configuration.
Installation of above setups on HACMP clusters.
Executing DDL’s and DML’s on the database (including on Q replicated tables).
Creating and managing SMS, DMS, AS table spaces.
Configuring incremental/full online/offline backups and resolving related issues.
Detecting and troubleshooting production issues using db2top, db2pd utilities and db2diag logs.
Using various snapshots, administrative views and system catalogue tables for troubleshooting.
Troubleshooting issues arising in Q replication using control tables and capture/apply logs.
Handling residual db2 instance and das processes to ensure smooth failovers/reboot.
Using data movement utilities such as import, export, load and db2move.
Using utilities such as reorgchk, reorg, runstats for maintenance and automated activities.
Executing patches including DDL, DML, DCL, index creation etc on above database types.
Monitoring the databases during production hours.
Query tuning and optimization using various snapshot’s and catalogue tables.
Monitoring the database and Q replication during data migration and other activities.
Performing maintenance activities such as reorg, runstats etc.
Resolving tickets assigned to us by performing corresponding DB activities.
Monitoring and managing file system usage, lock wait, log archival and backup issues.
Performing various DB activities such as archiving, purging and populating tables as required.
Managing DB’s during active to passive node and data centre to data rescue centre failovers.

EXPERIENCE OVERVIEW:

Confidential, Jersey City, NJ

Database Administrator

Responsibilities:

Writing Stored Procedures for multiple applications under PADT MS project.
Writing views, triggers, SQL’s Functions
Handling DBA Tasks.
Identifying, analysing and tuning database manager and database configurations.
SQL Analysis and optimization.
Monitoring DB2 UDB databases.
Backup and Recovery Procedures planning and implementation.
Database objects creation, updation as per client/application requirement.
Implementing and managing DB2 row and column access control.
Providing support for migration of data from legacy system to DB2 environment.
Identifying data mapping issues and resolution.
Data movement across multiple environments.
Identifying business requirement and suggesting structural changes in DB.

Confidential

Database Developer & Administrator

Responsibilities:

24x7 Production Support in mission critical OLTP environment.
Involved in database installation/up gradation and migration in HACMP and Q - replication configured environment.
Handling DBA Tickets.
Identifying, analysing and tuning database manager and database configurations.
SQL Analysis and optimization.
Monitoring DB2 UDB databases.
Backup and Recovery Procedures planning and implementation.
Performance monitoring and tuning,
Daily / weekly /Monthly Database maintenance activities.
Database objects creation, updation as per client/application requirement

Confidential

Database Developer & Administrator

Responsibilities:

24x7 Production Support in mission critical OLTP environment.
Involved in database installation/up gradation and migration in HACMP and Q-replication configured environment.
Handling DBA Tickets.
Identifying, analysing and tuning database manager and database configurations.
SQL Analysis and optimization.
Monitoring DB2 UDB databases.
Backup and Recovery Procedures planning and implementation.
Performance monitoring and tuning,
Daily / weekly /Monthly Database maintenance activities.
Database objects creation, updation as per client/application requirement

We provide IT Staff Augmentation Services!

Database Administrator Resume

Jersey City, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship