Mh Dba consultant Jobs – 12 Open Jobs Today

MS SQL DBA CONSULTANT
Swathi Business Solutions —Mumbai, Maharashtra
- Rotational shift
- Microsoft Access
- Azure
- Windows
Consultant - Oracle App DBA
Yash Technologies —Pune, Maharashtra
- Oracle
- Software troubleshooting
- Databases
3d
Sr. Consultant - Enterprise Application - Oracle N 4B
Genpact India Pvt. Ltd. —Pune, Maharashtra
- Full-time
- Hybrid work
- Microsoft Access
- Oracle
- Computer Science
Quick apply
Oracle Apps DBA Consultant
Depth Consultancy Services —Mumbai, Maharashtra
- Email
- Oracle
- Bachelor's degree
Senior Technical Lead
HCLTech —Pune, Maharashtra
- Master's degree
- AI
Specialist - System Management
LTM —Pune, Maharashtra
- Oracle
- DevOps
- Databases
Quick apply
9d
Senior Analyst
Eclerx —Mumbai, Maharashtra
- Full-time
- Oracle
- Master's degree
- SQL
Senior Process Manager
Eclerx —Mumbai, Maharashtra
- Oracle
- Master's degree
- SQL

I want to receive the latest job alerts for dba consultant in mh

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

dba consultant jobs near mh

Database Administrator jobs in Pune, Maharashtra

Oracle Consultant jobs in Pune, Maharashtra

Senior Analyst jobs in Mumbai, Maharashtra

Database Administrator jobs in Mumbai, Maharashtra

Senior Technical Lead jobs in Pune, Maharashtra

Senior Process Manager jobs in Mumbai, Maharashtra

Database Administrator jobs in Chennai, Tamil Nadu

Database Administrator jobs in Ghaziabad, Uttar Pradesh

System Administrator Linux Redhat, Linux , Sql jobs in Madurai, Tamil Nadu

Database Administrator jobs in Kphb Colony, Hyderabad, Telangana

Server Administrator jobs in Chennai, Tamil Nadu

Database Administrator jobs in Surat, Gujarat

Database Administrator jobs in Ballygunge, Kolkata, West Bengal

Oracle Consultant jobs in Kolkata, West Bengal

Oracle Consultant jobs in Bengaluru, Karnataka

Walkin Interview, Sap Consultant jobs in Hyderabad, Telangana

Travel Consultant jobs in Mumbai, Maharashtra

Oracle Consultant jobs in T Nagar, Chennai, Tamil Nadu

Marketing Analyst jobs in Bengaluru, Karnataka

Senior Citizens jobs in Mira Road, Mumbai, Maharashtra

MS SQL DBA CONSULTANT

Swathi Business Solutions
Mumbai, Maharashtra

Apply Now

Job details

Qualifications

RDBMS
Microsoft Access
Azure
Buffer (application)
Ansible
MCSE
Microsoft SQL Server
SSRS
Windows
SQL
Database design
Database administration
AWS
Analysis skills
Bachelor's degree
ITIL
Business continuity planning
SSIS
Clustering
Communication skills
Pre-sales
Active Directory
High availability

Full job description

Experience: 6 - 8 YEARS

Location: MUMBAI

CTC TO BE OFFERED : Mention Your Current & Expected CTC

Notice Period: IMMEDIATE

KeySkills:

DATABASE, DBA ADMINISTRATION, DATABASE AUTOMATION, DATABASE ARCHITECTURE, DATABASE MIGRATION, DATABASE SECURITY, PERFORMANCE TUNING, HIGH AVAILABILITY, BACKUP & RECOVERY, MONITORING, REPORTING, CLOUD, OPERATING SYSTEM, NETWORKING, ETL, REPORTING, ITSM

Job Description:

Provide database administration service along with Team Lead.

Coordination with Global customers.

Following standard team processes and defines new ones with corrections.

The individuals will be expected to be fully-functional DBA’s who can perform traditional DBA

activities independently and guide team members too.

Able to provide escalation support whenever required.

From an operational perspective, responsibilities include troubleshooting problems, working

maintenance windows and providing 24x7 on-call supports on a rotational basis.

Database automation for MSSQL using Ansible

Pre-installation Tasks

Installing SQL Server and Patch Mgmt

Installing & Maintaining DB Tools

Uninstallation

Database Upgrade

Database Migration

Database Patch Installation

Physical Database Design and Implementation

Database Setup in 32 and 64 architecture

Database Clean up / Removal

DB Cloning

Design Database, RAID configuration & Capacity Planning for Large Databases

Setup and implement Cluster Setup in multiple nodes environment

Implement High Availability configuration like replication and log shipping

Start up and shutdown of Database instances

Maintaining Database replication / standby / clusters

Job scheduling

Verify all Instances and dependent services are running

Look for any new error log entries

Session / Process Monitoring

Query or Transaction monitoring

Lock and Deadlock monitoring

Activity / Transaction Log monitoring

Job monitoring and Purging Job history

Replication / Log shipping monitoring

Monitor Space usage /growth of Database objects

Verify free space in filegroups / databases

Monitor transaction log growth and truncate schedule

Reorganization of DB to remove fragmentation

Update Stats for hot objects

Purging of DB logs and trace files

Schedule maintenance plans for maintenance like DBCC REINDEX / INDEX DEFRAG

Creation and schedule maintenance plans and jobs for update stats , defragmentation, checking database integrity

Verify that Server has enough resources for acceptable performance

Periodic Report Generation on Database Health

Identify bad growth projections

Identify space-bound objects

Review contention for CPU, memory, network, and disk resources

Generating statistics

Look for objects that break rules.

Ensure that all indexes use an index tablespace

Ensure that all tables have unique primary keys.

Look for harmful growth rates

Examine tuning opportunities.

Look for I/O Contention

Review fragmentation by investigating row chaining and other areas of fragmentation

Database Objects Creation / Review

Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc

Capture Performance Statistics using performance monitors

User / Schema Creation

User Management

Roles and Privileges Management

Look for security policy violations

Privileges & Access controls on Database
Verify that the database backup was successful

Backup execution and monitoring

Define Backup policy and retention policy for complete/differential/transaction backup

Conduct Backup, restoration drills for backup verification in different scenarios

Database Connectivity issues

Slow response

Operations timed out

Dead locks

Database Hangs

Database incident and error resolution

Transaction Log Backup Stuck for Space

Database incident and error resolution

Vendor Management

System Performance Monitoring

Maintaining Environment details and change management

Windows Scripting for automations of DB related work

SSIS and SSRS

Implement ITIL processes & Maintain Transition Management Docket

Adherence to Change Management Process

Presales knowledge / experience is added advantage.

Implement ITIL processes & Create Transition Management Dockets

Presales knowledge / experience is added advantage.

QUALIFICATION:

As per the Project Requirement

EXPECTED SKILLS / EXPERIENCE (L1 / L2 / L3) : L3

At least SQL DBA experience of 6+ years is required

Thorough Knowledge of Windows Operating System, Networks and Active Directory

Knowledge of creating and maintaining standby / replication setup

Strong in SQL fundamentals

Knowledge of using Enterprise Manager and Query Analyzed for basic administration

Knowledge of configuring and setting up maintenance activities for DB

Knowledge of SQL statements tuning and DB Tuning

Knowledge on DB structures (filegroups, Indexes - clustered /non clustered/fillfactor)

Knowledge on Memory structures (configurable parameters)

Knowledge of complete /differential / transactional backups and their recovery scenarios

Knowledge on High Availability configuration like replication and log shipping , cluster setup

Knowledge of DTS and bcp and other data load tools across same and different RDBMS

Knowledge on database design and storage recommendation and NTFS file systems & capacity planning

Knowledge in making scripts for automations , writing procedures and functions

Knowledge of ITIL processes & Transition Management

Excellent communication Skills

Prior experience in a 24x7 environment desired

Strong analytical and troubleshooting skills.

Provide on-call support as and when required

Ability to handle pressure

ADDITIONAL QUALIFICATION / SKILLS:

Team Leader

MCSE MSSQL Certification is mandatory

Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on

In depth Knowledge on SQL server 2008, 2012, 2014, 2016, 2017, 2019, 2022 Versions.

Cloud, Azure, AWS

Database automation for MSSQL using Ansible

PERSONAL ATTRIBUTES :

Accepts Responsibility

Openness

Positive attitude

Integrity

Commitment

Judgement

Organized

Proactive

Note:

(i) Our client is looking for immediate & early joiners.

(ii) Having LinkedIn Profile is a must.

(iii) Being an immediate & high priority requirement interested candidates can share their Resumes with Photograph in word doc. format

Apply Now

Refine Your Search

dba consultant jobs in mh

MS SQL DBA CONSULTANT

Consultant - Oracle App DBA

Sr. Consultant - Enterprise Application - Oracle N 4B

Oracle Apps DBA Consultant

Senior Technical Lead

Specialist - System Management

Senior Analyst

Senior Process Manager

I want to receive the latest job alerts for dba consultant in mh

Explore jobs in more locations

Experience: 6 - 8 YEARS

Location: MUMBAI

CTC TO BE OFFERED : Mention Your Current & Expected CTC

Notice Period: IMMEDIATE

KeySkills:

Job Description:

Note:

Jobseeker tools

Employer Tools

Browse

Stay Connected