Oracle Database Administrator

Job Description

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 OIT’s 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 City’s 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:

• Learn, implement and operate enterprise class database management and reporting systems.
• Understand and execute the architecture and design of database management system solutions.
• Understand and execute data management and data security policies and procedures.
• Write database and reporting systems operations automation scripts.
• Work collaboratively
• Work independently
• Think systemically
• Make presentations
• Provide support to a customer base

Knowledge Areas:

• Conceptual grasp of Database Management systems, including Oracle, SQL Server and PostgreSQL
• Familiarity with data management principles and practice
• Experience with cloud based service offerings (GitHub, etc.)
• Operational Knowledge of Database Programming Languages
• General Knowledge of Software Programming (mastery of a programming language is a plus).
• Knowledge of ITSM/ITIL concepts and processes (Incident Management, Change Management, Problem Management, Release Management, etc.)
• Working Knowledge of Microsoft Office Products: Visio, PowerPoint, Excel, Word
• Knowledge of a database reporting software:  SSRS, Business Objects, Oracle BI, Power BI, etc. is a plus
• Knowledge of Data Warehousing Concepts is a plus.
• Knowledge of Information Security Concepts: Identity and Access Management, etc.
• Knowledge of Network Architecture concepts.

Qualifications

Education

• Completion of a Bachelor’s Degree program at an accredited college or university which has included a course in computer science, mathematics, business or equivalent.
• Completion of a Masters in Information Systems (MIS) is a plus

Experience

• 5 years in information technology and data management