Senior Database Administrator

Searce Inc; Jaipur; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

A tech solutions company based in India is seeking a Database Administrator with 7-9 years of experience in Cloud Database Administration. The ideal candidate must have proficiency in PostgreSQL and MySQL database management, including installation, configuration, and performance tuning. This role also emphasizes security, backup procedures, and troubleshooting. A Bachelor's or Master's degree in engineering is preferred, but substantial programming experience will also be considered. The company offers a dynamic work environment focused on technology.

Qualifications

• 7-9 years experience in Cloud Database Administration.
• Proficient in PostgreSQL database management, installation, and performance tuning.
• Proven experience as a Database Administrator with a focus on PostgreSQL/MySQL/MSSQL.

Responsibilities

• Design, implement, and maintain PostgreSQL/MySQL database structures.
• Install and configure PostgreSQL/MySQL database management systems.
• Implement and maintain security measures for databases.

Skills

SQL programming and query optimization

Data modeling and database design

Backup and recovery procedures

Performance tuning and optimization

Security protocols and measures

Capacity planning and scalability

Education

Bachelor's or Master's degree in engineering

Tools

PostgreSQL

MySQL

MSSQL

Amazon RDS

Cloud SQL

Job description

Responsibilities

1. Database Design and Implementation:
   • Design, implement, and maintain PostgreSQL/MySQL database structures to meet organizational requirements.
   • Ensure efficient and secure storage, retrieval, and management of data.
2. Installation and Configuration:
   • Install, configure, and maintain PostgreSQL/MySQL database management systems and related software.
   • Ensure proper functionality and performance of both database environments.
3. Data Security:
   • Implement and maintain security measures for PostgreSQL/MySQL databases to prevent unauthorized access.
   • Monitor and audit user access, ensuring data confidentiality and integrity.
4. Backup and Recovery:
   • Develop and implement backup and recovery procedures for both PostgreSQL/ MySQL databases.
   • Regularly test and update backup and recovery processes.
5. Performance Tuning:
   • Monitor and optimize the performance of PostgreSQL/ MySQL databases.
   • Analyze query execution plans, indexing strategies, and other factors to enhance efficiency.
6. Capacity Planning:
   • Assess current and future capacity requirements for both PostgreSQL/ MySQL databases.
   • Plan for and implement capacity expansions as needed.
7. Database Maintenance:
   • Perform routine maintenance tasks, such as applying patches and updates, for PostgreSQL/ MySQL environments.
   • Optimize database operations to ensure continuous and reliable performance.
8. Troubleshooting:
   • Diagnose and resolve database-related issues for both PostgreSQL/MySQL.
   • Collaborate with other IT professionals to address system errors and performance challenges.
9. Data Migration:
   • Upgrade database software and ensure data integrity during migrations.
   • Work closely with developers, system administrators, and other IT team members.
   • Ensure seamless integration of PostgreSQL/MySQL database systems with other components of the IT infrastructure.

Qualifications

Is Education overrated? Yes. We believe so. However there is no way to locate you otherwise. So unfortunately we might have to look for a Bachelor\'s or Master\'s degree in engineering from a reputed institute or you should be programming from 12. And the latter is better. We will find you faster if you specify the latter in some manner. Not just a degree, but we are not too thrilled by tech certifications too ... :)

To reiterate: Passion to tech-awesome, insatiable desire to learn the latest of the new-age cloud tech, highly analytical aptitude and a strong ‘desire to deliver’ outlives those fancy degrees!

• 7-9 years experience in Cloud Database Administration
• Proficient in PostgreSQL database management, including installation, configuration, and performance tuning.
• Experience with Amazon RDS or Cloud SQL and managing databases in cloud environments.
• Proficient in PostgreSQL/MySQL/MSSQL database management, including installation, configuration, and performance tuning.
• Proven experience as a Database Administrator with a focus on PostgreSQL/MySQL/MSSQL.
• In-depth knowledge of database design, implementation, and management for either PostgreSQL/MySQL/MSSQL environments.
• Familiarity with database security, backup procedures, and performance tuning for both systems.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Relevant certifications are a plus.

Skills:

• SQL programming and query optimization for both databases.
• Data modeling and database design for PostgreSQL/MySQL/MSSQL.
• Backup and recovery procedures for both environments.
• Performance tuning and optimization for PostgreSQL/MySQL/MSSQL.
• Security protocols and measures for PostgreSQL/MySQL/MSSQL.
• Capacity planning and scalability for both systems.