Oracle Architect / Developer

To Apply: hr@mediafriendsinc.com

Date Posted: Monday February 08, 2010

Company: MediaFriends

Location: Woburn, MA

Responsible for architecting, development and supporting the Oracle databases and ensuring their performance, availability and security within a defined customer install base. Install, configure, troubleshoot and maintain a database system. Implement, configure and troubleshoot databases instances, replication, backup, partitions and storage through remote support for defined install base. Monitor and optimize system performance using index tuning, disk optimization, and other methods.

Primary responsibilities will entail definition of the Database Architecture, Data Modeling, Data Analysis, Database Design and Optimization, installation of new software and the relevant support of that solution.

• Database Architecture – architect the structure and foundation by which the company’s products will be based and grow, accounting for scalability, reliability and availability within real world parameters of cost and efficiencies.
• Data Modeling and Optimization – Through modeling the data, optimize the system layouts to take the most advantage of the I/O subsystem.
• Database Design – Involvement in the preliminary database design stages with a focus on operational support; point out potential problems, and assist the development team with special performance considerations.
• Data Analysis – Frequently called upon to analyze customer’s data storage in the database to ensure performance and efficiency of that data storage.
• Installation – Primary job to work with the support organizations and customers on installation of the database solution, from application through to administration.

Duties and Responsibilities

• Define the system architecture, design, and development of the Database layers.
• Improve existing models, transaction cost reduction, and increase overall data throughput.
• Tune SQL queries and database performance for OLTP and DSS applications within development, testing and production environments.
• Participate in design and code reviews, documentation of design, and implementation of methodologies to ensure high quality software.
• Install, manage and optimize a range of moderate to eventually very large (1TB+) Oracle databases
• Diagnose and troubleshoot performance problems using Method-R performance analysis methodology.
• Lead and execute the data modeling process.
• Perform database system and SQL profiling activities based on poorly performing use cases.
• Refactor poorly performing SQL when necessary.
• Review and tune initialization parameters, memory structures and physical data layout for optimal performance.
• Database design, table design, data modeling & performance tuning
• Developing stored procedures and triggers, etc.
• Work with functional specialists and team leads to create accurate level of effort estimates and schedules.
• Create and maintain tools that simplify Database Support tasks.
• Responsible for trouble shooting the performance issues on the application backend & databases.
• Design, code, and test new features and functionality based on requirements provided.
Perform software maintenance and bug fixes as needed.
• Participate in design and code reviews, documentation of design, and implementation of software development lifecycle methodologies to ensure high quality software.
• Responsible for ensuring availability and performance of the databases that support the system.
• Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.
• To proactively monitor the database systems to ensure secure services with minimum downtime.
• Responsible for supporting, providing guidance or consulting on database related questions from support organization as required.
• Approve, schedule, plan, implement and supervise the installation and testing of new databases
• Responsible for providing trend analysis to the service management team to enable them to make informed decisions regarding resource management.
• Responsible for problem escalation to Oracle Development team or company’s engineering center as appropriate.
• Responsible for improvement and maintenance of the databases to include rollout and upgrades.
• Responsible for implementation and release of database changes as submitted by the development team
• Responsible for helping to define and develop database changes under the direction of the engineering team.
• Write and code logical and physical database descriptions or direct others in coding descriptions.
• Maintain and increase knowledge and skills pertaining to field through training and study.

Skills / Attributes Required

• 5-10 years of work experience (8i, 9i and 10g and/or rel. 11)
• Proven track record in building highly scalable/performing/24x7 web-enabled database applications.
• Knowledge of Oracle Parallel Server, Oracle Enterprise Manager, Symmetric Replication, Advanced Queuing and Application Server
• Oracle’s BI stack (Discoverer, BI Beans, etc) is an added bonus
• PL/SQL programming/debugging and Perl/Unix shell scripting
• Strong debugging skills related to install and upgrade for each of the supported technology components
• Provide basic relational database and middleware technologies administration/support
• Knowledge of Oracle RDBMS installation /configuration, patching cloning, troubleshooting, performance tracking /tuning, backup/recovery, remote monitoring etc
• 10g Application Server experience
• Extensive knowledge of Oracle (PL/SQL).
• Experience working in both OLTP and Data Warehouse environments.
• Oracle Streams
• RAC experience
• Experience with Oracle on Solaris, Linux and Windows platforms
• General familiarity with SA of Solaris, Linux and Windows
• HA installation, configuration, and support
• Experience of managing multiple RDBMS on large systems
• Experience working with an application development team in an agile software development environment.
• Demonstrated proficiency of troubleshooting techniques and detail-oriented problem diagnosis.
• Demonstrated proficiency in DBA tools like IRWIN, TOAD, and others.
• Experience of working in a team that delivers and supports 5x9’s environment
• Practical experience in monitoring and tuning for high transaction, latency sensitive environment
• Experience of other database systems, preferably SQL Server
• Oracle Certification, preferably OCP
• Familiarity with SAML and OpenID a plus

We are looking for an enthusiastic and communicative team member with a positive attitude, dedication and willingness to work hard with a minimum of supervision. If you thrive in a small-team, dynamic environment and enjoy working with cutting edge technology to develop tomorrow's technology products, than this is your opportunity to work as a member of a high-powered team working on the development of a suite of the products of tomorrow.

This is a not a contract or short-term position. Local candidates and Principals only, please. No phone calls.

For more information, or to apply, please forward your resume to hr@mediafriendsinc.com