Sr Information Specialist - Database Administrator – Irvine

Alcon is the world's leading eye care company with sales of $4.9 billion. The company's nearly 13,000 employees worldwide, work in 75 facilities around the world to research, develop, manufacture and sell our products in more than 180 countries. Alcon is the largest specialty eye care company in the world and leads the growing $14.5 billion market for eye care products. For nearly 60 years, Alcon has delivered strong and stable growth, and it is positioned to build on this record in the years to come. For nine consecutive years, Fortune magazine has selected Alcon as "One of the 100 Best Companies to Work For". Alcon's U.S. General Office is based at its 300-acre campus located in Fort Worth, Texas.

This position will be responsible for administering, Oracle, and MS SQL Server databases located at the Irvine Technology Center and some JD Edwards AS/400 functions. Additional responsibilities include the configuration management and deployment of the custom and third-party business applications implemented by the IT Applications Development group.

Primary Accountabilities:
• Performing the installation, configuration, administration, maintenance, automated data extraction, transformation, and loading, backup, recovery, and performance tuning processes for all business databases using Oracle and MS SQL Server platforms in development, test/validation, and production environments.
• Reviewing the design and performing the deployment of database configurations (new and updated schemas and data loading jobs – SQL scripts stored procedures, DTS packages, etc.) in test/validation and production environments.
• Overseeing the creation, maintenance, scheduling and monitoring of database controlled jobs for Oracle and MS SQL Server databases in development, test/validation and production environments.
• Defining, implementing, and managing appropriate use of PVCS for development, maintenance, validation, and production use for the Irvine Technology Center's business applications.
• Deploying applications into server-based development, test/validation and production environments.
• Managing the creation, maintenance, scheduling & monitoring of AS/400 jobs related to the JDEdwards ERPx application and coordinating with GIT personnel in Fort Worth as needed to adjust ITC job scheduling to support changes in production schedules required due to maintenance or emergencies in GIT production schedules.

Requires – Education: B.S. in Math, Computer Science or equivalent technical training. Prefer M.S. in Computer Science, with an emphasis on database management systems.

Experience: 8-10 years of hands-on experience as both an Oracle and MS SQ Server DBA and development of client/server and web-based applications using complex SQL statements, stored procedures and automated data loading processes. Prefer 5-7 years of hands-on experience with all three database platforms (Oracle, MS SQL Server, and AS/400
Must be proficient in Oracle 8i, 9i, and 10g and MS SQL Server 2000 and 2005 database design, administration (creation, monitoring, maintenance backup, restore, security, installation, configuration, and deployment), automated data migration tools and techniques (SQL scripts, stored procedures, DTS packages, etc.) and performance tuning. Proficiency in the development of database-driven client/server and web based applications using complex SQL statements and stored procedures.

Our generous benefits package includes the Alcon 401(k) Plan which matches employee contributions up to 5% of eligible pay at the rate of $1.00 for each dollar contributed, and the Alcon Retirement Plan (ARP), a qualified plan in which Alcon contributes 7% of eligible pay to the accounts of all eligible employees. By combining the Company's contributions to the 401(k) and ARP, employees can receive up to 12% of eligible pay from Alcon towards retirement. Alcon also offers medical, dental, vision, life and disability coverage, an on-site fitness center and much more. Consider having all this in a fast paced environment within a stable world-class organization.


Alcon is an Equal Opportunity Employer committed to quality through diversity. M/F/D/V. Pre-employment drug testing.

Apply Here