Senior DB2 SQL Developer

Persistent Systems

United States

Hybrid

USD 110,000 - 160,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid work
Education sponsorship
Long Service awards
Health insurance

Job summary

Persistent Systems is seeking a Senior DB2 SQL Developer with DBA knowledge to join our healthcare data initiatives in Alameda, California. The contract role requires 7 to 8 years of experience, strong expertise in SQL Server and IBM DB2, and hands-on TSQL, performance tuning, ETL, and data governance.

You will design, develop, and optimize database objects, implement data integration and archival processes, and collaborate with cross-functional teams to deliver scalable, compliant data

Qualifications

  • Experience with MS SQL Server and IBM DB2 on zOS.
  • Strong proficiency in TSQL, stored procedures, functions, and performance tuning.
  • Experience with ETL, Data Migration, Data Integration, and HCM Extract.

Responsibilities

  • Design, develop, and maintain SQL Server and IBM DB2 database objects.
  • Develop and optimize complex SQL queries and database code.
  • Perform database performance tuning, query optimization, locking, and concurrency troubleshooting.
  • Design and implement database schemas, data models, and relationships.
  • Develop and maintain ETL, data integration, and migration processes across sources.
  • Ensure data security, backup, and disaster recovery standards.

Skills

MS SQL Server
DB2 on zOS
TSQL
Stored Procedures
Functions
Triggers
Performance tuning
ETL
Data Migration
Archiving/Retention
Security/Backup/DR

Tools

Azure SQL
Azure Blob Storage
BigID

Job description

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem.

Our disruptor's mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We reported $1,654.4M FY26 revenue with 17.4% Y-o-Y growth. We have delivered 24 sequential quarters of growth with $436.0M in Q4 FY26 revenue, up 3.2% Q-o-Q and 16.2% Y-o-Y growth. Our 27,500+ global team members, located in 18 countries, have been instrumental in helping the market leaders transform their industries. We have been recognized as the Fastest Growing IT Services Brand Globally in the 2026 Brand Finance IT Services 25 Report. We named a Leader in the Everest Group Private Equity (PE) Services PEAK Matrix® Assessment 2026 and Software Product Engineering PEAK Matrix® Assessment 2026.

Job Title: Senior DB2 SQL Developer with DBA knowledge

Location: Alameda, California

Job Type : Contract

Years of Experience: 7 to 8 Years

About Position

We are seeking a skilled Database Administrator (DB2) with strong expertise in SQL Server and IBM DB2. The ideal candidate will have a solid background in TSQL, Performance Tuning, ETL, ARCHIVING, and Database Lifecycle Management. This role will support BigID onboarding, data governance, retention, archival, and deletion initiatives across enterprise healthcare systems.

What You'll Do
  • Design, develop, and maintain SQL Server and IBM DB2 database objects, including tables, views, indexes, stored procedures, functions, triggers, and packages.
  • Develop and optimize complex SQL queries, scripts, and database code, ensuring 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 to support business and application requirements.
  • Develop, support, and maintain ETL, data integration, migration, and data extraction processes across multiple data sources.
  • Ensure data integrity, security, compliance, backup, recovery, and disaster recovery standards are consistently maintained.
  • Collaborate with application development, analytics, and business teams to translate requirements into effective database solutions .
  • Participate in the full database lifecycle, including design reviews, code reviews, deployments, upgrades, release management, and technical documentation while promoting database best practices and standards.
Mandatory Skills
  • Strong hands-on experience in MS SQL Server and DB2 on z OS.
  • Expertise in TSQL, Stored Procedure, Functions, Triggers, Views, Indexes, and Packages.
  • Database performance tuning, query optimization, locking, deadlock, and concurrency troubleshooting.
  • Experience with ETL, Data Migration, Data Integration, and HCM Extract.
  • Knowledge of ARCHIVING, retention, purge, and deletion processes.
  • Database security, backup/recovery, replication, and Disaster Recovery.
Preferred Skills
  • Experience with Azure SQL, Azure Blob Storage, and related Azure IaaS.
  • Understanding of Data Governance tools such as BigID.
Expertise You'll Bring
  • The successful candidate will bring a combination of technical expertise and a proactive approach to database management,
  • Ensuring optimal performance and compliance with data governance standards.
  • Your ability to collaborate effectively with cross-functional teams will be essential in driving successful outcomes in our healthcare data initiatives.
  • Competitive salary and benefits package
  • Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
  • Opportunity to work with cutting-edge technologies
  • Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
  • Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents
Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

  • We support hybrid work and flexible hours to fit diverse lifestyles.
  • Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
  • If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment
Let's unleash your full potential at Persistent - persistent.com/careers
"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Server- Database Administrator (DBA)
SQL Server- Database Administrator (DBA)

Persistent Systems • New Jersey

Hybrid
USD 110,000 - 150,000
Competitive salary
Hybrid work
Professional growth
+2
Senior DB2/SQL Developer (DBA) — Hybrid Alameda Contract
Senior DB2/SQL Developer (DBA) — Hybrid Alameda Contract

Persistent Systems • United States

Hybrid
USD 110,000 - 160,000
Hybrid work
Education sponsorship
Long Service awards
+1
Senior DB2 Mainframe Programmer
Senior DB2 Mainframe Programmer

360 IT Professionals Inc. • Austin (TX)

On-site
USD 100,000 - 120,000
Group health insurance
Sr Azure Data Engineer
Sr Azure Data Engineer

Persistent Systems • New Jersey

Hybrid
USD 120,000 - 160,000
Competitive salary
Talent development
Cutting-edge technologies
+2
Urgent Need Sr DB2 DBA LinkedIn id
Urgent Need Sr DB2 DBA LinkedIn id

USM • Cincinnati (OH)

On-site
USD 90,000 - 120,000
Sr. DB2 Programmer / Developer
Sr. DB2 Programmer / Developer

360 IT Professionals • Austin (TX)

On-site
USD 100,000 - 120,000
Group health insurance
Lead DB2 DBA: Strategy, 24x7 Support & Optimization
Lead DB2 DBA: Strategy, 24x7 Support & Optimization

Usmsystems • Saint Paul (MN)

On-site
USD 90,000 - 120,000
Senior DB2 z/OS Lead DBA – OLTP & DW
Senior DB2 z/OS Lead DBA – OLTP & DW

Usmsystems • Cincinnati (OH)

On-site
USD 90,000 - 120,000
Senior IBM i Technical Architect
Senior IBM i Technical Architect

Persistent Systems • Philadelphia

On-site
USD 140,000 - 170,000
Hybrid work and flexible hours
Competitive salary and benefits
Education sponsorship and professional
+1
Database Administrator at TEKsystems Omaha, NE
Database Administrator at TEKsystems Omaha, NE

TEKsystems • Omaha (NE)

On-site
USD 14,000 - 17,000
Medical, dental & vision
401(k) Retirement Plan
Life Insurance
+5