The Database Administrator Principal - Oracle and Linux designs, develops, maintains, and implements database models, dictionaries, and a fault tolerant infrastructure for the company's most critical systems by providing a highly-complex, reliable, and scalable database platform architecture in support of the organization's information systems needs and Business Continuity Plans. Additionally, provides technical leadership to peer and junior personnel and provides 24/7 support for assigned production database systems.
(Typical duties include the following, although specific duties vary by assignment or contract.)
Designs, implements, and administers database systems' security model, safeguarding the company's critical and sensitive data, and enforcing compliance to audit, legal, and regulatory guidelines, including SOX, HIPPA/PPI, and DCAA.
Designs, implements, automates, and manages database systems' pro-active maintenance processes to ensure optimal database system performance, data integrity, minimal down-time, effective resource allocation and capacity planning, fast issue resolution, and guaranteed backup and recovery-ability.
Designs databases structures in accordance with industry best practices to improve database/application performance by implementation of indexes, partitions, data compression, and storage volume layout.
Plans, designs, implements, documents, and tests database high-availability and the disaster recovery (DR) strategy.
Designs and implements the following technologies: data archiving, data warehouse, data marts, data extraction, transformation, and loading (ETL), and data integration.
Develops and maintains documentation for database architecture, design, installation, configurations, operational processes and procedures, data-flow, trouble-shooting, and database maintenance. Documentation may include Visio design diagrams, data dictionaries, storage configuration, security model, and data modeling.
Advises and collaborates with business units, project managers, program managers, application developers, security and infrastructure, and Business Intelligence teams, and users on reliable, innovative, and cost effective database solutions to business problems, high-performance and highly-available data architectures, database management system features and capabilities, cost-effective licensing models, and the operation, maintenance, security, and performance tuning of database systems.
Provides functional leadership including mentoring other database administrators on technical database architecture and design details and provide advanced technical assistance to development staff. May provide work direction, quality review/feedback and assess completion of assignments for designated staff.
Maintains Oracle Linux server environment including deploying quarterly patches, updating deployment images, and deploying new servers including utilizing configuration management tools like Ansible, Puppet, etc. Conducts pro-active monitoring of servers using Oracle OEM, Solarwinds, etc.
Troubleshoots and resolves Oracle Linux server issues, as reported by application and business unit support teams.
Performs other duties as assigned.
Knowledge & Skills
Excellent data communication and people skills.
Current on the latest database industry advances, plus familiarity with multiple database platforms.
Advanced understanding of Networking, Web Farms, Network Load Balancing (NLB) technologies, Data Marts, Data Warehouse, and ETL.
Knowledge of enterprise agreements. Ability to work closely with vendors to resolve highly technical incidents.
Experience maintaining a small enterprise Oracle Linux environment including administering BIND, configuring storage including remote storage with MPIO, and Active Directory integration.
Experience with Oracle ASM.
Experience supporting Oracle applications such as Peoplesoft, Hyperion, Primavera,etc. is a plus.
Experience with administering virtual Linux servers on VMWare or Hyper-V is a plus.
Proficient in completing daily assignments and project activities with great attention to detail and a high degree of accuracy.
Excellent analytical and critical thinking skills, good judgment, and an ability to act decisively.
Ability to work without direct supervision and self-learn.
Experience & Education
Bachelor's degree in Computer Science or associated discipline, or equivalent work experience (1 year of relevant work experience may substitute for each 1 year of college education).
Eight (8) years' experience in Oracle database design, database architecture, performance tuning, monitoring & alerting, troubleshooting, and administration.
Eight (8) years Linux administration experience in an enterprise environment.
Physical Requirements/Working Environment
Normal office environment
Ability to work 24x7 on-call rotation schedule