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.
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.