- Job Title: Senior Applications DBA
- Location: State of North Carolina
- Job Type: Hybrid
- Contract Length: 12 months Contract
- One of our gov. client is looking for Applications DBA to support migration of Oracle database effort from on-prem to AWS cloud and development support of various applications 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.
SKILLS-
- Demonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environment
- Modifying the database structure, creation, and update to existing database objects per application needs
- Experience in configuring, monitoring, and Cache management for Oracle database servers
- Strong experience in allocating system storage and planning future storage requirements for the database system
- Experience in Install, configure, and troubleshoot/maintain Golden Gate
- Must have experience in implementing and supporting Oracle on AWS including EC2, RDS, and S3
- Experience authoring code in SQL, PL/SQL on Unix/Linux
- Proficiency in one or more shell scripting languages
- Hands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host access
- Monitoring performance metrics, response times, and request rates
- Designing and implementing backup/restore service and disaster recovery (DR) solutions
- Installing and upgrading the database software, Patching the software that powers database
- Good Analytical, Technical, Time Management, and Communication Skills
- Participate in on-call rotation and weekend work
- Experience with advanced security and Oracle DataGuard replication
- Experience in Oracle Data Masking and Subsetting
Job Type: Contract
Pay: $82.00 per hour
Benefits:
- Dental insurance
- Health insurance
Schedule:
- 8 hour shift
Experience:
- supporting Oracle on AWS including EC2, RDS and S3: 2 years (Preferred)
- tuning Oracle Databases in an enterprise environment: 7 years (Preferred)
- designing schema, SQL development: 7 years (Preferred)
- Cache management for Oracle database servers: 3 years (Preferred)
- Install, configure, and troubleshoot,maintain Golden Gate: 2 years (Preferred)
- authoring code in SQL, PL/SQL on Unix/Linux: 5 years (Preferred)
- Oracle Data Masking and Sub setting: 4 years (Preferred)
- Cúram Software and database schema: 4 years (Preferred)
Ability to Relocate:
- Suite 007 Research Triangle Park, NC 27709: Relocate before starting work (Required)
Work Location: In person