Senior Database Administrator & Ops Engineer

RedIron Technologies Inc.; Groton (MA); On-site; USD 95,000 - 120,000; Full time

Job summary

RedIron Technologies Inc. is seeking an experienced Oracle Database Administrator to manage Oracle databases and ensure high availability and performance. You'll work on tasks like database bug resolution, performance tuning, and security measures while collaborating with DevOps teams.

Ideal candidates should possess a B.S. in Computer Science and have extensive experience with Oracle databases and Linux shell scripting. Multiple positions are available, and telecommuting options are offered.

Qualifications

• 5 years of experience with Oracle databases.
• Knowledge of Oracle PSU patching and Active Data Guard.
• Experience with Oracle Export Import Utility.

Responsibilities

• Test databases and correct errors.
• Implement security measures for information.
• Monitor production, test, and development database environments.

Skills

Oracle databases

Linux Shell Scripting

Database performance tuning

Oracle Table partitioning

Education

B.S. degree in Computer Science, Information Systems or related field

Tools

Oracle 10g/11g/12c

Oracle Middleware (Weblogic) 11g/12c

Recovery Manager (RMAN)

Postgres RDBMS

Job description

• Full-time

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 to 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.

http://www.RedIron.com

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.

Qualifications

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