| PostgreSQL DBA (Database Administrator) || Remote || Contact at Remote, Remote, USA |
| Email: ashik@smartitframe.com |
|
https://jobs.nvoids.com/job_details.jsp?id=1638058&uid= From: Syed Ashik, Smart IT Frame ashik@smartitframe.com Reply to: ashik@smartitframe.com Hi All , Warm greetings from Smart IT Frame! We are currently seeking candidates for an exciting job opportunity within our organization. If you're interested in learning more about this role, please don't hesitate to get in touch. You can either share your updated resume. Role : PostgreSQL DBA Location: US Remote Type: Contract Top Qualifications: SQL and PostgreSQL Scripting (, Perl) DevOps, DB Design & Modelling Responsibilities: Installation and Configuration: Install, configure, and upgrade PostgreSQL databases. Database Design: Design and implement database schema, indexes, and constraints. Performance Tuning: Monitor and optimize database performance, queries, and indexing. Backup and Recovery: Develop and implement backup and recovery strategies. Security: Implement security measures, manage user access, and monitor database activity. Troubleshooting: Identify and resolve database issues, errors, and conflicts. Maintenance: Perform routine maintenance tasks, such as updating statistics and vacuuming. Replication and High Availability: Set up and manage replication, failover, and high-availability solutions. Monitoring and Alerting: Monitor database performance, set up alerts, and notify teams of issues. Documentation: Maintain documentation on database design, configuration, and procedures. Collaboration: Work with development teams to optimize database usage and resolve issues. Staying Up-to-Date: Keep current with PostgreSQL features, best practices, and new releases. By fulfilling these roles and responsibilities, a PostgreSQL DBA ensures the reliability, efficiency, and security of PostgreSQL databases. Work with business customers gathering requirements and provided analysis, and programming support on integration of these customer requirements into existing software. Working on new Unix Scripts for batch processing jobs. Working & writing PL/SQL scripts. Working & writing Wrote Perl scripts to analyse the logs. Writing SQL scripts for Data clean up. Involve in Code Review and Test Cases Review. Provide technical support for the project. Knowledge in Mulesoft integration is plus Required Skills for PostgreSQL DBA: SQL and PostgreSQL fundamentals: SQL syntax and querying - PostgreSQL data types, tables, indexes, and constraints - Understanding of PostgreSQL architecture and internals Database design and modelling: Data modeling concepts (entity-relationship diagrams, normalization) - Database schema design and optimization Performance tuning and optimization: Query optimization techniques - Indexing strategies - Understanding of execution plans and query analysis Backup and recovery: Backup and recovery concepts (full, incremental, differential) - Understanding of PostgreSQL backup tools (pg_dump, pg_basebackup) Security and access control: User management and authentication - Role-based access control (RBAC) - Understanding of PostgreSQL security features (SSL, encryption) Replication and high availability: Understanding of replication concepts (master-slave, multi-master) Setting up and managing replication - High-availability solutions (failover, load balancing) Monitoring and troubleshooting: Understanding of PostgreSQL logs and monitoring tools (pg_stat_statements) - Troubleshooting techniques for performance, connectivity, and data issues Scripting and automation: Familiarity with scripting languages (Bash, Python, Perl) - Automating tasks using cron jobs, scripts, and tools (pg_agent) Keywords: database information technology procedural language PostgreSQL DBA (Database Administrator) || Remote || Contact ashik@smartitframe.com https://jobs.nvoids.com/job_details.jsp?id=1638058&uid= |
| ashik@smartitframe.com View All |
| 10:30 PM 07-Aug-24 |