2 Crest IT Consulting Jobs
2-4 years
Crest IT Consulting - Database Administrator - MySQL/PostgreSQL (2-4 yrs)
Crest IT Consulting
posted 2mon ago
Flexible timing
Key skills for the job
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 description2-4 Yrs