Job Description
Title: Sr. Oracle DBA

Job Duties:
Assist with creating Oracle server environment complete with administrative policies, procedures and documentation
Incident and problem resolution
Assist with governing tasks such as monitor performance, space, backups, availability and resources, and size of physical database objects to support ongoing capacity management and promote continuous service
Periodic Recovery Testing
Assist with governing, planning or performing the following:
o Database software patching
o Data load and Refresh
o Data archival and purging
o Apply maintenance and corrective service for database products and associated DBMS products and tools
o Database system level database backup and recovery
o Perform database system level space management and monitoring
o Run Database system level reorganizations, statistics and other applicable utilities to ensure proper database function and performance
o Perform automated startup and shutdown of the production database (this does not include business applications)
Execute Object DDL to create database objects (i.e., tables, indexes, packages)
Move database objects between physical structures (i.e., development to production)
Maintain database security accesses at database and object level
Setup and retain use of DBMS System Administration ID & privileges
Manage database transaction logs (active and inactive)
Provide monthly reporting statistics as required
Provide SME consultation to project teams implementing developed or third party solutions that require database component(s) in the design. Review and recommend changes where necessary and/or support the established database policies, guidelines, procedures, etc. as they apply to development and implementation of new database objects, etc.
Other duties as assigned by Database Manager

Requirements:
Bachelor of Science in Computer Science or equivalent work experience; IT Professional with 7+ years industry experience; 5+ years experience with Oracle database administration and maintenance, using versions through 11gR2.
Ability to perform in an architectural role, i.e., makes recommendations for design regarding topics such as SAN storage, RAC node configuration, ASM disk group strategy, etc.
Working knowledge of a virtual environment and SAN storage solutions
Strong hands-on aptitude in performing administration functions such as installations and configurations, creating databases, backups and restores, and database migrations
Strong hands-on experience in troubleshooting RAC related issue.
Experience in database optimization and performance tuning including:
o SQL optimization;
o Index creation and rebuilds
o Triggers, views and stored procedures
Experience with Precise performance monitoring tool.
Practical experience in managing Oracle security best practices
Expert knowledge of database recovery models including Mirroring, Clustering and Log Shipping
Ability to develop trend and analysis reports indicating database growth and load to anticipate storage, CPU and memory needs;
Ability to research new products, tools, methodologies, and standards related to all aspects of the database environment and its security and make recommendations.
24 x 7 On-call availability for emergency support to the primary database MRO team
Occasional evening and weekend work to perform maintenance and upgrades, and emergency troubleshooting.
Strong experience in data warehouse tuning and best practices, including partitioning, parallelization, star schema design.
Working knowledge of Informatica and Business Objects tools would be highly desirable
Strong Sun Solaris OS (Unix Understands how Oracle parameters interact (cause/effect) with the OS system and can quickly ascertain problem areas and make accurate recommendations for improvement.

Additional Preferred Qualifications:
Oracle certification (OCP)
SQL Server 2005/2008 experience and/or certification (Microsoft MCDBA and/or MCSE)
Key Skills: