Senior DBA - SQL Server & DB2 on z/OS | Hybrid
Persistent Systems Limited
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
Persistent Systems Limited is seeking a skilled Database Administrator (DBA) with strong expertise in MS SQL Server and IBM DB2 to support BigID onboarding, data governance, retention, archival, and deletion across enterprise healthcare systems. The role emphasizes T-SQL proficiency, performance tuning, and lifecycle management.
The ideal candidate will design schemas, optimize queries, ensure data security and compliance, and collaborate with cross-functional teams to enable data-driven
Qualifications
- 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.
Responsibilities
- Prepare and onboard databases for BigID scanning and policy execution.
- Develop and maintain database objects, scripts, and automation processes.
- Support archival, retention, and deletion initiatives.
- Design database schemas, data models, and integrations.
- Monitor and optimize database performance.
- Ensure data security, compliance, backup, and recovery standards.
- Collaborate with application, analytics, and infrastructure teams.
Skills
Tools
Job description
Persistent Systems Limited is seeking a skilled Database Administrator (DBA) with strong expertise in MS SQL Server and IBM DB2 to support BigID onboarding, data governance, retention, archival, and deletion across enterprise healthcare systems. The role emphasizes T-SQL proficiency, performance tuning, and lifecycle management.
The ideal candidate will design schemas, optimize queries, ensure data security and compliance, and collaborate with cross-functional teams to enable data-driven
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
