Postgresql Database Administrator

1 day ago

Chennai, Tamil Nadu, India Chola MS Full time

Job Description

Designation : Postgres DBA

Job Location : Chennai

Job Objective

The Database Administrator role is to administer design database schemas, all type of database objects like tables, views, stored procedures, functions etc for IT project, including maintaining databases while ensuring high levels of data availability. The Database Administrator will evaluate and advise on all technology components for database management systems and applications. They may handle databases for entire systems as well as for individual applications. Using their analytical and problem-solving skills, database administrators help companies structure their data in a way where it's easily accessible, valid and secure environment. work on continues upgradation of technical artifacts.

Core Responsibilities:

  • Postgres SQL, SQL Server, Enterprise monitoring.
  • Extensive work experience on query optimization, script optimization, other related optimization tools and techniques including Performance monitoring.
  • Design and create database objects such as data table structures, stored procedures, views, Triggers, reports, Database Administration, Configuration, Maintenance and Support.
  • Data migration, backup, restore & recovery, Resolving performance issues, blocking and deadlocks.
  • Implement and Monitor 2-Node Active\Passive clustering to provide High Availability for mission critical events, database mirroring, replication and log shipping.
  • Implement and maintain security and integrity controls including backup and disaster recovery strategies for DBMS.
  • Help in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
  • Create alerts and notifications, operator, Database mail configuration for system errors, insufficient resources and fatal database errors.
  • Database partitioning, replication, Migration
  • Able to handle large database (more than 1 TB)
  • Integrate Database with Windows Active directory security for database/table level permissions
  • Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
  • Coordinate and work with other technical staff to develop relational databases and secondary databases, Identify inefficiencies in current databases and investigate solutions.
  • Diagnose and resolve database access and security issues.
  • Plan and execute data migrations between different database systems.
  • Develop, implement, and maintain change control and testing processes for modifications to databases. Ensure all database systems meet business and performance requirements.
  • Creating and scheduling Jobs in Database, ETL, deploy SQL patches, Perform Data Migration Activity.
  • Coordination with respective OEMs/Vendors.

Education and Experience

Education: B.E or B.Tech in CS or PG in IT/CS or equivalent

Experience:

  • 7+ years of experience in database administration using Postgres
  • Work experience must span over 5 turn key projects (end to end) as DBA
  • Certification in DBA

Essential Skills

  • Experience in Postgres database architecture logical and physical design
  • Experience in Postgres SQL/ MS SQL Server database architecture logical and physical design (preferable)
  • Knowledge of BI tools
  • Experience of querying/ data retrieving using multiple database types
  • Exposure to Database administration jobs
  • Scheduling tasks, jobs, and data migration
  • Knowledge of Postgres administration on Linux / Windows
  • Knowledge of Client tools for Postgres/ MS SQL

  • Database Administrator

    2 weeks ago

    Chennai, Tamil Nadu, India SourcingXPress Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Company:Udu Labs Private LimitedWebsite:Visit WebsiteBusiness Type:StartupCompany Type:Product & ServiceBusiness Model:B2BFunding Stage:SeedIndustry:Software DevelopmentJob DescriptionThis is a full-time, on-site role for a Database Administrator located in Chennai. The Database Administrator will be responsible for maintaining and managing databases,...

  • Database Engineer(PostgreSQL)

    1 day ago

    Chennai, Tamil Nadu, India Workday Full time

    Your work days are brighter here.We're obsessed with making hard work pay off, for our people, our customers, and the world around us. As a Fortune 500 company and a leading AI platform for managing people, money, and agents, we're shaping the future of work so teams can reach their potential and focus on what matters most. The minute you join, you'll feel...

  • MySQL database administrator

    7 days ago

    Chennai, Tamil Nadu, India Open Hand Solutions Full time

    Location : Chandigarh / Chennai We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other...

  • Senior Database Administrator

    3 days ago

    Chennai, Tamil Nadu, India Fidelity Investments Full time

    Job DescriptionJob Title: Senior Database AdministratorThe Purpose of This RoleApplication DBA – Lead role is a Production Database Support team under WI Data Engineering Team. This team supports various databases to manage WI critical applications for the business. WI Database Administration Support group provides database services related to the Oracle,...

  • Principal Database Administrator

    2 weeks ago

    Chennai, Tamil Nadu, India Fidelity Full time

    The Purpose of This RoleApplication DBA Principal role is a Production Database Support team under WI Data Engineering Team. This team supports various databases to manage WI critical applications for the business. WI Database Administration Support group provides database services related to the Oracle, SQL, PostgreSQL hosted in On-Premises, Azure / AWS and...

  • PostgreSQL

    3 weeks ago

    Chennai, Tamil Nadu, India, Tamil Nadu Tata Consultancy Services Full time

    Role - PL/SQL DeveloperLocation - Experience - 4 to 10 yrsPostgres SQL performance tuning expert. 1. Should know the PostgreSQL database and working experience as well. 2. Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning. 3. In Performance tuning -Constraints creations,...

  • Senior Oracle Database Administrator

    2 weeks ago

    Chennai, Tamil Nadu, India Aalayam Selveer co MAPA Solutions Full time ₹ 10,00,000 - ₹ 20,00,000 per year

    Senior Oracle Database AdministratorChennai, IndiaAbout the RoleWe are looking for an experienced Oracle Database Administrator (DBA) to join our growing technical team in New Jersey. The Oracle DBA will be responsible for the design, implementation, maintenance, and performance tuning of Oracle databases supporting mission-critical enterprise applications....

  • Oracle Database Administrator

    3 weeks ago

    Chennai, Tamil Nadu, India, Tamil Nadu Tata Consultancy Services Full time

    TCS present an excellent opportunity for Oracle DBAJob Location: Chennai, KolkataExperience required : 8-12 yrsInterview Date: 13-Nov-25 (Thursday)Must-Have10–15 years of experience in Oracle Database Administration.In-depth knowledge of Oracle versions 12c, 19c, and 21c.Experience with RAC (Real Application Clusters) and ASM (Automatic Storage...

  • Oracle Database Administrator

    6 days ago

    Chennai, Tamil Nadu, India, Tamil Nadu Tata Consultancy Services Full time

    TCS present an excellent opportunity for Oracle DBAJob Location: Kolkata, ChennaiExperience required : 8-12 yrsVirtual Interview date: 20-Nov-25 (Thursday)Must-Have10–15 years of experience in Oracle Database Administration.In-depth knowledge of Oracle versions 12c, 19c, and 21c.Experience with RAC (Real Application Clusters) and ASM (Automatic Storage...

  • Database Administrator

    7 days ago

    Chennai, Tamil Nadu, India Tata Consultancy Services Full time

    We are hiring forDatabase Administrator .Role: Database AdministratorExperience: 8 years to 10 yearsLocation: Hyd,Delhi,Mumbai,Pune,Banglore,ChennaiTechnical skill- Mongo DBInterested candidates can send their resume on below mail ID along with below details-Please share below details-Full Name:Email:Contact Details:Total Experience:Current...