Experience

5-10 Years

Position: MS SQL 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).

Monitoring using OEM, AWR, ASH, ADDM
Strong Linux/Unix and shell scripting skills

Required Skills:

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

Required Technical/ Functional Competencies

Customer Management:

• Has working knowledge of customers' business domains and technology suite.
• Use latest technology, proactively suggest solutions to increase business, and understand customer's 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 solution's 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.

Required Behavioral Competencies

Accountability:

• 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