Urgent Need Sr DB2 DBA LinkedIn id
Core
Senior DB2 z/OS Database Administrator responsible for supporting large-scale operational, OLTP, and analytical databases, ensuring performance, availability, and security.
Role type
Senior IC database administrator (mainframe)
Builds
Production database environments for large-scale operational and analytical workloads
Domain
Mainframe database administration (DB2 z/OS)
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
DB2 z/OS administration, SQL performance tuning, database capacity planning, disaster recovery, data migration, stored procedures (SQL/Native/COBOL), database partitioning, sysplex environment management, IBM Admin tool suite, Omegamon, DB2 utilities (LOAD, UNLOAD, RUNSTAT, REORG, COPY, MERGECOPY, MODIFY, SPUFI), data modeling (Star Schema, ODS)
Preferred skills
Data modeling with Star Schema and ODS concepts, IBM Optim Move for DB2, Erwin or IDA data modeling tools, onshore/offshore model experience
Technologies
DB2 V10+, Z/OS, Omegamon v5.1+, Data Studio, Query Monitor, IBM Admin tool suite
Responsibilities
Database design, development, and administration of large-scale operational and analytical data structures; SQL performance tuning on OLTP and data warehouse environments; optimizing DB2 resource utilization; providing data migration support; leading and mentoring less experienced database analysts; providing on-call rotational 24/7 incident response; performing database capacity planning and trend analysis; deploying database changes in accordance with change management policies; maintaining data integrity through backup and restoration policies.
Seniority
Senior, hands-on IC with technical leadership
