ROLES AND RESPONSIBILITIES: Design stored procedures, views, functions, triggers, indexes, constraints in a PostgreSQL environment. Develop complex SQL code using joins, subqueries and troubleshoot the SQL code. Integration of multiple data sources and databases into one system. Build clean and reusable SQL queries for future use. Improve the performance and optimise SQL queries to get best results. Work with team members on design of software systems and support to development team. Establish processes and best practices with defined database standards. SKILLS / COMPETENCIES: Extensive experience working with enterprise applications using PostgreSQL. Strong knowledge and experience in query optimisation, performance tuning, using SQL profiler, Performance monitor and related monitoring tools. Experience developing complex queries, Stored Procedures, Views, Functions, Triggers and troubleshooting the same. Familiarity with RDBMS principles, normalisation, database design is an added advantage. Understanding of the fundamental design principles behind a scalable application. SPECIAL REQUIREMENTS FOR THE ROLE: 5+ years experience in SQL development, performance tuning and query optimisation. Strong analytical, problem solving, English communication skills, both written and spoken. Knowledge of PHP/ Laravel will be an added advantage. Experience with enterprise-scale systems a major plus.
Full stack developer with Excellent Technical knowledge and Hands on with • Java(IntelliJ , Tomcat, apache), J2EE (Spring and Hibernate) , OOPS, AngularJS, CSS , HTML5, SQL Join & Aggregation Queries, Stored Procedures. • Agile methodology (Scrum) with Visual Studio source control • REST APIs, MySql, AWS • 5-8 years of experience Note: You will be on permanent of “Infinitum Global” and work in client Location at Wipro, Bangalore This will be C2H, After 4 to 6 months you will be permanent with Wipro
Dear Candidate , Avhan is looking for MYSQL Developer having 2-4 years experience . JD . Experience in Microsoft SQL Server – T-SQL, Extract, Transform, Load (ETL) data operations. 2. Experience in design, develop, building and analyzing database management system to include database modeling and design relational database architecture based on Client requirements. 3. Advanced knowledge of SQL, ability to apply SQL creatively to a wide variety of business requirements. 4. Adding constraints to the tables, identifying columns for Indexes and using Hints, Index Seek in queries for performance. 5. Good use of Transaction Isolation levels in the procedure/queries. Experience in writing Stored Procedures, Triggers, Functions and Complex queries to support application development. 6. Optimizing (using Execution Plan), Debugging and testing the queries in procedures and others for performance efficiency. 7. Intermediate knowledge of Service Broker. Manage Client deliverables on quality, productivity and timeliness. 8. Database version: Microsoft SQL Server 2008, 2008 R2, 2012, 2014 and MySQL. 9. Third party tools like SQLToad, RedGate SQL Compare, TFS (Team Foundation Server).