What are the responsibilities and job description for the GA DHS - Database Administrator position at RICEFW Technologies Inc?
Weare seeking a highly skilled Database Administrator to manage and optimize ourOracle and PostgreSQL databases.
The ideal candidate will be responsible for theinstallation, configuration, maintenance, and performance tuning of our databases,ensuring their availability, reliability, and security.
Key Responsibilities :
Install, configure, and maintain Oracle andPostgreSQL databases.
Perform database backups, restores, and disasterrecovery operations.
Monitor database performance and optimizequeries and indexes for improved performance.
Analyze and resolve performance issues throughquery optimization, indexing, and tuning.
Implement and monitor database performancemetrics and alerts.
Conduct regular database health checks andperformance reviews.
Ensure database security through usermanagement, access control, and encryption.
Implement and enforce database security policiesand compliance requirements.
Monitor and audit database activities to detectand respond to security threats.
Apply patches, updates, and upgrades todatabases and related systems.
Manage database migrations and version upgradeswith minimal downtime.
Develop and maintain documentation for databaseconfigurations, procedures, and policies.
Provide technical support and troubleshootingfor database-related issues.
Collaborate with development and operationsteams to resolve database-related problems.
Participate in on-call rotation and respond tocritical incidents as needed.
Design and implement robust backup and recoverystrategies for databases.
Test and validate backup and recovery proceduresto ensure data integrity and availability.
Monitor backup processes and address any issuesrelated to backup failures.
Qualifications and Preferred Skills :
Bachelor s degree in computer science,Information Technology, or a related field.
Proven experience as a Database Administratorwith expertise in Oracle and PostgreSQL.
Strong knowledge of database design, datamodeling, 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 attentionto detail.
Strong communication and collaborationabilities.
Certifications in Oracle Database Administration(e.g., OCA, OCP) and PostgreSQL.
Experience with additional database technologiesor cloud databases (e.g., AWS RDS, Azure SQL).
Knowledge of database high availabilitysolutions and clustering.
Required / Desired Skills
Skill
Required / Desired
Amount
of Experience
Bachelor s degree in computer science, Information Technology, or a related field.
Required
Proven experience as a Database Administrator with expertise in Oracle and PostgreSQL.
Required
Strong knowledge of database design, data modeling, and SQL.
Required
Experience with database performance tuning, backup and recovery, and security practices.
Required
Familiarity with scripting languages (e.g., Python, Shell) for automation tasks.
Required
Certifications in Oracle Database Administration (e.g., OCA, OCP) and PostgreSQL.
Required
Experience with additional database technologies or cloud databases (e.g., AWS RDS, Azure SQL).
Highly desired
Knowledge of database high availability solutions and clustering.
Highly desired
Questions
Question
Question1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question2
Please list candidate's email address that will be used when submitting E-RTR.
Question3
Candidate must be paid the rate of NA if selected for engagement therefore the SRP rate cannot exceed NA. Do you accept this requirement?
Question4
The maximum mark-up for this engagement s SRP rate is NA%. To be competitive on pricing, a mark-up below the NA% threshold is suggested. Do you agree to propose a mark-up at or below NA%?
Question5
This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement?
Question6
The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client s selection date. Do you accept this requirement?
Question7
Remote Work Permitted : Due to COVID-19, the client has agreed to allow the selected candidate to work remotely for the time being. However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement?
