Oracle Database Administrator

The Oracle Database Administrator is a full performance technologist responsible for providing operational data management services to the City.  This responsibility includes functioning as an experienced professional able to understand and independently implement the standards of OITs Oracle practice. This position reports to the IT Director Data Management and receives guidance and direction from Principal Database Administrators.

Essential Functions

• Provides hands-on operational support to the Citys mission critical databases : Oracle SQL Server PostgreSQL.
• Contributes to the sustainability and ongoing support of the Oracle Enterprise Database Platform under the guidance of the Principal Oracle Database Administrator.
• Collaborates with the GIS team to ensure that their PostgreSQL databases are properly supported.
• Performs general Database Administration : DBMS software install database object management startup and stoppage patching and upgrade etc.
• Identifies performance issues and carries out Performance Tuning.
• Participate in database software products evaluation.
• Monitors database management systems (DBMS) and data reporting platforms across the Solution Deployment Life Cycle (Development Test Production) and insures that they perform within the expected service level.
• Participates in the collection of database operations metrics for reports and capacity planning.
• Execute the established database operation policies procedures and processes.
• Understand and execute the database security policies procedures and processes.
• Perform reliable backup and restore operations that meet the operations level requirements.
• Provisions DBMS user access in accordance with the established data management procedures and policies.
• Participates in the database operation cost accounting and budgeting process.
• Abides by the various data management compliance requirements : HIPAA Criminal Justice System IRS etc.
• Regularly communicates with the customer and address or escalate any identified dissatisfaction.
• Shares technical knowledge with the Database Management Group team.
• Participates in the review and approval of software solution architectures.
• Writes database and reporting systems operations automation scripts.
• Performs various data management operations and configurations : Data ETL(extraction transformation and load) data replication data profiling etc.
• Create and maintain documentation on architecture standards and processes

Competencies Knowledge Skills and Abilities

Ability to :

Knowledge Areas :

Qualifications : Education

Experience

Additional Information :

Salary : $75k-85k

Important : To be considered candidates must provide a cover letter and resume.

All applications should include the following :

A one-page cover letter clarifying your interest and qualifications for the role. It really helps us understand why youre interested in this position. We read every single one!

Your resume or curriculum vitae.

Optionally an online professional portfolio or public GitHub account.

We wont accept or review incomplete applications.

Work Setting : in-person (onsite)

Discover the Perks of Being a City of Philadelphia Employee :

We offer Comprehensive health coverage for employees and their eligible dependents

Our wellness program offers eligibility into the discounted medical plan

Employees receive paid vacation sick leave and holidays

Generous retirement savings options are available

Pay off your student loans faster - As a qualifying employer City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.

Enjoy a Free Commute on SEPTA - Starting September 1 2023 eligible City employees will no longer have to worry about paying for SEPTA public transportation. Whether youre a full-time part-time or provisional employee you can seize the opportunity to sign up for the SEPTA Key Advantage Program and receive free Key cards for free rides on SEPTA buses trains trolleys and regional rails.

Unlock Tuition Discounts and Scholarships - The City of Philadelphia has forged partnerships with over a dozen esteemed colleges and universities in the area ensuring that our employees have access to a wide range of tuition discounts and scholarships. Experience savings of 10% to 40% on your educational expenses extending not only to City employees but in some cases spouse and dependents too!

Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!

Effective May 22 2023 vaccinations are no longer required for new employees that work in non-medical non-emergency or patient facing positions with the City of Philadelphia. As a result only employees in positions providing services that are patient-facing medical care (ex : Nurses doctors emergency medical personnel) must be fully vaccinated.

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race ethnicity color sex sexual orientation gender identity religion national origin ancestry age disability marital status source of income familial status genetic information or domestic or sexual violence victim status. If you believe you were discriminated against call the Philadelphia Commission on Human Relations at or send an email to

Remote Work : No

Employment Type : Full-time

Key Skills

Children Activity,Cost Accounting,Feed,Corporate Strategy,ERP

Experience : years

Vacancy : 1