Job Description :
We are looking for consultants for multiple location:
Position : DB2 DBA
Senior Applications DBA for DB2 –
Provide primary database architectural and administrative support for new projects (such as Data Modeling, Attribution and Referential Integrity Assure that Database availability and performance meets or exceeds customer SLA’s. Available as DBA for large, mission-critical applications, as well as application development support to a large developer community. Assist Application Development Project Lifecycle, from design, configuration, and construction, through migration to production, as well as SQL optimization and post-implementation support. Assist Application Development Maintenance and Enhancement activities – including, but not limited to, schema changes and code reviews. Configure and install logical database objects. Configure and install Stored Procedures and Triggers. Define Application Objects. Define application disk storage requirements. Create/execute tests for Application Objects. Maintain security to Application Objects. Determine, prioritize and modify queries, reports and views. Perform SQL query performance analysis & optimization. Troubleshoot and resolve Application problems. Perform application table data conversion. Provide support for customer problems and requests. Provide expert technical assistance to team members where needed. Define physical data models for Data Warehouse needs. Define DPF (database partitioning features) and clustering strategy. Assist with and lead SQL performance and tuning efforts
Expertise and/or relevant experience preferred/desired:
Natural
COBOL
SAS
CURAM
J2EE