Job ID :
5310
Company :
Internal Postings
Location :
ALPHARETTA, GA
Type :
Hire
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
14 May 2014
Job Seekers, Please send resumes to resumes@hireitpeople.com

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.