Duration : 12 months
ROLE: Application DBA/SQL Developer
Responsibilities • Conducts SQL query tuning and optimization in a DB2 environment
• Monitors and tunes DB2 using IBM DataStudio
• Provides management of databases, backup/recovery, archiving, space management, table performance tuning
• Provides Logical and Physical data modeling
• Works with application groups to design and implement the database requirements
• Provides DB2 security, provide assistance for BIND problems
• Interacts with operations staff on production problems and ensure adequate production procedures are in place
• Provides assistance to end users SQL requests
• Monitors and tunes database performance during testing and production operations; coordinates and implements database sizing/resizing, restructures and index rebuilds; assists with capacity planning for future database growth; documents benchmarks and procedures needed to optimize performance; ensure that all performance guidelines are followed • Develops and modifies database definitions including entities, attributes, relationships, and referential integrity triggers. Maintains detailed database design documentation • Develops, maintains and supports procedures, standards and interfaces for centralized database management • Installs, patches, upgrades, maintains, and supports DB2 in all environments
• Implements database access procedures including User ID administration
• Implements Database Change Requests (DBCRs), i.e., data repairs
• Assists application development and maintenance staff with database questions and issues
• Plans and implements strategies and procedures for physical disaster/recovery and contingency planning. Establishes mechanisms for replicating production databases in development environments
• Provides problem resolution support, specific to database issues; identifies and resolves database problems, coordinating with application users to determine symptoms and ensure accurate problem definition
• Assists in development and improvement of database administration-related plans, processes, procedures, standards and priorities.
• Maintains detailed knowledge of all database administration processes, procedures, and quality standards
REQUIRED SKILLS:
• 5+ years of experience with DB2 SQL development and DB2 administration
• 4 years of progressively complex experience and intermediate-level skill in analysis, architecture, design, installation, configuration, administration, operation, and maintenance of database systems, two (2) of which must have been in a technical lead position.
• 2 years of experience and intermediate-level skill supporting very large, complex automated systems using both custom and off-the-shelf enterprise and business applications. Intermediate-level skill and knowledge in database design and development, as evidenced by the following:
• 2 years of experience filling a lead role as a database administrator
• Experience working with IBM PureScale
• Experience working with IBM Data Studio
• Intermediate-level skill and knowledge of at least eight (8) of the following database design, development, and administration-related concepts, methods, and tools:
o Physical and Logical Data Modeling (e.g., with UML)
o Database Definition Language (DDL) o Writing SQL stored procedures
o Index analysis
o Normalization and de-normalization
o Referential integrity
o Data replication concepts1/1 o Locking Strategies
o Reporting Tools o Extract Transform and Load (ETL) tools o analytical processing (OLAP), etc.
Thanks & Regards,
Krish @ Compusoft Integrated Solutions Inc.
Direct: 248-419-0533 ||Fax : 248-538-8435
E-mail: krish@compusoft-is.com
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment