Job Description :
Role: Mid-level DBA
Location: Mechanicsburg, PA
H1B need not to Apply
Required skills:
DB2 DBA, Hands on experience on Query Tuning and optimization.
3+ years of experience with DB2 SQL development and DB2 administration• Experienced in analysis, architecture, design, installation, configuration, administration, operation, and maintenance of database systems• Experienced in supporting very large, complex automated systems using both custom and off-the-shelf enterprise and business applications. • Good in database design and development, as evidenced by the following:o Experience working with IBM PureScaleo Experience working with IBM Data Studioo Candidates have experience with DB2 UDB for Linux• Good in the database design, development, and administration-related concepts, methods and tools such as PDM, LDM, DDL, SPs, Index analysis, Normalization and de-normalization,Referential integrity, Locking Strategies, Reporting Tools and analytical processing (OLAP)• Proficiency in writing SQL procedures, functions and packages for administration and application support and experience with Q replication, Range partitioned tables, Hash partitioned tables, Replicated MQT and MDC• Experience in working with db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advis, db2explain, db2diag• Experience providing appropriate Database Performance tuning support with