Job Description
| Job Description: | Bill Rate: $ 60-$62 Location: ONSITE~Phoenix,AZ Duration: 6 months Role Title: Database Admin DBA 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, encryption, and object validity checks. Monitor and support Data Guard, GoldenGate, PostgreSQL/SQL Server/YugabyteDB replication, replication lag resolution, DR activities, switchovers, and failovers. Support export/import, data truncation, and application-requested database activities in accordance with change controls. Develop self-service and automation tools. Raise and coordinate vendor cases for DBMS software issues and work directly with application, infrastructure, development, and DBA teams. Drive documentation, standardization, operational improvements, and DBA process automation. Experience in scripting and AI related tools. Experience on Public cloud environments." Experience REquired: 6-8 Years Role Descriptions: Databases: Oracle| PostgreSQL| Microsoft SQL Server| YugabyteDB| Aurora PostgreSQL| AuroraMySQL| and SpannerPublic Cloud: AWS| Azure| GCPIaC: TerraformConfiguration Management: AnsibleSource Control & CI/CD: GitHub| GitHub ActionsMonitoring: Grafana| Prometheus| ORACLE OEMContainers: Docker| KubernetesScripting: Shell| Python| PowerShellOperating Systems: Linux/Unix/windowsRoles & ResponsibilitiesProvide 24x7 support for Production (E3) and lower environments; act as the first point of contact fordatabase incidents| restore service| perform troubleshooting| and route issues when required.Manage database startups| shutdowns| restarts| instance failover| switchover| parameter changes| andpre/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| blockingsessions| and long-running session reports.Manage database| tablespace| ASM| archive log| backup| Oracle Home| and OS filesystem capacity Essential Skills: Databases: Oracle| PostgreSQL| Microsoft SQL Server| YugabyteDB| Aurora PostgreSQL| AuroraMySQL| and SpannerPublic Cloud: AWS| Azure| GCPIaC: TerraformConfiguration Management: AnsibleSource Control & CI/CD: GitHub| GitHub ActionsMonitoring: Grafana| Prometheus| ORACLE OEMContainers: Docker| KubernetesScripting: Shell| Python| PowerShellOperating Systems: Linux/Unix/windowsRoles & ResponsibilitiesProvide 24x7 support for Production (E3) and lower environments; act as the first point of contact fordatabase incidents| restore service| perform troubleshooting| and route issues when required.Manage database startups| shutdowns| restarts| instance failover| switchover| parameter changes| andpre/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| blockingsessions| and long-running session reports.Manage database| tablespace| ASM| archive log| backup| Oracle Home| and OS filesystem capacity Desirable Skills: Keyword: Skills: Oracle DBA Experience Required: |
|---|
Numbers & Facts
| Location | Aurora, IL |
| Industry | Computer/IT Services |
| Salary | $60–$62 Per Hour |
| Company Size | 500 to 999 employees |
| Year Founded | 1990 |
| Website | http://q1tech.com/ |
About Company
Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.
Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder