Senior Oracle Database Administrator (Tantus)
Role details
Job location
Tech stack
Job description
In anticipation of a recompete contract award, Tantus, a Sikich Subsidiary- is looking for a Senior Oracle Database Administrator.
What will you do in this role?
- 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
Requirements
- 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
Preferred Certifications & Qualifications
- 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 & conditions
paid time off, paid holidays, sick time, tuition reimbursement, flex time, 401(k), In compliance with this state's pay transparency laws, the salary range for this role is $160,000 - $180,000. This is not a guarantee of compensation or salary, as final offer amount may vary based on factors including but not limited to experience and geographic location.
In addition, specific skills/experience required are as follows:
- Values driven - You embody and model absolute integrity and servant leadership and you have a bias for action and continuous innovation.
- Uncompromising problem solver - You see opportunities in every business challenge and can develop, articulate and implement solutions.
- Collaboration - You are a relationship builder across all levels of the organization and across all business units.
- Instills trust - You do what you say, without ego, and you follow through on commitments consistently and credibly.
- Impact & influence - You are relentlessly focused on making a difference and can gain support for ideas, proposals and solutions. You get others to act, with or without formal authority, to advance initiatives and objectives.
About Tantus, a Sikich Subsidiary
Tantus, a Sikich Subsidiary offers the public and private sectors a diverse platform of professional services across consulting, technology and compliance. Highly specialized and hands-on teams deliver integrated solutions rooted in deep industry experience. Our approach is strategically and thoughtfully designed to help our clients, teams and communities accelerate success.
Tantus, a Sikich Subsidiary has approximately 2,000 team members and operates across North America, EMEA and APAC.
Tantus, a Sikich Subsidiary Total Rewards
Our team members enjoy expansive benefits ranging from competitive compensation and insurance options to wellness programs and a flexible time off policy, to name only a few. Tantus, a Sikich Subsidiary also takes pride in prioritizing team members' health, total wellbeing and time spent with family, friends and in the pursuit of personal goals, hobbies, and endeavors.
Some examples of our many 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.
We also offer:
- 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.
Want to learn more? Visit our Careers website or Glassdoor profile.
Tantus, a Sikich Subsidiary is an Equal Opportunity Employer M/F/D/V