Lead Application DBA

APPLY NOW »

Date: Jan 12, 2022

Location: Dallas, TX, US

Company: New York Life Insurance Co

 

When you join New York Life, you’re joining a company that values development, career growth, collaboration, innovation, and diversity & inclusion. We want employees to feel proud about being part of a company that is committed to doing the right thing. Through various resources and programs, you can grow your career while developing personally and professionally.

 

 

 

Looking for a highly motivated Application DBA with well-rounded experience to lead our team. This role requires a highly motivated individual with a strong sense of ownership, technical and analytical expertise as well as an aptitude for business requirements documentation and designing system process flow. The candidate must have experience managing an Application DBA team.  Candidate must effectively communicate between end users and technical teams and be able to triage issues.

 

Responsibilities include but are not limited to:

  • Translating logical data models into physical database designs
  • Specify physical  database characteristics
  • Design efficient indexes
  • Map database objects to tablespace locations
  • Analyze data access and modify requirements to ensure efficient SQL and optimal database design
  • Assist developers with database activities (App DBA)
  • Build and maintain the database design
  • Tune database queries in conjunction with Performance Engineering and AppDev teams
  • Create DB Structure based on App Team requirements
  • Deployment of DB Structure through the environments in conjunction with release management plans
  • Preparation of deployment instructions for DB Structure and components to Production
  • Define, create, maintain all database objects (except application tablespaces) 
  • Forecasting initial application database allocations and growth due to changes
  • Forecast database system allocations and resources for growth
  • Design and planning of application backup and recovery (Export/Import, except RMAN)
  • Recommend and POC enhancements
  • Recommend SQL Tuning with AppDev team, productionalize enhancements, schedule into release
  • Maintaining Application Jobs Information
  • Monitor database performance by gathering and analyzing database statistics and performing benchmarks
  • Logical DB Backup and Restore (Data dump Export & Import)
  • DB Performance reporting
  • Disaster Recovery - verify logical backups / availability of schemas
  • Database Security Auditing
  • Execute database object creation and modification scripts developed by authorized user that require super-user authority (Except Script Needs to run using DBA or sysdba privilege).
  • Provide awareness of issues to all DB teams
  • Refreshing Development or QA DB instances from Production
  • Assists vendors with database activities (SaaS and Integration)
     

 

Required Skills / Knowledge:  

  • Requires in-depth and specialized knowledge and experience in Oracle systems administration; possesses extensive knowledge in related technologies (e.g. RAC, Data Guard, Installation and Upgrades, PSU patching).  
  • Oracle Version 11g.
  • Must have knowledge of industry best practices, trends and benchmarking regarding security, processes, services and engineering solutions and make recommendations to management on improvements.
  • Possesses, or is able to absorb very quickly, in-depth working knowledge of the company’s IT processes.
  • Possesses, or is able to absorb very quickly, a deep and wide understanding of the organization, its products and services and key business drivers
  • Understands customer requirements and anticipates changing business needs and challenges, and their subsequent impact on the technical direction of a solution.
  • Able to communicate complex ideas; persuade and negotiate with others, often at senior levels, to adopt a different point of view.
  • Able to deliver results focused on operational excellence and best practices.
  • Able to work independently and lead problem determination efforts requiring assistance from cross functional teams for the most complex situations.
  • Typical candidates will possess 8+ years of relevant experience and BA/BS Degree in Computer Science or equivalent experience.
  • Oracle certifications are a plus.
  • Working knowledge of MS SQL Server RDBMS a plus.

 

SF: LI-CC1

SF: LI-PC1

 

Recognized as one of Fortune’s World’s Most Admired Companies, New York Life is committed to improving local communities through a culture of employee giving and volunteerism, supported by our Foundation. We invite you to bring your talents to New York Life, so we can continue to help families and businesses “Be Good At Life.” To learn more, please visit LinkedIn, our Newsroom and the Careers page of www.NewYorkLife.com.

Job Requisition ID: 85509

 

 

 


Nearest Major Market: Dallas
Nearest Secondary Market: Fort Worth

Job Segment: Engineer, Database, DBA, Social Media, Oracle, Engineering, Technology, Marketing