DevOps Intern

Job Title: Database Administrator (PostgreSQL) 

Experience: 3 to 6 years 

Location: Gurgaon (Hybrid) 

Employment Type: Full-time 

Job Description: 

We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL and strong RDBMS concepts. The ideal candidate will be responsible for database performance monitoring, optimization, automation, and interaction with development teams to support business requirements. 

Key Responsibilities: 

1. Database Administration & Management 

• Manage, configure, and maintain PostgreSQL databases ensuring high availability and reliability. 
• Implement Primary-Slave replication architecture and ensure smooth data synchronization. 
• Work with AWS RDS for PostgreSQL database hosting. 
• Automate database backups and manage release versions for database changes. 
• Implement point-in-time recovery (PITR) backups in AWS RDS to ensure data integrity and disaster recovery. 

2. Performance Monitoring & Optimization 

• Regularly monitor database health and performance metrics. 
• Analyze and optimize slow queries to enhance application performance. 
• Fine-tune database performance using configuration parameters, buffers, connections, Disk IOPs, and memory. 

3. SQL Development & Optimization 

• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views. 
• Implement indexing strategies to improve query performance. 

4. Collaboration & Requirement Analysis 

• Work closely with application developers and business analysts to understand new product requirements. 
• Provide recommendations on database design and architecture for scalable solutions. 

5. Database Security & Compliance 

• Implement best practices for database security, access control, and data integrity. 
• Ensure compliance with data governance and security policies. 

6. Automation & Maintenance 

• Automate database maintenance tasks such as backups, indexing, and archiving. 
• Establish monitoring and alerting systems to proactively address database issues. 

Technical Expertise Required: 

• 3 to 6 years of experience as a Database Administrator (DBA). 
• Strong knowledge of PostgreSQL and RDBMS principles. 
• Experience in writing stored procedures, SQL functions, and SQL Views. 
• Hands-on experience in query optimization and performance tuning. 
• Understanding of Primary-Slave architecture and replication setup. 
• Knowledge of database configuration tuning (buffers, connections, Disk IOPs, Memory, etc.). 
• Experience in automating database backups and version control for DB changes. 
• Familiarity with AWS RDS for PostgreSQL and point-in-time backup (PITR). 
• Experience in cloud-based database solutions (AWS RDS, Azure, GCP). 
• Strong problem-solving and analytical skills. 

Preferred Qualifications: 

• Experience in high-availability solutions and disaster recovery strategies. 
• Exposure to NoSQL databases is a plus. 
• Experience with database migrations and upgrades. 

One of our premium-based product customers, we are looking to hire a team of software Developers in Bangalore, looking for Tech Geeks, who have 2+ years of experience full-time.

SENIOR SOFTWARE DEVELOPMENT ENGINEER - FRONTEND

● Overall, 2-4 years of experience.

● Solid foundations of Javascript, Responsive web, CSS, Semantic HTML and how the

internet works.

● Strong proficiency with React and its core principles. React Native is a plus.

● Solid understanding of Chrome dev tools, APIs and frontend performance.

● Working knowledge of GitHub and popular cloud platforms like AWS, Fly, Cloudflare,

etc.

● Understanding of software design patterns, high-level design and architecture.

● Ability to independently do LLD and technology exploration around a given problem

statement.

Roles and Responsibilities:

• Designing and producing animation content while collaborating with other artists in a team-focused environment.
• Conceive, layout, and design enticing motion graphics videos for various media.
• Collaborate with Creative Team in designing and creating boards, when required.
• Research and analyze the best design techniques and solutions for creating motion graphics.
• Assist in selecting audio, video, colors, animation, etc. for graphic design.
• Research and analyze the best design techniques and solutions to create motion graphics.
• Assist in designing and creating storyboards.
• Maintain up-to-date knowledge about the latest graphic design techniques. 

Requirements:

• Proficient with Adobe suites like After Effects, Premier Pro, Photoshop, and Illustrator.
• 1-6 years of professional experience.
• A clear understanding of visual hierarchy and information design concepts.
• Comfortable with social media and collaboration/project management tools.
• Strong portfolio showcasing his/her design and motion graphics skills.
• Knowledge of Lottie files and Bodymovin is a plus.

Kindly provide the online portfolio videos of the candidates through platforms like Behance or similar alternatives. Please refrain from sharing portfolios in Google Drive format.

• Develop new user-facing features
• Build reusable code and libraries for future use
• Ensure the technical feasibility of UI/UX designs
• Optimize application for maximum speed and scalability
• Assure that all user input is validated before submitting to the backend
• Collaborate with other team members and stakeholders

Skills And Qualifications

• Proficient understanding of web markup, including HTML5, CSS3
• Basic understanding of server-side CSS pre-processing platforms, such as LESS and SASS
• Proficient understanding of client-side scripting and JavaScript frameworks, including jQuery
• Good understanding of advanced JavaScript libraries and ReactJS frameworks.
• Good understanding of asynchronous request handling, partial page updates, and AJAX
• Basic knowledge of image authoring tools, to be able to crop, resize, or perform small adjustments on an image. Familiarity with tools such as Gimp or Photoshop is a plus.
• Proficient understanding of cross-browser compatibility issues and ways to work around them.
• Proficient understanding of code versioning tools, such as Git / Mercurial / SVN.
• Self-motivated and a good team player.
• Good communication and interpersonal skills.
• Preferred years of experience- 2- 3 years
• Bachelor’s Degree in Engineering from a reputed Institute.

• Write clean, scalable code using .NET programming languages
• Remain up to date with the terminology, concepts and best practices for coding mobile apps
• Develop technical interfaces, specifications, and architecture
• Use and adapt existing web applications for apps
• Create and test software prototypes
• Develop client displays and user interfaces
• Assist software personnel in handling project related work and other requirements
• Coordinate with other software professionals and developers

• Have architected /designed at least 2-3 systems/products of enterprise scale from scratch.
• Have banking and Financial service background and preferably worked in Mobile/Digital platform design and development. Payments /OLTP preferred.
• Should have experience of 20+ years with J2ee, REST, Microservice, API, Messaging, Encryption, security, NLP, ML background.
• Have 7+yrs of experience in Architecture field, designing and end to end not from consulting Architecture.
• Responsible for design, architecture, and delivery of a feature or component/product with the highest quality with high-level directions from architects
• Driving innovations in the platform constantly & remaining ahead of the curve
• Development and testing of features/functions delivered via applications and services.
• Prototype ideas quickly using cutting edge technologies.
• Collaborating with peers and Architects both within their team and across the organization to deliver end-to-end products & features
• Working with product managers using agile methodologies to deliver high quality solutions on time
• Provide functional, design, and code reviews in related areas of expertise with-in team and cross-team.
• Working with operations teams to ensure your applications and services are highly available and reliable
• Mentoring junior engineers in the team both in the technical as well as on the product side
• Define and devise processes, tools and methodologies to achieve excellence in software development, testing and deployment, and in the management of the Centre.
• Good experience in working with any of the programming languages like PHP, Python, Django, Golang, Java, C++
• Experience developing applications that use high volume of data along with experience building applications on top of RESTful APIs.
• Solid knowledge of JAVA, J2EE, data stream, processing, big data etc.
• Comfortable with writing unit tests using JUnit
• Worked with Git and are comfortable with Merge/Rebase concepts.
• Worked with tools such as Eclipse, WebStorm, Ant, Maven, Jenkins, Sonar, JSLint, Grunt and App Servers such as Tomcat, Jboss.
• Solid knowledge of algorithms, design patterns, and componentization approaches.
• Experience and knowledge of open source software, frameworks and broader cutting-edge technologies.
• Experience in software design patterns, problem solving and troubleshooting skills.
• Ability to determine impact of architectural solutions and recommendations.
• Must have experience in justification of technology solutions to business leaders.
• Experience in refactoring existing codebase and in understanding existing implementations to decide to refactor or rewrite.
• Know how to identify Performance bottlenecks and use good coding patterns to avoid them in the first place.
• Have strong attention to detail.
• Ability to operate effectively both independently as well and within a team using Agile methodology.
• Proven problem-solving and interpersonal communication skills.
• Knowledge of payment domain will be an added advantage

Qualifications

• BE/BTech/ME/MTech in EE/CS or an equivalent qualification.
• 20+yrs of Experience.
• Minimum 12+years of hands on Java programming experience.