29+ Performance tuning Jobs in India

Position: Sybase Developer

Location: Bangalore /Pune

Exp.Level: 8+ Yrs

Proven experience as a. Sybase Developer

Familiarity with Oracle, Sybase, Performance tuning and Optimization

Required Skills: Sybase, Performance tuning and Optimization

Role: Oracle Apps DBA Consultant 

Exp: 4-6 years

As Oracle Apps DBA, able to implement Patching, Cloning, Backup and restoring RMAN. Having experience in Oracle 11i RAC, ERP 12.2 & experience in Performance tuning.

Responsibilities:

• · The Oracle Applications DBA will be responsible for the overall management and maintenance of Oracle EBS R12.2 applications & database, and other non-ERP Oracle databases.
• · The DBA will provide technical and operational DBA support for the day to day operations on ERP oracle database, ERP applications, and non-ERP Oracle databases for data warehouse and other applications.
• · The DBA will partner with technical, functional, development and business groups to ensure that database performance standards adhere to enterprise service level agreements

Job Description:

Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:

• Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
• Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
• Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
• SQL Query tuning and performance tuning.
• Develop/migrate existing scripts to SSIS.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
• Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
• Importing and exporting the data from different sources using tools, writing required scripts.
• Works closely with other members of the team to accomplish the projects.
• Assists project teams to design and develop core business components utilizing  industry-accepted analysis and design standards.
• Provides and/or assists with, project management and project leadership.
• Create and maintain documentation for all the projects.
• Working with NOSQL databases (Mostly on MongoDB) .

PRIMARY SKILLS: 

TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.

SECONDARY SKILLS:

Database Administration

REQUIRED SKILLS:

• 3+ years of professional experience in working with MSSQL Server 2008 and above.
• 3+ years of professional experience in writing TSQL scripts.
• Thorough experience in SQL query tuning and performance tuning.
• Experience in developing and maintaining SSIS packages.
• Experience in working with NoSQL databases. MongoDB would be preferable.
• Fluent knowledge of MSSQL server DBA.
• Should be a good team player and should possess good attitude and work ethics.
• Should possess excellent communication and written skills.

PREFERRED SKILLS:

• MSSQL DBA.
• SSIS.
• NOSQL, MongoDB

Role and responsibilities

·      Collect requirements, design, develop and test software code.

·      Fix bugs and provide production support.

·      Prioritize multiple tasks and manage time effectively.

·      Learn new technologies outside his/her primary skills.

·      Develop solutions to challenging problems.

·      Effectively communicate with team members, project managers and clients, as required.

Technical skills requirements

The candidate must demonstrate proficiency in,

·      SQL, PL-SQL & RICE Components.

·      Develop applications, reports and interfaces using standard Oracle development methodologies.

·      BI Publisher, RDF/XML & Discoverer Reports.

·      Form Personalizations.

·      Unit test the reports with standard E-Business suite application.

·      Performance Tuning & Optimization.

·      Table-level technical knowledge of OM, Inventory Management, Purchasing, GL, AR, AP, and FA.

·      SQL Developer, TOAD, SQL Loader

Nice-to-have skills

·         SQL Tuning

·         EBS Finance/SCM functional knowledge

·         Performance Improvements and External Integrations

·         Ability to develop applications and modules keeping scalability and performance in mind.

Primary Responsibilities

• Architect and drive complex software performance improvement projects that mitigate the performance challenges of the product and establish new guidelines for future product features
• Work with the development team, and database administrators to analyze performance bottlenecks, make recommendations to address performance concerns, and co-design performance into new feature development
• Efficiently working with various profiling and monitoring tools to identify performance and concurrency bottlenecks, propose and implement optimizations to improve cloud product
• Review end-user usage patterns and customer logged performance defects and enhance performance test coverage based on gaps identified.
• Understand database internals, server and storage system design, application interactions with database queries and stored procedures and with other downstream systems
• Troubleshoot issues experienced by users and propose solutions

Basic Qualifications

• 8+ years of experience in implementing and driving software performance engineering projects and solutions. Advanced level experience with concurrency, multithreading, and distributed system architectures
• Experience analyzing performance bottlenecks with application code interfacing with databases using ORM Frameworks, cache layers, data storage, servers, networking, and database query protocols including developing stored procedures, SQL queries, and database applications
• Working knowledge of relational database internals (locking, consistency, replication, serialization, failover, recovery)
• Comfortable with Windows, SQL Server, .NET Framework/Core, GIT, Nuget, SPA, Modern UI Frameworks, ORM Framework NHibernate in terms of both tools and application development
• Passionate about finding software performance bottlenecks and optimizing code to produce a better customer experience
• Experience with APM (Application Performance Monitoring), RUM (Real User Monitoring), and other Dev tools used for Performance monitoring and analysis
• Experience with performance bottleneck analysis, system design for scaling

We are looking for an iOS application developer who possesses a passion for pushing mobile technologies to the limits and will work with our team of talented engineers to design and build the next generation of our mobile applications.

MUST BE ABLE TO WORK AT OUR OFFICE IN : Sec. 63, Noida, UP 201301

Responsibilities:

• Design and build advanced applications for the iOS platform
• Collaborate with cross-functional teams to define, design, and ship new features.
• Unit-test code for robustness, including edge cases, usability, and general reliability.
• Work on bug fixing and improving application performance.
• Continuously discover, evaluate, and implement new technologies to maximize development efficiency.
• Very good experience with Objective-C and iOS SDK
• Good working knowledge in Cocoa Touch
• Experience with memory management and caching mechanisms specific to mobile devices.
• Experience working with iOS frameworks such as Core Data, Core Animation, Core Graphics, and Core Text.
• Experience in Payment gateway integration in mobile apps.
• A portfolio of iOS in the app store is a plus.
• Git & Gerrit.
• UI & UX experience.
• Experience in Swift4 and above version of Swift.
• REST API association, Locations, and Map API.

Required Candidate profile

• A minimum of 3 years of experience in iOS app design and development
• Experience working with iOS frameworks such as Core Data, Core Animation, Core Graphics and
  Core Text
• Experience in imaging/pdf manipulation sdk will be preferred.
• Working experience with PDFTron sdk
• Experience with third-party libraries and APIs
• Working knowledge of the general mobile landscape, architectures, trends, and emerging
  technologies
• Solid understanding of the full mobile development life cycle

• Translate designs and wireframes into high-quality code
• Design, build and maintain high performance, reusable, and reliable Java
• code
• Ensure the best possible performance, quality, and responsiveness of the
• application
• Identify and correct bottlenecks and fix bugs
• Help maintain code quality, organization, and automatization
• Follow best practices in code implementation
• Willing to work on flexible time zones if required

• Strong knowledge of Android SDK, different versions of Android, and how to deal with different screen sizes
• Familiarity with RESTful APIs to connect Android applications to back-end
• services
• Strong knowledge of Android UI design principles, patterns, and best
• practices
• Experience with offline storage, threading, and performance tuning
• Ability to design applications around natural user interfaces, such as touch
• Familiarity with the use of additional sensors, such as gyroscopes and
• accelerometers (preferred)
• Knowledge of the open-source Android ecosystem and the libraries available for common tasks
• Ability to understand business requirements and translate them into technical
• requirements
• Familiarity with cloud message APIs and push notifications –
• A knack for benchmarking and optimization
• Understanding of Google's Android design principles and interface guidelines
• Proficient understanding of code versioning tools, such as Git
• Familiarity with continuous integration
• Must have experience in Chat (one to one, group chat, file sharing)
• Knowledge in Google Maps APIs is preferred

• Minimum 3 years of working experience in database related projects.
• Working experience on any of the leading Database management systems viz., Oracle,SQL-Server, etc. (Experience on Postgres database systems will be an added advantage).
• Adequate Database Development skills & should be proficient in SQL coding.
• Working experience in Database SQL Optimization/Performance Tuning.
• Working experience on any of the Database Programming languages viz., PL/SQL, PL/pgSQL,T-SQL,etc.
• Flexible to learn, adopt & scale to any data centric technologies as per the evolving Organizational product strategies.

• Good to have skill sets of the Candidate:
• Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts.
• Working experience on Data Analytics/Reporting/ETL or exhibits sound knowledge over the concepts.
• Database agnostic approach to data/database solutions.
• Exhibits sound knowledge on Big-data/Hadoop, Kafka, Map-Reduce programming, NoSQL,etc.

Oracle OAS Developer

Senior OAS/OAC (Oracle analytics) designer and developer having 3+ years of experience. Worked on new Oracle Analytics platform. Used latest features, custom plug ins and design new one using Java. Has good understanding about the various graphs data points and usage for appropriate financial data display. Worked on performance tuning and build complex data security requirements.

Qualifications

Bachelor university degree in Engineering/Computer Science.

Additional information

Have knowledge of Financial and HR dashboard

Preferred Education & Experience:

• Bachelor’s or master’s degree in Computer Engineering, Computer Science, Computer Applications, Mathematics, Statistics or related technical field or equivalent practical experience. Relevant experience of at least 3 years in lieu of above if from a different stream of education.

• Well-versed in and 5+ years of hands-on demonstrable experience with:
  ▪ Data Analysis & Data Modeling
  ▪ Database Design & Implementation
  ▪ Database Performance Tuning & Optimization
  ▪ PL/pgSQL & SQL

• 5+ years of hands-on development experience in Relational Database (PostgreSQL/SQL Server/Oracle).

• 5+ years of hands-on development experience in SQL, PL/PgSQL, including stored procedures, functions, triggers, and views.

• Hands-on experience with demonstrable working experience in Database Design Principles, SQL Query Optimization Techniques, Index Management, Integrity Checks, Statistics, and Isolation levels

• Hands-on experience with demonstrable working experience in Database Read & Write Performance Tuning & Optimization.

• Knowledge and Experience working in Domain Driven Design (DDD) Concepts, Object Oriented Programming System (OOPS) Concepts, Cloud Architecture Concepts, NoSQL Database Concepts are added values

• Knowledge and working experience in Oil & Gas, Financial, & Automotive Domains is a plus

• Hands-on development experience in one or more NoSQL data stores such as Cassandra, HBase, MongoDB, DynamoDB, Elastic Search, Neo4J, etc. a plus.

• 9+ years of experience in enterprise web application design and development with 4+ years of experience as an automation architect.
• Experienced in technology stack selection and the definition of solution, technology and integration architectures for small to mid-sized applications and cloud hosted platforms
• Strong understanding of various design and architecture patterns
• Experience in implementing and governing software engineering processes, practices, tools and standards for development teams
• Experience of setting up and operating the DevOps and automation infrastructure for continuous integration and delivery
• Full SDLC experience leveraging Agile, TDD and BDD for building and rolling out highly transactional and highly available platforms hosted on premise and on the cloud
• Proficient in effort estimation techniques
• Must be hands on technology and able to troubleshoot critical issues in design or code
• Experience in Mobile Applications automation using SeeTest, Appium
• Strong hands-on experience of designing and developing technology frameworks and micro-services, APIs, REST Web Services, leveraging Java and open source technology stack (i.e. Java, JavaScript, Node.js/ Angular.js/ React.js, Spring Bot, Non-blocking Java, etc. )
• Hands on experience with JBehave, Cucumber, TestNG, Extent Reports
• Strong design, development and performance tuning skills on at least two or more databases such as Oracle, SQL Server, NOSQL and NewSQL (e.g. PostgresQL, Cassandra, Mongo DB, Cosmos DB, MySQL etc.)
• Experience on enterprise architecture patterns and a couple of past examples of architecting high availability, scale and performance applications 
• Strong experience with code review and evaluate the architecture as well as design towards a set of business and technology goals
• Experience with SonarQube code coverage and code quality
• Experience with Cypress JavaScript automation
• Experience on command prompt tools like Shell Script, UNIX
• Hands on experience on Cloud stacks (AWS preferred)
• Hands on experience with standalone applications automation using UFT, LeanFT and VB Script
• Knowledge of principles on code quality, distributed applications, TDD & test automation, self-monitoring applications, refactoring and technical debt

• Assisting developers to write efficient code.
• Tuning and debugging customer installations.
• Maintaining internal development and test databases.
• Working closely with leading experts in Supply Chain management to support various E2open teams.
• Provides on-call support in a 24x7 environment.

The position requires night shift work to support the US time zone.

Required Experience/Skills:

• Bachelor's/Master's/PhD degree in Engineering, Computer Science, Mathematics, or other Science with a consistent academic record (Preferably more than 70%)
• Oracle-certified DBA with 3+ years of DBA experience
• Oracle 12c and 19c experience is a must.
• Experience in Performance Tuning and Query Optimization is a must.
• Expertise and development experience in PL/SQL and SQL
• Experience in Oracle installation, upgrade backup, and recovery methods.
• Experience in Unix/Linux shell scripting.
• Track record of delivering quality work on time and ability to expand own expertise.
• Self-motivated, detail and team-oriented
• Solid verbal and written communication skills
• Enjoys dynamic, result-oriented work culture.
• Excellent problem-solving and troubleshooting skills.
• Experience considered a plus: 
• MySQL and PostgreSQL
• Knowledge of server, storage, and networking technology.
• Supply Chain background

We are looking for a hands-on iOS Developer to join our mobile team. The apt applicant must have iOS software development skills, a passion for delivering high-quality, rock-solid apps. iOS programming works closely with other app development and technical teams.

• Translate designs and wireframes into high-quality code.
• Design, build and maintain high performance, reusable, and reliable code.
• Ensure the best possible performance, quality, and responsiveness of the application.
• Identify and correct bottlenecks and fix bugs.
• Help maintain code quality, organization, and automatization.

An enthusiastic individual with the following skills. Please do not hesitate to apply if you do not match all of it. We are open to promising candidates who are passionate about their work and are team players.

• Bachelor's degree or higher in Computer Science and minimum 4 years of Software Development experience- Knowledge of Mobile automation and experience on platforms such as espresso
• Knowledge of application profiling and performance monitoring tools such as iOS profiler, AppDynamics, Dynatrace, etc.
• Excellent coding skills in an object-oriented language.
• Experience with offline storage, threading, and performance tuning
• Have published at least one original iOS app.- Understanding of Apple's iOS design principles and interface guidelines- Strong knowledge of iOS UI design principles, patterns, and best practices

You will be working with top-quality engineers who have built one of the best employee engagement SaaS platforms. You will be reporting to AVP Engineering and working closely with the Architect and other leads.

A wholesome opportunity in a fast-paced environment that will enable you to juggle between concepts, yet maintain the quality on content, interact and share your ideas and have loads of learning while at work. Work with a team of highly talented young professionals and enjoy the benefits of being at Empuls.

A fast-growing SaaS commerce company based in Bangalore with offices in Delhi, San Francisco, and Dublin. Empuls works with over 100 global clients. We help our clients engage and motivate their employees, sales teams, channel partners, or consumers for better business results.

We look forward to connecting with you. As you may take time to review this opportunity, we will wait for a reasonable time of around 3-5 days before we screen the collected applications and start lining up job discussions with the hiring manager. We however assure you that we will attempt to maintain a reasonable time window for successfully closing this requirement. The candidates will be kept informed and updated on the feedback and application status

About Sportz Interactive

Sportz Interactive (SI) works with its clients and partners to revolutionize the sports fan experience across consumption points by creating best-in-class, kickass products. SI was founded in 2002 as a B2B sports content business. Through the years, it gained immense reputation for its state-of-the-art hosted solutions, digital simulators, match centers and fantasy games. Sportz Interactive has a fantastic reputation in the online sports community, having worked with clients across the globe including the likes of The International Cricket Council, STAR Sports, Yahoo!, AOL, Eurosport, Castrol, Web 18, NDTV, Nimbus, Times of India, Rediff.com and Singtel amongst others. 

Sportz Interactive provides in-depth sports information and content and specializes in product development for the web, mobile and other interactive platforms. 
http://www.sportzinteractive.net/">www.sportzinteractive.net 

Designation: Senior Associate 

Office Location: Goregaon East, Mumbai

Position description:

3+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills.

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

• 6+ years of experience working with MongoDB or other NoSQL databases.
• Maintain and configure MongoDB (developer)
• Keep clear documentation of the database setup and architecture.
• Backup and Disaster Recovery management.
• Adept with all the best practices and design patterns in MongoDB for designing document schemas.
• Good grasp of MongoDB’s aggregation framework.
• Ensure that the databases achieve maximum performance and availability.
• Design indexing strategies.
• Configure, monitor, and deploy replica sets.
• Should have experience with MongoDB Atlas.
• Should have minimum experience with development and performance tuning.
• Create roles and users and set their permissions.
• Excellent written, verbal communication skills and critical thinking skills

Company Description

At Bungee Tech, we help retailers and brands meet customers everywhere and, on every occasion, they are in. We believe that accurate, high-quality data matched with compelling market insights empowers retailers and brands to keep their customers at the center of all innovation and value they are delivering. 

We provide a clear and complete omnichannel picture of their competitive landscape to retailers and brands. We collect billions of data points every day and multiple times in a day from publicly available sources. Using high-quality extraction, we uncover detailed information on products or services, which we automatically match, and then proactively track for price, promotion, and availability. Plus, anything we do not match helps to identify a new assortment opportunity.

Empowered with this unrivalled intelligence, we unlock compelling analytics and insights that once blended with verified partner data from trusted sources such as Nielsen, paints a complete, consolidated picture of the competitive landscape.

We are looking for a Big Data Engineer who will work on the collecting, storing, processing, and analyzing of huge sets of data. The primary focus will be on choosing optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them.

You will also be responsible for integrating them with the architecture used in the company.

We're working on the future. If you are seeking an environment where you can drive innovation, If you want to apply state-of-the-art software technologies to solve real world problems, If you want the satisfaction of providing visible benefit to end-users in an iterative fast paced environment, this is your opportunity.

Responsibilities

As an experienced member of the team, in this role, you will:

• Contribute to evolving the technical direction of analytical Systems and play a critical role their design and development

• You will research, design and code, troubleshoot and support. What you create is also what you own.

• Develop the next generation of automation tools for monitoring and measuring data quality, with associated user interfaces.

• Be able to broaden your technical skills and work in an environment that thrives on creativity, efficient execution, and product innovation.

BASIC QUALIFICATIONS

• Bachelor’s degree or higher in an analytical area such as Computer Science, Physics, Mathematics, Statistics, Engineering or similar.
• 5+ years relevant professional experience in Data Engineering and Business Intelligence
• 5+ years in with Advanced SQL (analytical functions), ETL, Data Warehousing.
• Strong knowledge of data warehousing concepts, including data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures, data modeling and performance tuning.
• Ability to effectively communicate with both business and technical teams.
• Excellent coding skills in Java, Python, C++, or equivalent object-oriented programming language
• Understanding of relational and non-relational databases and basic SQL
• Proficiency with at least one of these scripting languages: Perl / Python / Ruby / shell script

PREFERRED QUALIFICATIONS

• Experience with building data pipelines from application databases.
• Experience with AWS services - S3, Redshift, Spectrum, EMR, Glue, Athena, ELK etc.
• Experience working with Data Lakes.
• Experience providing technical leadership and mentor other engineers for the best practices on the data engineering space
• Sharp problem solving skills and ability to resolve ambiguous requirements
• Experience on working with Big Data
• Knowledge and experience on working with Hive and the Hadoop ecosystem
• Knowledge of Spark
• Experience working with Data Science teams

Looking for talented and passionate people to be part of the team for an upcoming project at client location.

QUALIFICATION AND EXPERIENCE

• Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
• Experience of working in a production support environment
• Engineering or Equivalent degree
• Passion for open-source technologies is desired

ADDITIONAL SKILLS

• Install & Configure PostgreSQL, Enterprise DB
• Technical capabilities PostgreSQL 9.x, 10.x, 11.x
• Server tuning
• Troubleshooting of Database issues
• Linux Shell Scripting
• Install, Configure and maintain Fail Over mechanism
• Backup - Restoration, Point in time database recovery
• A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
• A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

RESPONSIBILITIES

• Monitoring database performance
• Optimizing Queries and handle escalations
• Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
• Implement security features
• DR implementation and switch over

WHAT IS IN IT FOR YOU?

Our ideal candidate is someone who is an exceptional JS developer with significant experience on React and Node. You should be able to build and support complex applications single-handedly with a keen eye towards UX, design, security and performance. Additionally you will need to have a basic understanding of microservices, API integrations to aid in achieving our vision of building the most robust and scalable integration platform in the B2B Retail + Food verticals. You will be responsible for architecture, design and implementation of the entire system to support thousands of customers globally. Our stack is primarily built around Node, PHP, React, Angular, Mongo, PHP and advanced Infra and DevOps tools such as Kubernetes, Grafana, Prometheus, ELK and more.

Mentoring should come naturally to you, as well as finding the right balance towards process and documentation.

Highlights:
1) You will be working on interesting technical challenges in a product centric and open-source driven environment.
2) You will help set a very high bar on code quality with a focus on test driven development and writing highly performant, fault tolerant and secure code.
3) You will take ownership of product features from conception to implementation, testing deployment and support.
4) A lot of freedom on when and where you work from - just get stuff done.
5) You will open source as much as possible, and blog about cool things that you learnt and built.
6) You will help define who we become as a company.
7) You will get stock options in line with silicon valley standards.


Caveats:
1) We have a strict no-divas rule. There are a lot of smart engineers on the team but no one with an attitude / superiority complex.
2) If you think writing tests for your code, writing docs, doing customer support etc are not your cup of tea, this isn't the right role for you.
3) Similarly, if you're viewing this just as a 20-40% increment opportunity over your current compensation, this isn't the right role or company for you.


This role can be the growth opportunity of a lifetime for anyone who has been operating as a backend lead and wants to grow into a fullstack CTO. Check out the links below if you'd like to learn more about us. We encourage people from underrepresented groups to apply.

1) Why ShoppinPal? - https://www.youtube.com/watch?v=cE7DgtwA0ws" target="_blank">https://www.youtube.com/watch?v=cE7DgtwA0ws
2) Our hiring philosophy and process http://techstory.in/building-startup-team/" target="_blank">http://techstory.in/building-startup-team/
3) Our culture- https://www.shoppinpal.com/culture">https://www.shoppinpal.com/culture

• MSSQL, SSIS, Performance Tuning, Data modeling.
• Experience in No SQL tools is must
• Candidate should have exposure to write scripts in Python/Node JS/MongoDB or any other tool
• Maria DB/MYSQL, Mongo DB, Github, Jira
• Understand Requirements from client and on-site team.
• Participate in preparing design and data modelling.
• Comfortable with SQL Stored procedures and queries development.
• Comfortable with SQL Stored procedures and queries development.
• Manage SQL Server through multiple product lifecycle / environments, from development to critical production systems.
• Apply best in industry standard techniques for data modeling to ensure performance, integrate and requirement.
• Ability to analyze independently problems and resolve them on time.

Roles and Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation, including Patch Management and Version Control. Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database/application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24x7 support when required.
• Perform general technical troubleshooting and give consultation to development teams.
• Interface with Oracle Corporation for technical support.
• Analyse potential impact of problem resolution and take corrective measures when needed.
• Root Cause Analysis.

Education, Skills and Experience required:

• Engineering or Technical Degrees (BE/ B.Tech/ ME/ M.Tech/ M.Sc / MCA)
• Minimum 4 years of relevant industry experience.
• Must have experience on multiple Hardware and Software Environments and be comfortable with complex heterogeneous systems environments.
• Must be an Oracle Certified Professional DBA (11g or above) with hands-on experience of RAC, RMAN.
• Good understanding of the Oracle database, related utilities and tools and underlying operating system.
• Excellent knowledge of the physical database design and all Oracle backup and recovery scenarios.
• Developing, managing and testing back-up and recovery plans. Data archival and space management.
• Ability to perform both Oracle and operating system performance tuning and monitoring.
• Good knowledge of Oracle security management and Oracle data integrity.
• Experience in code/data migration, database change management and data management through the various stages of the development life cycle.
• Sound knowledge of both database and system performance tuning and implemented application systems.
• Should have the ability to handle multiple projects and deadlines.
• Male candidates preferred as the role requires working in shifts.