Job Description
Senior Administrator (System, Storage, Database)
Skills
“· Creation & managing Database schema, tables, tablespaces and users, roles & groups.
· Performance tuning, Query tuning by generating and explaining plan for SQL queries.
· Expert in DBA functions like managing databases, backups
& restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability.
· Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.
· Monitoring Alert Log, scheduled jobs and troubleshooting database problems.
· Understanding of basic database fundamentals: multi- version control, concurrency, transactions, indexing, locking.
· Analyze, recommend, and implement configuration for Optimized Performance.
· Ability to plan hardware capacity requirements for storage, memory, and CPU Cycles.
· Expert with setting and trouble shoot replication.
· Ability to configure and trouble shoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.
· Understanding of UNIX environment with shell scripting.
· Ability to identify defects in the environment and proactively intervene to reduce downtime.
· Server configuration and client authentication.
· In-depth knowledge of Database Security.
· Data Replication – Streaming replication.
· Any other required tasks”