Senior Database Administrator – Ops Engineer

Role Overview

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

Tech Stack

• AWS
• Linux
• Oracle
• Postgres
• RDBMS
• Shell Scripting

Benefits

• Telecommuting available, work remotely from anywhere in the United States