Apex Informatics
Atlanta, GA, USA
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.