Senior Database Administrator & Ops Engineer

RedIron is a retail systems integrator and software provider that specializes in designing, implementing, integrating, and maintaining retail software platforms. They are seeking a Senior Database Administrator & Ops Engineer to manage Oracle databases, ensure security measures, and optimize database performance while collaborating with DevOps teams.

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

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
• 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