
- Strong proficiency in MySQL database administration, migrations /up-gradation, patching, cloning, capacity planning, designing, and automation of database tasks.
- Good experience with the latest versions of the database
- In-depth experience configuring database replication on multiple versions
- Strong experience in Monitoring, DB Performance Tuning, DB Availability, DR, Security, Storage
- Analyzes and provides recommendations to optimize the database for improved performance, manageability, and scalability
- Expertise in enterprise backups, recovery, and performing point-in-time recovery Experience in deploying and integrating PM tools
- Experience in data partitioning and encryption
- Knowledge of de-facto standards and best practices in MySQL and MongoDB
- Proficient in writing and optimizing SQL statements and Knowledge of MySQL features, such as its event scheduler
- 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

Similar jobs
Requirements
• Extensive and expert programming experience in at least one general programming language (e. g.
Java, C, C++) & tech stack to write maintainable, scalable, unit-tested code.
• Experience with multi-threading and concurrency programming.
• Extensive experience in object oriented design skills, knowledge of design patterns, and a huge passion
and ability to design intuitive modules and class-level interfaces.
• Excellent coding skills - should be able to convert design into code fluently.
• Knowledge of Test Driven Development.
• Good understanding of databases (e. g. MySQL) and NoSQL (e. g. HBase, Elasticsearch, Aerospike etc).
• Strong desire to solve complex and interesting real world problems.
• Experience with full life cycle development in any programming language on a Linux platform.
• Go-getter attitude that reflects in energy and intent behind assigned tasks.
• Worked in a startup-like environment with high levels of ownership and commitment.
• BTech, MTech or Ph. D. in Computer Science or related technical discipline (or equivalent).
• Experience in building highly scalable business applications, which involve implementing large complex
business flows and dealing with huge amounts of data.
• 3+ years of experience in the art of writing code and solving problems on a large scale.
• Open communicator who shares thoughts and opinions frequently, listens intently, and takes
constructive feedback.
Task:
- Develop, record, and maintain cutting-edge web-based PHP applications.
- Build innovative, state-of-the-art applications and collaborate with the User Experience (UX) team
- Ensure HTML, CSS, and shared JavaScript is valid and consistent across applications.
- Prepare and maintain all applications utilizing standard development tools.
- Utilize backend data services and contribute to increase existing data services API.
- Lead the entire web application development life cycle right from concept stage to delivery and post launch support.
- Refactor, optimize, and improve the existing codebase for maintenance and scale.
- Use test driven development and acceptance tests to ensure feature quality
- Convey effectively with all task progress, evaluations, suggestions, schedules along with technical and process issues.
- Document the development process, architecture, and standard components.
- Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as a liaison between development staff and project manager.
- Keep abreast of new trends and best practices in web development.
We wish:
- Previous working experience as a PHP Developer for 4 year(s)
- User authentication and authorization between multiple systems, servers, and environments
- Integration of multiple data sources and databases into one system
- Familiarity with limitations of PHP as a platform and its workarounds
- Proficient in PHP, HTML5, JavaScript, JQuery Expert
- Experience with PHP MVC frameworks (Symfony, Laravel, Yii, CodeIgniter, Zend, etc.)
- Excellent relational database skills with MySQL
- Experience with building restful JSON web services
- Knowledge of API’s, such as Twitter, Facebook, Google maps, Instagram, etc.
- Understanding of responsive design frameworks such as bootstrap
Desirable:
- Should have problem-solving skills
- Good experience in oops concept
- Good experience in MVC
- Good experience in jQuery & JavaScript
- Learn & work on new technologies/ frameworks.
- Knowledge of bootstrap
We Offer:
- Freedom to realize your ideas & individual career & development opportunities.
- A motivating work environment, flat hierarchical structure, numerous company events that cannot be forgotten, and fun at the workplace with flexibilities.
- Professional challenges and career development opportunities.
HIRING SQL Developers with max 30 days Of NOTICE PERIOD
Job ID: TNS2022DB08
Who Should apply?
• Only for Serious job seekers
• Technically Strong Candidates who are willing to take up challenging roles and want to raise
their Career graph
• No DBA’s & BI Developers please
Why Think n Solutions Software?
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment
Criteria:
• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• Candidates will be selected based on logical / technical and scenario-based testing
Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.
Job Description:
1. Technical Skills Desired:
a. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS
Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in
an application development environment and eagerness to switch DB.
b. Design database tables, views, indexes
c. Write functions and procedures for Middle Tier Development Team
d. Work with any front-end developers in completing the database modules end to end
(hands-on experience in parsing of JSON & XML in Stored Procedures would be an
added advantage).
e. Query Optimization for performance improvement
f. Design & develop SSIS Packages or any other Transformation tools for ETL
2. Functional Skills Desired:
a. Banking / Insurance / Retail domain would be a plus.
b. Interaction with a client a plus.
3. Good to Have Skills:
a. Knowledge in a Cloud Platform (AWS / Azure)
b. Knowledge on version control system (SVN / Git)
c. Exposure to Quality and Process Management
d. Knowledge in Agile Methodology
4. Soft skills: (additional)
a. Team building (attitude to train, work along, mentor juniors)
b. Communication skills (all kinds)
c. Quality consciousness
d. Analytical acumen to all business requirement
e. Think out-of-box for business solution
- Manage and improve the engineering process continuously and make sure the team delivers the quality code with zero-waste.
- Should provide technical leadership to major projects, but also build and manage a team of 5-8 top-notch engineers.
- Should do sprint planning and run daily stand-ups and deliver 100% hit rate.
- Maintain the legacy code base and reduce tech debt on a continuous basis.
- Able to handle multiple projects and deliver with stringent timelines without compromising the code quality.
- Work with the product team for roadmap planning and delivery as per the plan.
- Conduct sprint planning & sizing, engineering grooming, daily stand-ups, and deliver with zero spillovers.
- Prepare & publish sprint reports to the leadership team and provide visibility to stakeholders.
- Hire and mentor junior/ senior team and make them engineering champions.
- Mentor the engineering team with your technical skills to write scalable, generic, reusable code.
- Develop and Coach engineers on the team, share engineering pointers, conduct regular 1-1s with the team, and help them advance in their careers.
Requirements
- Having work experience in a Product organization with 7 -10 yrs also in leading a cross-functional engineering team that includes API Development and Backend & Middleware development.
- Should have experience in the continuous delivery process. Ship new features and improvising the code base continuously.
- Should have involved in setting up engineering process.
- Must have experience in microservices and distributed patterns.
- Must have worked on high traffic and throughput application.
- Must have prior experience in handling mid to large-size projects.
- Must have worked on high traffic and throughput application.
- Should have managed and lead the engineering team of Web App and Backend development teams.
- Must-Have Experience in Python programming & Postgressql/ Nosql (MongoDB as a data store.
- Must have experience in modern back-end tech stacks (Django, Postgress, NoSQL) and cloud design & deployment patterns.
- Must be conversant with AWS, Docker/Kubernetes
- Should be good with design patterns and integration patterns.
- Should have knowledge/ experience in concurrent programming & distributed locks.
- Requires solid understanding of technologies and architecture in a highly scalable and available set-up.
- Should have handled multiple epics, themes, and experience of delivering high-quality projects on time.
- Should have managed end to end development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations

- Translation of complex functional requirements into technical requirements
- Design, develop and maintain complex systems using best of the breed development practices and technology.
- Responsible for the overall software development life cycle.
- Delivery of High Quality & Scalable systems and applications with a sharp focus on timelines.
- Being on the lookout for bettering the software engineering practices and tools within the organization
- Collaboration with other stakeholders to provide robust and well-rounded solutions
- Report on the status of product delivery and quality to management, customer support and product teams.
- Experience of 5+ years in designing & developing highly scalable, performant web applications
- Strong programming, debugging, and problem-solving skills
- Strong Computer Science Fundamentals (Data structures and Algorithms)
- Sound understanding of object-oriented programming and excellent software design skills.
- Good experience of Restful services using Java Springboot
- Strong understanding of database design and SQL (PostgreSQL / MySQL) development
- Good to have knowledge of NoSQL technologies like Redis, MongoDB, Cassandra or any other NoSQL database
- Knowledge of design patterns and good to have experience of large-scale applications
- Should have experience in Apache Kafka, RabbitMQ, SQS or other Queueing systems.
- Experience of working with Amazon Web Services (AWS), Google Cloud Computing (GCP) would be considered as an advantage
- Experience of developing with Serverless Model will be an advantage.
Ruby and Rails
Creating JSON based web services from Ruby on Rails (RoR) apps
HTML5, CSS3, JavaScript, jQuery, CoffeeScript, Ajax, lodash/underscore.js
A firm grasp of object-oriented analysis and design
Good to have knowledge in any front end framework, Angular or above versions, Backbonejs, Ember.js
Should have extensive experience in Agile software development principles, practice, and process
Should have worked on enterprise-cl applications
RoR Performance tuning and scaling
Proficiency in English strongly preferred
A proactive and resourceful person who achieves with minimal oversight
Team player with the ability and desire to become an integral part of a fast-paced team
Good knowledge of relational databases MySQL, Oracle, Microsoft SQL Server, DB2 or similar
Hands-on experience with at least one of the NoSQL environments like MongoDB, Couchbase, Cassandra
Experience with text search systems like elastic, solr or similar
Hands-on experience in integrating with third-party REST APIs
Managing code with Git and other version control tools
Good to have knowledge of Nginx
Why join the navy when you can be the pirate?
Get onboard this ship & let's make KYC and onboarding easier than ever!
We want to ensure that our tech is successfully consumed by end users easily.
We are looking forward to work with you.
We would love to have you for the following reasons :
- Strong hold in python based backends such as Flask & Django
- Knowledge of backend principles, patterns, and best practices
- Aware of the open-source ecosystem and the libraries available.
- Proficient understanding of Git
- Must have written Unit, Integration and UI Test Cases
- Understanding of Cloud hosting (AWS,Azure) principles and interface guidelines
- Experience in working with distrubuted data using REST APIs, JSON and other technologies
- Potential interns with experience in containers will hold an advantage.
- Experience in Kafka & ELK will be an advantage.
- Experience of 1-2 years.









