Sr. Oracle DBA

Software Guidance & Assistance, Inc., (SGA), is searching for a Sr. Oracle DBA for a direct placement assignment with one of our premier financial services clients in Irving, TX.

Responsibilities :

Responsible for providing Application Database support to the entire reference data applications for database & application enhancements.

Lead application database administration, architect resilient database solutions and performance tuning efforts.

Able to make changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages using CI/CD pipelines such as LightSpeed and promote them to higher environments (UAT, Production and Cob) following SDLC using Release on Demand.

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.

Should be able to help in finding current performance bottlenecks and provide solutions to improve performance

Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions.

Working 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.

Ensure weekend activities complete successfully through assignment, coordination, oversight and validation.

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.

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

Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding the firm, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Required Skills:

Bachelor's degree/University degree or equivalent experience

12+ years of relevant experience in Application DBA.

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

Leadership skills, Great communication, Team player, Ownership & Accountability.

Extensive experience in Application DBA, performance Tuning and GoldenGate implementation.

Experience in managing and implementing successful projects

Subject Matter Expert (SME) in at least one area of Applications Development

Ability to adjust priorities quickly as circumstances dictate

Demonstrated leadership and project management skills

Consistently demonstrates clear and concise written and verbal communication

Preferred Skills:

Master's degree preferred

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.