Lead Associate Principal, Database Administration

OCC • Franklin, TN

7d • Hybrid

About The Position

To be considered for this position, applications and resumes are accepted only through our careers site by directly applying to the posted job. We do not accept unsolicited resumes or sales solicitations from staffing agencies. Any OCC employee wishing to submit a referral must do so through their Workday account. Any resume submitted outside of an active job posting will not be considered for employment. What You'll Do: This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.

Requirements

• 3+ years’ experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years’ experience as an associate DBA
• Well versed in all phases of Systems Analysis and Design
• Experienced in two or more programming languages and two or more scripting languages
• Practiced at Entity/Relationship or Object modeling and translation to physical database designs
• Proficient in DML, DDL, and database utilities for at least two DBMS technologies
• Proficient in all access methods of a DBMS as well as the underlying operating system access methods
• Knowledge of hardware and operating system capabilities within one Environment
• Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
• Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility
• Speed / Sense of Urgency –Contributes additional effort when necessary to get the job done and to help others meet their objectives
• Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise
• Communicates openly and effectively. Challenges established practices appropriately
• Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations
• 5+ years’ experience with PostgreSQL (preferred EnterpriseDB (EDB) version)
• 1+ years’ Terraform, Ansible, Jenkins & CI/CD skills
• bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business

Nice To Haves

• 1+ years’ experience with Barman (EDB Backup and Recovery Manager)
• 1+ years’ experience with SQL Server
• Related financial industry experiences
• PostgreSQL Professional Certification

Responsibilities

• Assists with the design, implementation, and maintaining databases
• Manage database performance and disk usage
• Provides support in database access methods
• Provides consultation support in database analysis, modeling, coding, and production problem resolution.
• Develops maintenance, backup and recovery procedures and documentation
• Participates in Disaster Recovery drills
• Provides Primary On-Call Support for production problems
• Understands and supports corporate data standards
• Recommends and assists with new DBMS and operational standards.
• Participates in testing and in evaluations of new software and software release upgrades
• Supports business studies, proposal teams and costing/feasibility studies
• Prepares system documentation
• Maintains metadata repositories
• Other duties as assigned

Benefits

• A hybrid work environment, up to 2 days per week of remote work
• Tuition Reimbursement to support your continued education
• Student Loan Repayment Assistance
• Technology Stipend allowing you to use the device of your choice to connect to our network while working remotely
• Generous PTO and Parental leave
• 401k Employer Match
• Competitive health benefits including medical, dental and vision

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees