| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes MS SQL DBA South Amboy, NJ Sr Oracle DBA AWS Solution Architect Irvington, NJ Oracle Hyperion Dba Edison, NJ DBA Princeton Junction, NJ Project Manager, DBA, Developer, Tester, Analyst, Unix, C#, SQL Staten Island, NY SQL DBA 10001 Oracle DBA Hicksville, NY |
|
Click here or scroll down to respond to this candidateCandidate's Name YERAMAKA
Email:EMAIL AVAILABLE
Phone: PHONE NUMBER AVAILABLE
DBA experience Summary:
Rich experience with DB2 UDB 9.1, 9.5, 9.7 and 10.5 Installations, Configurations and
Administration with strong database programming skills.
Expertise in using DB2 Movement Utilities like Export, Import and Load.
Good Experience on Restore the Backup images using Redirect Restore method from source
server to destination server.
Expertise in applying PATCHES (Fix Packs) on db2 servers.
Good experience on HADR setup lying between primary and standby servers.
Expertise in version migration from lower to higher versions.
Good knowledge on preparing purging policies and backup policies.
Scheduling database backups in Backup scripts using Cron Jobs and Scheduled Jobs..
Expertise in creating Instances, DB2 databases, bufferpools, Tablespaces as per client
requirement.
Good experience on monitoring archive mount points and data mount points and temp utilization.
Expertise in running REORG and RUNSTATS for better performance of the database.
Expertise in scheduling compressions on big tables and monitoring the reorgs and runstats.
Good experience on maintaining Database Level (DB CFG) and Database Manager Level
(Instance) Parameters.
Experience in design and maintenance of databases, performance tuning and troubleshooting.
Highly motivated team player with strong communication, analytical and interpersonal skills.
Capacity planning, reclaiming unused space.
TECHNICAL SKILLS:
OPERATING SYSTEMS AIX, Linux, Windows NT server, Sun Solaris
C, C++, VC++, SQL, PL/SQL
LANGUAGES
SCRIPTING Shell script
DB2(UDB 8.1 to 10.5)
DATABASES
HIGH AVAILABILITY SOLUTION HADR
Page 1 of 6
GUI DB2 Control center, Autosys, DB Artisan, Rapid Sql, Ignite,
CDC Console Management, Clear Case
TICKETING TOOL IBM Maximo, Citrix, BMC remedy tool, Service now
Insurance , Banking, Financial
DOMAIN KNOWLEDGE
PROFESSIONAL EXPERIENCE:
Client: All State Insurance Company, Chicago IL Feb' 15 to till Date
Role: UDB DB2 DBA
My Responsibilities:
Understand requirement of new project and estimate project duration and deliver it on time
Understand and execute new requirement on existing environment.
Work proactively to gauge the performance of the application & database and provide
recommendations to achieve the optimal architecture.
Maintain standard procedural documentation related to all aspects of operating the database
platforms.
Document known errors or workarounds in the shared Knowledge Base.
Work on different kind of issue raised by user.
Work on different JIRA request and insure timely completion of it.
Work on different issue related to Q replication.
Setup Q replication between different environments.
Onboard system/environment in different tools.
Create and Schedule automated scripts
Support different maintenance or environmental activity.
Environment: DB2 UDB LUW EE/EEE(DPF) V9.7 FP8, V10.1, AIX 5.3/6.1,Zlinux, Linux, Java,
WebSphere 6.1, putty.
Page 2 of 6
Client: Chrysler Group LLC
Role: UDB DB2 DBA Dec13jan15
Roles & Responsibilities:
Daily management, maintenance, monitoring, tuning and support for DB2 v9.0 and V9.5 databases in
UNIX environment (RHEL 5.0) and windows platforms.
Perform database software installations including database creation, configuration and applying fix
packs.
Responsible for application SQL Query tuning, database parameter tuning, operating system tuning,
memory tuning.
Database Backup/Recovery on databases and file system backups. Redirect Restore to move
application from Development, QA and Production.
Implement and test HADR performance for production environments.
Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration
phases and in performing post migration tasks
Daily and weekly database Maintenance and data movement activities such as backup, reorgchk, reorg,
run stats, export, import, load and all related activities for OLTP database.
Provide oncall support in adherence to specific business and customer Service Level Agreements.
Environment: DB2 UDB V9.0/V9.5, RHEL V5.0, Putty
PNC Bank, Ohio, USA
Role: DB2 UDB DBA Oct 12 Nov13
Roles & Responsibilities:
Expertise in development support activities including installation, configuration and successful
deployment of changes across all environments
Made recommendations to the managers on what hardware and software to purchase
Implemented Database partitioning and Archival logging in DB2 UDB
Worked on fix pack installation as well as version upgrades
Created databases and instances in DB2 UDB
Instituted new data definitions for system enhancements
Developed and maintained compliance to database standards and procedures
Understanding of database access and ability to assist developers in implementing efficient SQL code
Perform file system copy from production to nonproduction using TSM backup and
recovering DB2databases in nonproduction environment
Database sizing, Table space Management, Transaction Management and Security Administration
Establish standards, controls, and procedures to ensure data integrity and security
Responsibilities include disaster recovery, capacity planning and Real Time monitoring, troubleshooting
Page 3 of 6
and proactive maintenance
Helped developers in adhoc reports
Strong in performance monitoring and filetuning of database for optimal performance of SQL queries
using visual explain
Provide assistance to the development team on performance tuning, resolving locking solutions, assist
data modeler with SQL scripts
Data maintenance utilities used REORGCHK, REORG, RUNSTATS, BACKUP, RECOVER/RESTORE,
LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, IMPORT and INGEST
Performed routine maintenance, database performance tuning and monitoring
DB2Look utility is used to find all DDL and DML commands in the databases
Snapshot monitoring was done to detect deadlocks, buffer pools and lock escalations
Involved in writing scripts to trouble shoot triggers and stored procedures
Offshore coordination, work allocation, monitoring junior DBA's and work review etc
Provided production support for critical applications running on 24/7 basis
Duties included being oncall during the weekends, setting up restores, performing backups and creating
new tables, table spaces, buffer pools, etc.
Environment: DB2 UDB EE V 8.1 fp14, V 9.5 fp1, V9.7 FP1, AIX (5.3), Solaris 10, Java,
WebSphere 5.1.
Client: State Bank of India, Pune India Sep'10Aug'12
Role: UDB DB2 DBA
Roles & Responsibilities:
24x7 Production Support.
DB2 Installation on severs and upgradation.
Monitoring the database on Partitioned and nonpartition Environment
Participated in restructuring of Multipartition environment.
Solving Tickets Related to Any DB issue.
Conversion of tablespace storage type.
Used db2 governer and query patroller.
Deadlock detection and troubleshooting.
Page 4 of 6
Using db2top in efficient way.
Implementation of HADR
Write script to automate the regular activities, Reorg, Runstats, backup.
Automated regular monitoring like tablespace monitoring, memory, mount points, HADR
Interact with business team and development teams for new functionality and requirement.
Perform restore on different situation depending upon requirement
Apply fix pack on HADR, HACMP environment and troubleshooting.
Purging activity as per application team requirement.
Environment: DB2 UDB EE V 8.1 fp12, V 9.5 fp1, AIX (5.3), Solaris 9, NetBackup, Java,
WebSphere 6.0.
Client: CSCChennai, Tamil Nadu, INDIA
Role: UDB DB2 DBA June'08 Aug'10
Roles & Responsibilities:
24x7 Production Support.
Involved in database installation.
Handling DBA Tickets.
Fix pack installation.
Database, tablespace and DB objects creation and maintenance
Analyze and implement DB2 Reorg utility based on the need for database reorganization
SQL Analysis and optimization.
Monitor DB2 UDB databases for space utilization and performance degradation and tune
as needed.
Monitoring Backup, Roll forward, etc.
Determine need for DB2 UDB utilities and implement to enhance performance.
Backup and Recovery Procedures planning and implementation.
Performance tuning.
Migration from DB2 V8 to DB2 V9.
Daily / weekly /Monthly DBA maintenance tasks.
Environment: DB2 UDB EE V 8.1 fp12, V 9.0 fp1, AIX (5.3), NetBackup, Java, WebSphere.
Page 5 of 6
EDUCATION:
Bachelor of Technology, 2008, JNTU, India.
Page 6 of 6
|
