Ahmedabad, GJ, India
Information Technology
Other
Prodapt
Overview
Overview:
Oracle Administration & Maintenance
My SQL:
"Database Installation & Maintenance
Assist in the installation, basic configuration, and patching of MySQL instances.
Assist in the installation, basic configuration, and patching of MySQL instances.
Perform routine database maintenance tasks, including index optimization and table defragmentation (OPTIMIZE TABLE).
Execute minor version upgrades and engine maintenance for AWS RDS instances.
Performance Monitoring & Optimization
Monitor core database metrics (CPU, Memory, Connections, and I/O) to ensure high availability and scalability.
Monitor core database metrics (CPU, Memory, Connections, and I/O) to ensure high availability and scalability.
Identify slow-running queries using the Slow Query Log and provide initial analysis to developers for tuning.
Track storage growth and manage disk space to prevent ""Disk Full"" incidents in both on-premise and AWS environments.
Backup, Recovery & Replication
Verify the success of daily backups (using mysqldump, mysqlpump, or Percona XtraBackup) and perform routine restore tests.
Verify the success of daily backups (using mysqldump, mysqlpump, or Percona XtraBackup) and perform routine restore tests.
Monitor MySQL replication lag and status (SHOW REPLICA STATUS) to ensure data consistency across clusters.
Respond to automated alerts and incidents promptly to minimize downtime and meet SLAs.
Security & Compliance
Manage user accounts, grants, and password policies to ensure data confidentiality and integrity.
Manage user accounts, grants, and password policies to ensure data confidentiality and integrity.
Implement predefined security measures and audit user access in accordance with company standards.
Ensure SSL/TLS certificates are updated and encrypted connections are enforced where required.
Collaboration & Documentation
Partner with L1/L2 Support teams to resolve escalated connectivity and performance tickets.
Partner with L1/L2 Support teams to resolve escalated connectivity and performance tickets.
Document all configuration changes, incident post-mortems, and ""How-To"" guides for the internal knowledge base.
Collaborate with development teams to implement schema changes and basic database design improvements."
Oracle Administration & Maintenance
Install, configure, and upgrade Oracle database software.
Apply quarterly patches for Grid and Oracle home
Configure and maintain standby database.
Monitor database performance and implement optimization strategies.
Ensure database security and compliance with organizational policies.
Perform regular backups and recovery operations.
Collaborate with developers to design and implement database solutions.
Troubleshoot and resolve database-related issues promptly.
Develop and maintain database documentation and standards.
Plan and execute database migrations and upgrades.
Setup Oracle golden gate both uni-directional and bidirectional.
Maintain Oracle Golden Gate synchronization with source.
Identify the Oracle Golden Gate sync related issues and implement the best practices.
Identify the performance issues and implement the best practices.
User creation and access management.
Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.
Create and maintain RAC with Data guard.
Administration of RAC database.
AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal
Apply quarterly patches for Grid and Oracle home
Configure and maintain standby database.
Monitor database performance and implement optimization strategies.
Ensure database security and compliance with organizational policies.
Perform regular backups and recovery operations.
Collaborate with developers to design and implement database solutions.
Troubleshoot and resolve database-related issues promptly.
Develop and maintain database documentation and standards.
Plan and execute database migrations and upgrades.
Setup Oracle golden gate both uni-directional and bidirectional.
Maintain Oracle Golden Gate synchronization with source.
Identify the Oracle Golden Gate sync related issues and implement the best practices.
Identify the performance issues and implement the best practices.
User creation and access management.
Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.
Create and maintain RAC with Data guard.
Administration of RAC database.
AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal
Similar Jobs
View All
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in