Oracle Database Administrator Axeda Corporation
THIS JOB HAS EXPIRED Axeda is looking for a high energy Oracle 11g R2 RAC database administrator (DBA) for its SaaS hosting environment and infrastructure. The DBA will work closely with the development team to identify the optimal physical implementation of the logical model. In addition, the successful candidate also be responsible for monitoring the production databases and providing support, including problem identification and remediation, as well as performance monitoring. The production DBA will ensure that all changes to production databases are fully tested and are secure against unauthorized access and accidental damage. The DBA will also assist in infrastructure work to standardize the Oracle DB environment. Seven years of database experience required.
Become a member of our challenging and rewarding team!
Assist in ensuring the security, availability, integrity, and functionality of high transaction volume production databases.
Design, plan, install, and manage database systems in a high volume SaaS environment
Design and hands on implementation of fault tolerant, redundant database systems that will achieve SLA goals monthly.
Document and maintain our database instances and systems and proactively perform audits to ensure database instances are tuned and have optimal performance.
Troubleshoot database instances and performance issues. Require response to escalations from operations team 24x7.
Design physical model for performance (de-normalize; add indexes) and understand all of the Oracle and 3rd party database administration and performance tools.
Manage database backups and participate in recovery exercises
Database tuning, SQL tuning and optimization of query plans.
Maintain on-call pager support.
Capacity planning for production and non-production databases
Perform User Security Audits (assigned roles / privileges, quota usage)
Test and Apply Oracle Critical Security Patches & Patch Sets
Assist in Disaster Recovery documentation, planning and testing
B.S. degree in computer science, MIS, or equivalent experience
Demonstrable experience tuning individual SQL queries, database applications, and optimizing databases in a high transaction volume environment.
Hands on experience configuring, optimizing for performance upgrading, and troubleshooting Oracale RAC DBMS 11g R2 (standard and enterprise versions required)
Hands on experience with Linux RHEL 5+ or Oracle Enterprise Linux distribution
Proven experience configuring Oracle components to industry best practices for performance and availability including (ASM, Clusterware, voting disks, etc.)
Demonstrable experience with Oracle Partitioning, RMan, and Datapump
Proven experience increasing DB performance by monitoring and adjusting:
server tuning (CPU, RAM, DISK I/O),
workload tuning (optimizer params, metadata),
object tuning (concurrency, caching, row packing)
SQL statement tuning (execution plans, efficient syntax, profiles)
Experience with logical data modeling, including developing and maintaining data model diagrams (ERD), facilitating structured data modeling meetings
Experience working in a highly available 24X7 database environment
Education & Experience:
Bachelors degree in Computer Science or equivalent
4+ years of experience designing, deploying and managing a high volume, high-availability, database instances and systems is required.
||Foxboro, MA |
THIS JOB HAS EXPIRED