We provide IT Staff Augmentation Services!

Database Administrator Resume

New, JerseY

CAREER SUMMARY:

  • Having around 5 Years of total IT experience in DB2 as a DB2 UDB (LUW)Administrator, And Oracle
  • Experience on DB2 utilities, handling production and Development Issues, and I have a good knowledge on ITIL.I have good knowledge on SAP Basis.
  • As a proactive team member able to handle good organizational, communication skills.
  • DB2 installations, configurations, patching and upgrades in Production, Q/A, Test and Dev environments
  • Experience on DPF environment.
  • Experience on creating the new database and maintaining database objects
  • Providing technical expertise to design most efficient and cost effective solutions for DB2 based database systems
  • Automating repetitive tasks
  • Advanced performance tuning, advanced troubleshooting and problem determination
  • Create DB2 database online/offline backups
  • Experience on creating the new Table Spaces (DMS) .
  • Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms
  • Experience on maintaining Database Manager and Database Configuration Parameters
  • Expertise in using DB2 Movement Utilities like Export, Import and Load
  • Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
  • Experience in replication (both SQL and QREP). understanding of HA,DR Database and storage technologies like Data replication, SRDF/non - SRDF
  • Good knowledge of SQL replication .
  • Knowledge of SQL programming, Database and SQL performance tuning
  • Able to manage and deploy application database modifications
  • Knowledge of LDAP role-based authentication usage within DB2 LUW environments preferred
  • Experience with partitioned and non-partitioned environments preferred
  • Able to resolve performance issues using various tools
  • Participate in Database Maintenance and DR activities
  • Build and configure multiple DB2 databases, clustered, non-clustered and virtual environments .
  • Generating DDL using DB2LOOK utility .
  • Strong Shell Scripting experience in Red Hat and SUSE Linux
  • Performance tuning by monitoring, taking snapshots
  • I have knowledge of Oracle Enterprise Manager(OEM)
  • Opening PMR with IBM through phone or tickets in case of Database failures or any support required & driving them to closure
  • I do have experience on Problem Resolution, Configuration Management, Capacity Management
  • I have experience with TSAMP in a production environment
  • I worked supporting DB2 in a WCS (Web sphere Commerce Server) environment
  • Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database.
  • Table space management - Adding, dropping, extending, reducing and resizing table space containers
  • Backup & Recovery of Database, Online database backup, archived log files and Offline
  • Granting /revoking various authorizations to different Users/Groups
  • Implemented DB2 Security, Locking and Concurrency Control using Isolation levels.
  • Good knowledge on Incident, Problem and Change management process
  • Managing P1/P2 Bridge Calls
  • May manage smaller projects/initiatives as an experienced individual contributor with specialized knowledge within assigned discipline
  • Performs DB2 database testing
  • Leverages understanding of database technologies and supporting technologies to build and maintain databases
  • Strong collaboration, team building, interpersonal, communication skills with proficiency of grasping new technical concepts quickly.

TECHNOLOGY PROFICIENCY:

Operating System: Linux (SUSE and Red Hot),AIX, Unix, Sun Solaris, Windows

Languages: SQL, UNIX, Shell Scripting, awk, C

RDBMS: IBM DB2 UDB LUW V9.1, V 9.5, V9.7, V 10.1&V10.5,SQL Server 2005/2008/2012 , Oracle (OEM),Netezza

DBA Tools: Putty, IBM data studio,DB2 control center, Change Data Capture (CDC), Optim Performance Manager, DB2 Performance Expert, Erwin, ER/Studio, Rational Data Architect, DPROP, DB2 Replication Center, DB2 connect, and Quest Tools, VERITAS NetBackup, TSM, DB2 Federation, DB2 Query Patroller,DB2 Governor, db2top and db2pd,SRDF/non-SRDF

Application Server: WebSphere, WebLogic, JBoss,Cognos

Reporting Tools: Service Now, CA ( SDM ),JIRA

PROJECTS EXPERIENCE:

Confidential, New Jersey

Database Administrator

Environment : DB2 UDB V9.7, V10.1,V10.5 OS - AIX, LINUX

Responsibilities:

  • Developed and Maintained Development, Test and Production DB2 UDB Linux/Unix/Windows(LUW).
  • AIX / Linux / CRON job experience
  • Performed SQL Tuning using EXPLAIN, tuning Database/ Database Manager configuration parameters for optimal database performance
  • Created Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes, Triggers, Table spaces, Buffer Pools, User Roles, User Defined Types (UDT) and functions.
  • Maintained database security by Granting/Revoking users/role (v.10.1) authorizations and privileges
  • I Do have a experience in UNIX with AIX 5.x/Linux preferred.
  • Experience on DB2 Installation, Planning, Migration and Maintenance & upgrading activities.
  • DB2 Cataloging Databases on various node directory / catalog configuration.
  • Database performance tuning using DB2dart, DB2explain utilities.
  • Maintained database concurrency by setting proper Isolation Levels and Locks for queries
  • Extensive experience in fine tuning of long running queries.
  • Worked on data movement IMPORT, EXPORT and LOAD utilities.
  • Oracle Installation, Configuration and Upgrading Experience (AIX / Linux)
  • Oracle Migration experience: 11.0 - 12g
  • Oracle profiler / Operational Support experience
  • Oracle RAC w/data guard experience
  • I have a Knowledge on SQL and PL/SQL
  • Experience on database physical and logical design principals
  • Experience in DB2 High Availability (HADR, TSA, HACMP).
  • Solid knowledge of high availability using Tivoli / TSAMP policies.
  • Performed database maintenance tasks REORGCHK, RUNSTATS, REORG on daily/weekly basis
  • Experience with RDBMS like Oracle or Microsoft SQL Server
  • Experience in Performance monitoring/testing COGNOS applications
  • Experience reviewing SQL to address performance problems
  • The internal drive, intellectual curiosity, ability to learn, and desire to help the customers succeed.
  • Experience on Trouble shooting database issues using db2diag and notification logs, snapshot, event monitor, db2hc or enabling hmon .
  • Table space creation on DPF environment
  • Experience with testing methods
  • Experience in at least one DB2 database technology, technical or application area
  • Design experiences, preferably with database architecture standards or frameworks
  • Experience designing, modeling, creating and maintaining databases based on business requirements
  • Writing and testing shell scripts for automating database activities
  • I do have a experience Table space management - Adding, dropping, extending, reducing and resizing table space containers
  • Identifies what needs to be done and accepts task responsibilities and is results-driven. in clustered environments, and full application SDLC.
  • Done Backup (online and offline), Restore and Redirect Restore
  • Experience installing and supporting DB2LUW on both Windows and Linux
  • Experience database performance tuning is expected.
  • Experience on Backup and recovery methods including point in time recovery.
  • Setup and maintain documentation and standards.
  • Perform defect prevention plan and continual improvement tasks.
  • Resolve issues related to data propagator SQL replication.
  • Experience in multiple operating systems like Red Hat Linux Advanced for DB2 (LUW).
  • Experience with change control management for moving changes from Development to Production.
  • Experience with Content Management, Business Intelligence systems,And with Big Data
  • Experience Use of problem and change management tools & Managing Archive log files
  • Involved in L2 and L3 activities.
  • Attending Weekend calls with offshore and onsite teams
  • Supported on-call DBA responsibilities in UDB off-hour (24/7).

Confidential

DB2 DBA

Environment : DB2 V9.5,V10,V10.5 Sun solarise, AIX, Linux, Oracle, IBM Data Stage and Netezza

Responsibilities:

  • Create and Manage Servers, instances and databases
  • Performed SQL Tuning using EXPLAIN, tuning Database/ Database Manager configuration parameters for optimal database performance
  • Worked on Workload Manager to explicitly control and influence resources during execution by mapping all the queries to service classes.
  • Maintained database concurrency by setting proper Isolation Levels and Locks for queries
  • Worked on data movement IMPORT, EXPORT and LOAD utilities.
  • Recovered database using crash, version and roll-forward recovery methods.
  • Experience in setting up and maintaining High availability disaster recovery (HADR).
  • Performed database maintenance tasks REORGCHK, RUNSTATS, REORG on daily/weekly basis .
  • Implemented DB2 Performance Expert monitoring tool on Dev, QA and Prod servers.
  • Used db2expln, db2ckbkp, db2look, db2move, db2pd, db2rbind and db2mtrk utilities
  • Wrote shell scripts and setting up CRON jobs to take backup, runstats, reorg, disk space monitoring, I/O contention, log growth and rate of database growth.
  • Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations.
  • Maintaining and troubleshooting health parameters of the database such as Deadlocks, Lock timeouts/escalations, Buffer Pool/Catalog hit ratio, Utility/Database heaps.
  • Monitoring Tablespace utilization, Diaglog, Disk I/O, CPU utilization on a regular basis.
  • Establish standards and procedures to implement database security and auditing procedures
  • Involved in applying latest fixpaks on all UDB databases.
  • Troubleshoot database production problems and database connectivity issues
  • Implement Business Continuity Solutions such as Database refresh, cloning, Database Backups, etc.
  • Monitoring the database environment on a regular basis for performance and other issues
  • Configure and maintain database high availability
  • Monitoring all the database and Instance parameters using Foglight monitoring tool.
  • Responsible for designing, implementing and testing Disaster Recovery procedures and processes
  • Experience on that Computer Security Policies, General IT and SOX Controls are followed
  • Experience on compliance with naming standards
  • Participate as a team member in projects that require outages, upgrades and patches to databases
  • Produce documentation and procedures regarding the proper use and operation of the DBMS
  • Capacity Planning
  • Coordinate the resolution of DBMS problems that require DBMS vendor intervention
  • Opened PMR's and Service tickets to get the resolution from IBM for critical database issues
  • Experience with change control management for moving changes from Development to Production.
  • Supported on-call DBA responsibilities in UDB off-hour (24/7).

Confidential

DB2 DBA

Responsibilities:

  • Tuning of DB and DBM configuration parameters
  • Monitored the table space’s growth and added/extended the containers accordingly worked with data movement utilities IMPORT, LOAD, and EXPORT
  • Reorganizing Tables and Indexes for improving performance
  • Altered Buffer pool size and Threshold.
  • Monitored Databases using Database monitors, Snapshot Monitor, and Event Monitor.
  • Generating DDL using DB2LOOK utility
  • Done Backup (online and offline), Restore and Redirect Restore
  • Checked the database backup image's integrity using db2ckbkp
  • Granting database privileges to the users
  • Performance tuning the database for better and faster results
  • Table space management - Adding, dropping, extending, reducing and resizing table space containers
  • Exporting the data from production and loading it in test boxes
  • Sending daily and weekly reports and handovers.

Hire Now