20 Nov
|
pulsecrafts solutions
|
Noida
20 Nov
pulsecrafts solutions
Noida
Key Responsibilities
Db2 Database Administration
- Administer DB2 environments by performing installation, configuration, upgrades, patching, parameter tuning, and ongoing maintenance to ensure stable and secure database operations.
- Manage database objects and structures including tables, indexes, schemas, procedures, constraints, and storage settings while supporting efficient schema changes and database design standards.
- Execute SQL and data operations using strong knowledge of SQL, DDL, DML, and DCL to support development, validation, troubleshooting, and operational database tasks.
Performance Tuning And Optimization
- Analyze and improve database performance by identifying bottlenecks, reviewing execution plans, and recommending corrective actions to enhance query and system efficiency.
- Optimize indexing and statistics to improve access paths, query response times, and overall workload performance across critical applications.
- Support capacity planning by monitoring usage trends, growth patterns, and performance indicators to maintain scalable and resilient database environments.
Backup Recovery And Disaster Recovery
- Implement backup and recovery procedures to safeguard data integrity and ensure rapid restoration in the event of outages, failures, or corruption.
- Support disaster recovery readiness through validation of recovery processes, documentation of runbooks, and participation in recovery testing and failover planning.
- Maintain high availability practices by ensuring continuity strategies are aligned with business continuity and operational requirements.
Maintenance Monitoring And Support
- Perform routine maintenance such as reorgs, housekeeping, database health checks, and storage management to maintain optimal system performance.
- Use monitoring tools effectively including BMC MainView and File-AID to diagnose issues, track alerts, and support proactive operational support.
- Respond to on-call needs by investigating incidents, resolving production issues, and ensuring timely communication with stakeholders during critical events.
Data Governance And Integrity
- Protect data integrity through disciplined administration practices, validation controls, and adherence to database standards and operational procedures.
- Support data management initiatives by contributing to data conversions, maintenance activities, and structured change execution across environments.
- Collaborate on data modeling and design to ensure database structures align with performance, reliability, and maintainability requirements.
Key Skills & Qualifications:
Must Have Skills
- DB2 database administration experience
- Solid understanding of DBA concepts and operational support
- Proficiency in SQL, DDL, DML, and DCL
- Experience with reorg, backup, recovery, and maintenance activities
- Knowledge of performance tuning, indexing, and statistics management
- Hands-on exposure to JCL and mainframe or enterprise database operations
- Familiarity with BMC MainView and File-AID
- Understanding of disaster recovery planning and execution
- Strong knowledge of RDBMS concepts, database design, and data integrity
- Excellent communication and stakeholder collaboration skills
- Master's degree or post-graduation qualification
Positive To Have Skills
- Experience with database conversions and migration activities
- Exposure to advanced capacity planning and trend analysis
- Knowledge of automation for database maintenance tasks
- Experience supporting high-availability or enterprise continuity environments
- Familiarity with performance diagnostics and root-cause analysis methodologies
KPIs for Success in This Role:
- Maintain database availability and stability with minimal unplanned downtime
- Complete backup and recovery processes within defined operational targets
- Improve query and system performance through tuning and indexing recommendations
- Ensure timely execution of reorgs, maintenance, and health check activities
- Resolve database incidents within agreed SLA timelines
- Maintain data integrity and compliance with internal database standards
- Support successful disaster recovery and recovery testing outcomes
- Deliver accurate and timely communication during production support and on-call activities
Why Join Us?
- Join a company that values operational excellence, reliability, and data-driven decision-making.
- Work on critical DB2 environments that directly support business performance and continuity.
- Gain exposure to complex database administration, tuning, and recovery challenges in a hybrid work model.
- Be part of a collaborative team where your expertise in DBA, performance, and data integrity has visible impact.
- Build your career with a permanent opportunity offering long-term growth and technical depth.
Education
PGMasters/Post-Graduation
Pay: ₹1,200,000.00 - ₹1,500,000.00 per year
Work Location: In person
📌 Database Administrator (Noida)
🏢 pulsecrafts solutions
📍 Noida