The Job logo

What

Where

Sign in

Database Performance Engineer - Pune

ApplyJoin for More Updates

You must Sign In before continuing to the company website to apply.

Job Description

Zycus is looking out for a Database Performance Engineer having expertise in Postgre database solutions including, configuration, performance tuning, troubleshooting, and backups.

Roles and Responsibilities:

  • The PostgreSQL and Mongo Database Performance Engineer will be responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases.
  • Must have strong experience in DB tuning and implementing optimized configurations as per application load
  • Hands on knowledge on writing stored procedures, functions, packages, triggers, and other database objects, to implement business logic and data processing
  • Optimize queries for efficient execution and improved database performance
  • Proficient in code reviews to ensure adherence to coding standards and best practices
  • Performance Tuning and resolve performance issues in the database and queries
  • Provide technical support and assistance to end-users, troubleshooting queries/DB related issues
  • Identify and resolve errors in queries for robust error handling
  • Design and create database objects, including tables, views, indexes, and sequences
  • Write complex SQL queries to retrieve, insert, update, and delete data
  • Familiar with SQL sub queries, Joins, applying Constraints
  • Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
  • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime.
  • Develop Stored Procedures and Database Triggers in support of application development.
  • Participate in application development projects and be responsible for the database architecture and design.
  • Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
  • Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
  • Responsible for efficient recovery of databases in case of crashes.
  • Responsible for regular maintenance of databases and proactive remediation of database operational problems.
  • Responsible for Query tuning and preventative maintenance.
  • Experience with Mongo DB ATLAS is nice to have but not mandatory
  • Support complex web-based applications.

Job Requirement

  • 5-8 years of relevant experience in PostgreSQL required
  • Experience in Performance Tuning of large Mongo DB instances
  • Experience as DBA in high-load, large-sized production DB
  • Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
  • Must have strong knowledge of AWS Cloud and Azure Cloud.
  • Good Knowledge of pgbadger and pgclue report analysis
  • Hands-on experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster).
  • Must have strong knowledge of Linux operating systems
  • Strong understanding of command line and server administration.
  • Knowledge of shell scripting (e.g., Bash, Perl).
  • Strong experience in Performance tuning
  • Excellent communication and presentation skills with the ability to communicate at all levels of the organization.
  • Technical leadership and mentoring skills to guide and act as SME.
  • Exceptional problem-solving skills
  • Keen to learn new technology with enthusiasm and critical thinking
  • Ability to work within a team environment. Self-starter and ability to perform work with minimal supervisory direction
  • Excellent analytical and problem solving skills
  • Ability to detect and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues. Have proficiency with Linux for basic administrative tasks
  • Experience with Unix/Linux including basic commands and basic shell scripting.
Set alert for similar jobsDatabase Performance Engineer - Pune role in Pune, India
Zycus Logo

Company

Zycus

Job Posted

a year ago

Job Type

Full-time

WorkMode

On-site

Experience Level

3-7 years

Category

Software Engineering

Locations

Pune, Maharashtra, India

Qualification

Bachelor

Applicants

Be an early applicant

Related Jobs

Zycus Logo

Database Performance Engineer- Mumbai

Zycus

Mumbai, Maharashtra, India

Posted: a year ago

Job Description Zycus  is looking out for a Database Performance Engineer having expertise in Postgre database solutions including, configuration, performance tuning, troubleshooting, and backups. Roles and Responsibilities: The PostgreSQL and Mongo Database Performance Engineer will be responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases. Must have strong experience in DB tuning and implementing optimized configurations as per application load Hands on knowledge on writing stored procedures, functions, packages, triggers, and other database objects, to implement business logic and data processing Optimize queries for efficient execution and improved database performance Proficient in code reviews to ensure adherence to coding standards and best practices Performance Tuning and resolve performance issues in the database and queries Provide technical support and assistance to end-users, troubleshooting queries/DB related issues Identify and resolve errors in queries for robust error handling Design and create database objects, including tables, views, indexes, and sequences Write complex SQL queries to retrieve, insert, update, and delete data Familiar with SQL sub queries, Joins, applying Constraints Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage. Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime. Develop Stored Procedures and Database Triggers in support of application development. Participate in application development projects and be responsible for the database architecture and design. Participate in the creation of development, staging, and production database instances, and the migration from one environment to another. Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release. Responsible for efficient recovery of databases in case of crashes. Responsible for regular maintenance of databases and proactive remediation of database operational problems. Responsible for Query tuning and preventative maintenance. Experience with Mongo DB ATLAS is nice to have but not mandatory Support complex web-based applications. Job Requirement 5-8 years of relevant experience in PostgreSQL required Experience in Performance Tuning of large Mongo DB instances Experience as DBA in high-load, large-sized production DB Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc. Must have strong knowledge of AWS Cloud and Azure Cloud. Good Knowledge of pgbadger and pgclue report analysis Hands-on experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster). Must have strong knowledge of Linux operating systems Strong understanding of command line and server administration. Knowledge of shell scripting (e.g., Bash, Perl). Strong experience in Performance tuning Excellent communication and presentation skills with the ability to communicate at all levels of the organization. Technical leadership and mentoring skills to guide and act as SME. Exceptional problem-solving skills Keen to learn new technology with enthusiasm and critical thinking Ability to work within a team environment. Self-starter and ability to perform work with minimal supervisory direction Excellent analytical and problem solving skills Ability to detect and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues. Have proficiency with Linux for basic administrative tasks Experience with Unix/Linux including basic commands and basic shell scripting.  

Zycus Logo

Database Performance Engineer - Bengaluru

Zycus

Bengaluru, Karnataka, India

Posted: a year ago

Job Description Zycus is looking out for a Database Performance Engineer having expertise in Postgre database solutions including, configuration, performance tuning, troubleshooting, and backups. Roles and Responsibilities: The PostgreSQL and Mongo Database Performance Engineer will be responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases. Must have strong experience in DB tuning and implementing optimized configurations as per application load Hands on knowledge on writing stored procedures, functions, packages, triggers, and other database objects, to implement business logic and data processing Optimize queries for efficient execution and improved database performance Proficient in code reviews to ensure adherence to coding standards and best practices Performance Tuning and resolve performance issues in the database and queries Provide technical support and assistance to end-users, troubleshooting queries/DB related issues Identify and resolve errors in queries for robust error handling Design and create database objects, including tables, views, indexes, and sequences Write complex SQL queries to retrieve, insert, update, and delete data Familiar with SQL sub queries, Joins, applying Constraints Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage. Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime. Develop Stored Procedures and Database Triggers in support of application development. Participate in application development projects and be responsible for the database architecture and design. Participate in the creation of development, staging, and production database instances, and the migration from one environment to another. Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release. Responsible for efficient recovery of databases in case of crashes. Responsible for regular maintenance of databases and proactive remediation of database operational problems. Responsible for Query tuning and preventative maintenance. Experience with Mongo DB ATLAS is nice to have but not mandatory Support complex web-based applications. Job Requirement 5-8 years of relevant experience in PostgreSQL required Experience in Performance Tuning of large Mongo DB instances Experience as DBA in high-load, large-sized production DB Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc. Must have strong knowledge of AWS Cloud and Azure Cloud. Good Knowledge of pgbadger and pgclue report analysis Hands-on experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster). Must have strong knowledge of Linux operating systems Strong understanding of command line and server administration. Knowledge of shell scripting (e.g., Bash, Perl). Strong experience in Performance tuning Excellent communication and presentation skills with the ability to communicate at all levels of the organization. Technical leadership and mentoring skills to guide and act as SME. Exceptional problem-solving skills Keen to learn new technology with enthusiasm and critical thinking Ability to work within a team environment. Self-starter and ability to perform work with minimal supervisory direction Excellent analytical and problem solving skills Ability to detect and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues. Have proficiency with Linux for basic administrative tasks Experience with Unix/Linux including basic commands and basic shell scripting

Capgemini Logo

Performance Test Engineer - JMETER

Capgemini

Pune, Maharashtra, India

Posted: a year ago

Job Description Performance Testing with JMeter  Strong knowledge on JMeter scripting and executions. Candidate should be able to configure distributed mode of JMeter execution.  Should have experience in different types of test executions like Load, Stress Endurance  Test analysis using tools like Dynatrace or AppDynamics.  Knowledge on Linux like VMStat or top commands for test analysis  Primary Skills JMeter Dynatrace or AppDynamics Experience in Trading application  Resiliency Testing  Secondary Skills Good Communication skills Good Analytical Skills

Zycus Logo

Product Trainer - Pune

Zycus

Pune, Maharashtra, India

Posted: a year ago

Job Description Zycus is hiring for a Global Client Training & Change Consultan t / Trainer as a change catalyst to be a part of its client learning center - Zycus University. Candidate with an excellent communications skills along with Product training experience would ideal match for this role. Candidate should Intervene to conduct Root Cause Analysis & implement Corrective and Preventive actions for any client dissatisfaction, process deviation, or delivery misses. Candidate with certified on procurement industry practices would be added advantage . Domain knowdelge in Procurement / Supply chain / entire supply chain function knowledge would be added advantage to the role. TTT certified preferred.  This is a key client facing role that calls for identification and implementation of  Organziational Change Management (OCM) projects for global clients. The Client Change Consultant / Trainer  also manages the training operations and will be looked at to stay abreast of practices that continually support user learning requirements & trends. Roles & Responsibilities: Create and lead Change Management projects for clients - end to end Manage change activities for, and train clients (Virtual and Onsite) as and when required to step in. This could entail international travel (as per requirement). Identify continuous improvement programs for the team, execute and track them for successful completion Intervene to conduct Root Cause Analysis & implement Corrective and Preventive actions for any client dissatisfaction, process deviation, or delivery misses Stay continually certified on procurement industry practices and Zycus Product suite Mentor team to enhance their domain/industry/functional knowledge and delivery Audit team and training material for quality of delivery and process, provide feedback, and report along with action plans Conduct daily scrums and one on one's to discuss status updates, action plans, and red flags Manage mapping and scheduling of the team (including all internal processes for the activity) Be available and open to work in Flexible working hours including night shifts Track and present Team’s MBOs to Sr. Management, highlight trends and deviations along with Analysis and next steps. Candidate should be open to travel across the global based on business requirement ( Post Pandamic in furture 50% travel would be involved)  Job Requirement Candidates with 2 to 8 years product training experience would be prefered.  Any industry background with product training delivery to 1 or more global customer exposure is a must. Excellent Communication is a Must.  Proven track record of leading change management projects for clients is a must OCM experience for software/procurement deployments is preferred (not Incident Management) Change Management certification is an added advantage Excellent training delivery skills ( TTT certified preferred ) High degree of self-motivation and strong orientation toward teamwork Strong grasp of Written and Spoken English Time Management & Effective Prioritization Ability to understand how businesses work, have excellent analytical and solution driven approach. Qualification : Any graduate / Post graduate can apply . Additional certitication in product training would be added advantage. 

Zycus Logo

Senior Product Manager - Pune

Zycus

Pune, Maharashtra, India

Posted: a year ago

Job Description Zycus is looking out for a Senior Product Manager with an experience of at least 4-6 years post MBA. Candidates with excellent knowledge in technology & consumer products, and with a Masters in Business Administration, from Premium B-Schools are invited to apply for this position. Senior Product Manager will play a critical role in owning the entire product Life Cycle, right from planning to execution. Eager beaver- attitude and an obsession with deadlines, analysis of the product performance and driving a solution set across development teams, will be the drivers for this role. The selected candidate is responsible for creating a world class product, improving customer adoption and satisfaction and has the complete ownership of the product road map and development plans. At Zycus, we strongly believe that only an empowered Product Management team can take a product forward and so we entrust our product managers to take all the product related decisions. We treat the product managers as CEOs for their products, and product managers are evaluated upon the product’s success. Also, product managers are our evangelists – they are responsible for articulating the products’ vision to customers, partners, analysts and internal stakeholders like sales, pre-sales and implementation teams. The Role & Responsibilities Of The Position Would Include Development and implementation strategies that help in the product growth. Interaction with users, perform market research, and develop the products. Product Strategy and Vision Laying out Web, Mobile (iOS, Android) strategy and roadmap. Multi-functional team collaboration to understand and prioritize requirements. Defining features & requirements. Conceptualization and detailed wire framing/prototyping. Writing user stories and grooming those with design and engineering teams. Agile Product Implementation. Strong understanding of recent & emerging IT trends and technical architecture. Product Marketing: Evangelizing, influencing and collaborating with the product marketing and communications team to ensure proper, informative, impactful engagement with the market through branding, blogs, e-mailers and white papers. Go-to Market: Conducting feature training and demo sessions with sales and support teams. Collaborating with product marketing and communication team for branding, blogs and product launches. Requirements Total experience: relevant experience: 4-6 yrs (relevant Product Management Experience) post full time MBA. Job Requirement Job Requirement 4-6 years of relevant Product Management Experience Full time MBA from a Tier 1 B-School Proving experience in building a commercially successful Complex Enterprise SAAS Software Product. Very strong logical thinking capabilities and analytical skills Ability to Visualize and conceptualize new ideas and solutions UI designing & prototyping (use of wire framing tools) Ability to manage teams and build close relationships with different team members and driving to success Team handling experience

Zycus Logo

Manager - Cloud Infra and Cyber Security - Pune

Zycus

Pune, Maharashtra, India

Posted: a year ago

Job Description Zycus is looking for Manager - SaaS Infrastructure with 6-8 years of relevant experience. In this role, you will oversee and manage the infrastructure that supports the delivery of SaaS applications to customers. You will be responsible for leading a team of engineers and technicians to ensure the efficient operation, scalability, and reliability of the infrastructure. Key Responsibilities:  Provide management of technology initiatives including creating comprehensive plans for achieving infrastructure and security project objectives. Architect and implement state-of-the-art network and security solutions/services to secure deployment and operations of Zycus services running in both public cloud and on-prem environment. Responsible for driving Iac (Infrastructure As a Code) program by requirement gathering, prioritizing and planning IaC activities to implement self-service IT and Security catalogue. Implement frameworks and best practices in addressing all security domains such as endpoints, networks, applications, and infrastructure. Manage application and network security by focusing on vulnerable areas: network, OS, application layer and APIs. Propose revision of infrastructure operations and perform complex tasks on critical infrastructure upgrades, security projects and infrastructure enhancements. Identify and help mitigate security issues, misconfigurations, and vulnerabilities related to on-prem and public cloud platforms, and Kubernetes infrastructure. Configure, test, deploy, and upgrade hardware and software for production and non-production infrastructure systems and services. Analyze, troubleshoot and resolve hardware, software, process, and system failures for a globally distributed enterprise Work cross-functionally with Engineering, DevOps, and SRE teams to design and implement IT and security baseline controls. Job Requirement Bachelor's degree in computer science or related field with minimum of 6-8 years of hands-on experience in Infrastructure (on-prem, public clouds) provisioning and management. Certifications in network security, cloud security such as CCNA, OSCP, AWS. Extensive experience designing, managing, building, configuring, administering, operating and maintaining IT infrastructure technologies is required. Experience managing and hardening of on-premises (VMware, vSphere, ESXi) server environments including storage platforms (NetApp). Experience managing cloud network resources (AWS Preferred) such as VPC, URL Proxies, DNS, ACLs, Security groups, s3, Firewalls, IAM. Experience with enterprise security products such as Palo Alto Firewall, CyberArk, Zscaler, CrowdStrike, Akamai.e. Hands on experience in CyberArk PAM solution is preferred. Proven understanding of DNS, NAT, routing, switching, L3 firewall, WAF, load balancers, endpoint security, email security, Active directory/Azure AD, SSO, MFA, TCP/IP, DHCP. Hands on experience with IaC (Infrastructure as a cloud) and automation tools/technologies such as Terraform, helm chart, Cloud Formation, AWS Code Build, Jenkins, configuration automation tools (Puppet/Ansible/Chef/Salt), scripting (e.g. Bash/Python) is preferred.  Working knowledge of the various components of a modern, scalable web application including CDNs, proxies, load balancers, application servers, Web servers (Apache, nginx) etc. Managing security projects using Jira/Confluence and agile fundamentals like test-driven development, backlog management, and user stories. Must have the ability to work in a dynamic, fast-paced environment with exceptional analytical and problem-solving skills. Strong communication skills with the ability to interact with stakeholders at various levels. Familiarity with migration of on-premises systems to a cloud platform (AWS, Azure) a plus. Hands-on experience with monitoring and patch management tools like New Relic, Tanium, Qualys and Redhat Satellite desirable. Experience with IaaS cloud infrastructure, container technologies, and software-oriented architecture. Application architectural patterns, such as MVC, Microservices, Service Oriented Architecture, Serverless, Message bus/event driven, etc.