What are the responsibilities and job description for the Database Administrator position at PROCYON TECHNOSTRUCTURE?
We are seeking a highly skilled Database Administrator to manage and optimize our Oracle and PostgreSQL databases.
The ideal candidate will be responsible for the installation configuration maintenance and performance tuning of our databases ensuring their availability reliability and security.
Key Responsibilities :
- Install configure and maintain Oracle and PostgreSQL databases.
- Perform database backups restores and disaster recovery operations.
- Monitor database performance and optimize queries and indexes for improved performance.
- Analyze and resolve performance issues through query optimization indexing and tuning.
- Implement and monitor database performance metrics and alerts.
- Conduct regular database health checks and performance reviews.
- Ensure database security through user management access control and encryption.
- Implement and enforce database security policies and compliance requirements.
- Monitor and audit database activities to detect and respond to security threats.
- Apply patches updates and upgrades to databases and related systems.
- Manage database migrations and version upgrades with minimal downtime.
- Develop and maintain documentation for database configurations procedures and policies.
- Provide technical support and troubleshooting for databaserelated issues.
- Collaborate with development and operations teams to resolve databaserelated problems.
- Participate in oncall rotation and respond to critical incidents as needed.
- Design and implement robust backup and recovery strategies for databases.
- Test and validate backup and recovery procedures to ensure data integrity and availability.
- Monitor backup processes and address any issues related to backup failures.
Qualifications and Preferred Skills :
Required Skills : AWS Cloud FormationMySQL
Basic Qualification :
Additional Skills :
Background Check : No
Drug Screen : No
Key Skills
Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle
Employment Type : Full Time
Vacancy : 1
