• Senior DBA - PostgreSQL & Oracle

    Job Locations US-MA-Boston
    Posted Date 4 weeks ago(6/19/2018 12:38 PM)
    Job ID
    2018-1082
    # of Openings
    1
    Category
    Engineering
  • Job Description

    About us: Zillion exists to empower people in evolving behavior to a desired state through architecting human choice with support from digital and relevant human interaction. That is Zillion’s purpose. 

     

    Job Title: Sr. DBA 

     

    The Senior DBA will support in the design of strategies for enterprise database systems and set standards for operations, programming, and security in a SaaS product, assist in the design and construction of large relational databases, integrating new systems with existing applications and product and refine system performance and functionality.

     

    Responsibilities:

     

    Perform database development, monitoring, maintenance, reorganizations, resource management, schema management, and        capacity planning and performance tuning for PostgreSQL and Oracle.

     

    Analyzing Database logs for errors and performing routine table and index maintenance tasks. Resolving table and index level database corruption.

     

    Apply patches to fix bugs and/or enhance functionality as required and in conjunction with the company's procedures for change control.

     

    Good SQL scripts skills including SPs and PSQL scripting. Good Performance tuning skills. Configuration of SQL profiler, pgfouine and pgbadger to generate SQL trace and reports for performance tuning

     

    Good knowledge of disaster recovery principles and practices, including planning, testing and backup/recovery

     

    Work with application owners to support database consolidation, migration and virtualization.

     

    Work with developers and analysts to support development efforts which includes the use of Liquibase as a deployment technology.

     

    Work with various internal teams such as server, storage, backup & network administration teams to coordinate and troubleshoot infrastructure related issues.

     

    Strong understanding of PostgreSQL and Oracle database backup/recovery techniques and replication techniques in a production environment.

     

    Qualifications:

     

    • At least 5+ years of experience as senior/lead DBA/developer with design responsibilities in a large and challenging database environment.
    • Database administration with knowledge about High Availability, Load Balancing and Distributed Computing required.
    • Extensive knowledge of RDBMS (Oracle), Cloud Databases (RDS), NoSql type databases, PostgreSQL.
    • Understanding of Database Architecture concepts essential.
    • Experience and knowledge with data governance and metadata organization desirable.
    • Experience and knowledge of Amazon Relational Database Service (RDS) and cloud environments in general desirable.
    • Experience with Big Data/NoSQL would be a plus.
    • BS or MS in Computer Science or related field highly desirable.
     
     
    Zillion believes in the importance of an inclusive culture and that our differences drive innovation. Zillion prohibits discrimination on the basis of race, color, national or ethnic origin, religion, age, disability, marital status, gender, gender expression, or sexual orientation.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed