IBM DB2 Developer
Role: IBM DB2 Developer
Location: California - Remote (But need to travel 2 times every month on Tuesday)
Contract Role Summary We are looking for an experienced IBM DB2 Developer with strong expertise in database development, performance tuning, data integration, and database design. The role will focus primarily on DB2 development, with SQL Server development as an additional skill, and will work closely with application, analytics, and business teams to deliver scalable and reliable database solutions.
Key Responsibilities:
- Design, develop, and maintain IBM DB2 and Microsoft SQL Server database objects, including tables, views, indexes, stored procedures, functions, triggers, and packages.
- Develop and optimize complex queries, scripts, and database code to ensure high performance and scalability.
- Perform database performance tuning and troubleshooting, including query optimization, Explain Plan analysis, locking, deadlock, and concurrency issue resolution.
- Design and implement database schemas, data models, and relationships aligned with application and business requirements.
- Develop, support, and maintain ETL, data integration, migration, and data extraction processes across multiple data sources.
- Ensure database solutions meet required standards for data integrity, security, compliance, backup, recovery, and disaster recovery.
- Collaborate with application development, analytics, and business teams to translate requirements into effective technical solutions.
- Participate across the database lifecycle, including design reviews, code reviews, deployments, upgrades, release management, and technical documentation.
- Promote database development best practices, coding standards, and design standards across the team.
- Mandatory SkillsStrong hands-on IBM DB2 development
- Advanced SQL development and query optimizationDB2 stored procedures, functions, triggers, packages, indexes, and views
- Database performance tuning and troubleshooting
- Explain Plan analysis and query optimization
- Locking, deadlock, and concurrency troubleshooting
- Database schema and data model designETL, data integration, migration, and extraction
- Database deployment and release management
- Good-to-Have Skills
- Microsoft SQL Server development
- Experience working with multiple enterprise data sources
- Database security, backup/recovery, compliance, and disaster recovery knowledge
- Strong technical documentation and code/design review experience