Senior Oracle Database Administrator |
This job posting is closed.
Share this job:
- Location: Foxboro, MA
- Category: Computer/Software
- Posted: 88 days ago
Job Description:
Senior Oracle Database Administrator
Axeda is looking for a high energy senior 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!
Responsibilities
• Responsibilities include 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
• Responsible for designing 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.
• Manage and provide 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
• Develop Disaster Recovery documentation, planning and testing
Job Qualifications:
• 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, daily experience as a lead DBA 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
• 7+ years of experience designing, deploying and managing a high volume, high-availability, database instances and systems is required.
• Demonstrated experience as the senior database administrator in a SaaS business.
Axeda Corporation is an Equal Opportunity Employer
Apply online: https://home.eease.adp.com/recruit2/?id=961391&t=1
OR email resume to Tom: tsullivan@axeda.com
Axeda is looking for a high energy senior 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!
Responsibilities
• Responsibilities include 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
• Responsible for designing 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.
• Manage and provide 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
• Develop Disaster Recovery documentation, planning and testing
Job Qualifications:
• 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, daily experience as a lead DBA 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
• 7+ years of experience designing, deploying and managing a high volume, high-availability, database instances and systems is required.
• Demonstrated experience as the senior database administrator in a SaaS business.
Axeda Corporation is an Equal Opportunity Employer
Apply online: https://home.eease.adp.com/recruit2/?id=961391&t=1
OR email resume to Tom: tsullivan@axeda.com
About the Company:
Axeda provides the most advanced cloud-based software for managing connected products and implementing innovative M2M applications. We take the cost and complexity out of connecting and remotely servicing the products of the world's leading companies. Our customers use our M2M cloud service to deliver innovative M2M solutions and optimize their business processes with data from their connected products.
By relying on the Axeda Platform to power their connected products, companies are transforming their business by improving customer satisfaction, reducing costs, and generating new sources of revenue.
Axeda Corporation is an Equal Opportunity Employer