Introduction:
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; it's the reality we deliver through our innovative platform.
At Graphite GTC, 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 agile startups to established enterprises. By moving away from traditional hand-coding methods and embracing a visually driven approach to application design, we enable 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 set us apart in the market and has 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 blend 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 problem-solving happens swiftly 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:
We are seeking a skilled Oracle Database Analyst to join our dynamic team in Philadelphia. This role is pivotal in managing and optimizing our Oracle database systems to enhance data-driven decision-making across the organization. You will be responsible for designing, implementing, and maintaining Oracle databases, ensuring they operate efficiently, securely, and align with business objectives. The ideal candidate will have a strong background in Oracle technologies, database administration, and data analysis, coupled with a keen understanding of business processes.
Key Responsibilities:
Database Design and Implementation:
- Design, develop, and maintain Oracle databases to support business applications and systems.
- Develop and manage database schemas, tables, views, indexes, triggers, and stored procedures.
- Ensure data models are scalable, efficient, and aligned with organizational requirements.
Database Performance and Optimization:
- Monitor database performance and conduct tuning activities to optimize efficiency and scalability.
- Implement best practices for database indexing, partitioning, and query optimization.
- Analyze system performance metrics and adjust configurations to enhance database operations.
Data Security and Compliance:
- Implement robust security measures to protect sensitive data within Oracle databases.
- Manage user access controls, roles, and permissions to ensure data confidentiality and integrity.
- Ensure compliance with data governance policies, industry regulations, and best practices such as GDPR and HIPAA.
Backup and Recovery:
- Develop and maintain backup and recovery plans to safeguard against data loss.
- Perform regular backups, restore testing, and disaster recovery planning.
- Ensure high availability and reliability of database systems.
Data Analysis and Reporting:
- Extract, analyze, and interpret complex data sets to provide actionable insights.
- Develop custom reports and dashboards using Oracle reporting tools to support business decision-making.
- Collaborate with stakeholders to understand data requirements and deliver tailored solutions.
System Integration and Support:
- Support integration of Oracle databases with other applications and platforms.
- Assist in the migration of legacy systems to Oracle platforms when necessary.
- Provide technical support and troubleshooting for database-related issues, ensuring minimal downtime.
Documentation and Collaboration:
- Document database configurations, procedures, and changes to maintain an up-to-date knowledge base.
- Collaborate with cross-functional teams, including IT, developers, and business analysts, to align database solutions with business needs.
- Provide training and support to end-users on Oracle database functionalities.
Continuous Improvement:
- Stay current with the latest Oracle technologies, updates, and industry trends.
- Recommend and implement improvements to enhance system performance and user experience.
- Participate in professional development opportunities and share knowledge within the team.
Required Skills and Experience:
Citizenship:
- Must be a U.S. citizen.
Education:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Experience:
- Minimum of 5 years of experience working with Oracle databases and related technologies.
- Proven experience in database design, development, administration, and performance tuning.
- Experience with data analysis, data warehousing, and business intelligence reporting.
Technical Skills:
- Strong proficiency in Oracle Database technologies, including SQL and PL/SQL programming.
- Familiarity with Oracle tools such as Oracle Enterprise Manager, Data Guard, and RMAN.
- Experience with Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
- Knowledge of data modeling techniques and ETL processes.
- Experience with Unix/Linux operating systems and scripting languages (e.g., Shell, Python).
- Familiarity with Oracle Cloud Infrastructure (OCI) and cloud-based database solutions is a plus.
Soft Skills:
- Excellent problem-solving and analytical skills with a high attention to detail.
- Strong communication skills, both written and verbal, with the ability to explain complex concepts clearly.
- Ability to work collaboratively in a team environment and manage multiple tasks simultaneously.
- Proactive approach with a commitment to continuous learning and improvement.
- Strong organizational and time-management skills.
Certifications (Preferred):
- Oracle Certified Professional (OCP) in Database Administration.