Database Administrator Lead

4 days ago

Mumbai, Maharashtra, India Zensar Full time ₹ 5,00,000 - ₹ 15,00,000 per year

Description

Profile :DBA

A database administrator (DBA) manages computer databases.The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.

Year relevant Experience

DB

Oracle, MS SQL, MySQL, PostgreSQL

Skill Set

Capacity Planning

Ensuring that the database hardware and configuration allows for good operational readiness at any appropriate, planned level of usage.

Knowledge and data to show the current capacity of systems which are in place and the impact on future plans for growth.

Installation

Installing as per vendor best-practice documentation in a manner which allows for best-possible performance

By preparing well, you ensure that you do not need to change an entire configuration later, at the cost of downtime.

Configuration

Ensuring that the database configuration handles user needs

DB has enough RAM / CPU / Disk IO to handle queries

DB is maintained to ensure data-files are defragmented,

  • indexes are reorganized and pruned
  • statistics are up to date
  • No critical errors are happening
  • No poison wait types are in the Management views

Knowing the impact of each configuration option in SQL server to its operation

E.g. knowing that enabling Snapshot Isolation Transactions mean that TempDB is going to be working much harder and so disk reads/writes are critical to monitor when this option is enabled.

Database Design

DBA should have their own DB which audits changes to the DB and its configuration as well as auditing logons to the server and changed made to schema.

Migration

DBA should be able to migrate to new hardware as needed

Performance Monitoring

  • When queries to the server are slow at certain times but not at other times, this points to a DB problem, not an application issue
  • DBA needs to be able to explain why the DB is slow at certain times (common issues are CPU, Disk, RAM, Locking/Blocking)
  • If a DBA can determine that it is definitely application SQL which is bad 100% of the time, they can engage the vendor for assistance or a patch

Security

The DBA team are responsible for the security of data stored in the database, both in terms of disaster planning as well as physical security

Managing logons (users) for the database as well as roles and permissions

Monitoring for unauthorized access or suspicious activity such as deletions of data

Many of our customers use an Audit database which tracks changes using the SQL Server Events' system.

Troubleshooting

  • Errors which show up in the error logs, the Management Views of SQL server or the Agent log should be resolved
  • Some of these could be trivial while others could indicate corruption of data that needs to be remedied via the SQL server toolset

Backup and Recovery

Checking the integrity of backups and the validity of the recovery process is usually done quarterly

  • Lead Database Administrator

    4 weeks ago

    Mumbai, Maharashtra, India Evoke HR Solutions Full time

    Key Responsibilities : - Team Leadership : Lead and mentor a team of 5 DBAs, ensuring efficient operations and knowledge sharing.- Greenplum Administration : Manage the installation, configuration, and maintenance of Greenplum V6.x databases.- Performance Optimization : Monitor and optimize Greenplum performance, addressing issues like data skew and vacuum...

  • Database Administrator

    4 weeks ago

    Mumbai, Maharashtra, India TeamLease Edtech Full time

    Job DescriptionTeamLeaseEdTech is a leading Indian learningandemployability solutions provider that enables universities to create and manage online, distance, and blended programs via a mobilefirst, cloudbased platform. It has exclusive partnerships with about 4050 major universities across 16 states, offering over 200 accredited degree, diploma, and...

  • Lead Oracle Database Administrator

    5 days ago

    Mumbai, Maharashtra, India Innova ESI Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job Summary : We are looking for an experienced L3 Oracle DBA to manage, maintain, and optimize Oracle database systems. The ideal candidate will be responsible for database administration, performance tuning, security, backup and recovery, and ensuring high availability. Key Responsibilities :Install, configure, and upgrade Oracle database software and...

  • Regional Database Administrator

    5 days ago

    Mumbai, Maharashtra, India Linfox Asia Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    We are a leading logistics company committed to leveraging data to drive efficiency and innovation in our operations. We are seeking an experienced Data Administrator who is adept in managing databases, leading a team of Data Engineers, BI, and Data Integration resources. The ideal candidate will have extensive experience with Azure SQL, MS SQL, Oracle, and...

  • Database Administrator

    5 days ago

    Mumbai, Maharashtra, India Natobotics Technologies Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Urgent hiring for Database Admin with our esteemed banking client for Mumbai Powai.Exp: 10+yrsLocation: Mumbai PowaiFunctional Role: Database administratorJob Responsibilities:Engineer and automate various database platforms and services.Assist in the ongoing process of rationalizing the technology and usage of databases.Participate in the creation and...

  • Database Administrator

    1 week ago

    Mumbai, Maharashtra, India YO IT CONSULTING Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job Title : Database Administrator (In-House)Location : MumbaiExpeience : 3 to 5 Work Mode : On-site (Day Job, 5 Days a Week; flexibility required for weekends, nights, or remote work as per demand)Role Overview : We are seeking a skilled Database Administrator (DBA) with hands-on experience in managing Linux-based environments and relational databases....

  • Lead Database Administrator

    3 weeks ago

    Mumbai, Maharashtra, India Simple Logic IT Private Limited Full time

    Dear Candidate, Kindly find the Job Description below for your reference. Job Title: Lead Database Administrator Location: Vikhroli, Mumbai (all areas) & Navi Mumbai Required Skills & Experience: PostgreSQL DBA (Level 3) 7+ years of hands-on PostgreSQL DBA experience in production environments. Deep knowledge of PostgreSQL internals, architecture, and...

  • Oracle Database Administrator

    2 days ago

    Mumbai, Maharashtra, India Accelya Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Oracle Database AdministratorVikhroli, MumbaiRole purpose As Database Administrator, you will ensure data to the application tier is performant, secure and recoverable. You will be responsible for maintaining the integrity and performance of company databases and guarantee that data is stored securely and optimallyDuties and Responsibilities:Responsible for...

  • Database Administrator

    4 weeks ago

    Mumbai, Maharashtra, India Connect2Talent Full time

    Job Title : Database Administrator (DBA)Experience : 46 YearsLocation : Bangalore / MumbaiJob Type : Full-time | PermanentNotice Period : 30 DaysAbout the Role : We are seeking an experienced and detail-oriented Database Administrator (DBA) with strong expertise in Oracle, MySQL, PostgreSQL, and MongoDB. The ideal candidate will be responsible for...

  • Database Administrator

    4 days ago

    Mumbai, Maharashtra, India Mindspace Software Technologies Pvt. Ltd. Full time US$ 90,000 - US$ 1,20,000 per year

    Job Description:We are seeking an experienced Database Administrator to design, manage, and optimize our database systems. The role involves installation, performance tuning, normalization, archiving, and ensuring data integrity, availability, and security.Responsibilities:Install, configure, and maintain databases (MySQL, PostgreSQL, Oracle, SQL Server,...