Performance tuning Jobs
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
Responsibilities:
• Make decisions and resolve issues regarding objectives and operations of the fleet assets
in the database management area to meet business objectives.
• Prepare reports on database scalability and capacity planning as needed.
• Lead team to achieve objectives.
• Interpret and develop policies and procedures for functions with low to moderate complexity within scope of responsibility.
• Mentor and guide talent development of direct reports and assist in hiring talent.
• Work closely with the product development team from the design phase of application & throughout their Agile development journey, the future enhancements & releases
• Participate in the application stress/load test & proactively identify & resolve the DB performance (batch/OLTP) issues that can potentially breach the SLA’s when the code
moves to production
• Highlight the new DB features to the product teams that could be used in the application as future enhancements & releases
• Support the Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards
• Provide DB Capacity Analysis & provide insights to product teams on future storage & hardware requirements based on the current data growth & overall performance
• Identify aging data, propose/develop/implement data archiving, purging & partitioning solutions to manage the data growth
• Handling Database/Schema Refreshes for the lower database environments
• Understand the RTO/RPO requirements for the application & databases to define the database backup and restore policy
• Managing Database Security Audit violations & resolving them
• DB User/Access/Roles management
• Troubleshooting & fixing production DB/SQL performance issues
• Providing Oncall support, working with vendor on DB issues, bugs & provide solution
• Schedule and Co-ordinate various maintenance activities with Support teams.
• Collaborate and influence all levels of professionals including more experienced
managers.
• Work on any new DB technology/new-features, POC requirements from application team
• Help the application team in migrating their databases to public cloud (AWS).
• Establish performance standards, evaluate performance, train, and mentor team.
• Evaluate the database configuration and processes according to established policies and procedures of the organization.
• Identify and recommend opportunities for process improvement and risk control development.
Required Qualifications:
• 6+ years of DBA experience on SQL or NoSQL DB with performance Tuning
• 4+ years of experience in managing other databases like MS SQL Server, MySQL, PostgresDB & RDS on AWS.
• Hands on experience with NoSQL/Document databases and their administration.
• Experience on automation using any programming or scripting language.
• Should have at least one RDBMS certification.
• Hands on experience with Always on and High availability DBs.
• Hands on with SQL and NoSQL Database.
• Excellent understanding of the MongoDB installation, configuration, maintenance, security and audit logging.
• Experience with performance tuning and managing 1TB of Data
• Experience in backup/recovery procedures.
• Good understanding on Access Methods, Joins, different Indexes & its usage, Index scans, interpreting EXECUTION PLANS, Table/Index Statistics, Histograms, wait events etc
• Strong on PL/SQL Programming.
• Excellent communication skills
• Excellent verbal and written communication skills.
• Excellent interpersonal and customer service skills.
• Problem-solving and good analytical skills
• Communication, teamwork and negotiation skills
• Ability to work in tight deadlines under pressure
• Flexible and adaptable to changing business/technology requirements
• A sense of ownership that drives quality in everything you do
• A forward-looking attitude that keeps you aware of the latest in database & cloud technology space.
Preferred Qualifications:
• AWS/Azure/OCI cloud Certified
• Working experience on Snowflake Cloud Datawarehouse DB
• Python Programming for Automation for building dashboards
• Basic knowledge on Tableau/PowerBI for reporting.
Education:
• Finished Bachelors or Masters in Software Engineering.
• Preferred: BE/ B. Tech. / MCA / MSc. / BSc
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.
Strong experience with stored procedures, triggers, Views, CTE, Correlated SubQueries
Expert in troubleshooting and resolving database problems
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Knowledge of indexes, index management, and statistics
Experience working with small teams, with individual project responsibility
Ability to think strategically and abstractly
Detail-oriented and organizational skills
Excellent verbal and written communication skills
Nice to have SSRS and SSIS
Navtech (Navaratan Technologies)
Hyderabad, India
₹25L – ₹50L • No equity
Senior Microsoft SQL Developer:
Navtech is a premier IT software and Services provider. Navtech’s mission is to increase public cloud adoption and build cloud-first solutions that become trendsetting platforms of the future. We have been recognized as the Best Cloud Service Provider at GoodFirms for ensuring good results with quality services. Here, we strive to innovate and push technology and service boundaries to provide best-in-class technology solutions to our clients at scale. We deliver to our clients globally from our state-of-the-art design and development centers in the US, Hyderabad, and Pune.
We’re a fast-growing company with clients in the United States, UK, and Europe. 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.
We are looking for a Senior SQL Server 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.
Working as Senior SQL Server Developer at Navtech, you will:
- Design conceptual and logical data models and flowcharts.
- Improve system performance by conducting tests, troubleshooting and integrating new
- elements.
- Design and Build database systems of high availability and quality depending on each
- end user’s specialised role.
- Help write and optimize in-application SQL statements.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases.
- Use high-speed transaction recovery techniques and backup data.
- Provide proactive and reactive data management support and training to users.
- Determine, enforce and document database policies, procedures and standards.
- Perform tests and evaluations regularly to ensure data security, privacy and integrity.
- Monitor database performance, implement changes and apply new patches and versions when required.
Who Are We Looking For Exactly?
- 6+ years of experience SQL Server Development with at least 1 year of Lead experience.
- Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred)
- Advanced skills in resolving database locking conflicts/blocking and resource utilization.
- 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.
- A thorough understanding of Performance Monitoring, Tuning and Optimization, using native and third-party monitoring and troubleshooting tools.
- PowerShell scripting experience with ability to write automated scripts and strong
- Knowledge of system tables and DMV’s is required. (a plus).
- Experience in Postgres, No-SQL databases (a plus)
- MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus)
- Should have a Masters Degree /Bachelors (BS) in computer science, Software Engineering, IT, Technology Management or related degrees and throughout education in English Medium.
- Should have excellent logical, analytical and communication skills with client interaction experience.
Why Navtech:
- Performance review and Appraisal Twice a year.
- Competitive pay package with additional bonus & benefits.
- Work with US, UK & Europe based industry renowned clients for exponential technical growth.
- Medical Insurance cover for self & immediate family.
- Work with a culturally diverse team from different geographies.
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
Responsibilities:-
- 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
Required Skills:-
- 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
Location: Noida, UP.
-We will provide a best hike on candidate's current ctc or offered ctc.....
we will provide upto 25LPA -30LPA
As a senior developer you will involved in all phases of software
development life cycle. Should have hands on experience developing SAAS based software products with agile methodologies and are ready to
lead our junior developers. Must have good expertise in using technologies related springboot, hibernate, restful apis in AWS cloud environment
Responsibilities:
• Contribute to all phases of product development lifecycle.
• Understanding the requirements all the teams involved and planning the
development process.
• Write well designed, testable, efficient code.
• Support continuous improvements by investigating alternatives and
technologies and presenting these for architecture review.
• Designing, implementing, and maintaining java applications that are
often high-volume and low latency.
• Identify bottlenecks and bugs and advise solutions to these problems.
• Develop highly scalable REST APIs to use in our applications.
• Guide the team and help them in any complex situations.
- 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.
Ability to troubleshoot Database related issues.
- 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
- B.E Computer Science or equivalent.
- Demonstrable portfolio of released applications on the Android market with experience in
Android development.
- In-depth knowledge of at least one programming language like Kotlin
- Strong knowledge of how to work with RESTful APIs
- Strong Familiarity with OOP design principles
- Integrate with our backend web services to deliver better and faster user experience
- Strong knowledge of version control (i.e. git, svn, etc.)
- Ability to performance tune and scale applications
- Agile development experience
- Experience working at a software product company is a major plus
- Passion to learn and develop new skills continuously
- Strong sense of ownership in every application they build
- Working with highly collaborative and dynamic team environments
Experience:
- Min 3 year experience
- Startup experience is a must.
Location:
- Remotely, anywhere in India
Timings:
- 40 hours a week but with 4 hours a day overlapping with client timezone. Typically
clients are in California PST Timezone.
Position:
- Full time/Direct
Other Benefits
- We have great benefits such as PF, medical insurance, 12 annual company holidays, 12
PTO leaves per year, annual increments, Diwali bonus, spot bonuses and other
incentives etc.
- We dont believe in locking in people with large notice periods. You will stay here
because you love the company. We have only a 15 days notice period.
.
What is the role?
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.
Key Responsibilities
- 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.
What are we looking for?
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
Whom will you work with?
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.
What can you look for?
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.
We are
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.
Way forward
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.
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:
- Design conceptual and logical data models and flowcharts.
- Improve system performance by conducting tests, troubleshooting, and integrating new elements.
- Design and Build database systems of high availability and quality depending on each end user’s specialized role.
- Help write and optimize in-application SQL statements.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases.
- Use high-speed transaction recovery techniques and backup data.
- Provide proactive and reactive data management support and training to users.
- Determine, enforce and document database policies, procedures, and standards.
- Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
- Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
- Advanced skills in resolving database locking conflicts/blocking and resource utilization.
- 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.
- A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
- 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).
- Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
- PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
- Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
- Experience in Postgres, No-SQL databases (a plus).
- MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
- 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
Experience of design and development of Enterprise grade Mobile application
Hands on experience in performance tuning, debugging, monitoring
Experience designing clean and maintainable APIs
Experience with multithreaded programming, reusable frameworks, UI components, Android Jetpacks
tools and optimization techniques
REST API based web service and other system integration, web service integration,
Preferably have working experience of technologies like webRTC, ReactJS, NodeJS, JSON, Other hybrid
application development platform
Previous experience of developing VoIP based solution, live streaming/video calling based application
Nice to have: experience on Server side technologies like: J2EE, PHP. RDBMS knowledge on
MySQL/Oracle; Other associated technologies like: Git, JIRA, AWS technologies, Linux; Agile development
methodologies; Design Patterns like: MVC, MVVM ; Knowledge on various Security standards
DevOps understanding is a plus.
Previous experience of working in Product/Solution development or Start-ups will be added advantage
Domain Knowledge: Health care
Good Communication skil
Roles and Responsibilities
At least 5+ Yrs of experience of Android Java and Kotlin programming application development,
Experience of design and development of Enterprise grade Mobile application
Hands on experience in performance tuning, debugging, monitoring
Experience designing clean and maintainable APIs
Experience with multithreaded programming, reusable frameworks, UI components, Android Jetpacks
tools and optimization techniques
REST API based web service and other system integration, web service integration,
Preferably have working experience of technologies like webRTC, ReactJS, NodeJS, JSON, Other hybrid
application development platform
Previous experience of developing VoIP based solution, live streaming/video calling based application
Nice to have: experience on Server side technologies like: J2EE, PHP. RDBMS knowledge on
MySQL/Oracle; Other associated technologies like: Git, JIRA, AWS technologies, Linux; Agile development
methodologies; Design Patterns like: MVC, MVVM ; Knowledge on various Security standards
DevOps understanding is a plus.
Previous experience of working in Product/Solution development or Start-ups will be added advantage
Domain Knowledge: Health care
Good Communication skil
- 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?
You would be adding a great experience of working with a leading open source solutions company in South East Asia region to your career. You would get to learn from the leaders and grow in the industry. This would be a great opportunity for you to grow in your career through continuous learning, adding depth and breadth of technologies. Since our client work with leading open source technologies and engage with large enterprises, it creates enormous possibilities for career growth for our teamOur 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
2) Our hiring philosophy and process http://techstory.in/building-startup-team/
3) Our 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.
You will be a part of: Supply Chain Management (SCM)
Myntra-Jabong Supply Chain Management systems form the backbone of our core business and customer experience. Any business runs on a simple construct of Demand (Consumer) and Supply (Producer). However, a set of complex and intricate methods, processes and systems connect the demand with supply in a deterministic and predictable way. These methods, processes and systems collectively form the Supply Chain for the business. The multi-billion-dollar Myntra-Jabong business fundamentally rests on a set of highly scalable, robust and intelligent Supply Chain Management systems that solve real-world problems of predicting the demand from millions of our customers, for a combination of millions of products from our product catalogue, and intelligently connecting that demand to thousands of national and international sellers or suppliers using a set of advanced homegrown tech products that we build and manage.
SCM engineering employs new-age technologies such as Distributed Computing constructs, Machine Learning, Deep Learning, Computer Vision, Artificial Intelligence; scalable data stores in Mongo, Redis, Cassandra, MySQL, Elastic Search, Solr; scalable programming constructs in Node.js, GoLang, Java; JavaScript, Python, and new-age frameworks such as ReactJS and ReactNative to solve some of the hardest problems in the e-commerce business
with world-class software products.
The SCM engineering at Myntra-Jabong operates within two distinct verticals: Supply-chain Outbound (Fulfilment systems) & Supply-chain Inbound (Selection systems, Partner experience).
Your Responsibilities:
● Own the architecture of Myntra’s new product platforms to drive business results
● Be a visible leader to drive and own the architecture and design of some of the most advanced & complex software systems / products in the industry to create company wide impact.
● Help build, mentor and coach a team of very talented Engineers, Architects, Quality engineers, System Operation Engineers and DevOps engineers in architectural and design best practices.
● Be an operational and technical leader with a passion for distributed systems, cloud service
development, deployment and delivery.
● Be accountable for the design, for the ease of evolution, quality of the systems, performance, scaling, and availability characteristics and limitations of the systems.
● Envision and develop the long-term architectural direction, with emphasis on platforms/ reusable components while adopting a nimble delivery process. Establish structures and processes that ensure a high level of quality and reliability and extensibility of deliverables.
● Drive the creation of next generation extensible web, mobile and fashion commerce platforms, security protocols, customisation and tools to support continuous scaling, internationalization and platform extensions
● Drive code and design reviews of components / systems / products in scope and drives the
architectural governance for them
● Set directional paths for the teams/department for adoption of new technology stacks for solving business problems
● Be a very visible representative of multiple technology domains and represent Myntra in external technical forums
● Work with product management, business stakeholders and other engineering leaders to help define mid-term, long-term roadmaps and shape business directions
● Initiate and deliver leadership training within the engineering organisation, including training new managers, and drive the growth of leaders to create a strong leadership bench
Desired Skills and Experience
● 12 - 16 years of experience in software product development
● Must have a degree in Computer Science or related field
● A solid engineer at heart with excellent abstraction, coding and system design skills
● Proven track record of leading the architecture and delivery in a startup/e-commerce ecosystem within a high growth & matrix environment
● Successfully architected and led technology for consumer-facing products in the global market along with being an efficient proficient problem-solver who envisions business and technical perspectives to develop workable solutions
● Must have exposure to leading product development end-end (portfolio to delivery, re-architectures)
● Strong hands-on technology experience building and running large scale systems handling
multi-million sessions/transactions per day
● Solid experience in large scale Database systems like RDBMS & NoSQL stores
● Strong design/development experience in building massively large scale distributed internet systems and products
● Excellent programming skills in Java/GO and expertise in multi-threading and performance-oriented programming
● Solid experience in Distributed systems, highly scalable products, performance & reliability
● Excellent understanding of processing platforms and queues
● Experience and knowledge of open source software, frameworks and broader cutting edge
technologies around server-side development in Java
● Strong understanding of object-oriented programming, concurrency and fundamentals of
computer-science
