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.