Senior Oracle Database Administrator

Graphite Gtc - Philadelphia, PA

Full-time

Philadelphia, PA

Publishing Industries

About the position

As an Oracle Database Administrator (DBA) at Graphite GTC, you will play a vital role in managing our Oracle database systems, ensuring their optimal performance, high availability, and security. This position involves close collaboration with the development team to provide expert guidance on database migrations, backups, and recovery operations. You will be responsible for proactive monitoring, performance tuning, and implementing best practices for data management, all aimed at aligning with the organization's technological and business objectives.

Responsibilities

• Install new versions of the Oracle RDBMS and its tools.
• 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.
• Implement data models and database designs, data access, and table maintenance codes.
• Monitor and optimize the performance of the database through tuning and resource allocation.
• Conduct regular system audits to prevent unauthorized access.
• Diagnose and troubleshoot database errors; recommend and implement improvements.
• Implement and maintain database security strategies including user role management and privilege controls.
• Develop policies for data encryption, secure data access, and session management.
• Design and manage backup and disaster recovery plans and procedures.
• Perform regular backup tests to ensure recovery procedures are effective.
• Manage and configure backup solutions and ensure data recovery plans are in place.
• Ensure data integrity by performing regular database maintenance tasks.
• Implement mechanisms for high availability, such as Oracle Real Application Clusters (RAC).
• Regularly apply patches and updates to the Oracle database software.
• Manage version control of database schemas and ensure smooth migrations.
• Act as a liaison with Oracle Corporation for technical support.
• Provide consultancy services to development teams regarding database practices.
• Collaborate with IT security teams to ensure compliance with security policies.
• Monitor and analyze database usage and growth trends.
• Plan for hardware and software upgrades to ensure scalability.
• Develop and maintain comprehensive documentation for database environments.
• Establish and maintain security and integrity controls.
• Formulate policies, procedures, and standards relating to database management.

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.

Nice-to-haves

• Oracle certification (OCP, OCA) is a plus.