Responsible for all functions associated with the database management and support: Install, design, implementation and maintenance of Oracle databases including security, back-up, logging, reporting, trouble shooting, and recovery procedures
Able to tune complex application SQL queries with multi level joins. Some queries created by code generator software.
Work closely with Java developers for object designs and troubleshooting.
Work closely with other DBA team members to manage all technical aspects of database management and process tuning.
Manage User access and auditing.
Assist in maintaining and improving database operational efficiency
Perform daily, weekly, and monthly data maintenance tasks
Assist in developing feeds to Data Warehouse and Marts
Ensure data can be provided to support OLAP reports and various reporting requirements
Manage setup configurations
Test various internal applications, commercial apps, and DR testing.
Perform daily, weekly, and monthly data maintenance tasks
Develop and test backup procedures
Assist in data management processes
Collaborate with the development team in creating and following a well defined methodology to implement changes to database systems.
Responsible for analysis, design, implementation, project management, and maintenance of the logical and physical databases.
Involved in normalizing, data modeling, transformations, mapping and mining.
Performs activities related to database administration such as, access methods/time, device allocation, quality control, data validation checks, security, and documentation.
Provide analytical support during design and troubleshooting review sessions.
Additional Desired Skills
Experience with SYBASE DBMS.
Experience with SQL Server DBMS
Experience with data warehouse processes.
Experience with CONFIO Ignite tools.
Experience with Embarcadero Admin tools.
Experience with java, cobol, C++
Requirements & Experience
·Must have good communication and written skills.
·Must have good analytic and problem solving skills.
·Will require 40 to 50 hrs per week with occasional weekend and off-hours support.
·Experience with Oracle Integration Services and Reporting Services.
·Experience with MS Access interface to Oracle DBs.
·Must be self starter, able to work independently.
Minimum 3 to 5 years hands-on experience with Oracle 10g and 11g database administration.
Minimum 3 to 5 years hands-on operational experience with strong understanding of database structure, theories, principals and practices
Minimum of 3 to 5 years of experience with performance tuning complex queries.
·Must have experience with UNIX scripting
Experience with Clustering Technologies
Experience developing, implementing, and testing disaster recovery strategies.
Experience creating and maintaining an extraction, transformation, and loading process from source systems or files into a data warehouse.
Ability to plan, organize and work on multiple tasks simultaneously
Education
Bachelor's Degree in Computer Science or equivalent of experience and education