Serigor Inc

Senior Applications DBA (HYBRID)

Posted 8 Hours Ago

Be an Early Applicant

Raleigh, NC

Senior level

Information Technology

The Role

The Senior Applications DBA will manage Oracle databases during the migration to AWS, configure applications, troubleshoot issues, and implement best practices for database optimization. Responsibilities include schema design, performance tuning, managing databases on Linux, and ensuring high availability through replication and backup solutions.

Summary Generated by Built In

Job Title: Senior Applications DBA (HYBRID)
Location: Durham NC
Duration: 12+ Months
Job Description:
The client requires a Senior Applications DBA to support migration of Oracle database effort from on-prem to AWS cloud and development support of various applications for client in AWS Cloud.
Primary responsibilities include managing the application schema, design, and extensions within the database for development, test, and production environments for Oracle database on Linux platform. The responsibilities also include database technical support, performance tuning, application administration and consulting, and providing support for Oracle, Oracle Data guard, Oracle Golden Gate.
This resource will serve in a key role in the managing Oracle database on cloud platforms like AWS, Lead the development of procedures and best practices for effective database for high volume application system and providing database solution for application modernization.

Provision and manage Oracle database instances on AWS/Linux
Install, configure, and troubleshoot Golden Gate for batch and online process synchronization for high volume database.
Set up replication and high availability for Oracle databases using tools like Golden gate.
Monitor Oracle database performance.
Troubleshoot Oracle database problems.
Perform backups and restores of Oracle databases.
Work with application developers to identify and refine data requirements, table/database design, assist in SQL writing.

Skills:

Skill Required / Desired Amount of Experience Demonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environment Required 7 Years Modifying the database structure, creation, and update to existing database objects per application needs Required 7 Years Experience in configuring, monitoring, and Cache management for Oracle database servers Required 3 Years Strong experience in allocating system storage and planning future storage requirements for the database system Required 3 Years Experience in Install, configure, and troubleshoot/maintain Golden Gate Required 2 Years Must have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3 Required 2 Years Experience authoring code in SQL, PL/SQL on Unix/Linux Required 5 Years Proficiency in one or more shell scripting languages Required 2 Years Hands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host access Required 5 Years Monitoring performance metrics, response times, and request rates Required 5 Years Designing and implementing backup/restore service and disaster recovery (DR) solutions Required 2 Years Installing and upgrading the database software, Patching the software that powers database Required 3 Years Good Analytical, Technical, Time Management and Communication Skills Required 7 Years Participate in on-call rotation and weekend work Required 5 Years Experience with advanced security and Oracle Data Guard replication Required 2 Years Experience in Oracle Data Masking and Sub setting Highly desired Demonstrable skills with Cúram Software and database schema Desired

Top Skills

Oracle

Pl/Sql

SQL

View all jobs at Serigor Inc

View Serigor Inc Profile

Report Job

The Company

HQ: Baltimore, MD

146 Employees

On-site Workplace

What We Do

Serigor provides IT Services and IT staffing to Government and Commercial enterprises of all sizes. Serigor has twelve years of proven track record in IT Services, Government Solutions, and Staffing Solutions.

● MBE/WBE/WBENC/WOSB company, headquartered in Baltimore, MD.

● Multiple, multi-year contracts with Government Agencies at State, County, City, and Federal.

● Commercial clients include Fortune 1000 and Start-Ups all over the US.

● Onshore and offshore IT delivery centers.

● IT solutions encompass contracts that are Fixed Price, T&M, Product Development in all technologies.

● Workforce and staffing solutions encompass contract, contract-to-hire, permanent placement and statement of work job assignments.