Greetings. Please find below the available consultant currently available for projects Nationwide unless specified. Your help support and coordination is highly appreciated.
Please let me know if you can consider for any of your open requirement.
Here is the summary of this consultant
Name : Vignesh(DB2 DBA)
Current Location : OH
Relocation : Anywhere in U.S.
Experience : 8+ years
SUMMARY:
--
· Over 8 years of IT experience involving database administration at all phases of database development lifecycle i.e. design, development, implementation and maintenance and support of databases using DB2 V8.x/9.1/9.5/9.7 on AIX, Linux, Solaris, HP-UXand Windows.
· Migrated or upgraded DB2 UDB databases and installing Fix Packs to keep DB2 at most recent level.
· Involved in the database and application design reviews and designed and built the physical database structures using the logical model.
· Database monitoring and tuning experience using Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisorperformance tools.
· Implemented MDCs, MQTs, Replicated MQTs and Statistical Views in the Data Warehouses and Marts for the optimal performance.
· Experience on Database Partitioning Feature (DPF) for maintaining very large databases.
· Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
· Worked with third party utilities and tools like Toad and Quest Tools, IBM Data Studio, BMC Tools and Optim tools etc.
· Experienced in database administration tasks like SQL coding, Stored Procedures, Triggers, Referential Integrity, Index strategies, and SQL Troubleshooting.
· Experienced in running DB2 utilities like EXPORT, IMPORT, LOAD, DB2MOVE, REORG, RUNSTATS and DB2LOOK.
· Extensive experience in writing Korn shell scripts to automate database maintenance activities.
· Opened PMR's to get the resolution from IBM and collect the db2support, DB2DART (to verify architectural correctness of databases and objects), utilize CLI and db2trc for problem analysis and resolution.
· Proficient in scheduling/maintaining CRON/Autosys jobs based on application requirement.
· Excellent Interaction with clients, functional and business analysts and department Managers and different levels of users and developers and experience with Software Development Life Cycle.
· Experienced in educating and mentoring the users and developers about the DB2 best practices.
· Provide 24x7 on call support for databases supporting mission critical applications and off-hours maintenance.
· Excellent communication and interpersonal skills and being able to work independently with minimal or no guidance.
Technical Skills:
RDBMS : DB2 UDB 8.x/9.1/9.5/9.7/10.1, DB2/ZOS, SQL Server 2000/2005/2008
Operating Systems : AIX 5.3, 5.L, 6.1, Linux, Solaris, HP-UX, Windows XP/NT
Utilities/Tools : db2top, db2pd, db2batch, DB2 Performance Expert, Quest Central, Spotlight, BMC Patrol, IBM Query Patroller, TOAD, DB2 Connect, Event Monitor, Snapshot Monitor, TSM, Control-M, Data Propagator (DProp), Replication Center, IBM Optim Tools
Source Control : Manage Now, Rational ClearCase, MS VSS, SVN
Scripting/Languages : Shell Scripting (Bash, Korn), SQL Programming, PL/SQL, .NET, C, Java
ETL Tools : Informatica 8.6.1, SSIS, DataStage
Reporting Tools : Business Objects (BOXI R2), SSRS
Data Modeling : Erwin, IBM Infosphere Data Architect
To receive resume in word format kindly email to Swetha@keybusinessglobal.com
I would very much appreciate hearing from you and having opportunity to serve you on your needs. Looking forward to a fruitful interaction with you and your organization
Regards,
Swetha
Key Business Solutions, Inc.
|| Office: 916 514 6728 || Fax: 916 646 2081 || Email: swetha@keybusinessglobal.com || Website: www.keybusinessglobal.com ||
Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our mailing list.
You received this message because you are subscribed to the Google Groups "Jobs for USA consultants (Citizen G.C and H1B)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobs-for-usa-consultants-citizen-gc-and-h1b+unsubscribe@googlegroups.com.
To post to this group, send email to jobs-for-usa-consultants-citizen-gc-and-h1b@googlegroups.com.
Visit this group at http://groups.google.com/group/jobs-for-usa-consultants-citizen-gc-and-h1b.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment