SQL/DB2 Database Developer

  • Torrance, CA
  • Contract

Company Description

iSpace is a global services company focused on outsourcing, consulting and staffing. Over the last decade, we have helped numerous corporations and institutions reach their business objectives and IT goals.

iSpace services are centered in three areas - IT Outsourcing, IT Staff Augmentation, and Business Process Outsourcing. Our team of seasoned professionals based in the United States and India focus on providing results, driving innovation and affecting outcomes. Our clients have come to rely on our expertise, our commitment to quality, customer service and our innovative approach to problem solving to help create sustainable value for their customers and shareholders.i

Specializing in Healthcare, Entertainment, Automobile and Financial Services, we work with Fortune 1000 companies throughout the United States. Our commitment to customer satisfaction is reflected in the fact that over 90% of our client base have remained with us for over 5 years.

Job Description

Position: SQL/DB2 Database Developer

Duration: 12 Months

Location: Torrance CA

 

Description
General Responsibilities:

-        Provide Database development support for Client’s public websites

-        Troubleshoot and correct bugs/defects related to database objects

-        Analyze, design and code database enhancements

-        Perform unit, system and integration testing of database objects as appropriate

-        Assist the QA analyst, programmers and architects

-        Assist the other DBA’s and programmers as necessary

Qualifications

Skills and Experience:
Microsoft SQL Server:

-        3+ years experience with Microsoft SQL Server 2008

-        2+ years of experience in and SQL Report Services

-        3+ experience in SSIS ETL development

 

DB2 Experience

-        3+ years experience working on DB2 LUW

-        Must be familiar with DB2 Packages, Privileges, and database connectivity

-        Must possess good understanding of DB2 LUW utilities, commands, and standard DB2 LUW tools

-        Must have experience in utilizing DB2 specific Application Programming Interfaces (APIs)

-        Must have developed in DB2 LUW V9.1, V9.5, or V9.7 (nice to have V10.1)


Other Technical Experience

-        Experience with Crystal Reports & Reporting Services

-        Experience with Data Replication

-        Must be proficient in ANSI SQL

-        Proficient in C# as it applies to CLR stored procedures and SSIS development

-        Good understanding of Microsoft Web Technologies

-        Should have demonstrated ability to Analyze, design, develop and evaluate complex databases and stored procedures

-        Must have excellent background in producing high quality, structured, and production ready code

-        Should have demonstrated ability to work with Views, Data Dictionaries, UDF’s

-        Ability to analyze, evaluate and optimize data structure

-        Must have excellent background in producing high quality, structured, and production ready code

-        Must have scripting language experience: Korn Shell, C Shell, Bash, PERL (for Linux/Unix environment)

-        Good working knowledge of various Database Architectures (transactional vs. Reporting, etc...)

-        Experience working with Agile Methodologies


Other Requirements

-        Experience working in a team environment

-        Must be highly motivated self starter

-        Willingness to work outside of normal working hours when required