RedIron

Senior Database Administrator – Ops Engineer

RedIron

full-time

Posted on:

Location Type: Remote

Location: Massachusetts • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSLinuxOraclePostgresRDBMSShell Scripting

About the role

  • Test databases, correct errors, and make necessary modifications
  • Plan, coordinate, and implement security measures to safeguard information in files
  • Modify existing databases and database management systems
  • Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions
  • Perform all aspects of Oracle database administration
  • Actively participate in the daily Operational activities of customer databases
  • Monitor production, test, and development database environments and actively pursue any issues limiting the performance, scalability, and availability of these systems
  • Database bug resolution, address database security vulnerabilities
  • Analyze trends, report potential problems or areas of improvement concerning internal and customer databases
  • Performance tuning by analyzing Oracle AWR, ADDM, ASH reports
  • Setup, Configure and support Physical Standby (Active Data Guard) databases for high availability with proficiency in failover/switchover mechanisms
  • Setup, Configure Oracle database backups via Recovery Manager (RMAN) utility for Disaster recovery
  • Manage Database users, roles, and privileges
  • Provide Technical support to Customers
  • Plan Database refreshes from Production to non-prod environments to test application changes
  • Engineer migration plan for Oracle Databases from on-premises environments to AWS and devise suitable approach
  • Improve Database query workflow via implementing Oracle Table partitioning
  • Work on Oracle Export Import Utility (Classical & Data Pump) for Object level granular migration
  • Validate Oracle Database objects code and error corrections
  • Engineer parameters modifications in Database Management Systems
  • Automate Statistics collection against Enterprise Database servers to ensure Data dictionary views/tables/schemas are all current
  • Work closely with DevOps teams to review CPM backups periodically and to establish continuous delivery to Development teams
  • Devise learning curve via Test cases/Database Proof of Concepts
  • Participate in Managed Services on-call rotation

Requirements

  • B.S. degree in Computer Science, Information Systems or related field
  • 5 years of experience with Oracle databases
  • Knowledge of Oracle database 10g/11g/12c and Oracle Middleware (Weblogic) 11g/12c
  • Oracle PSU patching
  • Oracle Database Performance tuning
  • Oracle Active Data Guard
  • Oracle database backups via Recovery Manager (RMAN)
  • Oracle Table partitioning
  • Oracle Export Import Utility
  • Linux Shell Scripting
  • Postgres RDBMS
Benefits
  • Telecommuting available, work remotely from anywhere in the United States
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Oracle database administrationOracle database 10gOracle database 11gOracle database 12cOracle MiddlewareOracle PSU patchingOracle database performance tuningOracle Active Data GuardOracle database backups via RMANOracle Table partitioning
Soft Skills
technical supportproblem analysiscommunicationcoordinationplanning
Certifications
B.S. degree in Computer ScienceB.S. degree in Information Systems