Talent.com
PostgreSQL DBA

PostgreSQL DBA

MNJ SOFTWAREOsage City, KS, US
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.job_card.permanent
job_description.job_card.job_description

Overview

Join to apply for the PostgreSQL DBA role at MNJ SOFTWARE

MNJ SOFTWARE is an IT services, business solutions and outsourcing organization that delivers real results to global businesses, ensuring a level of certainty no other firm can match.

MNJ SOFTWARE offers a consulting-led, integrated portfolio of IT and IT-enabled services delivered through its Global Network Delivery Model, recognized as the benchmark of excellence in software development. MNJ SOFTWARE service offerings span business and technology consulting, application services, systems integration, product engineering, custom software development, maintenance, re-engineering, independent testing and validation services, IT infrastructure services and business process outsourcing. MNJ SOFTWARE takes pride in building strategic long-term client relationships. MNJ SOFTWARE is only hiring those authorized to work in India and unable to provide visa sponsorship at this time.

Job Details

  • JobID : J0101
  • Title : PostgreSQL DBA
  • Experience : 3-6 yrs
  • Job Type : Permanent / Contract [Depends on Project Needs or C2H]
  • Position Type : Full time [Monday – Friday]. Employees are required to have flexibility to work any of our 9-hour shift schedules during our normal business hours of (6am - 10pm IST) or (6pm to 6am IST). It may be necessary, given the business need, to work occasional overtime [unpaid].
  • Qualification : ME / M.TECH / BE / B.TECH / MCA / M.Sc(IT) etc

Technical / Functional Skills

  • Experienced with PostgreSQL & PostgreSQL Architecture.
  • Ability to Independently Monitor and Administrator databases.
  • Creation & managing PostgreSQL Schema, Tables, Tablespaces and Users, Roles & Groups.
  • PostgreSQL Index Management, Partitioning and System Catalogs.
  • Performance tuning, Query tuning by generating and explaining plan for SQL queries.
  • Expert in Backup & Recovery including Pg_dump, Setting up WAL archiving, Point in time recovery.
  • Knowledge on PG Admin and other PostgreSQL tools and utilities.
  • Knowledge on High Availability, Streaming Replication, Replication Failover, Repmgr, Barman, PG Bouncer and PG pathman.
  • Monitoring = Alert Log, Scheduled Jobs and Troubleshooting Database Problems.
  • Roles & Responsibilities

  • Hands on maintenance activities such as vacuum, vacuum full, analyze the database.
  • Understanding of basic Database Fundamentals : MVCC, Concurrency, Transactions, Indexing, Locking.
  • Analyze, recommend and implement configuration for Optimized Performance.
  • Ability to plan hardware capacity requirements for Storage, Memory and CPU Cycles.
  • Expert with setting and trouble shoot replication issues.
  • Understanding of UNIX environment with Shell Scripting.
  • Personal Attributes

  • Must be Analytical and possess good problem-solving capabilities
  • Independent thinker
  • Process

    Aptitude Tests, Technical Tests, Interviews, Medical Health Checkup.

    Reimbursement

    Best in Industry

    Certification

    Optional

    Location

    Remote (Work From Home)

    Competencies

  • Professionalism – Knowledge of general office and administrative support including MNJ SOFTWARE administrative policies, processes and procedures. Demonstrates professional competence and mastery of subject matter; is conscientious and efficient in meeting commitments, observing deadlines and achieving results; remains calm in stressful situations. Commitment to implementing the goal of gender equality by ensuring equal participation and full involvement of women and men in all aspects of work.
  • Teamwork – Works collaboratively with colleagues to achieve organizational goals; solicits input by genuinely valuing others' ideas and expertise; is willing to learn from others; places team agenda before personal agenda; shares credit for team accomplishments and accepts joint responsibility for team shortcomings; ability to work beyond normal hours.
  • Planning and Organizing – Develops clear goals that are consistent with agreed strategies; identifies priority activities and assignments; adjusts priorities as required; allocates appropriate amount of time and resources for completing work; foresees risks and allows for contingencies when planning; uses time efficiently.
  • Assessment – Evaluation of qualified candidates may include an assessment exercise which may be followed by competency-based interview.
  • Languages – English is the working language of this above stated post. For this post, fluency in oral and written English is required.
  • Note

    We\'re an Equal Opportunity Employer : You will receive consideration for employment without regard to race, sex, color, religion, sexual orientation, gender identity, national origin, protected veteran status, or on the basis of disability.

    No Fee

    MNJ SOFTWARE DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING).

    General Considerations

    According to policies and processes of MNJ SOFTWARE, the paramount consideration in the employment of the staff is the necessity of securing the highest standards of efficiency, competence, and integrity. Candidates will not be considered for employment with MNJ SOFTWARE if they have committed violations of national / international human rights law, violations of national / international humanitarian law, sexual exploitation, sexual abuse, or sexual harassment, or if there are reasonable grounds to believe that they have been involved in the commission of any of these acts. The term "sexual exploitation" means any actual or attempted abuse of a position of vulnerability, differential power, or trust, for sexual purposes, including, but not limited to, profiting monetarily, socially or politically from the sexual exploitation of another. The term "sexual abuse" means the actual or threatened physical intrusion of a sexual nature, whether by force or under unequal or coercive conditions. The term "sexual harassment" means any unwelcome conduct of a sexual nature that might reasonably be expected or be perceived to cause offence or humiliation, when such conduct interferes with work, is made a condition of employment or creates an intimidating, hostile or offensive work environment, and when the gravity of the conduct warrants the termination of the perpetrator's working relationship. Candidates who have committed crimes other than minor traffic offences may not be considered for employment.

    Due regard will be paid to the importance of recruiting the staff on as wide a geographical basis as possible. The MNJ SOFTWARE places no restrictions on the eligibility of men and women to participate in any capacity and under conditions of equality in its principal and subsidiary organs. The MNJ OFFICE is a non-smoking environment.

    The paramount consideration in the appointment, transfer, or promotion of staff shall be the necessity of securing the highest standards of efficiency, competence, and integrity. By accepting an offer of appointment, MNJ staff members are subject to the authority of the Managers and assignment by him or her to any activities or offices of the MNJ in accordance with staff regulation. In this context, all internationally recruited staff members shall be required to move periodically to discharge new functions within or across duty stations under conditions established by the MNJ.

    The evaluation of applicants will be conducted on the basis of the information submitted in the application according to the evaluation criteria of the job opening and the applicable internal legislations of the MNJ, the Staff Regulations and Rules, administrative issuances and guidelines. Applicants must provide complete and accurate information pertaining to their personal profile and qualifications according to the instructions provided in inspira to be considered for the current job opening. No amendment, addition, deletion, revision or modification shall be made to applications that have been submitted. Candidates under serious consideration for selection will be subject to reference checks to verify the information provided in the application.

    Seniority level

  • Mid-Senior level
  • Employment type

  • Full-time
  • Job function

  • Information Technology
  • Industries

  • IT Services and IT Consulting
  • #J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Postgresql Dba • Osage City, KS, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Senior Database Developer

    Senior Database Developer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Analyst / Database Developer to enhance data analytics capabilities in the pharmaceutical industry. Key Responsibilities Design, develop, and maintain the DATAstrea...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Remote Workday Database Administrator

    Remote Workday Database Administrator

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    A company is looking for a Remote Workday Database Administrator V.Key Responsibilities Manage day-to-day Workday configurations, integrations, and security assignments Build and maintain advanc...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior Databricks Architect

    Senior Databricks Architect

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Lead Consultant (Databricks Architect).Key Responsibilities Serve as the technical lead for project teams, ensuring high-quality execution and alignment with bes...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Database Escalation Engineer

    Database Escalation Engineer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Escalation Engineer - Federal.Key Responsibilities Support production reliability and scalability of customer applications and infrastructure services Restore...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior ADABAS Mainframe Programmer

    Senior ADABAS Mainframe Programmer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior ADABAS Mainframe Systems Programmer.Key Responsibilities Perform mainframe database software upgrades, administration, and tuning for ADABAS environments Manage...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Remote Senior Financial Analyst - AI Trainer

    Remote Senior Financial Analyst - AI Trainer

    Data AnnotationLawrence, Kansas
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Database Administrator

    Database Administrator

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Administrator III.Key Responsibilities Maintain multiple DB Server environments in Azure and On-Prem Partner with other Database Administrators to ensure data...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Database Developer

    Database Developer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Developer (Postgres / AWS).Key Responsibilities Design, develop, and implement cloud-based database architectures Manage and optimize Postgres / AWS Aurora en...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Database Support Engineer

    Database Support Engineer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Support Engineer - EMEA.Key Responsibilities Provide technical support to customers on TimescaleDB, including administration, design, optimization, and impleme...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle Database Administrator

    Oracle Database Administrator

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle Database Administrator to join their team in a remote position.Key Responsibilities Manage Oracle Development and database interfaces including ETL processes an...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Contract Database Specialist

    Contract Database Specialist

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Contract Database / Data Warehouse Specialist.Key Responsibilities Analyze and optimize storage strategies for ML experiment data and metadata Design and implement int...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Databricks Engineer

    Senior Databricks Engineer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Databricks Engineer / Cloud Data Engineer (Remote).Key Responsibilities Design, build, and optimize data pipelines using Databricks, Apache Spark, and Delta Lake...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Database Administrator (Postgres)

    Database Administrator (Postgres)

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Administrator (Postgres / AWS).Key Responsibilities Design, develop, and implement cloud-based database architectures Manage and optimize Postgres / AWS Auror...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Oracle Database Developer

    Oracle Database Developer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for an Applications Development Engineer.Key Responsibilities Develop and optimize Oracle databases, including advanced PL / SQL programming and procedure design Manage and mo...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Database Engineer

    Senior Database Engineer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Database Engineer.Key Responsibilities Design optimal Postgres data models and optimize data structures for performance Analyze database query load, manage upgr...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Database Engineer

    Database Engineer

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Engineer Contractor.Key Responsibilities Design and support highly scalable OLTP architectures Leverage Azure cloud data technologies for efficient data manag...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle GoldenGate Consultant

    Oracle GoldenGate Consultant

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle GoldenGate Consultant.Key Responsibilities Collaborate with clients to assess data management needs and current infrastructure Design and implement data integr...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior Database Administrator

    Senior Database Administrator

    VirtualVocationsTopeka, Kansas, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Database Administrator to manage and optimize database infrastructures.Key Responsibilities Administer and optimize Oracle and PostgreSQL databases in on-prem an...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30