About the Job:
-
Must be a U.S. Citizen.
-
Must be able to pass Minimum Background Investigation (MBI) / Medium-Risk federal agency security clearance.
-
Location: Hybrid work environment / 80% Remote – Candidate must live within 2 hours of a government facility.
Database Administration & Operations:
-
Install, configure, upgrade, and maintain PostgreSQL and Oracle database environments across development, test, staging, and production systems.
-
Manage database instances, schemas, users, and storage structures to ensure optimal performance and reliability.
-
Monitor and tune database performance, identify bottlenecks, and implement solutions to improve throughput and response times.
High Availability, Backup & Recovery:
-
Design and manage high-availability and disaster recovery solutions, including replication, clustering, Data Guard, streaming replication, and failover strategies.
-
Implement and manage robust backup, recovery, and retention policies using tools such as RMAN (Oracle) and pgBackRest or similar solutions (PostgreSQL).
-
Conduct regular disaster recovery tests and document procedures.
Security & Compliance:
-
Implement database security policies, manage access controls, and ensure compliance with organizational and regulatory standards.
-
Apply patches, perform vulnerability assessments, and support audits by providing required database evidence and documentation.
Development & Optimization:
-
Collaborate with developers, architects, and application teams to design efficient database schemas, queries, indexes, and stored procedures.
-
Design and implement robust data warehouse solutions, leveraging best practices for schema design, partitioning, and optimized query performance.
-
Conduct code reviews, performance tuning, and query optimization to improve application performance.
-
Automate administrative tasks using scripting languages (e.g., Bash, Python) and infrastructure-as-code tools.
Monitoring & Troubleshooting:
-
Implement and maintain database monitoring and alerting solutions to proactively identify and resolve issues.
-
Provide advanced troubleshooting and root cause analysis for database incidents, including performance degradation and outages.
-
Participate in 24/7 on-call support rotation and planned maintenance activities.
Required:
-
Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
-
7+ years of hands-on experience as a production DBA supporting large-scale PostgreSQL and Oracle environments.
-
Strong experience with database installation, configuration, patching, backup/recovery, and performance tuning.
-
Expertise with replication, clustering, high availability, and disaster recovery solutions.
-
Strong skills in SQL and PL/pgSQL/PL/SQL, query optimization, and indexing strategies.
-
MySQL, PostgreSQL, SQL ServerMongoDB, or Oracle Database Engineering.
-
Proficiency with database monitoring and automation tools (e.g., Oracle Enterprise Manager.
-
Strong scripting skills (e.g., Bash, Python) for automation and operational tasks.
-
Collaborate with cross-functional teams to develop ETL pipelines, data governance strategies, and reporting solutions within the OCI ecosystem.
-
Monitor, tune, and troubleshoot environments, proactively identifying and resolving potential issues to maintain high system health.
-
Document configurations, procedures, and best practices for ADB management, security policies, and migration strategies.
-
Familiarity with multiple RDMS products in addition to Oracle’s on premise and cloud services to include:
-
Install and use Oracle Enterprise Manager to monitor, manage, and optimize Autonomous Database (ADB) environments, ensuring comprehensive performance analysis, alerting, and reporting.
Preferred:
-
Experience with database migrations, cloud platforms (AWS RDS, Azure Database, Oracle Cloud), or hybrid environments.
-
Familiarity with DevOps practices, CI/CD pipelines, and infrastructure-as-code tools (e.g., Ansible, Terraform).
-
Certifications such as Oracle Certified Professional (OCP) or PostgreSQL Professional Certification are highly desirable.
Soft Skills:
-
Excellent analytical and problem-solving abilities.
-
Strong communication and documentation skills, with the ability to collaborate effectively with cross-functional teams.
-
Proven ability to manage multiple priorities in a fast-paced, mission-critical environment.
-
Leadership mindset with mentoring capabilities and strategic thinking.
About Wisemen Multimedia, LLC:
Founded in 2010, Wisemen Multimedia, LLC (EIN 27-2836493, DUNS 034-931-168, UEI QMEAXFXBFFT3) is a HUBZone certified hybrid digital business ecosystem creator for people, processes, and technologies. Our principal office is located at Peachtree Dekalb Airport in a designated Opportunity Zone. Let us know if you live in a Historically Underutilized Business Zone (HUBZone). Please copy and paste the link below and enter your home address to determine if you live in a HUBZone. https://maps.certify.sba.gov/hubzone/map#center=39.828200,-98.579500&zoom=5
