Location
Philadelphia, PA | United States
Job description
Job Summary:
As an Oracle Database Administrator (DBA) within our organization, your crucial role encompasses the comprehensive management of our Oracle database systems, ensuring optimal performance, high availability, and stringent security. You will work in close collaboration with our development team, providing expert guidance on database migrations, backups, and recovery operations. Your responsibilities include proactive monitoring and performance tuning, executing complex database migrations, and developing robust backup and disaster recovery strategies. Your expertise will not only support the direct management of database infrastructure but also contribute to the planning and implementation of best practices for data management, aligning with the organization's technological and business objectives. This position demands a proactive, innovative individual who thrives in a collaborative environment, ensuring our data assets are effectively protected, managed, and leveraged to drive success.
Responsibilities:
- Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
- Plan and execute upgrades of the Oracle database and application tools. Allocate system storage and plan future storage requirements for the database system.
- Assist in the design of database structures, data storage, data flows, and data retrievals to ensure high levels of data availability and security.
- Implement data models and database designs, data access, and table maintenance codes; resolve Oracle database capacity issues, replication, and other distributed data issues.
- Monitor and optimize the performance of the database through tuning, resource allocation, and database analysis.
- Conduct regular system audits to prevent unauthorized access.
- Diagnose and troubleshoot database errors; recommend and implement improvements to ensure system reliability and performance.
- Implement and maintain database security strategies that include user role management, privilege controls, and audit logging to protect sensitive data.
- Develop policies for data encryption, secure data access, and session management to comply with legal and regulatory standards.
- Design and manage backup and disaster recovery plans and procedures to ensure data integrity and availability.
- Perform regular backup tests to ensure recovery procedures are effective. Manage and configure backup solutions and ensure data recovery and redundancy plans are in place.
- Ensure data integrity by performing regular database maintenance tasks such as defragmenting, checking for corrupt data, and managing data replication processes.
- Implement mechanisms for high availability, such as Oracle Real Application Clusters (RAC), Data Guard, or other clustering technologies to minimize downtime and maintain business continuity.
- Regularly apply patches and updates to the Oracle database software to protect against vulnerabilities.
- Manage version control of database schemas and ensure smooth migrations between different database versions and platforms.
- Act as a liaison with Oracle Corporation for technical support when necessary.
- Provide consultancy services to development teams regarding database practices, query optimization, and efficient data management.
- Collaborate with IT security teams to ensure that the database environment adheres to the organization's security policies and guidelines.
- Monitor and analyze database usage and growth trends. Plan for hardware and software upgrades to ensure that the database infrastructure scales in line with application demands and data growth.
- Develop and maintain comprehensive documentation for database environments, including data standards, procedures, and definitions for the data dictionary (metadata).
- Establish and maintain security and integrity controls. Formulate policies, procedures, and standards relating to database management, and monitor compliance.
Requirements:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Proven working experience as an Oracle DBA.
- Hands-on experience with database standards and end user applications.
- Excellent knowledge of data backup, recovery, security, integrity, and SQL.
- Familiarity with database design, documentation, and coding.
- Previous experience with DBA case tools (frontend/backend) and third party tools.
- Familiarity with programming languages API.
- Problem solving skills and ability to think algorithmically.
- Oracle certification (OCP, OCA) is a plus.
Oscar Associates Limited (US) is acting as an Employment Agency in relation to this vacancy.
Report this job
- Dice Id: 10525742
- Position Id: PW1222-368
Job tags
Salary