Senior Database Administrator & Ops Engineer

by RedIron Technologies Inc.

Position Type: Full-time
Location: London, ON
Date Posted: Jun 01, 2024
RedIron Technologies Inc.

Job Description

Company Description

We are a retail systems integrator and software provider that helps you design, implement, integrate and maintain any major retail software platform - legacy or cutting edge.

Clients engage us when They want to dramatically improve their client experience without having the endure the cost and risk of replacing a core retail IT system. They need to achieve business outcomes leveraging ancient legacy systems AND cutting-edge technologies.

Our depth, experience and FOCUS on the retail industry make us unique and different in this space. We have completed over 1,000 technology projects in North American retail and bring that experience and expertise to each new one.

Job Description

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.


B.S. degree in Computer Science, Information Systems or related field plus 5 years of experience with Oracle databases and 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.

Additional Information

MULTIPLE POSITIONS AVAILABLE. Telecommuting available, work remotely from anywhere in the United States. Resume to: RedIron, 42 Fletcher Hill Lane, Groton, MA  01450