Professional Solutions Delivered - Charleston, SC
posted 4 months ago
Professional Solutions Delivered, LLC (ProSoDel) is seeking an Oracle Database Specialist to join our team in Charleston, SC. This role is critical in supporting our Oracle/Linux Opportunity, where you will be responsible for a variety of essential duties related to database management and application support. You will perform database and application regression testing on approximately 75 databases and 25-30 applications, ensuring that all systems are functioning optimally and securely. Your expertise will be vital in implementing DISA STIGs for around 100 Oracle Enterprise 8 instances, which is crucial for maintaining compliance and security standards. In this position, you will design and implement complex database architectures that prioritize high availability and performance. You will assess and develop long-term strategic goals for production databases in collaboration with data owners and department managers. Your responsibilities will also include installing and configuring new Oracle Database instances, planning and executing upgrades and migrations, and monitoring database performance to identify bottlenecks and implement necessary improvements. Tuning SQL queries and database parameters will be part of your daily tasks to optimize performance effectively. You will define and implement robust backup and recovery procedures, ensuring that regular backups, recoveries, and data refreshes are automated and performed as required. Security is paramount, and you will implement and maintain database security policies and procedures to ensure compliance with regulatory requirements for data safety and privacy. Managing schema changes, data migration, and transformation scripts will also fall under your purview, as will ensuring data integrity and quality across the database systems. As an Oracle Database Specialist, you will provide expert troubleshooting for complex database issues and offer technical support and guidance to development teams. You will analyze and predict future database resource requirements and scale database operations to meet the growing business needs. Additionally, you will develop and maintain scripts to automate common database administration tasks and document the database setup, architecture, and any changes applied. Maintaining updated documentation for data models and dictionaries is essential, as is providing expertise and training to junior database administrators and other technical staff. You will conduct knowledge-sharing sessions and workshops, collaborate with IT project managers and business analysts on project planning, delivery, and execution, and communicate effectively with the Program Manager to ensure that database capabilities and potential issues are known. Staying up-to-date with the latest Oracle technologies and best practices is crucial, as is evaluating and recommending new database technologies, tools, and features. This role may also involve performing related work as assigned.