MSR Technology Group ยท 5 hours ago
DB2 Admin
Jacksonville, FL
Full-time
Remote
Entry, Mid Level
Maximize your interview chancesBusiness Consulting and Services
Insider Connection @MSR Technology Group
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Install, configure, and maintain IBM DB2 databases on Linux, UNIX, IBM Could platforms.
Perform database upgrades and patches to ensure the environment is up to date and secure.
Manage database objects (tables, indexes, views, etc.) and ensure proper data integrity and normalization.
Handle database partitioning, clustering, and replication tasks.
Monitor and analyze database performance, identifying bottlenecks and tuning SQL queries for optimal performance.
Utilize tools such as IBM Data Studio, or third-party software for performance monitoring.
Conduct regular database health checks and make recommendations for improvements.
Design and implement robust backup strategies, including automated backups, point-in-time recovery, and disaster recovery planning.
Perform DB2 database restores and recoveries, ensuring minimal downtime.
Manage database log files and ensure recovery capabilities.
Perform regular maintenance tasks, including reorganization, compression, and data archiving.
Manage large volumes of transactional data and optimize database performance for OLTP and OLAP systems.
Troubleshoot and resolve database issues, including connectivity, performance, and corruption problems.
Provide support to development teams for database design, query optimization, and performance tuning.
Support high-availability environments and participate in on-call rotations for after-hours support.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Expertise in database configuration, tuning, security, backup, recovery, and troubleshooting within both distributed and mainframe environments.
Install, configure, and maintain IBM DB2 databases on Linux, UNIX, IBM Cloud platforms.
Perform database upgrades and patches to ensure the environment is up to date and secure.
Manage database objects (tables, indexes, views, etc.) and ensure proper data integrity and normalization.
Handle database partitioning, clustering, and replication tasks.
Monitor and analyze database performance, identifying bottlenecks and tuning SQL queries for optimal performance.
Utilize tools such as IBM Data Studio, or third-party software for performance monitoring.
Conduct regular database health checks and make recommendations for improvements.
Design and implement robust backup strategies, including automated backups, point-in-time recovery, and disaster recovery planning.
Perform DB2 database restores and recoveries, ensuring minimal downtime.
Manage database log files and ensure recovery capabilities.
Perform regular maintenance tasks, including reorganization, compression, and data archiving.
Manage large volumes of transactional data and optimize database performance for OLTP and OLAP systems.
Expertise on cloud platforms (IBM Cloud, Google Cloud) is critical.
Troubleshoot and resolve database issues, including connectivity, performance, and corruption problems.
Provide support to development teams for database design, query optimization, and performance tuning.
Support high-availability environments and participate in on-call rotations for after-hours support.
Company
MSR Technology Group
At MSR Technology Group (MTG), we ignite growth for businesses across diverse industries.
Wilmington, Delaware
1,001-5,000 employeesFunding
Current Stage
Late StageCompany data provided by crunchbase
