Job Description

Company Description:


Josh Software is relentlessly focused on discovering, developing and delivering innovative solutions that connect our customers to the people they serve through the advanced use of technology. With our reach, range and resources, we provide our customers a universal platform for driving their vision into their markets using consistent and reliable technology solutions. Josh Software has more than 17 years' experience and operates in the key strategic geographies in the USA, Australia, Europe, SE Asia and India.

Skills (Must have):

• Strong understanding of relational database design and development.
• Proficiency in writing complex SQL queries and stored procedures.
• Hands-on experience with database utilities and tools for maintenance and performance optimization.
• Knowledge of database replication, tablespace management, and security best practices.
• Experience in providing guidance and collaboration with development teams.
Ability to automate database management tasks and optimize data loading processes.
•



Responsibilities:

• Create database objects such as triggers, indexes, and views to support applications.
• Set up and manage streaming replication between databases.
• Monitor database performance and make necessary adjustments for optimal performance.
• Identify and resolve potential database issues proactively.
• Manage and maintain database backups, and perform restoration as needed.
• Ensure database security by applying preventive measures and adhering to security guidelines.
• Schedule regular maintenance activities on database servers.
• Maintain the database schema and manage database availability.
• Provide best practice guidance to the development team regarding database usage.
• Resolve any production data-related issues and manage tablespaces.
• Manage roles, privileges, and user access permissions by adding or removing users as required.
• Automate data loading processes to improve efficiency.
• Develop and maintain relational databases to meet application needs.
• Ensure data integrity and manage user access through defined permissions.
• Utilize utilities like pg_ctl and psql for effective database management.
• Write complex queries, functions, and procedures to retrieve data as required.
Analyze query costs and implement optimizations to improve performance.
•



Qualification:

• M.C.A, B.Sc/MSc Computers, B.E /B.Tech in Computer Science, Engineering, or a related field.

Additional Information:

• We offer a competitive salary and excellent benefits that are above industry standard.
• Do check our impressive growth rate on LinkedIn and ratings on Glassdoor
• Pls submit your resume in this standard 1-page format or 2-page format


Job ID


33037
Job Type


Full-time
Location


Mumbai
Experience


3 - 5 Years
Business Unit


Data Engineering
Organization


-
Posted


November 15th 2024
Posted By


Harshal Ingale