Note: The job is a remote job and is open to candidates in USA. Tantus, a Sikich Subsidiary is seeking a Senior Oracle Database Administrator to join their team. The role involves administering Oracle databases, ensuring maximum availability, and supporting data mart operations while maintaining compliance with security mandates.
Responsibilities
- Administer Oracle Enterprise Edition databases in standalone and multitenant (container/pluggable) architecture across development, test, staging, and production environments in Microsoft Azure
- Configure and maintain Oracle Data Guard for maximum availability and disaster recovery across all environments
- Implement, configure, and maintain Oracle GoldenGate bidirectional replication between internal and external database environments
- Perform Oracle Recovery Manager (RMAN) backup and recovery operations including point-in-time recovery and cross-platform restores
- Install, patch, and maintain Oracle Enterprise Edition databases including Transparent Data Encryption (TDE), auditing, and Oracle Connection Manager
- Administer Oracle Enterprise Manager (OEM) for performance monitoring, job scheduling, patch compliance, and target management
- Install, configure, and maintain MySQL instances on Ubuntu Linux in Microsoft Azure including replication, encryption, and automated backup strategies
- Analyze, troubleshoot, and optimize SQL and PL/SQL code including materialized views, stored procedures, complex queries, and ETL processes
- Coordinate and maintain access to upstream federal enterprise systems on behalf of the agency including centrally managed data repositories
- Support and maintain agency data mart operations including nightly data pulls from enterprise systems and ETL ingestion from external data sources
- Perform database security administration including account management, privilege assignment, TDE, auditing, and compliance with FISMA and agency ISSO security mandates
- Author and maintain database standard operating procedures (SOPs) covering installation, configuration, migration, patching, replication, backup and recovery, and Oracle Enterprise Manager and GoldenGate operations
- Conduct capacity planning, sizing, and performance requirements analysis for database infrastructure in Azure
- Support FISMA security assessment and authorization activities as they relate to database environments
- Provide advisory support to developers and architects on database design, performance tuning, and integration with federal enterprise platforms
- Conduct proactive vulnerability remediation through regular Oracle CPU patch application across all environments
Skills
- U.S. Citizenship and ability to obtain/maintain a Public Trust clearance
- Minimum 10 years of Oracle database administration experience; 20-plus years preferred
- Bachelor's degree in Management Information Systems, Computer Science, Information Technology, or a related field required
- Demonstrated expertise with Oracle Enterprise Edition on Windows, Linux, and Unix platforms including Oracle 19c
- Proficiency in SQL and PL/SQL including performance tuning, query optimization, explain plan and autotrace analysis, index strategies, and partitioning
- Hands-on experience with Oracle Data Guard, RMAN, Oracle GoldenGate replication, Oracle Connection Manager, and Oracle Enterprise Manager
- Experience with Oracle multitenant architecture including container databases and pluggable databases
- Experience administering Oracle databases in Microsoft Azure IaaS environments including VM provisioning and Azure-specific sizing and availability configurations
- Experience with MySQL administration on Ubuntu Linux including replication, encryption, and backup strategies
- Experience with Oracle Transparent Data Encryption (TDE) and auditing
- Experience with ETL processes and data integration from external data sources and centrally managed federal enterprise databases
- Proficiency with scripting languages including SQL, PL/SQL, T-SQL, Perl, and Python for automation and operational tasks
- Familiarity with FISMA security assessment and authorization activities and federal agency ISSO requirements
- Oracle Certified Professional (OCP) certification for Oracle 19c
- Experience supporting federal agency database environments with complex integration requirements across multiple enterprise platforms
- Experience with Oracle GoldenGate replication in environments requiring bidirectional data synchronization between internal and externally accessible database tiers
- Experience with Oracle multitenant architecture including conversion from single-tenant configurations
- Experience with Oracle Connection Manager for database connectivity across network security boundaries
- Experience with PostgreSQL database administration
- Familiarity with Oracle licensing requirements in cloud environments and Azure shape sizing for Oracle workloads
- Familiarity with HHS EPLC framework and federal IT governance processes
- Experience with Splunk or equivalent log monitoring tools for database security event analysis
Benefits
- Tantus, a Sikich Subsidiary maintains a Flexible Time Off (FTO) Policy. We encourage every full-time employee, as your role permits, to utilize paid time off (personal time, mental/physical health care, vacation, sick leave, etc.). Waiting for time off to accrue is common at other companies. At Tantus, a Sikich Subsidiary, you do not have to wait for this benefit to kick in. FTO is activated on your first day with our organization.
- Tantus, a Sikich Subsidiary will also recognize paid holidays during the year and strives to permit employees to have time off the last week of the calendar year when client and project work permits.
- Tantus, a Sikich Subsidiary offers a comprehensive wellness program to engage, challenge and empower team members to take responsibility for their wellbeing. Activities can be tracked through our wellness provider to obtain gift cards and other rewards.
- Flexible work arrangements
- Health, dental, vision, life, and accident/death/disability insurance options
- HSA employer contribution
- Eleven (11) paid holidays annually.
- A robust paid Parental Bonding Leave program covering birth, adoption, and foster children.
- 401(k) with employer contributions
- Tuition reimbursement
- Generous employee referral bonus program
- Client referral bonus program
- Pet insurance
- FORCE – Tantus, a Sikich Subsidiary community volunteer program enabling each team member to use up to four hours of paid time annually to volunteer and make a difference in their local communities.
Company Overview