Lead Associate Principal, Database Administration
National Black MBA Association, Dallas, TX, United States
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.
Primary Duties and 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
Supervisory Responsibilities: None
Qualifications:
[Required] 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
[Required] Well versed in all phases of Systems Analysis and Design
[Required] Experienced in two or more programming languages and two or more scripting languages
[Required] Practiced at Entity/Relationship or Object modeling and translation to physical database designs
[Required] Proficient in DML, DDL, and database utilities for at least two DBMS technologies
[Required] Proficient in all access methods of a DBMS as well as the underlying operating system access methods
[Required] Knowledge of hardware and operating system capabilities within one Environment
[Required] Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
[Required] Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility
[Required] Speed / Sense of Urgency –Contributes additional effort when necessary to get the job done and to help others meet their objectives
[Required] Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise
[Required] Communicates openly and effectively. Challenges established practices appropriately
[Required] Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations
Technical Skills:
[Required] 5+ years’ experience with PostgreSQL (preferred EnterpriseDB (EDB) version)
[Required] 1+ years’ Terraform, Ansible, Jenkins & CI/CD skills
[Preferred] 1+ years’ experience with Barman (EDB Backup and Recovery Manager)
[Preferred] 1+ years’ experience with SQL Server
Education and/or Experience:
[Required] bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
[Preferred] Related financial industry experiences
Certificates or Licenses:
[Preferred] PostgreSQL Professional Certification
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
Compensation:
The salary range listed for any given position is exclusive of fringe benefits and potential bonuses. If hired at OCC, your final base salary compensation will be determined by factors such as skills, experience and/or education.
In addition, we believe in the importance of pay equity and consider internal equity of our current team members as part of any final offer.
We typically do not hire at the maximum of the range in order to allow for future and continued salary growth. We also offer a substantial benefits package as noted on www.theocc.com/careers.
All employees may be eligible for a discretionary bonus. Discretionary bonuses are based on various factors, including, but not limited to, company and individual performance and are not guaranteed.
Salary Range $130,400.00 - $185,300.00
Incentive Range 8% to 15%
This position is eligible for an annual discretionary incentive compensation award, for which the target range is listed above (see Incentive Range). The amount of such award, if any, will be based on various factors, including without limitation, both individual and company performance.
OCC is an Equal Opportunity Employer #J-18808-Ljbffr
Primary Duties and 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
Supervisory Responsibilities: None
Qualifications:
[Required] 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
[Required] Well versed in all phases of Systems Analysis and Design
[Required] Experienced in two or more programming languages and two or more scripting languages
[Required] Practiced at Entity/Relationship or Object modeling and translation to physical database designs
[Required] Proficient in DML, DDL, and database utilities for at least two DBMS technologies
[Required] Proficient in all access methods of a DBMS as well as the underlying operating system access methods
[Required] Knowledge of hardware and operating system capabilities within one Environment
[Required] Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
[Required] Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility
[Required] Speed / Sense of Urgency –Contributes additional effort when necessary to get the job done and to help others meet their objectives
[Required] Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise
[Required] Communicates openly and effectively. Challenges established practices appropriately
[Required] Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations
Technical Skills:
[Required] 5+ years’ experience with PostgreSQL (preferred EnterpriseDB (EDB) version)
[Required] 1+ years’ Terraform, Ansible, Jenkins & CI/CD skills
[Preferred] 1+ years’ experience with Barman (EDB Backup and Recovery Manager)
[Preferred] 1+ years’ experience with SQL Server
Education and/or Experience:
[Required] bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
[Preferred] Related financial industry experiences
Certificates or Licenses:
[Preferred] PostgreSQL Professional Certification
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
Compensation:
The salary range listed for any given position is exclusive of fringe benefits and potential bonuses. If hired at OCC, your final base salary compensation will be determined by factors such as skills, experience and/or education.
In addition, we believe in the importance of pay equity and consider internal equity of our current team members as part of any final offer.
We typically do not hire at the maximum of the range in order to allow for future and continued salary growth. We also offer a substantial benefits package as noted on www.theocc.com/careers.
All employees may be eligible for a discretionary bonus. Discretionary bonuses are based on various factors, including, but not limited to, company and individual performance and are not guaranteed.
Salary Range $130,400.00 - $185,300.00
Incentive Range 8% to 15%
This position is eligible for an annual discretionary incentive compensation award, for which the target range is listed above (see Incentive Range). The amount of such award, if any, will be based on various factors, including without limitation, both individual and company performance.
OCC is an Equal Opportunity Employer #J-18808-Ljbffr