SQL&Oracle DBA

<div><h3>Responsibilities</h3><ul><li>Serve as Senior engineer for Microsoft SQL Server, Oracle and other database technologies.</li><li>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.</li><li>Actively participate in CAB meeting, DORM Calls, escalation calls, Improvement sessions</li><li>MS SQL production SQL Instance / database level performance tuning.</li><li>Understands SQL parameter/configuration files enhancement and deep tuning</li><li>Participates in SQL code-reviews for the application teams to enforce SQL coding standards.</li><li>Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.</li><li>Assist in the technical analysis and design for current and future projects.</li><li>Writes appropriate SQL scripts to extract data efficiently and in a timely manner.</li><li>Install database software/features on servers as needed.</li><li>Monitor databases for performance and issues using monitoring tools.</li><li>Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).</li><li>Working closely with Vendors and external support to provide stable environment</li><li>Architect and maintain Oracle RAC, Data Guard, ASM, and backup/restore strategies.</li><li>Lead performance tuning, patch management, and complex incident resolution.</li><li>Manage Oracle database lifecycle: provisioning, migration, upgrades.</li><li>Ensure high availability and replication readiness across DCs.</li><li>Ensure DB is maintaining at high level of consistency</li><li>Implement automation for routine tasks using Powershell/ T-SQL, PL/SQL scripting, Cron Jobs and SQL Jobs</li><li>Ensure NCA and NDMO compliance, secure data handling, and auditing.</li><li>Mentor L2 Oracle/SQL engineers and interface with solution architects.</li></ul><h3>Mandatory Skills</h3><ul><li>Bachelor's degree in a relevant field or equivalent combination of education and experience</li><li>Typically, 6+ years of relevant work experience in industry, with a minimum of 2+ years in a similar role</li><li>Advanced skills in Oracle 19c+, RAC, Data Guard, RMAN, OEM, SQL 2014, SQL2017, SQL2019, SSIS, SSRS</li><li>Expertise in SQL optimization and schema tuning, capacity tuning and database deep troubleshooting</li><li>Expertise in using combination of fine tuning tools: SQL Profiler, extended event, default trace, Windows performance counter</li><li>Have experience with Large database environment</li><li>Experience in hybrid cloud database setups</li><li>Knowledgeable with automation, reporting, automatic performance tuning</li><li>Strong knowledge of industry-standard database management practices and methodologies</li></ul><h3>Nice-to-Have Skills</h3><ul><li>Oracle Certified Professional (OCP)</li><li>Professional certification in database administration</li><li>Powershell</li><li>Windows&Unix administrations</li><li>ITIL</li></ul><p>About the company</p><p>DXC Technology</p></div>#J-18808-Ljbffr