Overview
On Site
Depends on Experience
Contract - W2
Contract - Independent
Contract - 4 Month(s)
Skills
Amazon RDS
Auditing
OCA
OCP
Oracle
PostgreSQL
SQL
Python
Shell
Identity Management
Cloud Computing
AWS RDS
Azure SQL
Database Administration
Amazon Web Services
Data Modeling
Database Security
Oracle Database Administration
SQL Azure
Scripting
Job Details
Title : GA DHS - Database Administrator
Location : Atlanta, GA
Duration : 4+ Months Client: State of GA Remote
Description: 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 database-related issues.
- Collaborate with development and operations teams to resolve database-related problems.
- Participate in on-call 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:
- Bachelor s degree in computer science, Information Technology, or a related field.
- Proven experience as a Database Administrator with expertise in Oracle and PostgreSQL.
- Strong knowledge of database design, data modeling, and SQL.
- Experience with database performance tuning, backup and recovery, and security practices.
- Familiarity with scripting languages (e.g., Python, Shell) for automation tasks.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration abilities.
- Certifications in Oracle Database Administration (e.g., OCA, OCP) and PostgreSQL.
- Experience with additional database technologies or cloud databases (e.g., AWS RDS, Azure SQL).
- Knowledge of database high availability solutions and clustering.
Required Skills:
- Bachelor s degree in computer science, Information Technology, or a related field.
- Proven experience as a Database Administrator with expertise in Oracle and PostgreSQL.
- Strong knowledge of database design, data modeling, and SQL.
- Experience with database performance tuning, backup and recovery, and security practices.
- Familiarity with scripting languages (e.g., Python, Shell) for automation tasks.
- Certifications in Oracle Database Administration (e.g., OCA, OCP) and PostgreSQL.
- Experience with additional database technologies or cloud databases (e.g., AWS RDS, Azure SQL).
- Knowledge of database high availability solutions and clustering.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.