MySQL Developer

Company Name - Trejhara Solutions Limited

Location : Mumbai & Pune

Designation : Application support engineer

Skills : SQL, UNIX, LINUX

Male candidates only

Immediate joiners preferred

1+ year of experience in Database Testing, ETL Testing, BI Testing, SQL
• Key Skillset: -
• Advanced SQL Skills and good Communication Skills are mandatory.
• Develop and execute detailed Data warehouse related functional, integration and regression test cases, and documentation
• Prioritize testing tasks based on goals and risks of projects and ensure testing milestones, activities and tasks are completed as scheduled.
• Develop and Design Datawarehouse testcases, scenarios, and scripts to ensure quality Data warehouse /BI applications.
• Report the status of test planning, defects and execution activities, including regular status updates to the project team.
• Hands on Experience on any SQL Too

Job Description

This requirement is to service our client which is a leading big data technology company that measures what viewers consume across platforms to enable marketers make better advertising decisions. We are seeking a Senior Data Operations Analyst to mine large-scale datasets for our client. Their work will have a direct impact on driving business strategies for prominent industry leaders. Self-motivation and strong communication skills are both must-haves. Ability to work in a fast-paced work environment is desired.

Problems being solved by our client: 

Measure consumer usage of devices linked to the internet and home networks including computers, mobile phones, tablets, streaming sticks, smart TVs, thermostats and other appliances. There are more screens and other connected devices in homes than ever before, yet there have been major gaps in understanding how consumers interact with this technology. Our client uses a measurement technology to unravel dynamics of consumers’ interactions with multiple devices.

Duties and responsibilities:

• The successful candidate will contribute to the development of novel audience measurement and demographic inference solutions. 
• Develop, implement, and support statistical or machine learning methodologies and processes. 

• Build, test new features and concepts and integrate into production process
• Participate in ongoing research and evaluation of new technologies
• Exercise your experience in the development lifecycle through analysis, design, development, testing and deployment of this system
• Collaborate with teams in Software Engineering, Operations, and Product Management to deliver timely and quality data. You will be the knowledge expert, delivering quality data to our clients

Qualifications:

• 3-5 years relevant work experience in areas as outlined below
• Experience in extracting data using SQL from large databases
• Experience in writing complex ETL processes and frameworks for analytics and data management. Must have experience in working on ETL tools.

• Master’s degree or PhD in Statistics, Data Science, Economics, Operations Research, Computer Science, or a similar degree with a focus on statistical methods. A Bachelor’s degree in the same fields with significant, demonstrated professional research experience will also be considered. 
• Programming experience in scientific computing language (R, Python, Julia) and the ability to interact with relational data (SQL, Apache Pig, SparkSQL). General purpose programming (Python, Scala, Java) and familiarity with Hadoop is a plus.  
• Excellent verbal and written communication skills. 
• Experience with TV or digital audience measurement or market research data is a plus. 
• Familiarity with systems analysis or systems thinking is a plus. 

• Must be comfortable with analyzing complex, high-volume and high-dimension data from varying sources
• Excellent verbal, written and computer communication skills
• Ability to engage with Senior Leaders across all functional departments
• Ability to take on new responsibilities and adapt to changes

 

Interpersonal Skills :

- Communicate and coordinate effectively across multiple internal teams and external contractors.

- Prioritize and deliver results effectively on concurrent projects in a fast-paced team-oriented environment.

Database Development Skills :

- Write and review MSSQL code and queries used in standard database objects (functions, stored procedures, triggers, and views) and queries generated by application.

- Automate, document, and demonstrate routine tasks and processes.

- Commit database administration and automation code to source control in Git repository.

- Track and apply changes to database objects and data transformations in testing and production environments.

- Maintain database continuous integration, delivery, and deployment efforts in support of DevOps initiatives.

- Leverage open-source platforms and cloud technologies to improve efficiency and scalability of data services.

Database Administration Skills :

- Deliver actionable feedback to business owners and development teams regarding SQL Server performance and scalability.

- Apply industry standard security principles and best practices.

- Provide and monitor Instance and Database level access to users and applications.

- Support audit compliance efforts by reporting on setup, configuration, and application data.

Required Experience :

- Proven track record of analyzing and solving complex data issues.

- Query tuning, optimization, and monitoring in an enterprise environment.

- Root cause analysis of performance and integrity issues.

- Data analytics and reporting using complex SQL queries.

Background :

- Degree in Computer Science or equivalent experience.

- 5-7 years of Microsoft SQL Server Database Engineer experience.

• Should have strong knowledge and hands-on with SQL, Java Selenium, and TestNG
• Good knowledge of the j-meter tool
• Hands-on with any of the defect management tools like Jira/Bugzilla
• Knowledge of Protractor, JavaScript, Soap UI is a plus
• Exposure to the usage of Testing Tools
• Hands-on JS/Scripting
• Knowledgeable in REST, XML/JSON, SOAP
• SQL Writing (Oracle DB)

Years of experience:

• 2+ years of actual QA experience comprising of both manual testing and creating automation frameworks.

Detailed Job Description:

• Experience in testing web-based applications.
• Experience in developing test cases and scenarios based on PRD/BRD/Use cases.
• Experience in testing Web Services
• Logging defects/bugs in the defect management tool
• Tracking the defects and retire them with appropriate test execution
• Good analytical and problem-solving skills
• Excellent written and verbal communication skills

 

About this role

We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career.  You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and  MongoDB/ Cassandra.

What You’ll Do

• Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team. 
• Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.
• Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.
• Work with our developers to optimize and tune their SQL queries.
• Assist in application development, debugging, and optimization with respect to data concerns.
• Provide input in the design and implementation of backup, recovery, and DR strategy
• Review application and database design for compliance.

What You’ll Need

• Ability to script in a high-level language like Python, Ruby, etc for Automation. 
• 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ Cassandra.
• 4+ years of experience in database design and DevOps on AWS.
• Must demonstrate a clear understanding of logical and physical database design and standards. 
• Experience in columnar data warehouse solutions like Redshift or Snowflake. 
• Must have extensive hands-on experience with MySQL in a large scale 24x7 production environment with millions of records.
• Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience

Bonus Points If You Have

• Experience with NoSQL solutions such as Cassandra/MongoDB etc.
• Experience with software development life cycle (SDLC) in an agile environment
• Hands-on production experience with Big Data applications such as Spark.
• Knowledge of development best practices (source control with Git, continuous integration, automated testing).

Responsible for driving and leading the analysis, design, development activities on assigned projects.
• Involved in entire SDLC lifecycle including analysis, development, fixing and monitoring of issues on the assigned product lines.
• Meets and exceeds standards for the quality and timeliness of the work products.
• Implements, unit tests, debugs and leads integrations of complex code.
• Identify opportunities for further enhancements and refinements to best practices, standards and processes. • Ensure robust, securely accessible, highly available and highly scalable product that meets or exceeds customer and end-user expectations
Experience 3 – 6 Years


Technical Duties & Responsibilities

With 2-4 years of experience in Scalable Architecture development. We are looking for Independent Contributors, who have good understanding of Microservices based architecture, and a comprehensive awareness of various architectures & their suitability as per product requirements: -
• Strong knowledge of microservices based architecture model.
• Good knowledge of messaging frameworks like RabbitMQ. Prefer a candidate who had earlier used messaging for a chat type solution or developed high transaction messaging queues.
• Should have experience in Elastic Search and Kibana. • Good understanding of RESTful architecture, database technologies (both SQL - and NoSQL).
• Ability to understand and solve performance issues and constraints.
• Should have understanding of scaling applications, and know the bottlenecks involved in resource optimization.
• Proficient in .Net framework and its languages with also good programming knowledge of JavaScript.
• Proficient in MS concepts like Asp.net, C#, MVC, webservices (development and consumption), API development
• Should have experience in Agile, iterative and Scrum based projects.
• Should have worked in a Test Driven Development (TDD) environment. Good knowledge of Object Oriented programming, Design Principles like SOLID, and Gang of Four Design patterns.

Customer / Tech Support Engineer JD

 

We are looking for a Customer Support Engineer/Tech Support Engineer who will be solving high-priority customer technical issues in a fast-paced environment. The support team is the foundation of everything the company does, and we take the role of supporting our merchants seriously. This is a highly cross-functional role; you'll work closely with company’s merchants to uncover their business goals and then coach them on the best ways to use the company website to achieve them. Your role would involve explaining technical concepts, providing support for overall systems testing and implementation into the production, and creating and improving documents that help customers solve their problems. If you are someone who enjoys solving merchants' technical problems, we want to hear from you.

• Participate in requirement, design discussions, and come up with solutions according to functional specifications
• Develop in-depth product expertise as a master Fulfil user and teacher
• Translate highly complex business requirements into technical solutions through efficient design and using appropriate tools and technologies
• Technical support and troubleshooting production issues and solution implementation
• Collaborating with the product team to share customer feedback, ensuring we continue to learn and improve our product and processes
• Identifying and resolving application issues, providing feedback for product improvements and overall direction
• Proactively identify areas of improvement and talk to our customers to ensure they are getting the most out of the product
• Involved in other programming and documentation including API references, guides, and tutorials
• Take an analytical approach to tracking points of friction for users, and then work with other teams to make those parts of our platform better

• Demonstrated proficiency with Python and SQL
• Relevant experience in working with eCommerce industry APIs e.g. Shopify, Magento, shipping carriers (e.g. USPS, DHL, FedEx etc), and Payment platforms
• Ability to adapt and write high-quality code that will be peer-reviewed.
• Familiarity with code versioning tools like GIT.
• Experience in working with web services i.e. HTTP, REST, JSON
• Superior interpersonal and customer support skills to provide excellent service
  
  

Roles and responsibilities:
1. To strive for continuous improvement of both technical and business knowledge
2. Engage proactively with stakeholders and other cross-functional team members in the
development of IT solutions
3. Ensure new database code meets company standards for readability,reliability and performance
4. Passionate about technology and applying it to business solutions
5. Work closely with business
The Ideal Candidate:
1. 3-6 years development experience with SQL SERVER / MySQL platforms
2. Strong Knowledge of T-SQL
3. A good understanding of data normalization,data modelling and database schema design
principals
4. Knowlegde of database optimization techniques
5. Monitor database performance , implement changes and apply new patches and versions when
required
6. Automate regular process, track issues and document changes
7. Assist developers with complex query tuning and schema refinement
8. Proven working experience as a Database administrator
9. Experience with backups,restores and recovery models

10. Knowledge of High-Availability (HA) and Disaster Recovery(DR) options for SQL Server
11. Experience on AWS technologies (RDS,EC2,EBS,S3,RedShift,Glue)
12. Experience in implementation & support of NoSQL technologies
redis,memcached,mongodb,elasticcache)
13. Hands on programming experience in Python
14. Ability to multi-task and work independently
15. Proficient in Waterfall & Agile development methodology especially when applied to stae-full
data environments
Good to have :
1. Experience with Financial Data, Capital Markets and Mutual funds industry/data
1. Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts
1. Understanding of Distributed Systems and Parallel Processing architecture

This is a startup about to be launched. We are looking for tech co founder who is willing to work on a great product built on Python and requires AI and Analytics. If this interests you then do join us.