Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Sr Database Administrator For Teradata Operations Engineering

Expired Job

Expedia Bellevue , WA 98009

Posted 3 months ago

Expedia

The Sr. Database Administrator/ Teradata Systems Engineer will perform the duties of a Senior level DBA, responsible for all of the daily maintenance, monitoring, performance analysis, troubleshooting, problem resolution, and user assistance required for Teradata database environments. As a Sr. Engineer you will thrive in a dynamic work environment made up of a global team that provides the highest level of service possible to both our internal and external customers by building a stable, scalable, and secure enterprise Teradata database environment, completing service requests quickly, and dedicatedly searching out opportunities for improvement and customer satisfaction.

Responsibilities Include

  • Perform performance tuning on complex queries with efficiency of PI/SI indexes, Join Index, PPI, Using Explain plan for analysis using Teradata Explain & Visual Explain, data distribution among AMPs and index usage, collect statistics, revision of correlated sub queries, etc.

  • Analyze DBQL entries to look for long-running queries, high CPU & I/O usage, spool usage, noting accounts, assessing SQL for troubleshooting and recommendations

  • Responsible for planning software lifecycle projects to ensure database environments is supported

  • Properly identify required hardware, software, database configuration, and architecture necessary to support application for capacity planning. Provide expertise in planning and execution of hardware/software upgrades and expansion. Proficient in shell scripting, system tuning and troubleshooting on UNIX systems.

  • Work with Teradata and other vendors to ensure standard methodologies are followed and environment is optimized. Collaborate with internal systems, storage, networking, and application teams

  • Ensure recovery time and recovery point objectives are met

  • Work with business units to understand their application DBA needs and assist in crafting services to meet those needs

  • Perform 24x7 production support for Teradata environments and regulated systems (SOX, HIPAA, etc.) in a rotation with other support staff

Basic/Required

  • Bachelor's degree in Computer Science, Information Technology, MIS, or other related technical discipline

  • 7+ years as a Teradata DBA

  • 3+ years working with Teradata 2650, 2750, 6700, 1700 and BAR hardware including handling expansion and upgrade processes

  • Familiar with Teradata DBMS version 15.10 and experience upgrading from previous version(s)

  • 3+ years administering a multi-appliance Teradata production environment

  • Expert knowledge in operating Teradata client software on SUSE Linux and Windows environments and configuration of connections strings

  • Expert knowledge with Teradata View point, Teradata PDCR, setting the alerts, TASM implementation and changes to the workloads if necessary. As well as using PDCR to generate various performance and system related reports

  • Expert knowledge with DBA activities like Setup database, users, tables, views, macros, stored procedures, checking the tables skew, profiles, roles, grant/revoke permissions, space management and troubleshooting the job failures, data labs, knowledgeable with database recovery and restart procedures, database monitoring and periodic performance tuning

  • Advanced knowledge in monitoring and maintaining a production Teradata environment

  • 3+ years of experience with logging onto the Teradata nodes, running tools from the Supervisor screen such as PackDisk, CheckTable, ScanDisk and other diagnostic tools such as VProcManager on the Supervisor screen

  • 3+ years with backup management design, implementation, maintenance of backup policies and backup jobs, administration of cleanup and retention, setting up new backup jobs using TARA GUI, moving data from one Teradata system to another using named pipe arc or Datamover

  • 1+ year working directly with Teradata GSC in resolving RDBMS related incidents

  • 1+ year hardware and software compression

Preferred

  • Teradata Certified Professional or Advanced Professional

  • Experience as both a Production and Application DBA, and completely knowledgeable on change control and system security procedures Experience supporting and implementing technology projects as the primary DBA in support of business initiatives

  • Demonstrated ability to integrate across technical teams to deliver successful technical solutions

  • Strong verbal and written communication skills and demonstrated ability to positively influence

  • Results oriented with strong problem solving and analytical skills

  • Self-motivated with a strong customer orientation

  • Inspires new ways of looking at problems, processes or solutions

  • Manages tasks to effectively and efficiently complete work responsibilities of self and others

  • Takes ownership of actions and follows through on commitments by courageously dealing with important problems, holding others accountable, and standing up for what is right

  • Delivers results through realistic planning to accomplish goals

  • Listens actively and invites dialogue to gain a shared understanding, then influences and acts to drive performance and achieve business goals

Expedia is committed to creating an inclusive work environment with a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. This employer participates in E-Verify. The employer will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) with information from each new employee's I-9 to confirm work authorization.


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Middleware / Database Administrator 4

Boeing

Posted 1 week ago

VIEW JOBS 12/5/2018 12:00:00 AM 2019-03-05T00:00 Boeing is seeking an experienced Middleware / Database Administrator (Level 4) to join our Data Solutions Strategy Technology & Tools team. This position is located in Bellevue, Washington. Job Responsibilities: * Develops, tests, implements and supports computing access management tools. * Leads activities to create, maintain, revise and troubleshoot computing accounts and access. * Supports computing security audits by evaluating reports and providing recommendations. * Analyzes metrics on activities related to account management. * Oversees the development and delivery of training on security and access requirements to support deployment of new applications. * Leads activities to document and maintain procedures for access administration and audit processes. Boeing is the world's largest aerospace company and leading manufacturer of commercial airplanes and defense, space and security systems. We are engineers and technicians. Skilled scientists and thinkers. Bold innovators and dreamers. Join us, and you can build something better for yourself, for our customers and for the world. Division CIO, Information & Analytics Relocation Assistance Available No. Relocation assistance is not a negotiable benefit. Qualifications Work Authorization Requirements: This position must meet Export Control compliance requirements, therefore a "US Person" as defined by 22 C.F.R. § 120.15 is required. "US Person" includes US Citizen, lawful permanent resident, refugee, or asylee. Basic Qualifications (Required Skills/Experience): * More than 5 years of experience in internet fundamentals related to web servers, internet security and other internet technologies * Experience with Oracle Internet Directory (OID) * Experience with WebLogic 11g and 12c versions * Experience in middleware and F5 load balancers * Experience performing problem diagnosis; performance tuning; capacity planning and configuration management Preferred Qualifications (Desired Skills/Experience): * Experience with an LDAP browser such as Oracle Directory Services Manager (ODSM) * Experience with Oracle Fusion Middleware Technology Stack * Experience with Oracle Access Manager (OAM) * Experience in a self-directed role and driving results * Experience with Cold Fusion Typical Education / Experience: Bachelor's degree and typically 10 or more years' related work experience, a Master's degree and typically 8 or more years' related work experience or an equivalent combination of education and experience. Experience Level Individual Contributor Job Type Standard Travel Yes, 10 % of the Time Contingent Upon Program Award No Union No Job Code BAUPP4 Boeing Bellevue WA

Sr Database Administrator For Teradata Operations Engineering

Expired Job

Expedia