Systems Engineer (POSTGRESQL DBA)
5 Months ago • 4-6 Years
System Design
Job Description
This Systems Engineer role focuses on PostgreSQL DBA responsibilities. Key duties include managing databases, ensuring data integrity, and optimizing performance. Responsibilities encompass database fundamentals like DDL, data types, indexing, stored procedures, and views. The role also involves managing locking, blocking, and deadlocking, along with TSQL queries. Additionally, the engineer will handle backup and restore operations, clustering, and SQL Server installation and configuration, including patching.
Must Have:
- PostgreSQL DBA expertise
- Strong knowledge of SQL DBA
- Experience with database fundamentals (DDL)
- Proficiency in TSQL queries (DML)
- Experience with backup and restore procedures
- Understanding of clustering
- Experience with SQL Server installation and configuration
Primary Skills
POSTGRESQL DBA
Secondary Skills
SQL DBA
Job Description
- DBA with a strong focus on PostgreSQLSQL
- Fundamentals (DDL)
- Data types
- Tables and Indexing
- Stored Procedures / Functions
- Views
- Locking / Blocking / Deadlocking TSQL Queries (DML)
- SELECT / INSERT / UPDATE / DELETE
- JOINS / UNIONHA/DR
- Clustering
- Backup and restore Install & Configuration
- Install SQL Server
- Configure instances to best practice
- SQL Patching
Set alerts for more jobs like Systems Engineer (POSTGRESQL DBA)
Set alerts for new jobs by Capgemini
Set alerts for new System Design jobs in India
Set alerts for new jobs in India
Set alerts for System Design (Remote) jobs
