[Remote] Senior Database Administrator & Ops Engineer
Note: The job is a remote job and is open to candidates in USA. RedIron is a retail systems integrator and software provider that helps clients improve their client experience through advanced technology solutions. They are seeking a Senior Database Administrator & Ops Engineer to manage and optimize Oracle databases, ensure security, and support clients with technical issues.
Responsibilities
- 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
Skills
- 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
- Knowledge of 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.
Company Overview