Sr. Consultant - Oracle DBA Job

Experience

5-10 Years

Job Description

Position: MS SQL & Oracle DBA
Experience: 5-10 Years
Location: Preferably NCR

Key Responsibilities:
. Administer and support both Oracle and 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
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

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