V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
• 外包信息请发到 /go/outsourcing 节点。
• 不要把相同的信息发到不同的节点
ywencn
V2EX  ›  酷工作

[成都或远程] Abovegem 求数据库管理工程师(DBA) 20K-30K

  •  
  •   ywencn · 2018-07-05 11:34:50 +08:00 · 1468 次点击
    这是一个创建于 2363 天前的主题,其中的信息可能已经有所发展或是发生改变。
    The company: http://www.abovegem.com

    The Database Administrator is responsible for full life cycle support of client and internal database(s).

    The DBA works within an environment of rapid growth and must anticipate and respond effectively to needs as they emerge. This position is expected to design, develop, enhance and monitor all production and test databases that exist within the technical architecture.

    This individual will be working with development and customer support, providing technical and operational support activities of Amazon RDS instances and standalone database servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing.

    Duties and Responsibilities:

    Responsible for the monitoring and uptime of all production databases.
    Total ownership of postgres, mongo, redis databases.
    Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
    Provide logical and physical replication support for postgres to postgres or postgres to redshift.
    Responsible for developing, tuning and troubleshooting Amazon ’ s data migration services.
    Work with data engineers to develop data-centric solutions, provide development support such as query tuning, SQL development, environment setup, and debugging.
    Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
    Develop Stored Procedures and Database Triggers in support of application development, if needed.
    Participate in application development projects and be responsible for the database architecture and design.
    Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
    Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
    Responsible for regular backups and recovery of databases.
    Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
    Responsible for pro-active remediation of database operational problems.
    Responsible for Query tuning and preventative maintenance.
    Support complex web-based applications.
    Perform other duties as assigned.
    Qualifications


    4-7 years of relevant experience.
    PostgreSQL experience required.
    Must have strong analytical, verbal and written communication skills.
    Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
    Must have strong knowledge of Linux.
    Strong understanding of command line and server administration.
    Knowledge of shell scripting (e.g., Bash, Perl).
    B.S. in Computer Science, Mathematics, or Engineering or equivalent work experience.

    Education: Bachelor ’ s degree minimu
    Experience: Minimum 4 years of experience
    Local Preferred: Yes

    Salary: full time 20k to 30k depends qualification

    Please send resume to: dachuan.yang@abovegem.com
    2 条回复    2018-07-06 08:21:03 +08:00
    yanginfor
        1
    yanginfor  
       2018-07-05 14:07:37 +08:00 via iPhone
    Databases come and go, MySQL is forever
    shenyangno1
        2
    shenyangno1  
       2018-07-06 08:21:03 +08:00 via iPhone
    @yanginfor Big brother six six six!
    关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   1008 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 20:49 · PVG 04:49 · LAX 12:49 · JFK 15:49
    Developed with CodeLauncher
    ♥ Do have faith in what you're doing.