Live Jobs

Role

Roles in this Job Family design, solution, deploy, migrate, manage, and change infrastructure services, Responsible for the design, optimization, and advanced administration of Oracle and MS SQL database systems. This expert-level role oversees lifecycle management, automation, and DR readiness of Oracle environments supporting critical services.

Essential Job Functions:

? Serve as SME (subject matter expert) for Microsoft SQL Server, PostgreSQL and other database technologies.
? Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On.
? MS SQL production database level performance tuning.
? Participates in SQL code-reviews for the application teams to enforce SQL coding standards.
? Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.
? Assist in the technical analysis and design for current and future projects.
? Writes appropriate SQL scripts to extract data efficiently and in a timely manner.
? Install database software on servers as needed.
? Monitor databases for performance and issues using monitoring tools.
? Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
? Architect and maintain Oracle RAC, Data Guard, ASM, and backup/restore strategies.
? Lead performance tuning, patch management, and complex incident resolution.
? Manage Oracle database lifecycle: provisioning, migration, upgrades.
? Ensure high availability and replication readiness across DCs.
? Implement automation for routine tasks using Ansible or PL/SQL scripting.
? Ensure NCA and NDMO compliance, secure data handling, and auditing.
? Mentor L2 Oracle engineers and interface with solution architects.

Basic Qualifications:

? Bachelor's degree in a relevant field or equivalent combination of education and experience
? Typically, 6+ years of relevant work experience in industry, with a minimum of 2+ years in a similar role
? Advanced skills in Oracle 19c+, RAC, Data Guard, RMAN, OEM.
? Expertise in SQL optimization and schema tuning.
? Experience in hybrid cloud database setups.
? Knowledge of Ansible or Terraform for automation.
? Strong knowledge of industry-standard database management practices and methodologies.

Other Qualifications:

? An advanced degree in a relevant field is a plus
? Oracle Certified Professional (OCP)
? Professional certification in database administration

Halian Group:

With over 28 years of experience, we have come to understand that innovation is the only way to provide agile, practical solutions that transform businesses and careers.

Our resourcing and smart services help you to realize tomorrow’s potential. Discover the amazing things possible when you bring the right people and the right technologies together.

At Halian, we recognize that diversity, equity, and inclusion (DEI) are essential to building high-performing teams for our clients. We are committed to connecting organizations with top talent from all backgrounds, ensuring that every individual feels valued, respected, and empowered to contribute their unique perspectives. We encourage applications from all qualified candidates, regardless of race, gender, disability, or any other characteristic that makes them unique. By fostering diverse and inclusive workplaces, we help our clients drive innovation, enhance collaboration, and better reflect the communities they serve.

#LI-CA1