Location – Hyderabad or Bangalore
Job/Role Description:
Oracle (Automation, Shell Scripting, Performance Tuning), SQL Server with 10+ Years Experience
Sr. DBA should be able to handle tasks on a hybrid environment in on premise and AWS cloud which include deployment, administration and optimization of databases hosted on Amazon Web Services (AWS) infrastructure including Design, manage, troubleshoot and debug software programs for databases, applications, tools, networks etc.
Work with DB team to provide enterprise-wide, Oracle/SQL Database Administration support for production systems and provide DBA services to application development teams, including database design, database provisioning, coding, patching, performance tuning and database production support. Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems to ensure user productivity.
Deploying and configuring Oracle 19c (and later versions) and Sql Server database systems both on EC2 as well as an RDS instance.
Performing routine maintenance tasks like Oracle backups, restores, and security measures to ensure the integrity and availability of data. This includes monitoring database performance, diagnosing and resolving issues, and optimizing database configurations for optimal performance. Debugging DB Job failures (such as archive logs, backup, failures, increasing swap space.
Monitoring database performance metrics and identify bottlenecks. Optimizing database queries, indexes, and configurations to improve performance and reduce latency.
Implementing and maintaining database security measures to protect databases from unauthorized access, data breaches, and other security threats.
This may involve configuring AWS security groups, IAM (Identity and Access Management) policies, encryption, and compliance with industry standards.
Implementing strategies for high availability and disaster recovery to ensure continuous access to data in case of system failures or disasters. This may involve setting up multi-AZ deployments, database replication, failover procedures, and automated backups.
Automating DB tasks such as patching, updating variable sets, analyzing metrics disk space using Ansible.
Key Skills: Oracle DBA, Performance Tuning, Shell
