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

Chelsea Phillips Real Estate Group

Real Estate Sales Manager Job at Chelsea Phillips Real Estate Group

 ...building scalable systems, and driving results? Do you believe real estate is more than transactions its about transforming lives through...  ....Chelsea Phillips Real Estate Group is hiring a Sales Manager to lead our fast-growing team in the heart of Savannah. We're... 

Freedom Outdoor Solutions

Construction Worker Job at Freedom Outdoor Solutions

 ...demonstrate the ability to follow instructions and work collaboratively within a team setting -Have your own vehicle -Previous experience in construction is preferred but not required. We are willing to train. Duties Assist in running materials Digging fence... 

United Placement Group

Attorney - Estate Planning - Flexible and Remote in ME Job at United Placement Group

 ...Estate Planning Attorney Grow Your Practice with Pre-Qualified Clients & Full Back-Office Support IMPORTANT: Applicants must be actively licensed and in good standing in the state(s) where they wish to practice. Tired of chasing leads or managing back-office... 

Lensa

Office Assistant 1 (Veterans' Home at St. Albans) (NY HELPS) Job at Lensa

 ...Civil Service, is seeking professionals in Jamaica, NY. Apply via Lensa today! NY HELP Yes Agency Health, Department of Title Office Assistant 1 (Veterans' Home at St. Albans) (NY HELPS) - 30846 Occupational Category Clerical, Secretarial, Office Aide Salary... 

Thompson Wealth Management

Digital Marketing Manager Job at Thompson Wealth Management

 ...Digital Marketing Manager Thompson Wealth Management and Federal Retirement Services Scottsdale, Arizona About Us: Thompson Wealth Management and Federal Retirement Services is a leading wealth management firm specializing in retirement planning and wealth...