Wait, What Do You Do?

XPO India Shared Services<table class="MsoNormalTable" style="width:7.5in;border-collapse:collapse;border:none" border="1" cellspacing="0" cellpadding="0"> <tbody> <tr> <td style="width:3.75in;border:solid windowtext 1.0pt;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> Job Title: Database Administrator </td> <td style="width:3.75in;border:solid windowtext 1.0pt;border-left:none;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> Reports to: Sr Manager Database Architecture </td> </tr> <tr> <td style="width:3.75in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> Job Grade: Assigned by Comp. Job Code: Click here to enter Job Code. </td> <td style="width:3.75in;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> FLSA Status: Assigned by Comp. FLSA Category, if Exempt: Assigned by Comp. EEO Category: Assigned by Comp </td> </tr> <tr> <td style="width:3.75in;border-top:none;border-left:solid windowtext 1.0pt;border-bottom:double windowtext 1.5pt;border-right:solid windowtext 1.0pt;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> Prepared By: Click here to enter name. </td> <td style="width:3.75in;border-top:none;border-left:none;border-bottom:double windowtext 1.5pt;border-right:solid windowtext 1.0pt;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> Date Approved: Entered by Comp. Approved By: Entered by Comp. </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> GENERAL DESCRIPTION: If you love working with databases and interest in performance monitoring, tuning and stability; this role could be for you. The role requires working extensively with Oracle databases. This role provides focusing on SQL queries, plan review and database administration, The Database administrator is responsible for daily monitoring of SQLs performance, up-time. This role drives resolution to technical issues. </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> ESSENTIAL DUTIES AND RESPONSIBILITIES <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Candidate should have 3+ years of experience</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Monitor SQL performance and tuning (plan, baselines, profiles) 40%</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Develop PL/SQL Procedures/Packages and automation 20%</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Manage deployment of DDL/DMLs to the database 10%</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Familiar with CICD concepts 10%</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Assists application developers with SQL review 10%</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Database administrator activities needed for high availability 10%</li> </ul> </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> SUPERVISORY RESPONSIBILITIES: <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">This Job has no supervisory responsibilities but in special circumstances may lead the work of others</li> </ul> </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> DECISION-MAKING RESPONSIBILITIES: <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">This Job requires independent decision-making and recommendations within the context of assigned task, and work with application development team</li> </ul> </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> EDUCATION/EXPERIENCE: <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Bachelor’s degree required; Oracle Database certification preferred</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Expertise in Oracle technologies, OCI, Exadata experience, Familiarity with monitoring tools like OEM ( 2+ years )</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Strong proficiency with SQL, Oracle partitioning and knowledge of Oracle PL/SQL (2+ years)</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Linux, shell scripting required (1+ year)</li> </ul> </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> CERTIFICATES AND LICENSES (list special certifications/licenses that are required or desirable to perform this job): <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">N/A</li> </ul> </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> JOB RELATED COMPETENCIES: To perform the job successfully, an individual should demonstrate the following competencies: <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Analytical Skills - <ul style="list-style-type:circle;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Focus on data driven analysis for solutioning and problem solving.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Self-motivate, goal driven; Identifies opportunities to increase accuracy and optimize resources;</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Identifies and resolves problems.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Demonstrates attention to detail</li> </ul> </li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Communication Skills – <ul style="list-style-type:circle;margin-bottom:0.0in;margin-top:0.0px"> <li style="text-align:justify;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Strong verbal and written communication skills including presentation and active listening skills.</li> </ul> </li> </ul> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="list-style:none;text-align:justify;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif"> <ul style="list-style-type:circle;margin-bottom:0.0in;margin-top:0.0px"> <li style="text-align:justify;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Presents organized and thorough information and data appropriate for intended audience.</li> </ul> </li> </ul> <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Time Management Skills - </li> </ul> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="list-style:none;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif"> <ul style="list-style-type:circle;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Demonstrates follow-up skills.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Provides timely and professional support to all internal application team</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Prioritizes regular workload, tasks to ensure work is completed accurately and efficiently within established time frame.</li> </ul> </li> </ul> <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Other - <ul style="list-style-type:circle;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Self-motivated.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Team-oriented. Consults with Team members and management as needed to complete assigned responsibilities.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Works with minimal supervision.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Establishes and maintains effective, collaborative work relationships both internally and externally.</li> </ul> </li> </ul> </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> Technical Competencies / Computer Skills – <ul style="margin-top:0.0in;margin-bottom:0.0in" type="square"> <li style="color:black;text-align:justify;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:10.0pt;font-family:Calibri, sans-serif">Deep knowledge/experience in the following: SQL, PL/SQL, Oracle, Unix, DBA tasks.</li> <li style="color:black;text-align:justify;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:10.0pt;font-family:Calibri, sans-serif">Experience with monitoring tools like OEM and SQL Tuning</li> <li style="color:black;text-align:justify;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:10.0pt;font-family:Calibri, sans-serif">Data modeling skill and use of Entity-Relation (ER) tool is good to have.</li> <li style="color:black;text-align:justify;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:10.0pt;font-family:Calibri, sans-serif">MSSQL database administration ( good to have )</li> <li style="color:black;text-align:justify;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:10.0pt;font-family:Calibri, sans-serif">Keeps current with emerging trends and database technologies.</li> </ul> <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="list-style:none;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif"> <ul style="list-style-type:circle;margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Other Technical / Computer Skills - </li> </ul> </li> </ul> <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="list-style:none;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif"> <ul style="list-style-type:circle;margin-bottom:0.0in;margin-top:0.0px"> <li style="list-style:none;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif"> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Thorough knowledge of internal company software applications</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">High-level learning agility</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Passionate, self-motivated; works with a sense of urgency under minimal supervision within a fast-paced environment.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Maintains strict confidentiality, high integrity, and high reliability.</li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Ability to bring resolution to highly complex and stressful situations </li> </ul> </li> </ul> </li> </ul> </td> </tr> <tr> <td style="width:7.5in;border:solid windowtext 1.0pt;border-top:none;padding:0.0in 5.4pt 0.0in 5.4pt" colspan="2" valign="top"> WORK ENVIRONMENT & PHYSICAL DEMANDS- The Work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Hours of Work/Travel <ul style="list-style-type:square;margin-bottom:0.0in;margin-top:0.0px"> <li style="text-align:justify;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Extended hours including weekends (on-call).</li> <li style="text-align:justify;margin:0.0in 0.0in 0.0in 0.0px;font-size:10.0pt;font-family:Calibri, sans-serif">Hours cover early mornings, evenings and weekends.</li> </ul> </td> </tr> </tbody> </table> XPO is an Equal Employment Opportunity Employer (M/F/V/H)Be part of something big