Senior Applications DBA

Job Number: 800230447
Job Type: Full Time(FTE)

Candidate Type – USA Work Authorization

Job Location – Raleigh, NC

Job Description

We are seeking a Senior Applications Database Administrator to join our team and support the migration and development of various applications. As a Senior Applications DBA, you will play a crucial role in the migration effort from on-prem to AWS cloud and the design and development of applications for our organization.

**This is a hybrid position**

Roles and Responsibilities
  • Manage the application schema, design, and extensions within the database for development, test, and production environments.
  • Provide technical support for database systems, including performance tuning, application administration, and consulting.
    Support Oracle, Oracle Data Guard, and Oracle Golden Gate, ensuring their efficient operation and high availability.
  • Collaborate with developers to refine data requirements, design databases, and develop effective database migration plans.
  • Perform backup and recovery tasks, monitor database performance, and reorganize database structures as needed.
  • Create and modify test and production data, base schemas, and participate in data archiving and data extract processes.
  • Provide technical leadership in data extract (full copy or subset) from production to non-production regions and data masking/de-identification of extracted data.
  • Collaborate with cross-functional teams to ensure compliance with database standards and best practices.

Basic Qualification:
7 years of experience with designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environment.
7 years of experience in modifying the database structure, creating and updating existing database objects per application needs.
3 years of experience in configuring, monitoring, and Cache management for Oracle database servers.
3 years of experience in allocating system storage and planning future storage requirements for the database system.
2 years of experience in supporting and implementing Oracle Golden Gate.
2 years of experience in implementing and supporting Oracle on AWS, including RDS.
5 years of experience authoring code in SQL, PL/SQL on Unix/Linux.
2 years of experience in one or more shell scripting languages
5 years of hands-on experience enrolling users and maintaining system security, controlling user access to the database, and locking down host access.
5 years of experience monitoring performance metrics, response times, and request rates.
2 years of experience designing and implementing backup/restore service and disaster recovery (DR) solutions on AWS cloud.
3 years of experience with installing, upgrading, and patching the software that powers the database (Oracle).
2 years of experience with data masking/de-identification of production data for non-production usage.
Strong experience in data archiving solutions for large Oracle databases
Ability to work cooperatively in a team environment to establish and maintain effective working relationships
Willingness to participate in on-call rotation and weekend work.
Preferred Qualification:

2 years of experience with advanced security and Oracle DataGuard replication.

Experience :

MySQL: 1 year (Preferred)
Database administration: 1 year (Preferred)
supporting and implementing Oracle Golden Gate.: 2 years (Required)
implementing and supporting Oracle on AWS, including RDS.: 2 years (Required)
authoring code in SQL, PL/SQL on Unix/Linux: 5 years (Required)
allocating and planning future system storage: 3 years (Required)
configuring, monitoring, and Cache managment: 3 years (Required)
modifying database structure, creating and updating database: 7 years (Required)
designing schema, access patterns and locking strategy: 7 years (Required)

Pay Range – DOE. Benefits are per company policy