Sr. SAP / SQL Database Administrator
Thermo Fisher Scientific Inc. (NYSE: TMO) is the world leader in serving science, enabling our customers to make the world healthier, cleaner and safer. With annual revenues of $10 billion, we have more than 30,000 employees and serve over 350,000 customers within pharmaceutical and biotech companies, hospitals and clinical diagnostic labs, universities, research institutions and government agencies, as well as environmental and industrial process control settings. Serving customers through two premier brands, Thermo Scientific and Fisher Scientific, we help solve analytical challenges from routine testing to complex research and discovery. Thermo Scientific offers customers a complete range of high-end analytical instruments as well as laboratory equipment, software, services, consumables and reagents to enable integrated laboratory workflow solutions. Fisher Scientific provides a complete portfolio of laboratory equipment, chemicals, supplies and services used in healthcare, scientific research, safety and education. Together, we offer the most convenient purchasing options to customers and continuously advance our technologies to accelerate the pace of scientific discovery, enhance value for customers and fuel growth for shareholders and employees alike. All of our employees share a common set of values - Integrity, Intensity, Innovation and Involvement. Our ability to grow year after year is driven by our ability to attract, develop and retain world-class people who will thrive in our environment and share in our desire to improve mankind by enabling our customers to make the world healthier, cleaner and safer. If you share in our values and if you're looking for an employer who is strongly committed to developing talent and rewarding achievement, come grow with us at Thermo Fisher Scientific. Thermo Fisher Scientific is an Equal Employment Opportunity and Affirmative Action employer. Job Description Sr. SAP / SQL Database Administrator Summary: Provide support, maintenance and enhancement of the existing Microsoft SQL Server and Oracle RDBMS environments (development, quality assurance and production). Resolve problems and answer questions related to the RDBMS and platform environment, contact vendor support when necessary and facilitate application development and client problem resolution 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 Create, maintain and enhance SQL and stored procedures as requested 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. Preschedule 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 Create database standards and documentation Conduct application transaction volume and traffic analysis and interpret the impact on database and network performance Qualifications: SAP Basis experience a plus. Experience providing production support in a multi-RDBMS environment. Proficient in SQL and creating and maintaining Stored Procedures. 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..Non-Negotiable Criteria: Bachelor’s degree in Computer Science or appropriate combination of education and experience. 5-8 years IT experience with a minimum of 2 years experience administrating SAP R/3 databases is required. Three years experience with Oracle 9i or higher and 1-2 years experience with Microsoft SQL Server is required. Job Level: Experienced
|