Senior/Lead Oracle DBA

Software Guidance & Assistance, Inc., (SGA), is searching for an Senior/Lead Oracle DBA for a CONTRACT assignment with one of our premier Financial clients in Tampa, FL . Responsibilities :

• Provide Application Database support to the entire reference data team for its enhancements.
• Responsible for ensuring availability and performance tuning of the databases that support the system.
• Should have excellent knowledge with Oracle Golden Gate tool and hands on experience.
• Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.
• To proactively monitor the database systems to ensure secure services with minimum downtime.
• Responsible for providing trend analysis to the service management team to enable them to make informed decisions regarding resource management.
• Responsible for problem escalation to Oracle Development team and third parties as appropriate.
• Responsible for improvement and maintenance of the databases to include rollout and upgrades.
• Responsible for implementation and release of database changes as submitted by the development team.
• Able to make changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages and promote them to higher environments (UAT, Production and Cob) following SDLC.
• Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes using Oracle 11g, 12c, 19c.
• Should be able to help in finding current issues and provide solutions to improve performance.
• Working knowledge of Linux Redhat, File System, Cluster Management and Oracle ASMC and 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.
• Ensure weekend activities complete successfully through assignment, coordination, oversight and validation. This may requires weekend work.
• Experience with Oracle Golden Gate 12c/19c implementation and support will be an added advantage.
• Respond to customer requests regarding outages, performance degradation and project status.
• Maintain flexible work schedules, which may include evenings, weekends or holidays to work on deployments or regularly scheduled maintenance.
• Resolve customer technical issues through diligent research, reproduction and troubleshooting.
• Document all technical inquiries, develop and review content for knowledgebase using tool set.
• Work directly with other team members to resolve problems in a timely manner.
• Develop work schedules and project plans in support of various App Dev requests.
• Maintain server, software, licenses and other inventories.
• Ensure weekend activities complete successfully through assignment, coordination, oversight and validation and Checkout.

• Engineering Graduate with 15+ years of working experience.
• Experience with Oracle RDBMS & Golden Gate 11g/12c/19c on RHEL 7.
• Oracle 11g, 12c, RHEL, 5 RHEL7, GoldenGate 12.3, 19c, MySQL, PostgreSQL, Sybase, MS SQL Server, AWS, UDeploy, TPAM, CyberArk, Autosys,Shell scripting, PL/SQL, T-SQL.
• Familiarity with project management tools and /or software packages.
• Demonstrated leadership in completing individual tasks and a team player.
• Experience working in a team-oriented, collaborative environment.
• Rapidly adapt and respond to changes in environment and priorities.
• Excellent communication, including listening skills, leadership, problem solving and analytical skills.
• Ability to elicit cooperation from senior management and other departments.
• Flexibility with working schedule, changing priorities and tight deadlines.
• Ability to work on many tasks simultaneously in a high-pressure environment.
• Good working knowledge of Networking.

• Experience with Sybase MS SQL Server, MySQL, PGSql is a plus.
• Experience with CyberArk, UDeploy, Autosys, SNOW is a plus.
• Experience with NO SQL DB is a plus.
• Experience working within an Enterprise IT Support environment.