14+ Databases Jobs in Chennai | Databases Job openings in Chennai

OJ Commerce Inc. is a fast-growing retailer serving the US market through OJ Commerce.com and various market places such as Amazon, Walmart, and eBay. OJ Commerce is a privately held, profitable company headquartered in Miami, Florida, USA with a 100% dedicated back-office in Chennai. The workhours are flexible with predominantly India business hours with some overlap with US Eastern Time business hours based on need.

Experience: 

4+ relevant experience

Role: Individual Contributor Role.

Location : Chennai - Ekaduthangal (Work From Office)

Skill Sets:

• In-depth knowledge in MS SQL Server and related tools & technologies such as SSIS, SSRS &SSAS

• Exposure to data modelling and ability to develop complex queries & procedures

• Manage and monitor performance, capacity and security of the database

• Continuously improve the performance of the database in alliance with the Database Adminstrator by optimizing jobs, procedures & queries

Desirable Skills:

➢ Candidates with experience in ecommerce / online retail is added value.

➢ Should be comfortable in dealing with senior leadership (internal & external)

➢ Communication Skills – Excellent verbal and written communication skills with ability to explain ideas very clearly.

➢ Self–motivated and flexible, with an ability to work independently.

Traits Expected: 

• Ability to work in a fast–paced, dynamic environment with limited resources

• Problem-solver with a desire to solve complex business problems with innovative & cost–effective solutions

• Excellent analytical and problem-solving skills, with out–of–the–box thinking.

Location: Chennai

Experience: 4 years

Job Description :

*4+ years of software design and development experience.

*Programming experience building .net web applications in .net core/.net 6                                                 

*Must have strong knowledge in any Database.

*AWS and Azure experience will be an added advantage.

*The candidate must have developed a browser-based application and used web services and APIs.

*Good communication skills (both verbal and written)

*Able to prioritize and deliver project activities on time

*Good understanding of client requirements.

• Experience working with community version PostgreSQL version 13 (or higher)
• Experience investigating/troubleshooting PostgreSQL performance issues with native Postgres catalog and statistics
• Familiarity with streaming and logical replication, HA, Backup and Recovery and Maintenance utilities including setup, configuration and monitoring.
• Strong troubleshooting and analytical skills
• 5+ years of PostgreSQL DBA experience

JD - System Analyst

1. Analysis and design of technical functionality and features.
2. Creation of requirements document and definition, Epics, User stories and addition of same to Fresh Release.
3. Facilitate daily scrums, stand-ups and meetings to monitor project progress and resolve any issues the team may be experiencing.
4. Collaborate with product owner and stakeholders and clear project obstacles and impediments that could slow down the team’s progress.
5. Meet and coordinate with internal stakeholders to establish project scope, system goals, and requirements.
6. Help the team boost their productivity and performance and helps development team create high-quality products.
7. Arrange and optimize product backlog.
8. Develop, analyze, prioritize, and organize requirement specifications, data mapping, diagrams, and flowcharts for developers and testers to follow.
9. Translate highly technical specifications into clear non-technical requirements.
10. Manage the set-up and configuration of systems. Provide documentation of all processes and training as needed.
11. Define and coordinate the execution of testing procedures and develop test cases to serve the overall quality assurance process.
12. Draw up, supervise and document testing schedules for complete systems.
13. Perform design, implementation, and upgrades of information systems to meet the business and user needs.
14. Implement best practices for scalability, support ability, ease of maintenance and system performance.
15. Identify options for potential solutions and assess them for both technical and business suitability.
16. Oversee implementation of a new system including data migration.

Requirements:-

• Bachelor’s Degree or Master’s in Computer Science, Engineering,Software Engineering or a relevant field. 
• Strong experience with Windows/Linux-based infrastructures, Linux/Unix administration.
• knowledge of Jira, Bitbucket, Jenkins, Xray, Ansible, Windows and  .Net. as their Core Skill.
• Strong experience with databases such as SQL, MS SQL, MySQL, NoSQL.
• Knowledge of scripting languages such as Shell Scripting /Python/ PHP/Groovy, Bash.  
• Experience with project management and workflow tools such as   Agile, Jira / WorkFront etc.
• Experience with open-source technologies and cloud services.
• Experience in working with Puppet or Chef for automation and configuration.
• Strong communication skills and ability to explain protocol and processes with team  and management.  
• Experience in a DevOps Engineer role (or similar role)
• AExperience in software development and infrastructure development is a plus

Job Specifications:-

• Building and maintaining tools, solutions and micro services associated with deployment and our operations platform, ensuring that all meet our customer service standards and reduce errors.  
• Actively troubleshoot any issues that arise during testing and production, catching and solving issues before launch.
• Test our system integrity, implemented designs, application developments and other processes related to infrastructure, making improvements as needed
• Deploy product updates as required while implementing integrations when they arise.  
• Automate our operational processes as needed, with accuracy and in compliance with our security requirements.
• Specifying, documenting and developing new product features, and writing automating scripts.  Manage code deployments, fixes, updates and related processes.
• Work with open-source technologies as needed.
• Work with CI and CD tools, and source control such as GIT and SVN.
• Lead the team through development and operations.
• Offer  technical support where needed, developing software for our back-end systems.

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

• Strong proficiency in MySQL database management
• Table design including normalization
• Database backups and recovery is a plus
• Experience with recent versions of MySQL
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Good Experience with Procedure and events in MySQL
• Experience with replication configuration in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
• Strong MySQL Queries tuning skills
• Write scripts using Shellscript to automate manual administrative tasks
• Maintain backups and perform point-in-time restorations
• Creating tables, alter column, and store procedure.
• Good Experience in Creating index and query optimizing
• Experience in MongoDB to SQL migration