Serigor Inc
Senior Applications DBA (HYBRID)
Serigor Inc, Raleigh, North Carolina, United States, 27601
Job Title:
Senior Applications DBA (HYBRID)Location:
Raleigh, NCDuration:
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 the 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/LinuxInstall, 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 environmentRequired7YearsModifying the database structure, creation, and update to existing database objects per application needsRequired7YearsExperience in configuring, monitoring, and Cache management for Oracle database serversRequired3YearsStrong experience in allocating system storage and planning future storage requirements for the database systemRequired3YearsExperience in Install, configure, and troubleshoot/maintain Golden GateRequired2YearsMust have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3Required2YearsExperience authoring code in SQL, PL/SQL on Unix/LinuxRequired5YearsProficiency in one or more shell scripting languagesRequired2YearsHands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host accessRequired5YearsMonitoring performance metrics, response times, and request ratesRequired5YearsDesigning and implementing backup/restore service and disaster recovery (DR) solutionsRequired2YearsInstalling and upgrading the database software, Patching the software that powers databaseRequired3YearsGood Analytical, Technical, Time Management and Communication SkillsRequired7YearsParticipate in on-call rotation and weekend workRequired5YearsExperience with advanced security and Oracle Data Guard replicationRequired2YearsExperience in Oracle Data Masking and Sub-SettingHighly desiredDemonstrable skills with Cúram Software and database schemaDesired
Senior Applications DBA (HYBRID)Location:
Raleigh, NCDuration:
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 the 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/LinuxInstall, 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 environmentRequired7YearsModifying the database structure, creation, and update to existing database objects per application needsRequired7YearsExperience in configuring, monitoring, and Cache management for Oracle database serversRequired3YearsStrong experience in allocating system storage and planning future storage requirements for the database systemRequired3YearsExperience in Install, configure, and troubleshoot/maintain Golden GateRequired2YearsMust have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3Required2YearsExperience authoring code in SQL, PL/SQL on Unix/LinuxRequired5YearsProficiency in one or more shell scripting languagesRequired2YearsHands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host accessRequired5YearsMonitoring performance metrics, response times, and request ratesRequired5YearsDesigning and implementing backup/restore service and disaster recovery (DR) solutionsRequired2YearsInstalling and upgrading the database software, Patching the software that powers databaseRequired3YearsGood Analytical, Technical, Time Management and Communication SkillsRequired7YearsParticipate in on-call rotation and weekend workRequired5YearsExperience with advanced security and Oracle Data Guard replicationRequired2YearsExperience in Oracle Data Masking and Sub-SettingHighly desiredDemonstrable skills with Cúram Software and database schemaDesired