Business development associate

Senior Oracle Database Administrator

Experience and CTC: 7 to 10 Years (20 LPA- 25 LPA)

Educational Qualification: B.Tech/ MCA

Location: Noida

Notice Period: Immediate to 20 Days

Required Skillsets:

DBA, RAC , RMAN, Perfromance tuning, Backup & recovery, Data guard

Primary Responsibilities

• Oracle database administration and basic understanding of performance Tuning
• Instance tuning, schema management, space management, disaster recovery, data replication, database refresh, and SQL programming and tuning
• Basic Understanding of Oracle RAC
• Basic Understanding of Oracle Data guard
• Understanding of UNIX shell scripting
• Knowledge of upgradation and Migration to higher version
• Should be ready for travel in India and abroad and open for working in any shift
• Good troubleshooting skills required and ability to handle production support
• Sound knowledge of Oracle Database Performance tuning
• Sound knowledge of RMAN backup and recovery procedure
• Ability to work across multiple global sites and working teams is imperative
• Experience with Grid Control, Performance Tuning and Diagnostic packs
• Should have worked on big Oracle development/UAT and production databases
• support across multiple hardware and software platforms including Solaris and AIX, HP-UX, LINUX is desired
• Ability to perform DBA activities that span multiple phases of database application life cycle
• Good understanding of Database performance tuning Oracle 11g & 10g
• Maintain standards and strategies for security, database objects and backup/recovery
• Validate that all physical database designs satisfy business requirements and meet standards to database objects, data integrity, security, performance and recoverability
• Understanding of Operating system like HP-UX, AIX, Solaris, Linux and storage
• Inventory of Best Practices , Automation scripts, SLA and KPI benchmark
• Must be self- motivated and well- organised

• Collection creation, access method tuning, sharding implementation, index creation, and debugging query execution to obtain top database performance.
• Execute DB upgrades on time
• Configuration of MongoDB instances, Schema and MongoDB modelling
• Table design, index utilisation, design indexing strategies , query plan analysis and Optimise performance issues
• Comprehend and translate business requirements into technical specifications and build elegant, efficient, and scalable solutions based on specifications
• Implement appropriate indexes (B-Tree, Geospatial, Text) for performance improvement
• Implement Mongo Management Service for automating a variety of tasks, including backup/recovery and performance management
• Recommend and implement best practices for Rest API integration framework/model
• Develop MongoDB and API prototypes and proofs of concept
• Implement optimal backup and recovery and assist developers in detecting performance problems using MMS and Mongo Profiler
• Work closely with the development teams to implement new features and enhancements and the maintenance and support of existing applications in production
• Automate routine DB operations with scripting
• Configure, monitor, and deploy replica sets and upgrade databases through patches
• Keep clear documentation of the database setup and architecture and plan procedures for backup in case of a data loss
• Ensure that the databases achieve maximum performance and availability
• Create roles and users and set their permissions and mentor staff on MongoDB best practices
• Write procedures for backup and disaster recovery

• Study design briefs and determine requirements
• Conceptualize visuals based on requirements
• Prepare rough drafts and present ideas
• Develop illustrations, logos and other designs using software or by hand Work with copywriters and brand leads to produce final design
• Test graphics across various media
• Amend designs after feedback
• Ensure final graphics and layouts are visually appealing and on-brand

• Proven graphic designing experience of 5 – 7 years
• A strong portfolio of illustrations or other graphics
• Familiarity with design software and technologies (such as InDesign, Illustrator, Dreamweaver, Photoshop)
• A keen eye for aesthetics and details
• Ability to work methodically and meet deadlines

• Experience in Asp .NET Core,EF Core, Asp .NET Core Blazor, ASP .NET MVC, C#
• Should have experience of all aspects of Software Development Life Cycle
• Excellent problem solver, able to assimilate formation quickly
• Excellent communication skills, oral and written
• Technical expertise: Demonstrates knowledge and experience in .net development
• Strong team player; work effectively in groups; and help others to get the job done
• Decision making: ability to analyze, integrate, evaluate and make decisions
• Motivation: Establish and communicate vision. Demonstrate enthusiasm and excitement
• toward achieving project goals
• High quality standards: accuracy, proficient and thoroughness in unit testing
• Time Management: Completes work in a timely manner to meet production deadlines
• Organizational skills: Ability to establish priorities for projects to meet goals
• 4+ years’ experience in .Net .

Responsibilities:

• Follow proper coding standards, application architecture guidelines and procedural guidelines
• Manage entire asp.net team and direct communication with client along with project manager

Apart from compensation, we are welcoming with:

• Unique Growth Opportunities.
• We will provide training based on Project Requirement
• You will learn directly from expert developers in the field.
• You will get an opportunity to work on the complete lifecycle of projects
• You will get an opportunity to work on multiple technologies.
• Discretionary Bonus.
• Work from Home, Flexible Timings, Paid Vacation and much more!
• Work Days: Monday to Friday.

 Immediate joiners preferred

• Researching on topics that are of interest to the target audience
• Writing compelling content for email campaigns, landing pages and communication with customers
• Proofreading, editing and improving content created by others and ensure brand consistency
• Working alongside team members to come up with concepts and ideas to increase revenue
• Ensuring correct grammar and spelling throughout content and website

Desired Candidate Profile

Summary
Our Kafka developer has a combination of technical skills, communication skills and business knowledge. The developer should be able to work on multiple medium to large projects. The successful candidate will have excellent technical skills of Apache/Confluent Kafka, Enterprise Data WareHouse preferable GCP BigQuery or any equivalent Cloud EDW and also will be able to take oral and written business requirements and develop efficient code to meet set deliverables.

Must Have Skills

• Participate in the development, enhancement and maintenance of data applications both as an individual contributor and as a lead.
• Leading in the identification, isolation, resolution and communication of problems within the production environment.
• Leading developer and applying technical skills Apache/Confluent Kafka (Preferred) AWS Kinesis (Optional), Cloud Enterprise Data Warehouse Google BigQuery (Preferred) or AWS RedShift or SnowFlakes (Optional)
• Design recommending best approach suited for data movement from different sources to Cloud EDW using Apache/Confluent Kafka
• Performs independent functional and technical analysis for major projects supporting several corporate initiatives.
• Communicate and Work with IT partners and user community with various levels from Sr Management to detailed developer to business SME for project definition .
• Works on multiple platforms and multiple projects concurrently.
• Performs code and unit testing for complex scope modules, and projects
• Provide expertise and hands on experience working on Kafka connect using schema registry in a very high volume environment (~900 Million messages)

• Provide expertise in Kafka brokers, zookeepers, KSQL, KStream and Kafka Control center.
• Provide expertise and hands on experience working on AvroConverters, JsonConverters, and StringConverters.
• Provide expertise and hands on experience working on Kafka connectors such as MQ connectors, Elastic Search connectors, JDBC connectors, File stream connector,  JMS source connectors, Tasks, Workers, converters, Transforms.
• Provide expertise and hands on experience on custom connectors using the Kafka core concepts and API.
• Working knowledge on Kafka Rest proxy.
• Ensure optimum performance, high availability and stability of solutions.
• Create topics, setup redundancy cluster, deploy monitoring tools, alerts and has good knowledge of best practices.
• Create stubs for producers, consumers and consumer groups for helping onboard applications from different languages/platforms.  Leverage Hadoop ecosystem knowledge to design, and develop capabilities to deliver our solutions using Spark, Scala, Python, Hive, Kafka and other things in the Hadoop ecosystem. 
• Use automation tools like provisioning using Jenkins, Udeploy or relevant technologies
• Ability to perform data related benchmarking, performance analysis and tuning.
• Strong skills in In-memory applications, Database Design, Data Integration.