Senior Database Administrator (MS Sql)

RESPONSIBILITIES:

Installation and Configuration:

Install PostgreSQL server software on appropriate hardware and operating system.

Configure PostgreSQL settings such as memory allocation, connection limits, logging, and authentication methods.

Database Design and Schema Management:

Design and create databases and schemas based on business requirements.

Optimize schema design for performance and scalability.

Manage database objects like tables, indexes, views, and sequences.

Backup and Recovery:

Implement backup strategies to ensure data protection and disaster recovery.

Perform regular database backups and test the restoration process.

Configure and manage PostgreSQL's built-in backup tools like pg_dump and pg_basebackup.

Monitoring and Performance Tuning:

Monitor database performance, resource utilization, and query execution times.

Identify and troubleshoot performance bottlenecks.

Tune PostgreSQL configuration parameters for optimal performance.

High Availability and Replication:

Configure and manage replication for data redundancy and failover.

Set up streaming replication, logical replication, or synchronous replication depending on requirements.

Implement tools like pgpool-II or repmgr for automated failover and load balancing.

Security Management:

Implement security best practices to protect sensitive data.

Manage user authentication and authorization using roles and permissions.

Configure SSL/TLS encryption for secure connections.

Apply security patches and updates in a timely manner.

Capacity Planning and Scaling:

Monitor database growth and plan for future capacity needs.

Scale PostgreSQL horizontally or vertically based on workload demands.

Evaluate and implement features like partitioning and sharding for improved scalability.

Automation and Scripting:

Develop scripts and automation tools for routine tasks like backups, monitoring, and maintenance.

Use tools like Ansible, Puppet, or Chef for configuration management and deployment.

Troubleshooting and Incident Response:

Investigate and resolve database-related issues such as data corruption, connectivity problems, and performance degradation.

Document troubleshooting procedures and maintain knowledge base for future reference.

Compliance and Auditing:

Ensure compliance with regulatory requirements such as GDPR, HIPAA, or PCI DSS.

Implement auditing mechanisms to track database changes and access.

Disaster Recovery Planning:

Develop and maintain disaster recovery plans and procedures.

Test disaster recovery plans regularly to ensure they are effective.

Documentation and Training:

Document configurations, procedures, and best practices.

Provide training and support to developers and other stakeholders on PostgreSQL usage and administration.