Required Skills:
5+ years of experience as an Oracle Application DBA, Oracle Certification preferred (OCA or higher), SQL and PL/SQL, Eclipse 3.3+, Solaris 10, Unix scripting, DB Schema Design, DB Performance tuning, Oracle 10g+, TOAD 9.6+ or similar, DB Artisan or similar, Microsoft Office 2007+, Microsoft Visio 2007+
· Responsible for high level database administration and related tasks on multiple DMBS platforms with emphasis on Oracle 11g.
· Create a logical model and transform logical design into efficient physical database elements, performing data table design, applying normalization and de-normalization principles as needed.
· Write Database procedures, functions, triggers and objects to assist developers with the implementation of new projects or for changes in existing projects for an enterprise application.
· Assist developers in troubleshooting and resolving database related issues that are outside the domain of application programming.
· Tune Database queries; apply indexes, hints and other database best practices as needed to keep the database in optimal shape to deliver peak performance on critical business days.
· Create and maintain application database related jobs and UNIX shell scripts to go with them to run a certain business function periodically.
· Monitor database on a regular basis to track the data replication and other critical tasks including the overall health of the databases.
· Considering volume, capacity and requirements to arrive at performance, data conversion, purge/archive and operation viability decisions.
· Responsible for implementing database architecture strategies.
· Participate in the evaluation, planning and implementation of database upgrades and monthly service patches.
· Work on Database administration projects that may span across parts of the enterprise and ensure deliverables are completed on time.
· Strives to drive overall costs lower for database performance, data conversion, and administration services.
· Lead efforts to implement standards across the enterprise for ease of support and recovery in relation to database administration (database security, disaster recovery, scripts, database documentation).
· Evaluate and deploy new technology to improve database efficiency, recoverability and help reduce overall operating cost.
· Perform advanced problem determination and data recoveries.
· Work on a shift basis or an on-call schedule to standby for potential production outages or perform routine off-hour maintenance tasks.
· Multi-task and work on several projects at one time.
· Very good Communication and Interact/coordination technically and non-technically with multiple teams involved.