Database Administrator

8 - 13 years

10 - 18 Lacs

Posted:1 day ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

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 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

Classification: Confidential

• 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.Role & responsibilities

Preferred candidate profile

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Wenger & Watson logo
Wenger & Watson

Recruitment/Staffing

Winchester

RecommendedJobs for You

bengaluru, karnataka, india