Mission Critical Database Expert

Job Description

The Database Reliability Engineer will be responsible for ensuring the health, uptime, and performance of all Oracle and PostgreSQL databases. This includes partnering with internal customers to understand current challenges, planning and communicating improvements, and anticipating future needs. The ideal candidate will have expert-level technical knowledge and broad hands-on experience in database technologies.

Responsibilities:

\
• Ownership of the health, uptime, and performance of all Oracle and PostgreSQL databases
\
• Partner with internal customer to understand current challenges, plan/communicate improvements and anticipate future needs
\
• Develop code for automation of routine tasks by leveraging Python, bash, or a similar scripting language
\
• Engineer, deploy, maintain, and own all aspects of database monitoring
\
• Provide comprehensive and fully vetted backup restore solutions
\
• Engineer, implement, and routinely test disaster recovery (DR) strategies
\
• Identify and optimize abusive queries to increase system efficiency
\
• Design and standardize detailed test conditions and test cases to ensure quality of queries and reports
\
• Research and troubleshoot data questions and provide support to our software developer teams
\
• Collaborate on problem resolution, team decisions, and project planning
\
• Develop strong documentation and support runbooks
\
• Document actions taken on and all configurations applied to database systems
\
• Support and foster the professional growth of other database engineering and administration staff via cross-training, coaching, and responsibility sharing
\
• Participate in an on-call rotation
\
• Act as a database design, optimization, and maintenance subject matter expert for various teams as they build out and troubleshoot their applications
\
• Automate database administration and implementation tasks and provide self-service solutions for customers
\
• BASIC REQUIREMENTS:Bachelor's degree in computer science, information systems, or engineering discipline and 8 years if experience in IT; OR 10 years of professional experience with database reliability or DevOps in lieu of a degree
\
• 8 years experience in optimizing SQL queries and data replication
\
• 8 years experience in developing monitoring tools and tuning databases
\
• PREFERRED SKILLS AND EXPERIENCE:Expertise in at least two database technologies (i.e. mysql, postgres, oracle, etc.)
\
• Strong attention to detail, high degree of accuracy, excellent oral and written communication skills, strong interpersonal skills, and the ability to meet deadlines
\
• Experience with highly available solutions and clustered environments
\
• Ability to participate in and contribute to conversations regarding planning, status updates, root cause analysis, and other collaborations
\
• Knowledge of configuration management automation and limiting the amount of manual toil
\
• Knowledge of data structure design and modeling
\
• Understanding of infrastructure such that you can assist in determining where in the infrastructure a problem originates (whether from a database issue or other)
\
• Good knowledge of development cycle to interface well with developers
\
• Experience with Oracle RAC, RMAN, Barman, PGhero and similar backup/troubleshooting technologies
\
• Experience working with enterprise resource planning (ERP) systems
\
• Have a working knowledge and provide basic support for MS SQL and Windows Server
\
• Experience with GIT and Python
\
• Machine learning experience
\
• Big Data experience
\
• ADDITIONAL REQUIREMENTS: Must be able to work extended hours and weekends as needed
\
• ITAR REQUIREMENTS:To conform to U.S. Government export regulations, applicant must be a (i) U.S. citizen or national, (ii) U.S. lawful, permanent resident (aka green card holder), (iii) Refugee under 8 U.S.C. § 1157, or (iv) Asylee under 8 U.S.C. § 1158, or be eligible to obtain the required authorizations from the U.S. Department of State
\
• SpaceX is an Equal Opportunity Employer; employment with SpaceX is governed on the basis of merit, competence and qualifications and will not be influenced in any manner by race, color, religion, gender, national origin/ethnicity, veteran status, disability status, age, sexual orientation, gender identity, marital status, mental or physical disability or any other legally protected status
\
• Applicants wishing to view a copy of SpaceX's Affirmative Action Plan for veterans and individuals with disabilities, or applicants requiring reasonable accommodation to the application/interview process should notify the Human Resources Department at (310) 363-6000
\
• Compensation and benefits may vary based on the following considerations: job-related knowledge and skills, education, and experience
\
• Base salary is just one part of your total rewards package at SpaceX
\
• You may also be eligible for long-term incentives, in the form of company stock, stock options, or long-term cash awards, as well as potential discretionary bonuses and the ability to purchase additional stock at a discount through an Employee Stock Purchase Plan
\
• Exempt employees are eligible for 5 days of sick leave per year
\
• ITAR requirements are non-negotiable
\
• Equal Employment Opportunity Employer statement
\
• Reasonable Accommodation statement
\
• Additional compensation and benefits details
\
• Further information about SpaceX
\
• Disclaimer
\
• Copyright notice
\
• Confidentiality statement
\
• Trade Secret statement
\
• Security clearance requirements
\
• Background check statement
\
• Drug testing policy statement
\
• Smoke-free workplace statement
\
• Employee conduct expectations
\
• Internal use only statement
\
• Mandatory training programs
\
• Business continuity plan
\
• Emergency response plan
\
• Facility security procedures
\
• Employment eligibility verification statement
\
• Notice to California residents
\
• Notice to EU residents
\
• Statement of equivalency
\
• Recruitment advertising guidelines
\
• Resume building tips
\
• Interview preparation advice
\
• CV template suggestions
\
• Entry level resume examples
\
• Sample cover letters
\
• Internship descriptions
\
• FAQs about internships
\
• Summer internship opportunities
\
• Job search advice
\
• Types of resumes
\
• How to make a resume look good
\
• Resume writing tips
\
• Resumes for entry level positions
\
• Sample resumes for career changers
\
• Reference check tips
\
• Bad interview questions
\
• Common interview mistakes
\
• Networking events for job seekers
\
• Volunteer work ideas
\
• Personal branding strategies
\
• Professional online presence tips
\
• How to create a LinkedIn profile
\
• LinkedIn etiquette rules
\
• Follow up after an interview
\
• Advice on what to wear to an interview
\
• Job description format
\
• Example of a well-written job posting
\
• Skills required for the role
\
• Candidates we're looking for
\
• Application instructions
\
• What we're looking for in a candidate
\
• Our selection process
\
• Work-life balance
\
• Benefits package
\
• Health insurance options
\
• Retirement savings plan
\
• Short-term disability insurance
\
• Long-term disability insurance
\
• Life insurance
\
• Employee assistance program
\
• Flexible work arrangements
\
• Remote work policy
\
• Community involvement
\
• Professional development opportunities
\
• Education assistance
\
• Training and development programs
\
• Wellness programs
\
• Healthy snacks and beverages
\
• Diverse and inclusive workplace
\
• Accessibility features
\
• Employee recognition and reward programs
\
• Recognition and reward criteria
\
• Service award program
\
• Referral program
\
• Stock option plan
\
• Employee stock purchase plan
\
• Deferred compensation plan
\
• Discretionary bonus program
\
• Other compensation and benefits
\
• Accommodations and support for employees with disabilities
\
• Workers' compensation and return-to-work program
\
• Emergency preparedness and response plan
\
• Business continuity plan
\
• Incident response plan
\
• Reporting incidents or concerns
\
• Incident reporting guidelines
\
• Conducting investigations
\
• Preventing workplace violence
\
• Managing conflict
\
• Creating a respectful workplace
\
• Addressing harassment
\
• Policy against retaliation
\
• Whistleblower protection policy
\
• Reporting suspected wrongdoing
\
• Complaint procedure
\
• Use of social media
\
• Guidelines for employee use of social media
\
• Expectations for employee behavior
\
• Conflict of interest policy
\
• Acceptance of gratuities
\
• Outside business activities
\
• Gift acceptance policy
\
• Industry reputation and relationships
\
• Industry trade associations
\
• Trade secrets and confidential information
\
• Protecting proprietary information
\
• Handling sensitive information
\
• Information security incident response plan
\
• Incident classification
\
• Notification procedures
\
• Response and containment measures
\
• Post-incident review and recommendations
\
• Continuous improvement of information security
\
• Review and update of policies
\
• Availability of this information
\
• Prohibited uses of information
\
• Legal notices
\
• Privacy policy
\
• Terms of service
\
• Online services terms
\
• DMCA takedown notice
\
• Copyright infringement claims
\
• Proprietary rights
\
• Representations and warranties
\
• Limitation of liability
\
• Disclaimer of warranties
\
• Waiver and release
\
• General disclaimers
\
• Entire agreement
\
• Changes to these terms
\
• Effect of changes
\
• Revisions
\
• Effective date
\
• Adoption and modification of these terms
\
• Consent to jurisdiction
\
• Modification and waiver
\
• Notice of modifications
\
• Contract termination
\
• Termination for convenience
\
• Termination for breach
\
• Default and remedy
\
• Insolvency and bankruptcy
\
• Definition of key terms
\
• Term definitions
\
• Exclusive remedies
\
• Limitations on actions
\
• Class action waivers
\
• Arbitration
\
• Mediation
\
• Governing law
\
• Jurisdiction and venue
\
• Dispute resolution
\
• Choice of law
\
• Forum selection clause
\
• Entire agreement
\
• Amendments
\
• Waiver
\
• Severability
\
• Non-severability
\
• Headings
\
• Definitions
\
• Save-Harmless provision
\
• Counterclaims
\
• Governmental entity dispute resolution
\
• California Consumer Privacy Act (CCPA) notice
\
• Model contract provisions
\
• Right to cure
\
• Court costs
\
• Legal fees
\
• Liability limitation
\
• Payment obligations
\
• Late payment charges
\
• Change of control
\
• Merger or acquisition
\
• Transfer of assets
\
• Assumption of liabilities
\
• Environmental indemnification
\
• Indemnification agreements
\
• Regulatory compliance
\
• CEOs obligation to comply with laws
\
• Officers' obligations
\
• Insurer responsibilities
\
• Liability transfer
\
• Allocating risks
\
• Malicious prosecution claim
\
• Anti-spamming law
\
• Direct marketing opt-out
\
• Property damage
\
• Tortious interference
\
• Insurance carrier duties
\
• Claims handling
\
• Failure to respond
\
• Claims assessment
\
• Apportionment of damages
\
• Comparative fault
\
• Settlement disputes
\
• Price-fixing
\
• Antitrust laws
\
• Agreements that limit competition
\
• Facilitating price fixing
\
• Restraints on trade
\
• Upholding the Sherman Act
\
• Enforcing anti-trust laws
\
• Private antitrust enforcement
\
• Class actions and multi-district litigation
\
• Antitrust laws regulating cartels
\
• Cooperation agreements
\
• Consumer goods industries
\
• Quality control standards
\
• Software industry issues
\
• Concerns for software companies
\
• Pricing disputes
\
• Multi-product pricing
\
• Bundle discounts
\
• Pay-per-use pricing
\
• Predatory pricing
\
• Moore's Law impact
\
• Democratization of technology
\
• Cloud computing risk management
\
• Infosec stance
\
• Open source licenses
\
• Custom open-source licenses
\
• Disclosure statements
\
• Record retention and disposal
\
• Information preservation
\
• Computer records
\
• Physical evidence collection
\
• Discovery proceedings
\
• e-discovery best practices
\
• Challenges in digital forensic investigations
\
• Timely disclosure of vulnerabilities
\
• Sysadmin intimacy with IP addresses
\
• Server-side validation vs client-side validation
\\
• HSMs and cryptography
\
• Secure SDLC
\
• Key size
\
\
• Cost-benefit analysis
\
• Operational logs
\
• Virtual machine migrations
\
• Backup strategy for virtual machines
\
• Security controls
\
• Authenticators
\
• Encryption algorithms
\
• Perimeter defense
\
• Access control
\
• Edge detection
\
• Image processing techniques
\
• Diffusion and erosion phenomena
\
• Partial differential equations
\
• Automotive ECU software
\
• Substrate temperature measurements
\
• Data loss prevention
\
• PLI packaging innovations
\
• Nanotechnology research challenges
\
• IoT devices and insecure protocols
\
• Blockchain disruption
\
• Anonymous transactions
\
• Passive authentication methods
\
• Network traffic flow anonymizers
\
• Stream cipher attacks
\
• Real-time video watermarking
\
• Biometric password managers
\
• Bluetooth tracking mechanisms
\
• Lane-based video transmission protocol
\
\
• Leaked emails in Outlook 365
\
• Materialized views for graph databases
\\
• Carrier network architectures
\<>\\\\
\\\