Job Description

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 Applications. Experience in managing and implementing successful projects including 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 of Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes, Table statistics using Oracle 19c and 23ai. Experience in designing, architecting, and implementing 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. #J-18808-Ljbffr

Job Tags

Similar Jobs