Upload Button Icon Add office photos
filter salaries All Filters

2 Crest IT Consulting Jobs

Crest IT Consulting - Database Administrator - MySQL/PostgreSQL (2-4 yrs)

2-4 years

Crest IT Consulting - Database Administrator - MySQL/PostgreSQL (2-4 yrs)

Crest IT Consulting

posted 2mon ago

Job Role Insights

Flexible timing

Job Description

Job Summary :

We are seeking a skilled and proactive Database Administrator (DBA) to manage and optimize our MySQL and PostgreSQL, Ms-SQL databases for our software platform.

The ideal candidate will ensure database reliability, performance, scalability, and security.

You will play a key role in fine-tuning queries, creating and managing indexes, optimizing database performance, and implementing robust security measures.

Key Responsibilities :

Database Management & Maintenance :

- Monitor, maintain, and manage MySQL and PostgreSQL MS-SQL databases.

- Perform regular database backups and recovery operations.

- Ensure high availability and disaster recovery setups are in place.

Performance Optimization :

- Analyze and optimize database queries for better performance.

- Add and manage indexes to improve query execution time.

- Perform database tuning and capacity planning.

Security Implementation :

- Implement and manage database security policies, including user access control.

- Ensure data integrity and implement encryption where necessary.

- Protect databases from unauthorized access and cyber threats.

Development Support :

- Collaborate with developers to design database schemas and architecture.

- Assist in creating stored procedures, triggers, and functions.

- Support and optimize database changes for new features and modules.

Monitoring and Troubleshooting :

- Set up and manage database monitoring tools to identify performance issues.

- Debug and resolve database errors, deadlocks, and locks.

- Monitor server health, logs, and system metrics to ensure smooth operation.

Qualifications and Skills :

Technical Expertise :

- Proficient in MySQL and PostgreSQL , MS-SQL database administration.

- Strong knowledge of SQL and query optimization techniques.

- Experience with database replication, clustering, and sharding.

Security and Compliance :

- Understanding of database security best practices.

- Knowledge of GDPR, HIPAA, or other relevant compliance standards (preferred).

Problem Solving and Analysis :

- Ability to analyze and resolve database issues efficiently.

- Strong troubleshooting and performance-tuning skills.

Tools and Utilities :

- Familiarity with database monitoring and management tools (e.g, pgAdmin, phpMyAdmin).

- Experience with backup and restore tools for MySQL and PostgreSQL.

Experience :

- Minimum 2-4 years of experience as a Database Administrator.

- Familiarity with Linux-based environments and shell scripting.

Soft Skills :

- Excellent communication and teamwork skills.

- Ability to document processes and maintain database-related documentation on skills.


Functional Areas: Software/Testing/Networking

Read full job description

What people at Crest IT Consulting are saying

What Crest IT Consulting employees are saying about work life

based on 6 employees
100%
75%
Flexible timing
Within city
View more insights

Crest IT Consulting Benefits

Health Insurance
Education Assistance
Free Transport
Child care
Gymnasium
Cafeteria +6 more
View more benefits

Compare Crest IT Consulting with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.5
Compare

LTIMindtree

3.8
Compare

Mphasis

3.4
Compare

Hexaware Technologies

3.5
Compare

Persistent Systems

3.5
Compare

Bajaj Finserv

4.0
Compare

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

4.0
Compare

HSBC Group

3.9
Compare

Cholamandalam Investment & Finance

3.9
Compare

Citicorp

3.7
Compare

BNY

3.9
Compare

SBI Cards & Payment Services

3.7
Compare

American Express

4.2
Compare

UBS

3.9
Compare

State Street Corporation

3.7
Compare

Similar Jobs for you

Database Admin at Big Oh Tech

3-4 Yrs

₹ 12-14 LPA

Database Admin at Searce

4-6 Yrs

₹ 12-18 LPA

Database Admin at Techberry Infotech

3-5 Yrs

₹ 12-15 LPA

Database Admin at Acumont Solutions

4-13 Yrs

₹ 16-60 LPA

Database Admin at Zifcare

4-6 Yrs

₹ 12-18 LPA

Database Admin at Hostbooks limited

4-6 Yrs

₹ 12-18 LPA

Database Admin at Orangeskill Technologies Pvt Ltd

4-6 Yrs

₹ 6-24 LPA

Database Admin at Evolutyz IT Services Pvt Ltd

3-5 Yrs

₹ 5-18 LPA

Database Admin at RCM

4-8 Yrs

₹ 8-16 LPA

Database Admin at Zoomcar

3-4 Yrs

₹ 12-18 LPA

Crest IT Consulting Mumbai Office Location

View all
Mumbai Office
101, plot no 40, Krishna Regency, Sector 30, Vashi, Navi Mumbai, Maharashtra 400703, India Mumbai
View on map
write
Share an Interview