Database Developer/Programmer
Position : Database Programmer:
Job Description / Required Skills
- Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.
- Hands-on development experience with T-SQL.
- Strong experience on Database designing, normalization, optimization and performance tuning.
- Experience in advanced SQL programming, problem-solving and analytical skills.
- Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.
- Experience in Refactoring/troubleshooting existing databases as needed.
- Deep understanding of referential integrity and indexing.
- Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.
- Ability to estimate development tasks accurately and meet agreed upon deadlines.
- Understanding of code promotion, version control and QA procedures.
- Good Communication skills.
Technical Skills:
- MySql, MS-SQL, SQL Server Management Studio and SQL Server Profiler.
- PostgreSQL
- DCL, DDL, DML Scripts.
- T-SQL, SSRS and SSIS
- OS Environments: Windows XP/Windows 7, Windows Server 2003/2008
Experience : 3 to 4 years
Qualification : B. Tech/BE/MCA/MSC Computers
Location : Mumbai
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs
Go Programming (Golang)
Ruby on Rails (ROR)
Ruby
Python
JavaJob Responsibilities
✓ Perform the role of Technical Lead on assigned projects to drive solution design (especially backend) and API services development.
✓ Be the thought leader and champion for above mentioned technologies.
✓ Drive technical analysis for new projects including planning and driving proof-of-concepts, if needed.
✓ Drive tasks related to backend development by providing architectural and technical leadership to mid-tier and database developers.
✓ Conduct peer reviews as the lead into Git to confirmed that developed code meets acceptable standards and guidelines.
✓ Work closely with the rest of the leads, mid-tier development, front-end developers, database developers, etc. to ensure end-to-end integrity of the solution being developed.
✓ Work closely with the rest of the tech leads and senior engineering leadership team to ensure reuse where applicable to increase productivity and throughput.
✓ Conduct technical interview to staff open positions in the backend team.
✓ Delegate work and assignments to team members
✓ Collaborate with their team to identify and fix technical problems
✓ Analyze users' needs and then finding applications to serve them
✓ Drive assigned tasks related to SOC 2 certification and ensure compliance to defined controls for areas under lead’s purview.
✓ Guiding their team through technical issues and challenges
✓ Prepare Technical design documents which would help the team to understand the technical flow
✓ Active participation in customer calls especially discussions related to Technical/Architectural and provide inputs.
Required Experience:
✓ Backend Lead around 14 years of experience
✓ Server less Computing Architecture
✓ NodeJS, MySQL, Jenkins, Python, GitLab Technologies
✓ Good knowledge of AWS Cloud
✓ Full cycle AWS implementation experience
✓ Project experience in development and maintenance support for AWS web service and Cloudbased implementations
✓ Experience leading teams of up to 10 + professionals
Ability to manage multiple tasks and projects in a fast-moving environment
Educational Qualifications:
Engineering graduate or B. Tech/MCA with relevant major subjects like Computer Science
Java
Spring Boot
Amazon Web Services (AWS)Required Skills:
- 4+ year of experience in Development in JAVA technology.
- Strong Java Basics
- SpringBoot or Spring MVC
- Hands on experience on Relational Databases (SQL query or Hibernate) + Mongo (JSON parsing)
- Proficient in REST API development
- Messaging Queue (RabitMQ or Kafka)
- Microservices
- Any Caching Mechanism
- Good at problem solving
Good to Have Skills:
- 4+ years of experience in using Java/J2EE tech stacks
- Good understanding of data structures and algorithms.
- Excellent analytical and problem solving skills.
- Ability to work in a fast-paced internet start-up environment.
- Experience in technical mentorship/coaching is highly desirable.
- Understanding of AI/ML algorithms is a plus.
PHP
Laravel
CodeIgniter
jQuery- Experience in JQuery is mandatory.
- Experience in PHP ORM framework is mandatory (Doctrine ORM or any other ORM- s).
- Experience in HTML, CSS.
- Strong in Object-Oriented Concepts.
- Experience in MYSQL.
- Good to have knowledge Of React.
- Need to be professional in Laravel MVC framework.
- Having knowledge in PHP, CSS3, HTML5, JavaScript, JSON/REST, JQuery, AJAX, Bootstrap4 is preferable.
We are looking to hire a talented PHP developer to manage our back-end services and ensure a seamless interchange of data between the server and our users. As a PHP developer, you will be responsible for developing and coding all server-side logic. You will also be required to maintain the central database and respond to requests from front-end developers.
To ensure success as a PHP developer, you should have in-depth knowledge of object-oriented PHP programming, understanding of MVC designs, and working knowledge of front-end technologies including HTML5, JavaScript, and CSS3. Ultimately, a top-level PHP Developer can design and build efficient PHP modules while seamlessly integrating front-end technologies.
PHP Developer Responsibilities:
- Conducting analysis of website and application requirements.
- Writing back-end code and building efficient PHP modules.
- Developing back-end portals with an optimized database.
- Troubleshooting application and code issues.
- Integrating data storage solutions.
- Responding to integration requests from front-end developers.
- Finalizing back-end features and testing web applications.
- Updating and altering application features to enhance performance.
PHP Developer Requirements:
- Bachelor’s degree in computer science or a similar field.
- Knowledge of PHP web frameworks including Yii, Laravel, and CodeIgniter.
- Knowledge of front-end technologies including CSS3, JavaScript, and HTML5.
- Understanding of object-oriented PHP programming.
- Previous experience creating scalable applications.
- Proficient with code versioning tools including Git, Mercurial, CVS, and SVN.
- Familiarity with SQL/NoSQL databases.
- Ability to project manage.
- Good problem-solving skills.
Ruby on Rails (ROR)Ruby
Javascript
MongoDBWe are looking to hire a talented ruby on rails developer to manage the interchange of data between our users and the server. You will be responsible for developing and maintaining the server-side logic for the central database, testing performance, troubleshooting, and integrating front-end elements into the application.
To ensure success as a ruby on rails developer, you should have extensive experience working with ruby and back-end integration techniques. Ultimately, a top-level ruby on rails developer can create clean, functional code that perfectly suits the needs of the company.
Ruby on Rails Developer Responsibilities:
- Designing and developing new web applications.
- Maintaining and troubleshooting existing web applications.
- Writing and maintaining reliable Ruby code.
- Integrating data storage solutions.
- Creating back-end components.
- Identifying and fixing bottlenecks and bugs.
- Integrating user-facing elements designed by the front-end team.
- Connecting applications with additional web servers.
- Maintaining APIs.
Ruby on Rails Developer Requirements:
- Bachelor’s degree in computer science, computer engineering, or related field.
- Experience working with ruby on rails as well as libraries like Resque and RSpec.
- Ability to write clean ruby code.
- Proficiency with code versioning tools including Git, Github, SVN, and Mercurial.
- Experience with AngularJS or BackboneJS.
- Familiarity with MVC, Mocking, RESTful, and ORM.
- Good understanding of front-end technologies including HTML5, JavaScript, and CSS3.
- Knowledge of server-side templating languages including Slim and Liquid.
- Familiarity with testing tools.
JavaSpring BootRequired Qualifications and Skills:
- 3-5 years of work experience in the development background, with at least 2 years experience in Java, Spring, Sprint Boot, Hibernate or JPA, MySQL, Oracle, Spring MVC.
- B.E. degree in Computer Science, Graduate in Software Engineering or equivalent
- Experience in Core JAVA, Spring, Spring Boot Frameworks.
- Experience with ORM's like Hibernate.
- Good knowledge of developing RESTful web services using Spring Boot, Java1.x,Servlet2.4, JSP2.0, JDBC3.0, Java Mail, Struts2.x, HTML, HTML5, Angular7+, JavaScript, JSF, Bootstrap2.x-3.x, JQuery & CSS 3.x, Maven 3.x, Apache Tomcat7
- Knowledge of Cloud AWS.
- Experience in any Messaging Queue e.g. Apache Kafka, ActiveMQ, etc.
- Experience on Web services with REST and SOAP.
- Experience working on tool set like Eclipse IDE, SQL clients.
- Experience using application server like Jboss, TomCat, Wildfly, glassfish.
- Experience in using tools like SOAP UI, POSTMAN
- Ability to write SQL queries to fetch data.
- Knowledge of Micro services, Redis Cache and Mongo DB (or any other NoSQL) is good to have
.NET
C#
HTML/CSS- Participate in requirement analysis
- Write clean, scalable code using .NET
- Test and Deploy applications and systems
SKILLS:
- Must have good command on c#
- Should have knowledge on the official ASP.NET, ANGULAR JS and MVC
PostgreSQLC#The Database Developer will perform day-to-day database management, maintenance and troubleshooting by providing Tier 1 and Tier 2 support for diverse platforms including, but not limited to, MS SQL, Azure SQL, MySQL,
PostgreSQL and Amazon Redshift.
They are responsible for maintaining functional/technical support documentation
and operational documentation as well as reporting on performance metrics associated with job activity and platform
stability.
Must adhere to SLAs pertaining to data movement and provide evidence and supporting documentation for incidents that violate those SLAs.
Other responsibilities include API development and integrations via Azure
Functions, C# or Python.
Essential Duties and Responsibilities
• Advanced problem-solving skills
• Excellent communication skills
• Advanced T-SQL scripting skills
• Query optimization and performance tuning familiarity with traces, execution plans and server
logs
• SSIS package development and support
• PowerShell scripting
• Report visualization via SSRS, Power BI and/or Jupityr Nootbook
• Maintain functional/technical support documentation
• Maintain operational documentation specific to automated jobs and job steps
• Develop, implement and support user defined stored procedures, functions and (indexed) views
• Monitor database activities and provide Tier 1 and Tier 2 production support
• Provide functional and technical support to ensure performance, operation and stability of
database systems
• Manage data ingress and egress
• Track issue and/or project deliverables in Jira
• Assist in RDBMS patching, upgrades and enhancements
• Prepare database reports for managers as needed
• API integrations and development
Background/Experience
• Bachelor or advanced degree in computer science
• Microsoft SQL Server 2016 or higher
• Working knowledge of MySQL, PostgreSQL and/or Amazon Redshift
• C# and/or Python
Supervisory/Budget Responsibility
• No Supervisory Responsibility/No Budget Responsibility
Level of Authority to Make Decisions
The Database Developers expedite issue resolution pursuant to the functional/technical documentation available.
Issue escalation is at their discretion and should result in additional functional/technical documentation for future
reference.
However, individual problem solving, decision making and performance tuning will constitute 75% of their time.
Javascript
NodeJS (Node.js)
GitHTML/CSSJavascript
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon