Ruby on Rails Engineer

Profile: Senior PHP Developer

Experience- 10+Years

Mode: Remote

Required Skills:

• PHP (10+ years) & Symfony framework (5+ years)
• Team leadership experience (3+ years)
• OOP, design patterns, RESTful APIs
• Database optimization (MySQL/PostgreSQL)
• Git, CI/CD, testing frameworks
• Excellent communication skills

Responsibilities:

• Lead PHP/Symfony development
• Mentor team members
• Ensure code quality through reviews
• Collaborate with stakeholders
• Manage sprint cycles
• Optimize application performance

Job Description:

• To resolve the tickets raised as per the defined standards of time, cost, and quality for increased customer satisfaction.

Skills and Experience

• Good SQL & PLSQL knowledge.
• Good Unix basic commands knowledge.
• Good Unix scripting knowledge will be an advantage.
• ANSI SQL
• Unix - Others/
• Experience - Fresher

• Design, develop and manage data on various open-source SQL databases
• End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
• Database cluster connectivity and security
• Conduct database training
• Software installation and configuration
• Database patching and upgrading
• Using monitoring and management tools
• Troubleshoot various issues with other dba’s/developers
• Point of Contact for Vendor escalation
• Point of Contact for professional service to Customers
• Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
• Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
• Ensures project documentation is complete, current, and stored appropriately
• Manages day-to-day project and scope changes
• Communicate and coordinate database changes, backups, and downtime to users
• Identifies potential security issues and recommend strategies to ensure database security
• Research and evaluate new technologies
• Proactively monitor systems for optimum performance and capacity constraints
• Establish standards and best practices for SQL
• Interact with and coach developers in SQL scripting
• Perform database backup and recovery
• Provides 24x7 support for enterprise database systems

• Must provide mentoring and training to other staff members
• Write procedural documentation including requirements for databases
• Develop and coordinate knowledge transfer
• Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
• Interacts with business units to gather, define, and organize the delivery of business solutions Data
• Modeling, design & implementation based on established standards
• Automate manual tasks

• Candidate with a college degree and relevant work experience
• 7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
• Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
• Experience in database performance tuning and strong SQL tuning skills
• Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
• Must be familiar with RDBMS concepts, practices, and procedures
• Must have knowledge of network connectivity
• Extensive experience with Export/Import, Backup and Recovery
• Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
• Extensive experience with MySQL (MariaDB, Percona) Galera cluster
• Experience with MaxScale
• Proficient in SQL Language
• Knowledge of ServiceNow, or similar Ticket Management Software
• Knowledge of SAN infrastructure including HP and NetApp
• Ability to work on projects at a time
• Knowledge of middle-tier application servers
• Strong troubleshooting and problem resolution skills
• Good knowledge of Data Modeling
• Knowledge of XML and JDBC

• Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
• Certifications on MySQL, PostgreSQL, and Aurora

Work Experience Required:

1) Senior-level Developer with 3+ years of experience in .Net technologies (.NET Core).

2) Have good hands-on experience working with Angular / Vue JS (Preferable) / React

3) Have strong hands-on experience of Entity Framework and writing LINQ queries.

4) Typescript experience is a plus.

5) Strong Web API and MVC app development experience is a plus.

Important skills:

• Review requirements, create system design documents and develop solutions
• Proficiency in C#, Angular-2, http://asp.net/">ASP.NET, OOPS, http://ado.net/">ADO.NET, WCF, Amazon Web service & cloud, JQuery, LINQ, XML Schema, XSLT & SQL Server
• Web API & Entity Framework
• Should be well versed with Data Structures & algorithms, Multithreading, and optimization Technique.
• Knowledge of SOA architecture will be an added advantage.
• Should have capabilities to develop the core modules/components and should have experience in one or more complete life cycle modules
• Preferable if having an understanding of software development lifecycle and exposure to AGILE and SCRUM Methodologies
• Strong analytical and problem-solving skills and Excellent verbal and written communication skills
• Experience in Production support will be an added advantage.

The candidate for the role will be responsible for enabling single view for the data from multiple sources. 

• Work on creating data pipelines to graph database from data lake
• Design graph database
• Write Graph Database queries for front end team to use for visualization
• Enable machine learning algorithms on graph databases
• Guide and enable junior team members

B.Tech with 2-7 years of experience

Must Have

Hands-on exposure to Graph Databases like Neo4J, Janus etc..

1. Hands-on exposure to programming and scripting language like Python and PySpark
2. Knowledge of working on cloud platforms like GCP, AWS etc.
3. Knowledge of Graph Query languages like CQL, Gremlin etc.
4. Knowledge and experience of Machine Learning 

Good to Have

• Knowledge of working on Hadoop environment

• Knowledge of graph algorithms

• Ability to work on tight deadlines