6 Database Schemas Jobs

Key Responsibilities Develop, test, and maintain robust server-side applications and APIs. Design and optimize database schemas and queries (SQL/NoSQL). Implement security and data protection measures. Collaborate with front-end developers to integrate user-facing elements with server logic. Troubleshoot, debug, and improve existing backend codebases. Write clean, maintainable, and well-documented code. Ensure high performance and responsiveness to requests from front-end. Participate in code reviews and team discussions. Stay updated with emerging technologies and industry trends.

Key Responsibilities: Database Management: Install, configure, and upgrade MySQL database servers and related tools. Design and implement database schemas, tables, indexes, views, stored procedures, functions, and triggers. Manage database capacity planning, storage, and space utilization. Implement and manage MySQL replication strategies (e.g., master-slave, GTID-based, semi-synchronous, Percona/Galera Cluster) for high availability and disaster recovery. Oversee data migration activities between different database systems. Develop and maintain documentation for database architectures, processes, and best practices. Performance Tuning and Optimization: Monitor database performance using tools like Percona Monitoring and Management (PMM), Query Profiler, slow query logs, Prometheus, and Grafana. Proactively identify and resolve database performance bottlenecks, including optimizing SQL queries, index design, and storage engine configurations. Analyze execution plans and recommend improvements. Configure database parameters for optimal performance. Backup and Recovery: Design, implement, and test comprehensive backup and recovery strategies to ensure business continuity and data integrity. Perform regular and ad-hoc full, differential, and log backups. Manage point-in-time recovery operations. Develop and maintain disaster recovery plans and participate in disaster recovery drills. Security and Compliance: Implement and enforce database security measures, including user access control, permissions, roles, and encryption. Conduct regular security audits and vulnerability assessments. Apply database patches and updates to address security vulnerabilities. Ensure compliance with data protection regulations and company policies. Troubleshooting and Support: Diagnose and resolve complex database issues, including latency, downtime, and scalability challenges. Provide proactive and reactive data management support to development teams and end-users. Participate in on-call rotation for production support as needed. Automation and Scripting: Automate routine database administration tasks using scripting languages (e.g., Bash, Python, Perl). Contribute to CI/CD pipelines for database deployment and management. Utilize infrastructure-as-code (IaC) tools like Terraform or Ansible for database provisioning and configuration. Collaboration and Communication: Collaborate effectively with developers, system administrators, and other IT teams to ensure seamless application integration and support. Translate business requirements into technical design specifications. Provide guidance and mentorship to junior DBAs and team members.

Skilled in database design, performance tuning, SQL optimization, and data security. Expert in stored procedures, data integrity, backups, and cross-functional collaboration for robust DB solutions. Mail:kowsalya.k@srsinfoway.com

Strong in JavaScript Frameworks Strong in HLDs & LLDs Strong into System design database Schemas Excellent in Coding Convention & Quality Standards Exp. in 3rd party skills (REST APIs, SOAP APIs, XML, JSON SaaS Application, AWS with S3, EKS, RDS, EC2 Required Candidate profile Building Application (Profilers, APM tools, Security Scanning Tools Exp in CI/CD tooling Competency frontend framework/Library ie React, Angular or NodeJS Developing Production Code TypeScript & React

We are seeking skilled SQL Developers with a minimum of 1 year of development experience to join us as freelancers and contribute to impactful projects Key Responsibilities: Write clean, efficient code for data processing and transformation Debug and resolve technical issues Evaluate and review code to ensure quality and compliance Required Qualifications: 1+ year of SQL development experience Expertise in writing complex SQL queries, optimizing database performance Designing database schemas Proficient in working with relational database management systems like MySQL, PostgreSQL, or SQL Server Flexible hours Remote opportunity Location-Delhi NCR,Bangalore,Chennai,Pune,Kolkata,Ahmedabad,Mumbai,Hyderabad

Job Summary Outmarch is a fast-growing retail startup searching for flexible go-getters who welcome the challenge of meeting the needs of a growing business. Your primary focus will be on developing and maintaining our backend infrastructure, including APIs, microservices, and databases. You will be responsible for ensuring that our backend systems are scalable, performant, and secure. You will also work closely with our front-end developers to ensure that our APIs are well-documented and easy to use. Responsibilities Design, develop, and maintain backend systems using Node.js Build and maintain APIs using RESTful principles Develop and maintain microservices using microservice architectures Design and optimize database schemas Implement security measures to protect our backend systems Write well-documented code and maintain clear documentation Work closely with front-end developers to ensure a smooth integration between the backend and frontend Collaborate with other backend developers to share knowledge and solve problems Required Skills Bachelor's degree in computer science, information technology, or a related technical field Strong proficiency in Node.js, Express, and other relevant frameworks and libraries Experience with database technologies, such as PostgreSQL or MongoDB Experience with microservice architectures Experience with API development using RESTful principles Excellent problem-solving and debugging skills Strong communication and collaboration skills Job Type: Internship Schedule: Day shift Monday to Friday