Database Administrator (tsc)
tsc United States
2025-03-12
Job posting number: #211073 (Ref:tsc-351812)
Job Description
Mainframe DB2 System DBA
• Ability to manage a multi-DB2 Data Sharing / Sysplex environment
• Manage DB2 disaster recovery requirements and provide event support
• Proficiency in DB2 Systems Performance Tuning and Capacity Planning
• Proficiency in application related performance and tuning, access path analysis including extensive SQL coding tuning
• Proficiency in the use of DB2 monitoring tools (DB2PM, Insight, OMEGAMON, Detector, RMF other)
• Logical and physical database design skills
• Knowledge and understanding of an SDLC development lifecycle
• Working knowledge of application development/debugging tools (Data Studio, Visual Explain, etc.)
• REXX, HTML and/or java coding ability
• Perform database refreshes or clones upon request
• Support data import or export requests as required
• Create copies of data or databases as requested
• Create and maintain database links
• Plan table space reorganizations
• Execute table space reorganizations on a scheduled basis
• Monitor and manage database space (add data files as needed)
• Maintain database inventory
• Create database indexes as requested by Customer
• Create and manage database and metadata profiles
• Configure and manage database audit profiles
• Perform database restores or recovery from export dumps or backups, archived logs or SAN
• Create, refresh development, test and staging databases from production data
• Implement database data definition requirements for applications (e.g., IMAC for tables, triggers, attributes, stored procedures)
View Orignal JOB on: italents.net
• Maintain documentation for all database instance parameters and system settings
• Implement database data definitions for applications and developer schemas
• Define and execute database start up, shutdown, performance monitoring and tuning scripts, and keep database running at defined service levels for the required workload
• Implement and administer appropriate database management Tools across all database instances. Performance metrics and historical data must be available for trending and reporting in order to meet Customer requirements
• Proactively identify and remediate bottlenecks (e.g., locking conflicts, latch contention, rollback requirements) for all database instances
• Resolve locking conflicts, latch contentio n, rollback requirements, problematic SQL, processes, etc., for all database instances
• Proactively monitor databases and report Incidents to the Service Desk
• Open, track, and manage to Resolution all database Incidents and Problems
• Import new versions of database code components supplied by application support and allow for rollback of data
• Patch database Software as needed according to development to QA to production life cycle, and provide one annual new version release update and unlimited minor patches and emergency releases, as necessary
• Execute Customer’s database backup and recovery policies
• Execute performance testing, database tuning, and threshold activities for both ongoing and project work
• Periodically run Tools to determine and validate database integrity
• Support database user ID administration
• Implement database security per design
• Provide security administration, including Service Requests, managing role and End User database permissions in accordance with Customer Policies
• Maintain consistent database parameters and system settings across all like instances according to Customer-approved development-to-quality assurance-to-production life cycle, including security and data privacy
• Collaborate with Customer in penetration test activities and perform database tuning to mitigate security risks identified in penetration test activities
Salary Range- $100,000-$120,000 a year
#LI-CO1
#LI-SN1