19 Nov
|
pulsecrafts solutions
|
Bengaluru
19 Nov
pulsecrafts solutions
Bengaluru
Key Responsibilities
Database Administration And Support
- Administer DB2 database environments across the mainframe landscape, ensuring high availability, stability, and adherence to operational standards.
- Monitor database health, capacity, and usage trends to identify risks and proactively prevent service disruption.
- Support application teams and production operations with database-related troubleshooting, issue resolution, and day-to-day DBA activities.
Performance Tuning And Optimization
- Analyze query performance, buffer usage, locking behavior, and access paths to identify bottlenecks and improvement opportunities.
- Execute performance tuning initiatives using indexing strategies, statistics updates, and SQL optimization techniques.
- Ensure efficient database response times by continuously refining DB2 parameters, utilities, and workload behavior.
Backup Recovery And Disaster Recovery
- Plan and maintain robust backup, recovery, and restoration procedures to safeguard data continuity and operational resilience.
- Validate disaster recovery readiness by supporting recovery testing, contingency planning, and documented recovery workflows.
- Respond to incidents with urgency and precision to minimize downtime and restore database services efficiently.
Maintenance And Database Utilities
- Perform core DBA maintenance tasks such as reorgs, stats collection, utilities execution, and routine housekeeping activities.
- Manage DB2 objects and structures, including tables, indexes, and related database components, to ensure optimal functionality.
- Oversee maintenance windows and coordinate work execution to reduce operational impact on business-critical systems.
Change Management And Release Support
- Review and implement database changes aligned with approved change management processes and release schedules.
- Coordinate with development, testing, and operations teams to ensure accurate and controlled deployment of database changes.
- Track schema changes, DDL updates,
and database conversions while maintaining version control and audit readiness.
Data Integrity And Governance
- Safeguard data integrity by enforcing database standards, access controls, and validation practices.
- Support database design and data modeling activities to ensure scalable and maintainable structures.
- Maintain compliance with internal governance practices and operational controls across the database environment.
Oncall And Production Support
- Provide on-call support for critical production incidents, ensuring timely escalation, resolution, and communication.
- Collaborate with cross-functional teams during outages, incidents, and major releases to restore service quickly and safely.
- Document root causes, corrective actions, and preventive measures to strengthen future operational readiness.
Key Skills & Qualifications:
Must Have Skills
- 8 to 10 years of hands-on experience as a DB2 Database Administrator in a mainframe environment
- Robust expertise in DB2 administration, database maintenance, and production support
- Proficiency in SQL, DDL, DML, and DCL for database structure and data management
- Experience with JCL, DB2 utilities, reorgs, backup and recovery, and performance tuning
- Working knowledge of BMC MainView, File-AID, and related mainframe support tools
- Strong understanding of indexing, statistics, conversions, and database optimization techniques
- Ability to support disaster recovery planning, testing, and operational readiness
- Solid grasp of change management processes and controlled production deployment
- Strong communication skills with the ability to coordinate across technical and business teams
- Masters or post-graduation qualification in a relevant discipline
Good To Have Skills
- Experience with advanced database design and data modeling concepts
- Exposure to large-scale enterprise RDBMS environments and integration patterns
- Familiarity with automation opportunities for DBA tasks and operational efficiency
- Experience supporting regulated or audit-sensitive enterprise environments
- Strong documentation skills for standards, runbooks, and operational procedures
- Prior experience in high-availability, mission-critical production support environments
KPIs for Success in This Role:
- Maintain high database availability and minimize unplanned downtime across production systems
- Deliver consistently improved DB2 query performance and reduced response times
- Complete database maintenance activities, including reorgs and statistics updates, within agreed SLAs
- Ensure timely and successful backup, recovery, and disaster recovery preparedness
- Resolve production database incidents within target response and resolution windows
- Implement database changes with accuracy, minimal disruption, and full compliance to change control
- Improve data integrity, system reliability, and operational stability through proactive DBA practices
- Provide clear communication and effective coordination during on-call support and critical incidents
Why Join Us?
- Join a growing organization where your DB2 expertise will directly support mission-critical enterprise operations.
- Work on complex, high-impact mainframe database environments that demand technical excellence and ownership.
- Be part of a team that values reliability, performance, and disciplined operational practices.
- Contribute to database modernization, stability, and long-term data platform resilience.
- Take on a role that offers visibility, responsibility, and the opportunity to influence critical technology outcomes.
Pay: ₹1,000,000.00 - ₹1,200,000.00 per year
Work Location: In person
📌 Senior MainframeDatabase Administrator (Bengaluru)
🏢 pulsecrafts solutions
📍 Bengaluru