Spartan Technologies, Inc.

Sr. Database Administrator (Oracle) (1162586)

Spartan Technologies, Inc. - Atlanta, GA

Duration: 3 Months C2H

Location: Atlanta, GA (Remote)

Responsibilities:

  • Participate in functional test planning and testing for the assigned application(s), functional area(s) or project(s)
  • Participate in problem solving and troubleshooting for the assigned application(s), functional area(s) or project(s)
  • Share knowledge by effectively documenting work
  • Respond quickly and effectively to production issues and taking responsibility for seeing those issues through resolution
  • Resolve database performance issues, database capacity issues, replication, and other distributed data issues
  • Install and maintain database software
  • Manage backup and recovery of databases using RMAN and/or Network Appliance Snapshots
  • Manage security of database structures and corporate data held within databases
  • Develop database procedures, triggers and SQL scripts for development teams
  • Assist in the definition and implementation of database standards
  • Review scripts submitted by the Development team to ensure that all standards are met
  • Monitor databases for errors and perform problem determination when necessary
  • Design and implement highly available production systems using the following technologies: Hot Standby/Data Guard, Oracle Goldengate, Advanced Queuing, Real Application Cluster (RAC) and Oracle Enterprise Manager
  • Participate in on-call rotations

Minimum Qualifications:

  • Bachelors degree or equivalent work experience
  • Minimum 10 + years of experience in Oracle database technologies
  • Prior experience writing PL/SQL triggers and/or procedures
  • Experience with Database SQL and Database tuning
  • Experience with Oracle GoldenGate is a plus
  • Experience developing ansible playbooks is plus
  • Experience working in AWS is a plus
  • Ability to work with minimal direction, yet also able to work in team environment
  • Working knowledge of LINUX and shell scripting
  • Experience configuring database network connectivity
  • Understanding of database backup and recovery techniques using RMAN and Network Appliance filers
  • Experience with high volume websites that use multi-tier architectures a significant plus
  • Understanding or experience using Oracle Real Application Cluster’s and implementation best-practices
  • Ability to analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, Disaster Recovery or high performance
  • Experience setting up and Managing OEM 13c is a plus

 



Posted On: Thursday, November 10, 2022



Apply to this job