Job Title : Sr Oracle DBA
Location: Cincinnati, OH 45202, USA
Duration: 6+ Months
Job Descriptions
- Reviews, evaluates, designs, implements, and maintains company database(s):
- Requires more years of experience, mid level and Senior level resumes;
- Creates database design specifications based on understanding of business transactions.
- Creates database objects (tables, etc.).
- Creates and maintains database definitions and tables.
- Designs, codes, tests and implements custom database scripts and formal procedures.
- Ensures data integrity; recommends action to maintain data integrity; establishes process / procedures for ongoing data cleanup.
- Monitors and maintains databases for proper performance tuning.
- Designs, implements and maintains data retention and archival; plans for storage needs, retention, backup and recovery.
- Designs, implements and maintains database security.
- Assists in identifying and resolving database problems.
- Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
- Designs and writes codes for database access, modifications and constructions, including stored procedures.
- Exhibits strong business knowledge and builds strong customer relationships.
Qualifications:
- Oracle Database 12c, 19c with multitenant is required.
- OEM Cloud Control 13c required.
- Oracle TDE required.
- Oracle DataGuard is required.
- Oracle Exadata Cloud is Desired.
- Snowflake database is Desired.
- Cloud platforms is Desired.
Skills:
- Ability to handle multiple tasks and projects simultaneously.
- Excellent analytical skills, attention to detail, and problem-solving skills.
- Integrates multiple concepts across job functions with a goal of overall benefit to the organization.
- Ability to develop and leverage strategic business relationships across the organization and externally.
- Strong verbal and written communication skills.
- Self-motivated team player who excels in a collaborative environment.
- Strong sense of personal accountability.
- Passionate about continuously improving organizational practices.
Responsibilities /Qualifiers
Reviews, evaluates, designs, implements and maintains company database(s): Creates database design specifications based on understanding of business transactions. Creates database objects (tables, etc.). Creates and maintains database definitions and tables. Designs, codes, tests and implements custom database scripts and formal procedures. Ensures data integrity; recommends action to maintain data integrity; establishes process / procedures for ongoing data cleanup. Monitors and maintains databases for proper performance tuning. Designs, implements and maintains data retention and archival; plans for storage needs, retention, backup and recovery. Designs, implements and maintains database security. Assists in identifying and resolving database problems.
Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
Designs and writes codes for database access, modifications and constructions, including stored procedures.
Maintains and develops business knowledge and customer relationships.
Performs other duties as assigned.