Oracle DBA/Developer

A financial firm is looking for an Oracle DBA/Developer to join their team in Tampa, FL.

Compensation: $115 - 150K

Responsibilities:

• Make changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages using CI/CD pipelines such as Client Project and promote them to higher environments (UAT, Production and Cob) following SDLC using Release on Demand
• Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions
• Ensure weekend activities complete successfully through assignment, coordination, oversight and validation
• Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
• Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
• Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
• Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
• Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
• Serve as advisor or coach to mid-level app DBAs and developers, allocating work as necessary

Qualifications:

• 12+ years of relevant experience in Application DBA
• Subject Matter Expert (SME) in at least one area of ApplicationsExperience in managing and implementing successful projects GoldenGate implementation
• Extensive experience in Application DBA, performance Tuning and Development
• Ability to adjust priorities quickly as circumstances dictate
• Demonstrated leadership and project management skills
• Consistently demonstrates clear and concise written and verbal communication
• Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes, Table statistics using Oracle 19c and 23ai
• Experience in designing, architecting and implement resilient database solutions
• Able to help in finding current performance bottlenecks and provide solutions to improve performance
• Knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle ASM & ACFS
• System analysis and design skill with knowledge of data flow diagrams, data dictionary techniques, case tools, Entity relation Modeling, design Technique, etc.
• Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout
• Change Control Management Skills using Source Control System
• Experience of working in a team that delivers a high availability service
• Experience with Oracle Golden Gate 12c/19c/23ai implementation and support
• Experience with building Database warehouse Solution. Extensive experience with Database compression and purging techniques
• Experience with MSSQL, mongoDB and postgres will be an added advantage

Education:

• Bachelor's degree/University degree or equivalent experience
• Master's degree preferred

Skills:
Oracle 19c/23ai, RHEL7/8, GoldenGate 19c/23c, MySQL, PostgreSQL, Sybase, MS
SQL Server, AWS, UDeploy, Client Project, TPAM, CyberArk, Autosys, Python Scripting,
Ansible, Shell scripting, PL/SQL, T-SQL, mongoDB, ServiceNow