
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.

Similar jobs



Job description:
Full Stack Asp.net developer essential knowledge in:
1) Asp.net MVC with C#.net, Asp.net Webforms added advantage,
2) Sql Server 2014 or above with strong hold on joins, stored procedures and handling larger database tables
3) Javascript/Jquery with skills on html and css.
4) Making and consuming RESTful web apis through Asp.net MVC application and jquery.
5) IIS management knowledge is the added advantage.
6) Loyalty Domain experience or knowledge is added advantage.
(OR)
7) Travel Domain experience or knowledge is added advantage.


We are now looking for,
Senior SW Developer – IoT Platform Development
to join the team of experts at the KONE Services & Solutions R&D. You will work together with other professionals to develop advanced KONE digital solutions that leverage the latest in cloud and connectivity technologies.
You are a cloud development expert who is passionate about designing and implementing solutions for our connectivity solutions. You are familiar with the software development patterns and can turn the architectural plans to concrete SW designs. You understand and appreciate the modern SW development practices. You work at your best when you are working with people, and you enjoy helping others.
You will work in a key role inside our Agile SW development team. Your closest colleagues will be other developers, test professionals and the PO of the team. You will be part of KONE Technology and Innovation unit’s IoT Tribe.
Main responsibilities include,
- Producing more efficient software designs for new features in our IoT platform tribe
- Developing clean and efficient code based on the specifications.
- Unit and Integration Testing for the developed code and integrate with code coverage tools.
- Verify and deploy programs and systems
- Recommend and execute improvement for the existing offerings from the IoT platform.
- Create technical documentation for reference and reporting.
- Participating in knowledge sharing and demos
To be successful in this role,
- Having a degree in Computer Science or equivalent with minimum 5+ years of relevant working experience.
- More than 3 years proven experience in developing high volume scalable cloud solutions utilizing platforms like Amazon AWS with IoT domain.
- Having hands on development experience with Java, Node JS and TypeScript.
- Experience working with MVC, WEB API, RESTful services with IoT domain
- Team player with capabilities to take the lead and develop own competencies around the core knowledge is a must.
- Understanding of React JS is an added advantage.
- Strong experience with Serverless Cloud Compute Services with AWS or Azure
- Experience in working with AWS platform and its core services like Lambda, CloudWatch, CloudFormation, CDK, SQS, S3 etc., or its equivalent Azure services
- Understanding of Serverless design, network security, cloud design patterns, high availability and secure systems.
- Hands on experience with both SQL and No-SQL databases.
- Experience on DevOps ways of working with good understanding on CI/CD
As an Oracle Process Manufacturing Functional Consultant, he will be providing functional inputs and support to the Oracle EBS team. The selected candidate must have experience in modules like Oracle Process Manufacturing, Sub ledger accounting and OPM financials with at least 2 implementations.
- - Bachelor’s Degree or foreign equivalent, will consider work experience in lieu of a degree.
- - 5 Years & above relevant Experience.
- - Have full life cycle implementations experience, with hands-on configuration, implementation and support.
- - Should be able to understand Business requirements and map them to proposed solutions/enhancements.
- - Testing and deployment of custom solutions.
- - Participate in functional testing and co-ordinate with cross functional stakeholders for timely delivery of the solutions developed
- Must have the experience of leading teams and drive customer interactions
- Must have multiple successful deployments user stories
- Extensive hands on experience in Apache Spark along with HiveQL
- Sound knowledge in Amazon Web Services or any other Cloud environment.
- Experienced in data flow orchestration using Apache Airflow
- JSON, XML, CSV, Parquet file formats with snappy compression.
- File movements between HDFS and AWS S3
- Experience in shell scripting and scripting to automate report generation and migration of reports to AWS S3
- Worked in building a data pipeline using Pandas and Flask FrameworkGood Familiarity with Anaconda and Jupyternotebook
We are looking for Senior Tally Developer to integrate our platform with Tally.
Job responsibilities will be cross-functional - ranging from "clean" coding to architectural changes to client interactions. Over a period of time, you're expected to challenge the existing tech stack and add your baby components to it. A person should be a team player, should have an eye for detail and problem-solving skills.
Requirements:
- 4+ Years of experience as a Tally Developer
- Insightful knowledge in building TDLs for Tally
- Familiarity with Agile development methodologies.
- Do high-level technical design with guidance, functional modeling, break-down of the module by thinking platforms, and re-use.
- Sense of ownership and attention to detail.

Responsibilities
- Installing and configuring Informatica components, including high availability; managing server activations and de-activations for all environments; ensuring that all systems and procedures adhere to organizational best practices
- Day to day administration of the Informatica Suite of services (PowerCenter, IDS, Metadata, Glossary and Analyst).
- Informatica capacity planning and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed.
- Manage backup and security of Data Integration Infrastructure.
- Design, develop, and maintain all data warehouse, data marts, and ETL functions for the organization as a part of an infrastructure team.
- Consult with users, management, vendors, and technicians to assess computing needs and system requirements.
- Develop and interpret organizational goals, policies, and procedures.
- Evaluate the organization's technology use and needs and recommend improvements, such as software upgrades.
- Prepare and review operational reports or project progress reports.
- Assist in the daily operations of the Architecture Team , analyzing workflow, establishing priorities, developing standards, and setting deadlines.
- Work with vendors to manage support SLA’s and influence vendor product roadmap
- Provide leadership and guidance in technical meetings, define standards and assist/provide status updates
- Work with cross functional operations teams such as systems, storage and network to design technology stacks.
Preferred Qualifications
- Minimum 6+ years’ experience as Informatica Engineer and Developer role
- Minimum of 5+ years’ experience in an ETL environment as a developer.
- Minimum of 5+ years of experience in SQL coding and understanding of databases
- Proficiency in Python
- Proficiency in command line troubleshooting
- Proficiency in writing code in Perl/Shell scripting languages
- Understanding of Java and concepts of Object-oriented programming
- Good understanding of systems, networking, and storage
- Strong knowledge of scalability and high availability



