Plans, designs, and installs computerized databases to include data definition, structure, documentation of databases, long-range requirements, operational standards and guidelines, and protection.
Essential Job Functions
Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files. Develops data retrieval queries and optimizes data queries within programs for performance for performance and maintainability. Determines data to collect and analyzes information as appropriate.
Analyzes and determines informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements and data output and reporting capabilities.
Assists development teams in defining logical attributes and inter-relationships and assists in designing data structures to accommodate database production, storage, maintenance and accessibility to enhance performance.
Tests designed applications utilizing database management software or general programming software to enhance performance.
Installs, implements and supports systems within user base; creates and updates database installation instructions and design changes for client use.
Installs new systems or new releases of database systems; determines table attributes, primary, and alternate keys for multiple databases. Installs and upgrades hardware and software as necessary to enhance database performance. Researches various hardware and software products; recommends solutions and implements approved products.
Utilizes standard corporate tools to record change and problem activities for tracking purposes.
Duties and Responsibilities:
Provide technical support for database environments, including testing and installation of DBMS upgrades
Assist in documenting database strategies and architectures
Participate in tool evaluation, integration and support
Monitor the performance of production systems and utilize appropriate tools to identify tuning requirements
Participate in logical and physical database design and assist application developers in applying DBMS technology
Backup and recovery processes and technologies
Database knowledge (logical and physical design)
Experience with troubleshooting database performance and query tuning Data integrity concepts
Broad technical knowledge of client/server and web-based environments
Database software maintenance (upgrades, service packs and patches)
Experience isolating, diagnosing and resolving DBMS problems, including root cause analysis
Experience working with Oracle advanced features such as RAC, Partitioning, Streams, OEM
Understands 24 X 7 database support
3 years experience as an Oracle 10g/11g DBA on multiple instances
5 years IT experience
Programming experience Linux/Unix OS and shell scripting
Good interpersonal skills
Bachelor s degree or equivalent work experience
Organizational \"Fit\" Considerations:
Strong Teamwork/interpersonal skills
Excellent attendance record
Ability and desire to provide training
May require occasional evening or weekend work
Associated topics: data architect, data center, data engineer, data integrity, data manager, data warehousing, hbase, mongo database, sql, sybase
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.