:: "DB2 Database Administrator" || Chicago IL || BCBSA

[Vikrant Chaudhary]

*DB2 DBA*

*Location*: Chicago IL

*Rate*: DOE

*Duration*: 6+ months Contract

*Interview Mode*: Phone interview then F2F/In- person

*End Client*: BCBS Association



 *Responsibility:*

· Plan work to meet project deadlines, accommodate demands by
development teams, set priorities and escalate issues appropriately

· Establish SQL Programming best-practices and standards based SQL
components programming templates (e.g. stored procedures, triggers, data
type rules and error handling)

· Conducts Performance Tuning on specific SQL and underlying Oracle
system.

· Assists Data Architect with physical design specifications.

· Understand logical schemas and generate & maintain physical
schema (tables, stored procedures, indexes etc.) as per the physical design
specifications.

· Supports development and testing teams with Oracle environment
needs, code-promotions and code deployments.

· Ensure the quality and integrity of data are maintained as design
and functional requirements change.

· Develop repeatable mechanism and procedures to load data for
development, testing and performance engineering activities.

· Develop and document Database design/implementation impacts based
on system monitoring reports.

· Direct and lead developers and analysts on SQL query development
and tuning

· Ability to participate in multiple projects concurrently

· Excellent communication skills (verbal, written and
presentation), customer service-oriented

· Strong problem solving skill set, and the ability to understand
new technologies quickly are essential

· Monitor database management systems as well as evaluating
database performance to maximize efficiency

· Work in an environment that practices strict change management

· Provide recommendations to application development teams for data
restructuring and performing complex maintenance

· Working knowledge of Agile/Scrum and participates in Agile/Scrum

· Deploy and manage changes in development, staging and production

· Involve in a rotation for on-call after hour for database support

· Design and optimize database and table partitioning strategy

· Design and fine tune SQL execution plans for best performance

· Design table structure (including indexing strategy) to optimize
SQL execution with focus on Java/Cognos/ETL performance

· Design rollout and migration strategies for new and existing
applications

· Enforce best practices in database development with focus on
performance and security

· Establish protocols to monitor performance (e.g. ADDM Analysis)



*Required Skills*

· The ideal candidate will have 8+ years of hands-on experience
with DB2 UDB v9.7 or later and DB2 utilities.

· 5+ years of database design and modeling for data warehouses and
OLTP databases, includes: definition, structure, documentation,
maintenance, long-range requirements, operational guidelines and protection.

· Provide technical expertise when interfacing with teams and
technologies that utilize and integrate with the databases.

· Provide problem remediation and root cause analysis for DB2 issues

· Expertise in optimize performance of DB2 databases is required.

· Excellent DB2 trouble shooting and performance analysis skills
are vital to this position.

· Flexibility to work with various technical and business user
teams to enhance enterprise application and database performance and
security is required.

· Excellent verbal and written communication skills are required.

· Excellent in SQL tuning.

· Monitoring, analysis, and tuning of DB2 UDBe databases and tuning
of SQL to achieve optimum performance.

· Extensive knowledge of data integration and processing including
extraction, transformation, and loading (ETL) using Data Stage, Informatica
or Ab Initio.

· Outstanding Communications Skills.

· This position provides on-call support in a 24 x 7 environment
and requires coverage after normal hours and on weekends.

· B.S. in Computer Science of equivalent.





Thanks,

*Amit Raj*


*Samson Software Solutions, Inc*

Email: *ami...@samsonsoft.com *
www.samsonsoft.com

-- 
You received this message because you are subscribed to the Google Groups 
"Business_Intelligence" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to business_intelligence+unsubscr...@googlegroups.com.
To post to this group, send email to business_intelligence@googlegroups.com.
Visit this group at https://groups.google.com/group/business_intelligence.
For more options, visit https://groups.google.com/d/optout.

DB2 Database Administrator-Chicago,IL

[Surendra Tummalacherla]

Hi,
We have a urgent opening on DB2 DBA position,
If you are interested please respond me ASAP to *suren...@palni.com
suren...@palni.com*,

*Role : DB2 Database Administrator*
*Location : Chicago,IL*
*Duration : Long term*

*Skills Required:*

   - Minimum of 7 years experience working with DB2
   - Multi-partition skills with large sized databases
   - 7-10 years experience in Information Systems
   - Strong team player with good interpersonal skills.
   - Should be a self starter who can work independently.
   - Strong problem solving skills and the ability to determine the root
   cause of complex problems.
   - Good written and verbal communication skills. Has the ability to
   communicate with both technical and non-technical audiences.
   - Ability to learn and assimilate new information quickly.
   - Proven project management skills and the ability to coordinate
   activities with other areas.
   - Proven performance  tuning experience
   - UNIX Platform experience,

-- 
You received this message because you are subscribed to the Google Groups 
Business_Intelligence group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to business_intelligence+unsubscr...@googlegroups.com.
To post to this group, send email to business_intelligence@googlegroups.com.
Visit this group at http://groups.google.com/group/business_intelligence.
For more options, visit https://groups.google.com/d/optout.

DB2 Database Administrator for IL

[uday]

Hi

Please let me know if you would be interested in the below mentioned
position:

Please send resumes to *u...@addonusa.com u...@addonusa.com *





*Role:  DB2 Database Administrator*

*Location: Chicago, IL(Local to IL)*

*Duration:3 Months*

*Interview:Phone+F2F*





Database Administrator will work with physical database tables and design,
will work withsystem administrator and use data dictionary software
packages to ensuredata integrity and security, recover corrupted data and
eliminate dataredundancy. Use tuning tools to improve database performance.
Work withthe application development teams, focusing on the back-end
portion of datastorage considerations and performance considerations for
applicationsystems being developed.

*MUST HAVES:*

· Excellent knowledge of DB2 Version 9.7 and DB2 V10.5 for AIX
Operating System.

· In-depth knowledge and experience in DB2 AIXwithin an enterprise
level environment

· Very strong knowledge of HADR,replication, CDC, range
partitioning, disaster recovery with businesscontinuity, Perform routine
maintenance (Backup and Recovery, REORGS,
RUNSTATS, etc.), Stored Procedures, Provide Load and Performance
testingsupport, Monitor database space usage, Monitor database
performancebottlenecks, etc., Unix Scripting skills (Perl, Shell, VBS, etc.)

· Knowledgeof load balancers, Independently solves complex problems

Takes a newperspective using existing solutions, works independently,
receives minimalguidance



Thanks  Regards,

*Uday*

*Technical Recruiter*

*Addon Technologies, Inc*

17197 N.Laurel Park Drive

Suite 513|Livonia|MI|48152

Fax: 734-418-2603

*E mail: u...@addonusa.com u...@addonusa.com*

*URL:www.addonusa.com http://www.addonusa.com*
  Jesus saved the thief
on the holy hill of Golgotha because of one hour's faith;
will he not save you too since you have believed? Luke 23:42

-- 
You received this message because you are subscribed to the Google Groups 
Business_Intelligence group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to business_intelligence+unsubscr...@googlegroups.com.
To post to this group, send email to business_intelligence@googlegroups.com.
Visit this group at http://groups.google.com/group/business_intelligence.
For more options, visit https://groups.google.com/d/optout.