Sr. Oracle DBA Job at Software Guidance & Assistance, Inc. (SGA, Inc.), Irving, TX

dzVuenNhWG1mRWZ4eUxuWGZKanZjQkF2dnc9PQ==
  • Software Guidance & Assistance, Inc. (SGA, Inc.)
  • Irving, TX

Job Description

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.

Job Tags

Weekend work,

Similar Jobs

Caldwell Electrical Contractors

Control Panel Designer Job at Caldwell Electrical Contractors

Caldwell Electrical Contractors, Inc is a Design/Build electrical & automation contractor actively seeking a highly talented Electrical Controls Designer to join our growing team. What we Offer: At Caldwell Electrical we believe in rewarding our employees for their...

Pyramid Consulting, Inc

PostgreSQL Database Administrator (DBA) Job at Pyramid Consulting, Inc

 ...Immediate need for a talented PostgreSQL Database Administrator (DBA) . This is a 12+months contract opportunity with long-term potential and is located in Plano, TX /Charlotte, NC (Hybrid). Please review the job description below and contact me ASAP if you are interested... 

Synergy Interactive

Senior Copywriter-Social Job at Synergy Interactive

 ...What you'll be doing: Connecting brands to real people in real-time Writing world-class work for a variety of clients across various industries including CPG, beverage/alcohol, QSR and casual dining, retail, and luxury automotive Collaborating with creative directors... 

OMNIVISION

Sr. ASIC Designer Job at OMNIVISION

Description Responsibilities: Design and implement module level micro-architecture Participate in top-level implementation and integration Participate in both top level and module level RTL coding, simulation, synthesis and timing closure Generate test cases...

The Planet Group

Construction Assistant Job at The Planet Group

 ...professionals during the critical planning phase of large-scale construction projects. You will be involved in developing budgets,...  ...Engineering, Architecture, or related field. ~25 years of experience in preconstruction, estimating, or related construction/engineering...