11+ Technical analysis Jobs in Hyderabad | Technical analysis Job openings in Hyderabad

Role: Oracle DBA Developer

Location: Hyderabad

Required Experience: 8 + Years

Skills : DBA, Terraform, Ansible, Python, Shell Script, DevOps activities, Oracle DBA, SQL server, Cassandra, Oracle sql/plsql, MySQL/Oracle/MSSql/Mongo/Cassandra, Security measure configuration

cid:[email protected]

Roles and Responsibilities:

1. 8+ years of hands-on DBA experience in one or many of the following: SQL Server, Oracle, Cassandra

2. DBA experience in a SRE environment will be an advantage.

3. Experience in Automation/building databases by providing self-service tools. analyze and implement solutions for database administration (e.g., backups, performance tuning, Troubleshooting, Capacity planning)

4. Analyze solutions and implement best practices for cloud database and their components.

5. Build and enhance tooling, automation, and CI/CD workflows (Jenkins etc.) that provide safe self-service capabilities to th6. Implement proactive monitoring and alerting to detect issues before they impact users. Use a metrics-driven approach to identify and root cause performance and scalability bottlenecks in the system.

7. Work on automation of database infrastructure and help engineering succeed by providing self-service tools.

8. Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata)

9. Monitor database performance, control access permissions and privileges, capacity planning, implement changes and apply new patches and versions when required.

10. Recommend query and schema changes to optimize the performance of database queries.

11. Have experience with cloud-based environments (OCI, AWS, Azure) as well as On-Premises.

12. Have experience with cloud database such as SQL server, Oracle, Cassandra

13. Have experience with infrastructure automation and configuration management (Jira, Confluence, Ansible, Gitlab, Terraform)

14. Have excellent written and verbal English communication skills.

15. Planning, managing, and scaling of data stores to ensure a business’ complex data requirements are met and it can easily access its data in a fast, reliable, and safe manner.

16. Ensures the quality of orchestration and integration of tools needed to support daily operations by patching together existing infrastructure with cloud solutions and additional data infrastructures.

17. Data Security and protecting the data through rigorous testing of backup and recovery processes and frequently auditing well-regulated security procedures.

18. use software and tooling to automate manual tasks and enable engineers to move fast without the concern of losing data during their experiments.

19. service level objectives (SLOs), risk analysis to determine which problems to address and which problems to automate.

20. Bachelor's Degree in a technical discipline required.

21. DBA Certifications required: Oracle, SQLServer, Cassandra (2 or more)

21. Cloud, DevOps certifications will be an advantage.

Must have Skills:

Ø Oracle DBA with development

Ø SQL

Ø Devops tools

Ø Cassandra

Job Description

Job Responsibilities

• Design and implement robust database solutions including

  • Security, backup and recovery

  • Performance, scalability, monitoring and tuning,

  • Data management and capacity planning,

  • Planning, and implementing failover between database instances.

• Create data architecture strategies for each subject area of the enterprise data model.

• Communicate plans, status and issues to higher management levels.

• Collaborate with the business, architects and other IT organizations to plan a data strategy, sharing important information related to database concerns and constrains

• Produce all project data architecture deliverables..

• Create and maintain a corporate repository of all data architecture artifacts.

Skills Required:

• Understanding of data analysis, business principles, and operations

• Software architecture and design Network design and implementation

• Data visualization, data migration and data modelling

• Relational database management systems

• DBMS software, including SQL Server  

• Database and cloud computing design, architectures and data lakes

• Information management and data processing on multiple platforms 

• Agile methodologies and enterprise resource planning implementation

• Demonstrate database technical functionality, such as performance tuning, backup and recovery, monitoring.

• Excellent skills with advanced features such as database encryption, replication, partitioning, etc.

• Strong problem solving, organizational and communication skill.

Role/Title: ASCP Functional consultant (Exp - 4 to 15 yrs.)

Location: Noida/Pune/Bangalore/Hyderabad/Chennai

Primary Skills/expertise: ASCP, MFG/MRP, MPS, WIP, BOM

Role & Responsibilities   

Functional Consultant with min 6-8 years of experience.

Skills –

• Oracle VCP-EBS - Advanced Supply Chain Planning (ASCP, MFG/MRP, MPS Planning Expert)

Detailed Job Description:          

• Strong experience in Oracle ASCP, MRP, MPS Planning and Manufacturing
• Good knowledge of Oracle EBS, Mfg., WIP, BOM
• Having done at least one end to end implementation of Oracle EBS Mfg. with primary focus on VCP modules
• Good knowledge of Supply Chain Management related business processes and Oracle configurations / functional setups, profile options, flex-fields, functional interfaces for R12 EBS
• Should have worked on customizations, Reports, interfaces etc. over MSC schema
• Understanding of software development methodologies, development processes, change management, and deployment procedures
• Experience with gathering user requirements, understanding and interpreting requirements specifications
• Ability to analyze, trouble shoot and effectively communicate functional details to end users
• Worked with Oracle Technical Support on SR resolution
• Self-motivated team player with ability to work independently as well as part of a team
• Strong analytical and problem-solving skills along with written and verbal communication skills
• Good to have – SQL-query knowledge, well known about VCP & Oracle-EBS Mfg. Tables, scheduling tools.
• Should have good understanding of Oracle-EBS Integrations with VCP
• Should have experience in client facing.
• Experience in working with multiple teams.
• Flexible in timings
• Expert in writing functional specifications
• Should able to understand holistic planning solution of customer
• Must have experience in Creation of different test scripts, doing testing, UAT support

Experience Level: 8 Yrs

Oracle EBS Techno Functional

Work from Office

Job Location Hyderabad or Chennai or can be remote for subcons

Tech round+ management + client round

Candidate should be excellent in oracle Finance techno functional role ( oracle apps) with EBS + Finance modules ( AP+AR+GL) + Insurance domain + Production application support project specifically in UAE based project experience.

• Experience in Oracle EBS (Technical) with R12 release.
• • Very good knowledge of R12 financial table structure.
• • Good Hands on Knowledge of SQL, PLSQL, Oracle reports, Oracle form. OAF/ADF, BI publisher reports, Shell scripting.
• • . Should have good Analytical and debugging skills.
• • Should have development experience in the EBS environment in Reports, Interfaces, Conversions, Extensions, Workflow (RICEW) and Forms deliverables.
• • Experience in P2P, Oracle General Ledger (GL), Account Payables (AP), Receivables (AR), Cash Management (CM), Sub-ledger Accounting (SLA), and System administrator modules.
• • Experience of end-user interaction for requirements gathering, understanding customer needs and working with multiple groups to coordinate and carry out technical activities which include new development, maintenance and production support activities.
• • Should have good knowledge of Agile Methodologies

Bachelor's degree in Computer Science, or information technology from an accredited institution; or equivalent experience

• Working with Banks in 24x7 based environment and identify Application problems and advising on the solution.
• Analyzing application/OS logs to spot common trends and underlying problems.
• Analyzing underlying database using SQL queries (MS SQL /Oracle or any other relational database).
• Deploying, testing, and reporting bugs/issues in new modules and support clients in testing.

Skills Required:

• Good analytical and problem-solving skills.
• knowledge of Linux Commands and database queries.
• Knowledge of Application servers i.e Apache Tomcat/ Jboss.
• Knowledge of shell script 
• knowledge on Banking Digital Products i.e. IMPS, UPI

Required:
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have:
1) Experience in SAP BO / Crystal report / SSRS / Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities:

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another

• 6 - 10 years’ experience in Oracle EBS (Techno-Functional)
• Experience in implementation, Support, and upgrade projects
• Experience at least in 2 R12.2 upgrade projects.
• Experience in Oracle EBS R12.2.7 or Higher versions of R12.
• Strong knowledge in SQL/PLSQL, Reports, Forms, and workflow. OAF is added advantage.
• At least 40% functional knowledge in SCM and Manufacturing (Modules: PO, OM, INV, WIP, BOM, Quality and Engineering)
• Excellent verbal and written communication skills