Alpha Omega Integration, LLC
Sr. Oracle Database Administrator
Alpha Omega Integration, LLC, Kiln, Mississippi, United States, 39556
This is a job for a Sr. Oracle Database Administrator with a company located in the Kiln, MS area. Job Summary: The Senior Oracle Database Administrator is responsible for monitoring, troubleshooting, maintaining, reporting, and upgrading the Enterprise Oracle environment at NCEI. Responsibilities: Determine requirements for new relational and non-relational databases. Develop recommendations and solutions for new database initiatives. Controlling and monitoring user access to the databases. Monitoring and optimizing the performance of the databases. Determine, enforce, and document database policies, procedures. and standards. Troubleshoot Oracle database performance incidents and problems across Dev, Test, and Production environments. Perform database and software lifecycle activities to ensure highest level of system performance and availability and compliance with business requirements. Perform Oracle database and application server administration. Modify database structures, as necessary, from requirements and DDL provided by application developer teams. Perform backup, data integrity validation, and restoration activities related to databases using systems such as Oracle Recovery Manager (RMAN), Tivoli Storage Manager (TSM), and operating system scripts. Use high-speed transaction recovery techniques and recover from database backups. Ensure compliance with the Oracle license agreement. Identifying areas for improvement in the current systems. Ownership of Database tasks and deliverables in Project Plans. Perform requirements gathering, planning and execution of approved migration activities to other database platforms, including "cloud" platforms. Analyze data stored in the database and make recommendations relating to performance and efficiency as it relates to data storage. Develop and maintain documentation related to database technology. Qualifications: Bachelor's Degree or equivalent in Computer Science or related field; demonstrated relevant experience and skillsets will be considered. 8 years of experience in database administration and development primarily in Oracle, but also familiarity with other databases (PostgreSQL, MariaDB). Demonstrated problem-solving skills and ability to logically analyze complex processes and systems. Superior analytical and troubleshooting skills. Strong understanding of RDBMS concepts, principles, and security. Oracle experience should include: RMAN, partitioning, parallel query, performance tuning, Enterprise Manager, APEX and demonstrated fluency in SQL and PL/SQL. Strong working knowledge (6 recent years) of Linux OS System Administration. This includes in-depth knowledge and experience with troubleshooting and resolving incidents and problems through the shell (command line interface). Extensive experience (4 recent years) with Linux shell scripting (e.g. BASH, KSH, etc.) Write and debug complex Structured Query Language (SQL). Excellent verbal and written communication skills. Hands-on experience with database standards and end user applications. Excellent knowledge of data backup, recovery, security, and integrity. Proven experience with database design, documentation, and coding. Previous experience with database case tools, IDEs and CLIs. Familiarity with programming languages, libraries, and APIs. Problem solving skills and ability to think algorithmically. Experience with Git, GitLab. Strong bias toward action, delivery, and implementation. Equal Opportunity Employer minorities/females/veteran/other individuals with disabilities/sexual orientation/gender identity.