About this role
<p><span style="font-family:Verdana, Geneva, sans-serif">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.</span></p> <p> </p> <p><span style="font-family:Verdana, Geneva, sans-serif">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.</span></p> <p> </p> <p><b><span style="font-family:Verdana, Geneva, sans-serif">We are looking forward to hire SQL DBA Professionals in the following areas :</span></b></p> <p> </p> <div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px">Experience</H2> </div><div><p>5-10 Years</p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px">Job Description</H2> </div><div><p><strong>Position: MS SQL DBA</strong><br><strong>Experience: 5–10 Years</strong><br><strong>Location: Preferably NCR</strong></p> <p><br><span style="text-decoration:underline"><strong>Key Responsibilities: </strong></span></p> <p>Administer and support MS SQL Server databases across environments<br>Ensure database availability, performance, security, and reliability.<br>Implement and manage backup, recovery, HA/DR strategies.<br>Perform performance tuning through indexing, query optimization, and capacity planning<br>Monitor database health and resolve production issues.<br>Support data migration and modernization initiatives.<br>Ensure security, compliance, auditing, and access control.<br>Collaborate with DevOps, application, and infrastructure teams.<br>Provide on-call support for critical incidents (P1 or P2).</p> <p> </p> <p>Monitoring using OEM, AWR, ASH, ADDM<br>Strong Linux/Unix and shell scripting skills</p> <p><span style="text-decoration:underline"><strong>Required Skills:</strong></span></p> <p>MS SQL DBA<br>SQL, PL/SQL, Performance Tuning<br>Backup/Recovery, Security, HA/DR<br>Linux/Unix, Scripting</p></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px">Required Technical/ Functional Competencies</H2> </div><div><p><b>Customer Management:</b></p> <ul> <li>Has working knowledge of customers' business domains and technology suite. </li> <li>Use latest technology, proactively suggest solutions to increase business, and understand customer's business.</li> </ul> <p><b>Projects Documentation:</b></p> <ul> <li>Has In-depth understanding of documentation involved in Project like BBP & Solution Design, FS etc.</li> <li>Able to build into require project documentation and can do a Peer review for team members documents.</li> </ul> <p><b>Domain/ Industry Knowledge:</b></p> <ul> <li> Working knowledge of customers' business processes and relevant technology platforms/products.</li> <li>Ability to prepare process maps, workflows, and business cases with application of industry standards and practices.</li> <li>Creation of medium to complex business models.</li> </ul> <p><b>Functional Design:</b></p> <ul> <li>Working knowledge of high-level scope analysis, solution design processes, implementation and integration approaches, as well as cross-functional processes.</li> <li>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.</li> <li>Understand the overall solution's integrity, application behavior, and business rules, providing input for technical components, data design, and prototype creation.</li> <li>Can coordinate process playbacks and prototype reviews with stakeholders and configure applications for realizing business solutions.</li> </ul> <p><b>Requirement Gathering and Analysis:</b></p> <ul> <li>Working knowledge of requirement management processes and requirement analysis processes, tools & methodologies.</li> <li>Able to analyze the impact of change requested/ enhancement/ defect fix and identify dependencies or interrelationships among requirements & transition requirements for engagement.</li> </ul> <p><b>Test Management:</b></p> <ul> <li>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.</li> <li>Execute automation test scripts/manual test cases as per test plan, record findings and DIT Test Cases against the baseline code provided.</li> <li> Identify, report and document defects identified and perform defect fix/ deviations from expected results</li> <li>Create test cases, test scenarios and test data and perform Development Integration Testing.</li> </ul> </div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px">Required Behavioral Competencies</H2> </div><div><p><b>Accountability:</b></p> <ul> <li>Takes responsibility for and ensures accuracy of own work, as well as the work and deadlines of the team.</li> </ul> <p><b>Collaboration: </b></p> <ul> <li>Shares information within team, participates in team activities, asks questions to understand other points of view.</li> </ul> <p><b>Agility:</b></p> <ul> <li>Demonstrates readiness for change, asking questions and determining how changes could impact own work.</li> </ul> <p><b>Customer Focus:</b></p> <ul> <li>Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.</li> </ul> <p><b>Communication:</b></p> <ul> <li>Targets communications for the appropriate audience, clearly articulating and presenting his/her position or decision.</li> </ul> <p><b>Drives Results:</b></p> <ul> <li>Sets realistic stretch goals for self & others to achieve and exceed defined goals/targets.</li> </ul> <p><b>Resolves Conflict:</b></p> <ul> <li>Displays sensitivity in interactions and strives to understand others’ views and concerns.</li> </ul> </div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px">Certifications</H2> </div><div><div>Mandatory</div></div></div></div><p> </p> <p><span style="font-family:Verdana, Geneva, sans-serif">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.</span></p> <p> </p> <p><b><span style="font-family:Verdana, Geneva, sans-serif">Our Hyperlearning workplace is grounded upon four principles</span></b></p> <ul> <li><span style="font-family:Verdana, Geneva, sans-serif">Flexible work arrangements, Free spirit, and emotional positivity</span></li> <li><span style="font-family:Verdana, Geneva, sans-serif">Agile self-determination, trust, transparency, and open collaboration</span></li> <li><span style="font-family:Verdana, Geneva, sans-serif">All Support needed for the realization of business goals,</span></li> <li><span style="font-family:Verdana, Geneva, sans-serif">Stable employment with a great atmosphere and ethical corporate culture</span></li> </ul>