11+ Query optimization Jobs in Mumbai | Query optimization Job openings in Mumbai

Office Location: Goregaon Mumbai

Position description:

4+ 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.

Job Description   - Omniflow and Java Developer

Should have working experience between 6-8 years in Java development

Mandatory skills are good knowledge of object oriented concepts, experience of working on Spring boot application, should have worked on hibernate ORMS and candidate must have clear understanding of database concepts

Optional skills include knowledge of angular framework and postgreSQL database

Good to have knowledge of jBPM open source workflow

Qualifications

Master or Bachelor degree in Engineering/Computer Science /Information Technology

Additional Information

Skills and Competencies:
Strong documentation skills
Excellent communication skills, both written and verbal
Decision making and problem solving skills
Good organizational skills        

 

Position : Database Programmer:

 

Job Description / Required Skills

• Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.
• Hands-on development experience with T-SQL.
• Strong experience on Database designing, normalization, optimization and performance tuning.
• Experience in advanced SQL programming, problem-solving and analytical skills.
• Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.
• Experience in Refactoring/troubleshooting existing databases as needed.
• Deep understanding of referential integrity and indexing.
• Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.
• Ability to estimate development tasks accurately and meet agreed upon deadlines.
• Understanding of code promotion, version control and QA procedures.
• Good Communication skills.

 

Technical Skills:

• MySql, MS-SQL, SQL Server Management Studio and SQL Server Profiler.
• PostgreSQL
• DCL, DDL, DML Scripts.
• T-SQL, SSRS and SSIS
• OS Environments: Windows XP/Windows 7, Windows Server 2003/2008

 

Experience         :               3 to 4 years

Qualification       :               B. Tech/BE/MCA/MSC Computers

Location               :               Mumbai

Postgress developer cum database architect

5-7 years experience

Knowledge and experience, specifically PostGre

-           SQL

-           Query Optimization / Optimization strategies (in PostGre)

-           AWS - RDS Relational Databse Service

-           Optional: AWS – RDS API / PostGre API

Dear Candidate, Please find below details : Ruby on Rails Developer Years of experience- 3 to 6 years Required Skills Ruby, Ruby on Rails, Experience in developing Web application using Ruby, RoR Databases: PostgreSQL Added advantages if candidates knows REST OS: Linux Please share your details across [email protected] with below details  Total Exp: Rel Exp: Current CTC: Expected CTC: Notice Period: Niyuj is a product engineering company that engages with the customer at different levels in the product development lifecycle in order to build quality products, on budget and on time. Founded in 2007 by passionate technology leader, Stable and seasoned leadership with hands-on experience working or consulting companies from bootstrapped start-ups to large multinationals. Global experience in US, Australia & India, Worked with fortune 500 companies to prominent startups, clients include Symantec, Vmware, Carbonite, Edgewater networks Domain Areas we work for : CLOUD SERVICES - Enterprises are rushing to incorporate cloud computing, big data, and mobile into their IT infrastructures. BIG-DATA ANALYTICS - Revolutionizing the way Fortune 1000 companies harness billions of data and turn it into a competitive advantage. NETWORK AND SECURITY - Network and security-related system level work that meets customer demands and deliver real value Our Prime customer, Carbonite, is Americas #1 cloud backup and Storage Company, with over 1.5 million customers and headquartered in Boston MA, with offices in 15 locations across the world. Your potential for exponential growth: Your experience and expertise would be a great addition to our team, and you will have an opportunity to work closely with industry leaders, literally sitting across the table and jointly building the future with folks who are noted gurus and industry veterans from prestigious institutions like IIT's and top US universities with industry experience in fortune 500 companies like EMC, Symantec and VERITAS.

Primary Responsibilities:

• Team with top-notch engineers, product managers, program managers, DevOps and QA following agile development methodologies
• Review functional requirements, providing technical feedback on feasibility and architectural approach and framework.
• Design and develop web / mobile applications
• Create Prototype and/or Proof of Concepts (POCs) when necessary
• Act in a technical leadership capacity: Mentor junior engineers and new team members, perform code reviews and apply technical expertise to challenging programming and design problems
• Utilize Agile Development, SCRUM / Pair / Extreme Programming methodologies
• Design and develop supporting components and microservices for the backend tiers focusing on fault-tolerance and scalability in a multi-tenant enterprise environment
• Maintain and improve the functionality and performance of the existing web applications
• Help shape and execute the technical roadmap to develop next generation features; integrate corporate- and product-level architecture principles and goals into the teams project work through designs, implementation strategies, and project planning.
• Drive a culture of quality, technical curiosity, continuous improvement, and evidence-based data driven decision making in the organization.
• Execute other Duties as assigned

Knowledge Skills and Abilities: Must have:

• 3+ years of experience developing Backend, API and data-based applications/software
• Experience with one of the major relational databases (MySQL, Oracle, Postgres) and NoSQL databases (Mongo DB, Cassandra, Dynamo DB or such)
• Expert object-oriented programming experience using Java
• Strong OO design and programming skills in Java, Hibernate, JPA, Spring Boot
• Worked in Maven, JPA, REST services, Postman
• Working knowledge on Spring Security / Spring Batch / ZUUL / Eureka / Hysterix
• Exposure with Frontend technologies (React.js, Angular or Ruby-on-Rails)
• Require experience and Strong understanding of entire Software Development Life Cycle (SDLC), Agile (Scrum), Software design/architecture process, unit testing & Test-Driven Development (TDD)
• Experience with web services (consuming or creating)
• Experience managing Cloud infrastructure (resources and service) in AWS, Azure and/or GCP
• Strong knowledge of SOA, object-oriented programming, design patterns, multi-threaded application development
• Experience in reporting and analytics, queuing and real-time streaming systems
• Git or similar distributed SCM tools experience.

If you find the above Job Description matching with your skills & experience and only if you can join in a maximum of 10 days, please revert to this email with your interest, specifying your current/ last drawn salary & expectations

About the Company

RealPort is a digital brokerage platform that provides small institutional investors around the
globe with access to single-asset infrastructure investments, sponsored by highly reputable
asset managers. Low minimum investment tickets and reduced fees allow small investors to
build customized, diversified co-investment portfolios across multiple sectors and risk categories
like their larger counterparts. In-depth risk analysis provided by RealPort’s exclusive analysis
partner Scope offers greater control and improved transparency on individual and portfolio risk.
Asset managers benefit from global access to professional investors and an improved time-/
cost- efficient fundraising process through RealPort's all-on-one platform.

We are:
● innovative problem solvers
● transparent
● trustworthy
● pragmatic
● dependable
● diverse,
... and are looking for a talented and dedicated Senior Python Developer with experience
building complex applications to join our team to work on an innovative FinTech platform.
You will be working alongside our Product and Technology teams in our Mumbai office.
You have a good understanding of:
● Python 3
● node.js
● PostgreSQL
● API / REST
● Django 2x and Django Rest Framework
● Supervisor
● Jenkins
● AWS
● Linux (Ubuntu)
● boto3.

Ideally, you have:
● Min. 5-8 years of experience building web application engines
● University degree from a reputable university
● Excellent communication skills in English and knowledge of European languages
(German and/or French preferred) is an added bonus
● Experience in banking/financial API integrations
● Familiarity with blockchain (open zeppelin, ERC223, truffle, solidity, solidity-coverage,ganache-cli, mocha-js).
You job will consist of the following:
● Deliver smooth functionality of the application while working closely with the Front end team
● Build efficient back-end features in Python
● Help design and implement functional requirements
● Manage testing and bug fixes
● Ultimately, you’ll build highly responsive web applications that align with our business
needs.

Others consider you to be/have the following:
● Excellent at communicating with different people from different walks of life and
cultures/work and communicate across multiple time zones
● Excellent demeanor, manners, and communication skills
● Exceptional organizational skills with great attention to detail
● Open/transparent, but trustworthy and trusting
● Ability to work independently and handle high volumes of work
● Ability to work on complex and uncertain topics independently
● Solution-oriented
● Strong analytical skills
● Critical, but positive and constructive
● Efficient, dependable, and accountable
● Discreet

Benefits:
● Work on a ground-breaking product at the forefront of FinTech innovation on a global
basis
● Opportunity to work with open-minded, experienced, talented, cross-functional, and
cross-cultural teams along with an innovative network of partners who are some of the
biggest companies in the industry
● Opportunity to travel for work
● Learn from teams with 15+ years product development experience
● Competitive salary package

Birla Gold and Precious Metals Ltd. are currently hiring for an PHP Developer for its office based at Andheri West. Job responsibilities :- Experience in frameworks knowledge (MVC) like Laravel - Proficient in object oriented PHP programming - Database experience of the following : Postgre SQL, MySQL or MS SQL Server (Preferably My SQL). - Object-oriented application building experience in a professional Agile/Scrum environment Qualication :- BE/ B Tech/ M Tech/ MCA degree holder with 3+ years of experience in PHP Development. Salary : Upto 55k per month About us : Birla Gold & Precious Metal Limited (BGPML) is a unique company born out of the great Indian wisdom of investing in Gold for a secure future. BGPML is in the primary business of Jewellery Retail and E-Commerce. It is a 100% subsidiary of KSS Limited (formerly known K Sera Sera Limited), a listed entity in Bombay Stock Exchange (BSE) and National Stock Exchange (NSE).BGPML prides itself for creating brand Cherish Gold a Virtual Jewellery mall with over thousands of brilliantly crafted and intricately created, eye dazzling designs, manufactured by Best Jewellery Houses of India. All Gold & Diamond products sold on Cherishgold.com are of the highest quality and Hallmark Certified. Cherish Gold has an Easy Return & Exchange Customer Friendly Policy. Cherish Gold can be accessed through multiple platforms like: Apps, Portal, Regional Managers, Ambassadors, Contact Centers or its beautiful and welcoming Physical Stores. All Products Purchased on Cherishgold.com have Doorstep Delivery. For further details you can visit us at www.birlagold.com

Desired Candidate Profile – 1. Must have hands-on experience in C#, C# OOPS concepts, SQL queries up to 3 yrs. (minimum). 2. Must have worked on WCF/Web services/MVC up to 2 yrs. (minimum). 3. Good to have exposure to PostgreSQL. 4. Good to have exposure to Web API (DotNet Core). 5. Good to have exposure to AngularJS (version 2 & above). 6. Good to have exposure to C# Unit Testing (VSTS, NUnit etc). 7. Must have good analytical & logical abilities, can work independently with minimum supervision.

• The candidate must be working on coding apart from just managing team or the project.• The candidate must be involved in coding modules, developing, testing and documenting it.• Preferring male candidate• Age Criteria: not more than 32-33 years of Age• Experience: 7-10 years of Experience on ASP . NET / MVS . NET on C# technology.Functional/Technical skills: • 7-8 years hands-on experience in software design and development, database design and development, and system integration• Hands-on experience with Microsoft technologies, specifically: .NET/ASP.NET MVC development, C#, mysql, SQL Windows 2008/2012 server• Hands-on experience with web technologies including JSON/XML, RESTful and SOAP-based web services, JavaScript, CSS, jQuery• Experience developing software using a formal and structured development methodology• Ability to work in a collaborative team environment• Experience with test driven development and proper unit testing of code• Iterative approach to development, using short development cycles and frequent buildsBehavioural skills: Communication skills/ team leading• Good communication skill (Written &Verbal)• Manage team• Ability to handle multiple projects and shifting prioritiesRole and Responsibilities:• Development of Modules/ Feature• Understanding of Business Process Requirement• Coding important portions of the project• Basic Testing of Self Developed Code• Creation of task-level project plans that detail the specific tasks required to deliver a solution• Communicate with clients regarding progress, challenges, timelines and end results of projects• To manage deployment environments and release quality solutions• Recruiting, training, guiding developers

Job Description We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required. Responsibilities Provision MySQL instances, both in clustered and non-clustered configurations Ensure performance, security, and availability of databases Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization. Prepare documentations and specifications Handle common database procedures, such as upgrade, backup, recovery, migration, etc. Profile server resource usage, optimize and tweak as necessary Collaborate with other team members and stakeholders Skills and Qualifications Strong proficiency in MySQL database management Decent experience with recent versions of MySQL Understanding of MySQLs underlying storage engines, such as InnoDB and MyISAM Experience with replication configuration in MySQL(Master slave, Master-Master) Knowledge of de-facto standards and best practices in MySQL Create and Manage MySQL users with proper permissions. Proficient in writing and optimizing SQL statements. Automate day to day regular tasks. Strong knowledge in MySQL Binlog and point in time recovery. Tuning MySQL servers configurations as per the workload. Decent experience in Linux Administration. Knowledge of MySQL features, such as its event scheduler Ability to plan resource requirements from high level specifications Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases Proficient understanding of code versioning tools such as (Git / Mercurial / SVN) The below qualifications are adds Plus: Public cloud platform (AWS/Azure/GCP). Knowledge in AWS RDS and Aurora. Python scripting. Query Tuning.