Senior Database Administrator - Ops Engineer

November 10

Apply Now

Receive Emails with Similar Jobs

RedIron

WebsiteLinkedInAll Job Openings

Omnichannel solutions • Mobile POS • Automated QA Testing • point of sale • retail

51 - 200 employees

🛒 Retail

🏢 Enterprise

🛍️ eCommerce

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.

Requirements

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