SQL/Oracle DBA
Role details
Job location
Tech stack
Job description
- Participate in presales interactions with customers when showcasing solution etc.
- Participate in solution response teams to ensure technical feasibility.
- Provide support to the Product Consultant by creating case studies, solution etc under guidance, when required.
Product Consulting
- Provide support to the product consultant, through analyzing customer requirements and provide recommendations through interactions with the customer.
- Coordinate with onsite team / clients for requirements gathering / functional clarifications.
- Identify valueadds (eg enhance existing features) which can address repeated issues during implementation.
Project Management
- Create estimates for project planning.
- Participate in deployment activities like reviewing all deliverables as per the delivery checklist and mock testing all deliverables.
- Participate in periodic internal review meetings.
- Prepare status reports and share the same with the Product Consultant for review.
- Create impact analysis for change requests/ maintenance issues in own area of work and seek review from Product Consultant.
- Interface with quality reviewers and auditors for the projects.
- Submit necessary artifacts, data etc as requested by the DAG.
Design And Implementation
- Monitor design, development and testing to ensure alignment with requirements traceability matrix.
- Create high level design.
- Guide the product specialist in translating the high level design into detailed design.
- Review to ensure that the design is comprehensive and addresses all requirements.
- Code for complex components.
- Review code created by the developers based on requirements.
- Participate in peer design reviews.
- Drive the review meetings with the customers on the design with support from the Product Specialist.
- Conduct root cause analysis of defects / process issues.
- Identify/design reusable components and solution enablers.
- Create product based KT document, for the customer.
Testing
- Create unit test cases and perform unit testing including complex components.
- Review unit test cases as created by Product Specialist and Product Analyst.
- Assist the testing team by reviewing test strategy document, when required.
- Provide UAT and implementation support.
- Drive clarifications / defect resolution to ensure timely deployment.
Innovation
- Contribute ideas / areas requiring improvements based on project implementation, team feedback etc.
- Identify best practices related to the project/product & document the same.
Capability Building
- Prepare guidelines and checklists for the team.
- Create and deliver training on products/modules.
- Mentor team from a technical/functional perspective to ensure delivery of the module.
Knowledge Management
- Contribute towards updating knowledge assets.
- Conduct knowledge transfer sessions for new joiners in the project team.
People Management
- Resolve conflicts within team members.
- Support team building activities.
- Provide administrative support.
- Provide inputs on goal setting and performance appraisal of team.
- Identify skill gaps and training needs required.
- Provide input into the learning and career plans for team members.
- Mentor team.
- Nominate team for awards.
- Conduct training through academy and induction of new team members.
Requirements
Science / Engineering graduate, * Database and SQL
Sql Dba
Monitor Databases for issues using tools such as RedGate
Identify long running processes and locks and resolve
Assist engineers in fine-tuning SQL code / building indexes
Understanding of SQL architecture, including availability groups
Backup and Restore databases
Maintain / create powershell scripts to automate various DBA tasks
Reset passwords, create user IDs, define security model
Handle incident tickets and change tickets for code deployments
Strong ability to multitask and work with minimal guidance.
Oracle Dba
Monitor Databases for issues using tools
PL-SQL programming experience
Identify long running processes and locks and resolve
Assist engineers in fine-tuning PL SQL code / building indexes
Understanding of DB architecture, including availability groups
Backup and Restore databases
Maintain / create powershell scripts to automate various DBA tasks
Reset passwords, create user IDs, define security model
Handle incident tickets and change tickets for code deployments
Strong ability to multitask and work with minimal guidance.
Good knowledge on Facets Data Models
