Sr Consultant - SQL DBA Job

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

We are looking forward to hire SQL DBA Professionals in the following areas :

Experience

5-10 Years

Job Description

Position: MS SQL & Oracle DBA

Experience: 5–10 Years

Location: Preferably NCR

Key Responsibilities

• Administer and support MS SQL Server databases across environments
• Ensure database availability, performance, security, and reliability.
• Implement and manage backup, recovery, HA/DR strategies.
• Perform performance tuning through indexing, query optimization, and capacity planning
• Monitor database health and resolve production issues.
• Support data migration and modernization initiatives.
• Ensure security, compliance, auditing, and access control.
• Collaborate with DevOps, application, and infrastructure teams.
• Provide on-call support for critical incidents (P1 or P2).
• Minimal experience in Oracle Database admin is good to have.
  
  

Oracle Specialization (Preferred)

• Experience with Oracle RAC, Data Guard, ASM.
• Monitoring using OEM, AWR, ASH, ADDM
• Strong Linux/Unix and shell scripting skills
  
  

Required Skills

• Oracle DBA, MS SQL DBA
• SQL, PL/SQL, Performance Tuning
• Backup/Recovery, Security, HA/DR
• Linux/Unix, Scripting
  
  

Customer Management

Required Technical/ Functional Competencies

• Has working knowledge of customers business domains and technology suite.
• Use latest technology, proactively suggest solutions to increase business, and understand customers business.
  
  

Projects Documentation

• Has In-depth understanding of documentation involved in Project like BBP & Solution Design, FS etc.
• Able to build into require project documentation and can do a Peer review for team members documents.
  
  

Domain/ Industry Knowledge

• Working knowledge of customers business processes and relevant technology platforms/products.
• Ability to prepare process maps, workflows, and business cases with application of industry standards and practices.
• Creation of medium to complex business models.
  
  

Functional Design

• Working knowledge of high-level scope analysis, solution design processes, implementation and integration approaches, as well as cross-functional processes.
• Able to understand and design processes, identify key business drivers, translate use cases into diagrams, update design specifications, and design modular, flexible solutions meeting business requirements.
• Understand the overall solutions integrity, application behavior, and business rules, providing input for technical components, data design, and prototype creation.
• Can coordinate process playbacks and prototype reviews with stakeholders and configure applications for realizing business solutions.
  
  

Requirement Gathering And Analysis

• Working knowledge of requirement management processes and requirement analysis processes, tools & methodologies.
• Able to analyze the impact of change requested/ enhancement/ defect fix and identify dependencies or interrelationships among requirements & transition requirements for engagement.
  
  

Test Management

• Able to perform unit testing & perform comparison testing for rehosting, report testing status and create iteration, system integration test plan and develop integration test cases as required.
• Execute automation test scripts/manual test cases as per test plan, record findings and DIT Test Cases against the baseline code provided.
• Identify, report and document defects identified and perform defect fix/ deviations from expected results
• Create test cases, test scenarios and test data and perform Development Integration Testing.
  
  

Accountability

Required Behavioral Competencies

• Takes responsibility for and ensures accuracy of own work, as well as the work and deadlines of the team.
  
  

Collaboration

• Shares information within team, participates in team activities, asks questions to understand other points of view.
  
  

Agility

• Demonstrates readiness for change, asking questions and determining how changes could impact own work.
  
  

Customer Focus

• Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.
  
  

Communication

• Targets communications for the appropriate audience, clearly articulating and presenting his/her position or decision.
  
  

Drives Results

• Sets realistic stretch goals for self & others to achieve and exceed defined goals/targets.
  
  

Resolves Conflict

• Displays sensitivity in interactions and strives to understand others’ views and concerns.
  
  

Certifications

Mandatory

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture

---