Database Administrator

Job Description :

- Bachelors degree or foreign equivalent required from an accredited institution.

- 10 to 16 years of hands-on experience in enterprise database administration, with strong, demonstrable expertise in Oracle, Sybase, Microsoft SQL Server, PostgreSQL, DataStax Cassandra, and Couchbase.

- Relevant certification or equivalent industry-recognized database certification.

Preferred:

- Proven hands-on experience administering and managing enterprise database platforms, including Oracle, Sybase ASE, Microsoft SQL Server, PostgreSQL, DataStax Cassandra, and Couchbase, covering installation, configuration, patching, upgrades, and ongoing maintenance.

- Strong understanding of database architectures and core concepts across RDBMS and NoSQL systems, including tablespaces, datafiles, filegroups, schemas, ASM, Cassandra keyspaces, Couchbase buckets, indexing strategies, query optimization, and transaction/log management.

- Extensive experience in database performance tuning and monitoring, utilizing tools such as:

1. Oracle (AWR, ADDM, ASH)

2. SQL Server (Query Store, Profiler)

3. PostgreSQL (EXPLAIN ANALYZE)

4. Cassandra and Couchbase monitoring utilities

5. Execution plan analysis and SQL/query optimization across platforms

- Strong expertise in backup and recovery solutions, including:

1. Oracle RMAN (full/incremental, archive log management)

2. SQL Server native backup/restore

3. PostgreSQL logical/physical backups (pg_dump, WAL archiving)

4. Cassandra snapshots and replication strategies

5. Couchbase backup and restore tools

- In-depth knowledge of high availability and replication technologies, including:

1. Oracle RAC, Data Guard, GoldenGate

2. SQL Server Always On Availability Groups, Log Shipping

3. PostgreSQL streaming and logical replication

4. Cassandra distributed clustering and replication

5. Couchbase Cross Data Center Replication (XDCR)

Skills

Oracle DBA, PostgreSQL, SQL Server, Cassandra, DBA, DB, IT Operations, Enterprise Management System