Apply on Employer Site

Wisemen Multimedia, LLC · 2 months ago

Sr. Oracle DBA

Atlanta, GA

Full-time

Hybrid

Senior Level

$110K/yr - $140K/yr

7+ years exp

Wisemen Multimedia, LLC is a HUBZone certified hybrid digital business ecosystem creator founded in 2010. They are seeking a Senior Oracle DBA to manage and optimize PostgreSQL and Oracle database environments, ensuring high availability, security, and performance while collaborating with development teams.

AnalyticsBusiness DevelopmentConsulting

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

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

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

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

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

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

Qualification

PostgreSQLOracle DatabaseDatabase AdministrationHigh Availability SolutionsSQLPL/pgSQLBackupRecoveryScripting BashScripting PythonData GovernanceETL PipelinesCloud PlatformsDevOps PracticesOracle Certified ProfessionalPostgreSQL Professional CertificationAnalytical SkillsLeadership MindsetCommunication Skills

Required

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

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

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

Install and use Oracle Enterprise Manager to monitor, manage, and optimize Autonomous Database (ADB) environments, ensuring comprehensive performance analysis, alerting, and reporting