Oracle DBA/Developer (VP)

Open Systems Technologies; Irving (TX); On-site; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a skilled Applications Development Technology Lead Analyst to drive application database support and enhancements. In this senior-level role, you will lead database administration efforts, architect resilient solutions, and optimize performance across various platforms. Your expertise in Oracle technologies and leadership skills will be vital in guiding teams and ensuring high availability of services. This position offers an exciting opportunity to impact critical applications within the banking sector while working with cutting-edge technologies and methodologies. Join a forward-thinking company that values innovation and excellence in database management.

Qualifications

• 12+ years of experience in Application DBA roles with expertise in performance tuning.
• Proven success in managing and implementing projects.
• Ability to quickly adjust priorities and demonstrate leadership.

Responsibilities

• Lead application database administration and architect resilient database solutions.
• Identify performance bottlenecks and provide solutions for improvement.
• Collaborate in teams delivering high-availability services.

Skills

Performance Tuning

Leadership

Communication

Database Administration

Oracle GoldenGate

Project Management

Teamwork

Problem Solving

Education

Bachelor's degree

Master's degree

Tools

Oracle 19c

GoldenGate

RHEL7/8

MySQL

PostgreSQL

MS SQL Server

AWS

Autosys

Job description

Get AI-powered advice on this job and more exclusive features.

The Applications Development Technology Lead Analyst is a senior-level position responsible for providing Application Database support for reference data applications, including database and application enhancements. The primary objective is to lead application database administration, architect resilient database solutions, and perform performance tuning.

Responsibilities:

1. Make changes to existing Data Models (Logical & Physical), such as Client Project models, and promote them to higher environments (UAT, Production, COB) following SDLC using Release on Demand.
2. Maintain excellent understanding of Database concepts including Procedures, Triggers, Packages, Constraints, Indexes, and Table statistics using Oracle 19c and 23ai.
3. Design, architect, and implement resilient database solutions.
4. Identify current performance bottlenecks and provide solutions to improve performance.
5. Review performance reports like AWR, ADDM, ASH and suggest enhancements.
6. Work with Linux Redhat, File System, Cluster Management (RAC), Oracle ASM & ACFS.
7. Conduct system analysis and design, utilizing data flow diagrams, data dictionaries, ER modeling, and design tools.
8. Design databases with normalization, STAR schema, and data modeling tools, including logical/physical layout engineering.
9. Collaborate in teams delivering high-availability services and oversee weekend activities.
10. Implement Oracle Golden Gate 12c/19c/23ai and support database warehouse solutions.
11. Apply database compression, purging, and enable encryption for data in transit and at rest.
12. Knowledge of MSSQL, mongoDB, and Postgres is advantageous.
13. Partner with management to ensure system integration, deploy new products, and improve processes.
14. Resolve complex business and system process problems, adhering to industry standards.
15. Ensure application design aligns with overall architecture and infrastructure goals.
16. Develop standards for coding, testing, debugging, and implementation.
17. Understand business areas and how they integrate to meet goals.
18. Provide in-depth analysis and develop innovative solutions.
19. Serve as an advisor or coach to mid-level DBAs and developers, managing work allocation.
20. Assess risks in business decisions, ensuring compliance with laws, regulations, and policies, and report control issues transparently.

Qualifications:

• 12+ years of experience in Application DBA roles, with expertise in performance tuning and GoldenGate.
• Proven success in managing and implementing projects.
• Subject Matter Expert in at least one application development area.
• Ability to quickly adjust priorities and demonstrate leadership and project management skills.
• Excellent communication skills.

Education:

• Bachelor's degree or equivalent; Master's preferred.

This description summarizes high-level responsibilities; additional duties may be assigned.

Technologies include Oracle 19c/23ai, RHEL7/8, GoldenGate, MySQL, PostgreSQL, Sybase, MS SQL Server, AWS, UDeploy, TPAM, CyberArk, Autosys, scripting languages, and NoSQL databases.

Skills include leadership, communication, teamwork, ownership, and accountability.

Seniority level

• Director

Employment type

• Full-time

Industry

• Banking