24 Sep
|
Trigent Software
|
Chennai
24 Sep
Trigent Software
Chennai
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:
Oracle (AWR, ADDM, ASH)
SQL Server (Query Store, Profiler)
PostgreSQL (EXPLAIN ANALYZE)
Cassandra and Couchbase monitoring utilities
Execution plan analysis and SQL/query optimization across platforms
- Robust expertise in backup and recovery solutions, including:
Oracle RMAN (full/incremental, archive log management)
SQL Server native backup/restore
PostgreSQL logical/physical backups (pg_dump, WAL archiving)
Cassandra snapshots and replication strategies
Couchbase backup and restore tools
- In-depth knowledge of high availability and replication technologies, including:
Oracle RAC, Data Guard, GoldenGate
SQL Server Always On Availability Groups, Log Shipping
PostgreSQL streaming and logical replication
Cassandra distributed clustering and replication
Couchbase Cross Data Center Replication (XDCR)
- Experience integrating databases with enterprise applications and identity systems, including LDAP/Active Directory for secure authentication and role-based access control.
- Proven ability to manage databases in highly available, scalable, and hybrid environments (on-premises and cloud platforms such as OCI, AWS, Azure), ensuring resilience and optimal performance.
📌 Database admin (Chennai)
🏢 Trigent Software
📍 Chennai