• Database administration and optimization — own maintenance, patching, and upgrades across our database fleet; lead performance tuning, indexing strategy, and query optimization for mission-critical, high-throughput systems. • Reliability, backup, and recovery — design and own backup/recovery strategy, replication, and disaster recovery planning to guarantee stability and data integrity for payment processing workloads. • Infrastructure as Code — automate database provisioning and maintenance with Terraform, working within the same IaC practices as the rest of the infrastructure team. • Data migration and conversion — plan and execute complex data migration and conversion routines for production systems, verifying successful completion with minimal risk and downtime. • Monitoring and performance — build the dashboards, alerts, and monitors that surface database health and performance issues before they become incidents. • Technical leadership — mentor engineers on database best practices, provide expertise on deployment and architecture planning, and proactively communicate risks, issues, and next steps to the team.

Role Description As a Senior Database Administrator, you will be responsible for end-to-end administration of Oracle 19c clustered database platforms. Your responsibilities will include: - Managing all Oracle databases and applications. - Managing all database objects, tuning, cloning, patching, and replication. - Creating and maintaining all databases required for development, testing, pre-prod, and production usage. - Installing new versions of the Oracle database in cluster and standalone environments. - Planning and implementing backup and recovery of the Oracle database. - Planning and configuring Disaster Recovery environment using Data Guard, and performing Disaster Recovery tests. - Controlling migration of programs, database changes, and reference data changes through the development life cycle. - Implementing operational automation using Ansible and shell scripting. - Performing complex performance tuning and optimization for operational efficiency. - Utilizing tuning utilities and reports such as AWR, ASH, ADDM, SQLT, SQL Tuning Advisor, SQL tracing and analysis, and database event tracing. - Performing frequent database refreshes and migrations. - Enforcing and maintaining database constraints to ensure integrity of the database. - Administering all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures. - Discovering and implementing performance and uptime improvement strategies. - Assisting with impact analysis of any changes made to the database objects. - Leveraging Oracle expertise and knowledge by providing PLSQL tuning recommendations to developers. - Participating in 24/7 on-call rotation for various Production support & database maintenance activities. Qualifications - Bachelor’s Degree or higher in Information Systems, Computer Science, or work equivalent. - Proven 5 to 7 years of Oracle DBA experience. - A minimum of 5 years of database support and design experience and migration/upgrade experience with Oracle. - 3+ years of experience administering Oracle RAC environments. - Experience working with Oracle RAC cluster and 19c database, preferable with multi-tenant architecture. - Work experience with installing and supporting Golden Gate, and configuring GoldenGate to be used as a replication tool. - Experience in installation, configuration, and maintaining Oracle RAC in Virtualized (VM) environment. - Experience in building a DR database using DataGuard, and experience in planning and supporting Disaster Recovery testing. - Working knowledge of Cloud infrastructure such as AWS or OCI. - A good knowledge of LINUX and Windows operating system(s). - Experience in Ansible or similar configuration management tools is desirable. - Good knowledge of Oracle backup and recovery scenarios. - A good knowledge & experience in using and configuring OEM. - Experience and knowledge in migrating code, database changes, and data through the various stages of the development life cycle. Benefits - Health and dental insurance. - Meal and restaurant vouchers. - Fixed monthly stipend for internet and mobile expenses. - InComm hardware/software. - Annual bonuses. - All positions are CLT.

• Responsible for the planning, design, implementation, and maintenance of moderately complex database environments • Ensure that database environments are recoverable and secure • Plan for and monitor the capacity of the database environments • Monitor database and server performance; provide analysis and solutions to performance issues • Plan and execute change within the systems by following the policies and procedures as defined by Information Services • Proactively identify potential issues and conceptualize their solutions while providing direct technical support and problem resolution assistance for all database environments • Develop knowledge and professional skills through cross-training, literature, and attendance at department meetings and vendor education • Develop and maintain positive relationships, both internal and external to CCHMC • Motivate people and encourage teamwork • Prepare oral and written presentations • Conduct and participate in instructional seminars • Develop expertise in several Cincinnati Children's computer-based systems • Manage the design, development, and implementation of new and enhanced projects • Identify the appropriate resources needed to complete projects • Communicate between internal and external parties on project related issues and developments • Develop and maintain project plans • Work with cross functional teams • Consult with end user community to develop requirements for database solutions • Ensure outstanding end-user support is provided, including ongoing monitoring of Service Level Agreements for incident management and collaboration with other areas to ensure customer-centered incident management and support • Adhere to and promote continual adoption of change management policies and procedures • Model outstanding customer service behavior, including timely and effective follow-up with customers • Always maintain CCHMC'S service standards of being Courteous, Attentive, Respectful, Enthusiastic team members and Safe. (CARES) • Mentor and train other database administrators • Participate in the interview process • Provide consultation and assistance to customers and Information Services personnel • Adhere to IS departmental on-call and Service Desk policies and procedures • Perform other duties as assigned.

Role Description We do have a job opening for Database Administrator - Senior for our direct client Province of Ontario. The position details are given below: - Creates and implements physical database designs and operates and administers the database management system (DBMS) including: - Database optimization - Capacity planning - Installation and migration - Database design - Performance tuning - Backup and recovery - Maintain and monitor a number of Oracle 10g, 11g, 12c, 19c databases in large multi-tenant environments including: - Database administration - Maintenance - Optimization - Migration - Fine tuning of databases - Design, build and configure Oracle Database Servers on: - Windows - Solaris - Linux - Lead and design solutions for enterprise Oracle migration project to migrate to 19c or higher. - Carry out complex/specialized systems analysis and design for success of Oracle migration. Company Description