Database Administrator, Senior

Requirements

• Database Concepts, Networking Hardware, Relational Database, Technical Support Certifications:
• None Experience:
• 7 + years of related experience US Citizenship Required:
• Yes
• Job Description:
• Essential Duties and Responsibilities:
• Resolve complex issues involving database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology.
• Perform testing, analysis, and modification of existing database SQL stored procedures.
• Evaluate, refine, and tune existing Oracle objects in support of application. Install, upgrade, patch, secure, diagnose system problems, user accessibility, and troubleshoot Oracle Database versions 12.2 through 19.26.
• Digest onsite concepts, design, implementation, limitations, and configuration of complex database environments.
• Ability to define, troubleshoot, document, and escalate issues as needed. Work closely with application development team to implement and support data-oriented development efforts.
• Work closely with support center to expeditiously resolve issues or problems as they arise.
• Assist with analysis and documentation of user requirements.
• Implement system security patches & Security Technical Implementation Guides (STIGs).
• Maintain electronic repository of all database baseline, changes, and documentation.
• Research and recommend solutions that best meet program needs and operational requirements.
• Work alongside senior application development managers to gather business rules and requirements.
• Evaluate existing database structures and propose solutions to enhance efficiency while maintaining date integrity.
• Create database schemas and objects such as tables, columns, triggers, stored procedures, scheduled jobs etc.
• Create database models based on current and future requirements outlined from customer.
• Evaluate, review, revise, and integrate database change requests.
• Utilize tools such as Visual Studio, Toad Data Modeler, SQLPLUS, Team Foundation Server, Azure Devops, Jira, and Solarwinds Helpdesk.
• Required Knowledge, Skills, and Abilities:
• Robust experience administering Oracle Database Enterprise Editions.
• Advanced degree of analytical ability. Advanced skills in problem solving.
• Skillful time management and organizational skills to set and meet deadlines.
• Ability to work both independently and within a team.
• Strong understanding of Oracle Data Guard Replication and Recovery Manager. Experience with Linux and Windows based operating systems administration and troubleshooting.
• Extensive knowledge of relational database concepts; Database Modeling, Design and Database Creation.
• Demonstrated proficiency in creating database schemas and objects pursuant to current oracle database industry standards and best practices.
• Ability to create, clone, plug and unplug pluggable databases in a multitenant environment.
• Experience working with programming languages such as SQL, PL/SQL, Shell Scripts, and Batch Scripts.
• Proven troubleshooting and problem-solving skills for critical database, application, network, and system administration issues.
• Ability to work efficiently under pressure and with a high degree of independence.
• Critical thinking skills, ability to accurately analyze information and make sound decisions.
• Strong knowledge of Oracle Database best practices, concepts, and technologies.
• Must be versatile, flexible, and proactive when resolving technical issues. Ability to handle diverse situations and rapidly changing priorities with deadlines.
• Graduate comprehension and understanding of the Open Systems Interconnection (OSI) model.
• Ability to demonstrate relational database constructs leveraging primary and foreign keys, check constraints, and creation of objects via command line.
• Preferred Knowledge, Skills, and Abilities:
• Positive experience in database administration with at least 7 years in a junior to mid-level position.
• Experience installing, configuring, and troubleshooting Oracle 19c software. Exposure to other RDBMS systems such as MSSQL and PostgreSQL is a plus.
• Bachelor's degree in a related field, such as Computer Science, Data Processing, Information Systems, or equivalent experience.
• Exp

Benefits

Additional Information

Type of Requisition: Regular Clearance Level Must Currently Possess: Secret Clearance Level Must Be Able to Obtain: Top Secret Public Trust/Other Required: None Job Family: IT Infrastructure and Operations Job Qualifications:

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at General Dynamics IT? Share your experience