Oracle9i PostgreSQL Administrator (Jobs in Nashville, TN)   Requirement id 149989 Job title Administrator Job location in Nashville, TN Skills required Oracel Database, Oracle11g/12c (With One Or More Of These Versions), Oracle 9i, PostgreSQL Open Date 14-Oct-2024 Close Date Job type Contract Duration 7 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Administrator: Oracel Database, Oracle11g/12c (With One Or More Of These Versions), Oracle 9i, PostgreSQL No of Submissions : 2 Start date : 10/14/2024 End Date : 04/30/2025 Submission deadline : 10/18/2024 Client Info : TN DHS Note: * Position Location : Remote Description : We are looking for senior-level database administrator with advanced expertise in both Oracle and PostgreSQL, along with a deep understanding of database architectures, security principles, and performance tuning methodologies. The candidate should also have strong problem-solving skills, attention to detail, and the ability to work under pressure while managing multiple complex database systems. The candidate must also be willing to participate in a rotational 24x7 on-call Production Support. 1. Database Installation and Configuration · Install, configure, and maintain Oracle Multi-Tenant Architecture and PostgreSQL database servers. · Set up instances, database parameters, and schema objects. · Perform upgrades and patch management to ensure databases are up-to-date with the latest features and security patches. · Experience Red Hat Linux Operating Systems. 2. Database Architecture and Design · Collaborate with development teams to design and implement efficient, scalable database solutions. · Create database structures, including tables, views, indexes, and constraints. · Define data storage, indexing strategies, and partitioning schemes for optimal performance. 3. Database Performance Monitoring and Tuning · Monitor database performance and system resource utilization to ensure high availability. · Identify bottlenecks, analyze slow queries, and tune databases for optimal performance. · Utilize tools like Oracle AWR, PostgreSQL pg_stat_statements, and other performance analysis tools. · Implement performance improvements such as indexing, query optimization, and caching mechanisms. 4. Backup and Recovery · Implement and manage backup and disaster recovery strategies (e.g., RMAN for Oracle, pg_dump for PostgreSQL). · Ensure data integrity and availability through regular backups and replication. · Perform recovery tasks in the event of database corruption or failure. 5. Security Management · Configure and maintain database security, ensuring appropriate user permissions and roles are in place. · Encrypt sensitive data, ensure secure connections, and apply security best practices. · Monitor for potential security threats and resolve vulnerabilities in both Oracle and PostgreSQL environments. 6. Capacity Planning and Scalability · Analyze and forecast future database storage requirements. · Plan for scalability, ensuring the databases can handle increasing workloads and data growth. · Optimize database storage and processing capabilities, balancing performance with cost. 7. Data Migration and Integration · Perform data migrations between Oracle, PostgreSQL, and other databases. · Develop and manage ETL (Extract, Transform, Load) processes for data movement and transformation. · Ensure data consistency and integrity during migration and integration efforts. 8. High Availability and Clustering · Implement and manage high availability solutions such as Oracle Data Guard Replication, RAC and PostgreSQL streaming replication or clustering. · Configure failover mechanisms to minimize downtime in case of hardware or software failure. 9. Database Troub   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 149989 while calling.   Other jobs in TN: Franklin (1), Nashville (6),    Oracel Database job openings in other states Jobs List NC FAST Senior Data Engineer (743008) Create date: 30-Jul-2024 Hybrid No of Submissions : 1 start date :08/12/2024 End date :08/08/2025 submission deadline : 08/06/2024 client info : NCDHHS-NCFAST Note: * Agency Interview Type: Either Webcam Interview or In Person * DHHS-ITD requires the services of Specialists in the ro.... (This job is for - job Jobs in NC Durham Engineer - (in Durham, NC)) Database Administrator 5 - 129546 Create date: 18-Apr-2024 No of Submissions : 1 Start date : 05/20/2024 End date : 1 Years from projected start date Submission deadline : 4/26/24 at 10am EST Client info : LARA Note : * Interview Process: Round 1 will be a virtual interview via MS Teams video. Round 2 may be held in-person. Candidates m.... (This job is for - RAC OEM Jobs in MI Lansing Administrator - (in Lansing, MI)) NC FAST DevOps Lead (710441) Create date: 24-May-2023 Hybrid Start date :06/05/2023 End Date :06/14/2024 Submission deadline :05/25/2023 Client Info :NCDHHS-NCFAST Description : ------------------------------------------------------ The NC Department of Health and Human Services seeks an experienced DevOps and Release process Lead for th.... (This job is for - DevOps Jobs in NC Durham TechLead - (in Durham, NC)) VDACS - Oracle BI Publisher (707612) Create date: 29-Mar-2023 start date : 04/10/2023 End date : 10/13/2023 submission deadline : 4/3/2023 client info : VDACS Note : * Hybrid Description : Oracle BI Publisher Report Writer that will convert Oracle Reports to BI Publisher Reports. .... (This job is for - job Jobs in VA Richmond Consultant - (in Richmond, VA)) .NET Web Developer II-114768-SP Create date: 28-Feb-2023 Start date : 03/27/2023 End Date : 06/30/2023 Submission deadline : 3/7/23 at 4:00PM CST. Client Info : DWD Note : * Interview Process: 30-minute online meeting with WebCam. * Duration of the Contract: 06/30/2023 with potential for 2-year extension. * Onsite or Remote? .... (This job is for - DB2 Jobs in WI Madison Developer - (in Madison, WI))     (Administrator: Oracel Database, Oracle11g/12c (With One Or More Of These Versions), Oracle 9i, PostgreSQL in Nashville, TN)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)