Database Admin DBA
External job listingat Kksoftwareassociates
We are hiring #Database_Admin_DBA for one of my clients. Interesting candidates please Position: #Database_Admin_DBA Location:ONSITE~Phoenix,AZ Description: "Databases: Oracle, PostgreSQL...
Salary
Not provided
Location
Phoenix, United States
Employment type
Full time
Workplace
Not provided
Database Admin DBA
Phoenix, United States
Job description
We are hiring #Database_Admin_DBA for one of my clients. Interesting candidates please
Position: #Database_Admin_DBA
Location:ONSITE~Phoenix,AZ
Description:
"Databases: Oracle, PostgreSQL, Microsoft SQL Server, YugabyteDB, Aurora PostgreSQL, Aurora
MySQL, and Spanner
Public Cloud: AWS, Azure, GCP
IaC: Terraform
Configuration Management: Ansible
Source Control & CI/CD: GitHub, GitHub Actions
Monitoring: Grafana, Prometheus, ORACLE OEM
Containers: Docker, Kubernetes
Scripting: Shell, Python, PowerShell
Operating Systems: Linux/Unix/windows"
Essential Skills:
"Provide 24x7 support for Production (E3) and lower environments; act as the first point of contact for
database incidents, restore service, perform troubleshooting, and route issues when required.
Manage database startups, shutdowns, restarts, instance failover, switchover, parameter changes, and
pre/post maintenance validations.
Monitor database availability, alert logs, OEM alerts, health checks, and infrastructure-related issues;
perform root cause analysis for Sev1 and Sev2 incidents.
Troubleshoot database and SQL performance using AWR, ASH, explain plans, locks, deadlocks, blocking
sessions, and long-running session reports.
Manage database, tablespace, ASM, archive log, backup, Oracle Home, and OS filesystem capacity;
forecast space needs and coordinate storage additions. Perform proactive and ad-hoc backups, restore points, flashback restores, RMAN table recovery, database restoration, and standby database rebuild. Support OS and database patching, upgrades, migrations, server reboots, and application or database maintenance changes. Schedule and maintain backup and database jobs using OEM and CRON; configure monitoring thresholds, alerts, reports, and Grafana dashboards. Administer users, profiles, roles, privileges, schema unlocks, DBA IDs, application access, and required access for RFC execution. Maintain database security, audit configuration, TDE,