Oracle OCI Administrator

U.S. Citizenship and U.S. residency required.

Position Summary 

The Database Administrator designs, installs, configures, and maintains Oracle and Microsoft SQL Server database management systems, including definition, structure, documentation, long-range requirements, operational guidelines, and protection. This role optimizes the data environment by keeping databases finely tuned, automating incoming and outgoing data feeds, and troubleshooting data access problems. 

The Database Administrator establishes and maintains security and integrity controls, designs and builds relational databases, and supports software developers with database operations, working with data users to recommend appropriate solutions. 

Core Responsibilities 

Database Design & Administration 

• Works with leadership to define, develop, and recommend database and related data management policies and procedures, building on responsibilities such as: 

• Manages database backup / recovery and configures parameters and prototypes designed against logical data models. 

• Defines data repository requirements, data dictionaries, and warehousing requirements. 

• Installs, configures, administers, patches, upgrades, and maintains Oracle and Microsoft SQL Server database environments, including production, test, development, and disaster recovery systems. 

Performance & Capacity Management 

• Optimizes database access and allocates/re-allocates database resources for optimum configuration, performance, and cost. 

• Drives end-to-end availability, performance monitoring, and capacity planning. 

• Supports multiple services and databases with diverse concurrent users, ensuring control, integrity, and accessibility of data. 

• Monitors and tunes Oracle and SQL Server database performance, including query optimization, indexing strategies, execution plan analysis, and capacity management to ensure optimal performance and availability. 

Technical Leadership & Automation 

• Acts as team/project lead on technical projects. 

• Provides technical, process, and functional guidance to less experienced team members. 

• Strategizes and owns the automation of administrative tasks. 

• Automates database administration tasks through scripting, scheduling, monitoring, and maintenance processes to improve operational efficiency and reduce manual effort. 

Organizational Contribution 

• Assists in driving organizational activities and initiatives.