Description
What You’ll Do:
- Define data architecture standards for the organization, structure, attributes, and nomenclature of data elements.
- Design, develop, test, and implement new database objects (tables, views, indexes, databases, etc) and administer existing architectures supported for performance and maintenance related issues.
- Analyze and recommend best practice steps to prevent potential database issues, such as performance degradation or potential loss of service as well as recommend actions to fix issues when database problems do occur (outages or potential errors).
- Recommend methods to recover or improve databases to include analysis/review of vendor products.
- Provide input into complex decisions as they relate to data architecture, infrastructure and/or administration.
- Consult with information systems areas on database issues and proposed changes.
- Recommend tuning to databases and queries when they are not performing to customer requirements.
- Analyze and recommend upgrades to database software and components based on security requirements, new technology, or evolving application system requirements.
- Analyze and recommend capacity planning (SAN storage) based on captured growth trends and monitoring.
- Review database environments to ensure they meet security controls and audit requirements; continually mitigate identified risks and vulnerabilities.
- Ensure recoverability of databases by creating, scheduling, and monitoring database backups for dependent systems.
- Support management on enterprise wide and departmental goals and objectives.
- Provide education and information on security policies, practices, and awareness programs.
- May provide estimation on work efforts and recommendations on training plans for less experience staff.
- Bachelor's Degree in a job-related field OR
- 4 years job related work experience OR
- Associate's Degree and 2 years job -related work experience
- 8 years of IT experience including varied database administration experience.
- Knowledgeable in most aspects of constructing data marts, data architectures and operational data stores.
- Good business analysis, data acquisition, and access analysis and design skills.
- Able to provide input into complex decisions as they relate to data architecture. Able to relate knowledge of security issues for data management to less experienced personnel.
- Standard office equipment.
- Database Administration Technical Support – troubleshooting, analysis, and resolution.
- Responsible for Oracle database security and compliance including remediation and audit support.
- Experience with Oracle Enterprise Manager
- Oracle Database installation, configuration, and patching.
- Work with application and other areas on design/development as well as technical issues for operational support.
- Able to communicate effectively with management on highly visible or critical operational issues.
- Able to create work instructions, desk procedures, database standards and other technical documentation.
- Experience monitoring databases with Opsview and Splunk.
- Experience with other RDBMS technologies.
- Experience with Automation tools such as Github, Python, and Ansible
- 401(k) retirement savings plan with company match
- Subsidized health plans and free vision coverage
- Life insurance
- Paid annual leave — the longer you work here, the more you earn
- Nine paid holidays
- On-site cafeterias and fitness centers in major locations
- Wellness programs and a healthy lifestyle premium discount
- Tuition assistance
- Service recognition
We participate in E-Verify and comply with the Pay Transparency Nondiscrimination Provision. We are an Equal Opportunity Employer.