Database Administrator

The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance.

Responsibilities

• Maintain and configure Postgres instances.

• Postgres DB replication like Streaming, Londiste, Logical strong hands on experience

• Strong experience with EFM, PgBouncer, PgPool, MTK, PgBadger, etc. tools from EDB

• Strong experience working on Postgres database in the production environment.

• DBA will be supporting the customer on a 24x7 support.

• Should have hand-on experience on Postgres user management and maintenance.

• Should have worked on security implementation for Postgres database.

• Have worked on maintenance tasks and knowledge of Backup and Recovery.

• Must have Database related issue troubleshooting / analytical skills

• Should have good communication, analytical, interpersonal and customer handling skills.

• Strong performance tuning experience

• Must have On-premise to Cloud DB migration experience

• Good to have cross DB migration experience

• Keep clear documentation of the database setup and architecture.

• Write procedures for backup and disaster recovery.

• Ensure that the databases achieve maximum performance and availability.

• Design indexing strategies.

• Configure, monitor, and deploy replica sets.

• Upgrade databases through patches.

• Create roles and users and set their permissions.

• Experience with other RDBMS Databases like MSSQL, MySQL.

• Passionate about embracing new database technologies.

• Demonstrate analytical, problem-solving, presentation, and interpersonal skills to handle various critical situations.

• Exhibit strong problem-solving skills and communications skills to handle critical circumstances well.

• Data modeling and database design.

• Metadata management and repository usage.

• Database Schema creation and management.

• Ensuring data integrity in all the environments.

• Ensuring availability.

• SQL Code reviews.

• Procedural Skills.

• Determine tools to be used for the product and set coding standards.

• Experience in developing scripts to automate frequent tasks.

• Knowledge of best patterns and practices for designing document schemas.

• Identifying user needs to create and administer databases.

• Ensuring that the database operates efficiently and without error.

• Making and testing modifications to the database structure when needed.

• Maintaining the database and updating permissions.

• Merging old databases into new ones.

• Software installation and Maintenance.

• Data Extraction, Transformation, and Loading.

• Specialized Data Handling.

• Database Backup and Recovery.

• Performance Monitoring.

• Database Tuning.
• • Troubleshooting. Skills : Postgres, SQL, Linux, DBA, PL / SQL, ETL,Linux.