About the position
The DB2 System DBA position requires a highly skilled individual with more than 6 years of related work experience. The role involves various responsibilities including infra solutioning on MDM with various products, performing database refreshes or clones upon request, and supporting data import or export requests as required. The DBA will create copies of data or databases, maintain database links, and plan and execute table space reorganizations on a scheduled basis. Additionally, the DBA will monitor and manage database space, maintain database inventory, and create database indexes as requested by customers. The position also involves creating and managing database and metadata profiles, configuring and managing database audit profiles, and performing database restores or recovery from export dumps or backups.
Responsibilities
- 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
- 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
- Implement and administer appropriate database management Tools across all database instances
- Proactively identify and remediate bottlenecks for all database instances
- Resolve locking conflicts, latch contention, rollback requirements, problematic SQL, processes, etc.
- 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
- Patch database Software as needed according to development to QA to production life cycle
- 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
- Maintain consistent database parameters and system settings across all like instances
- Collaborate with Customer in penetration test activities and perform database tuning to mitigate security risks
Requirements
- More than 6 years related work experience
- Experience with infra solutioning on MDM with various products
- Strong knowledge of database management and administration
- Experience in database backup and recovery processes
- Proficiency in performance monitoring and tuning of databases
- Ability to manage database security and user permissions
Benefits
- Salary Range: $100,000-$120,000 a year
