KEY ROLE FOR SAP MICROSOFT SQL & ORACLE DATABASE ADMINISTRATOR
Thermo Electron, #5 on the Fortune 100 List of Most Admired Companies, is actively looking for a SAP Microsoft SQL/Oracle Database Administrator to provide support and maintenance of the existing Microsoft SQL/Oracle RDBMS environments (development, quality assurance and production)in our SAP implementation.
Over the past 4 years, Thermo has gone from a global holding company to an "operating" corporation of multiple divisions. Its IT focus is to integrate these divisions within a SAP environment. Thermo offers all the benefits of a large financially sound company with the opportunities that a ?new? company can offer.
RESPONSIBILITIES:
* Resolve problems and answer questions related to the RDBMS and platform environment, contact vendor support when necessary, facilitate application development and client problem resolution with optimum speed and efficiency
* RDBMS performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency
* Maintain database backup/recovery environment: Respond quickly to refresh data; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error
* Install and upgrade RDBMS and related products: Keep RDBMS at current release and maintenance levels; install supporting products; provide current, stable production, quality assurance and development environments
* Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or defragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance
* Perform application data refreshes on request: Refresh data from one environment to another at the request of the application development staff; execute necessary tasks to accomplish this, including export, drop, create, and import prescheduled time to minimize impact; provide application development staff optimal development environment with current data
* Work closely with Systems Programmer ? RDBMS to create database schemas and subschemas; lead/review database designs; estimate sizes of new databases. Research and recommend optimal design criteria.
* Capacity planning and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out-of-space conditions
* Develop rules, procedures, and standards for the access and maintenance of shared data resources
* Review overall physical database structures for performance quality, recoverability, maintenance, and space requirement considerations
* Participate in the evaluation and recommendation of DBA tools and new DBMS technologies
* Serve as business liaison to database vendors
* Provide the definition and development of database documentation and standards
* Conduct application transaction volume and traffic analysis, and interpret impact on database and network performance
REQUIREMENTS:
* 5-8 years? IT experience, a minimum of 3 years with Microsoft SQL Server is required
* 1-2 years? experience with Oracle is required
* Two years' experience with SAP R/3 and BW is desired
* Proficient in SQL, creating and maintaining Stored Procedures
* Experience providing production support in a multi-RDBMS environment
* Strong analytical, problem solving and multi-tasking skills required, as well as communication and interpersonal skills and good organizational skills
* Must be committed to provide a high level of customer service to internal clients
* Bachelor?s degree in Computer Science OR appropriate combination of education and experience.
Thermo Electron offers a highly motivating and exciting work environment for employees to work, grow and succeed. As a $11.5B global corporation with offices in 30 countries, Thermo provides opportunities for employees to advance their careers and build world-class skills and competencies. To learn more, visit
|