Oracle Database Administrator

Since our inception in 2017, Graphite GTC has been on a mission to redefine the landscape of software development. Our groundbreaking No-Code development platform has transformed the way software is conceived and created, democratizing the process and making it accessible to all. Our mantra, "Better. Faster. Cheaper.â„¢" is not just a slogan; its the reality we deliver through our innovative platform.At Graphite GTC, we are not just a technology company; we are a beacon of innovation in the no-code application development sphere. Our vision is to provide equal access to cutting-edge technology for a diverse range of clients, from sprightly startups to established enterprises. We achieve this vision by moving away from traditional hand-coding methods and embracing a visually driven approach to application design, enabling anyone to craft sustainable, enterprise-class applications. Our proprietary software stands as a testament to our innovative spirit and technical prowess. This intellectual property has not only set us apart in the market but has also been the cornerstone of our service offerings. We have evolved into a full-service IT and consulting powerhouse, catering to an impressive roster of clients including the U.S. government, leading pharmaceutical companies, educational institutions, and giants in the construction and sustainability sectors.Our team is a melting pot of experienced professionals and vibrant technologists, all united by a shared passion for innovation. We foster a culture where humor meets humility, creativity intersects with collaboration, and where problem-solving happens at the speed of thought in our open, dynamic office environment. Graphite GTC stands today as a leader, not just in no-code application development, but as a full-fledged IT and consulting partner, trusted by some of the most prestigious organizations across various sectors.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 organizations 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 organizations 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.

Created: 2024-11-02