SQL DBA
SQL DBA
Posted on :
04-12-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Job Description of PostGreSQL Plus Google Cloud Platform:
Key Responsibilities:
Database Architecture and Design:
o Design and implement robust scalable and highly available PostgreSQL database
solutions.
o Collaborate with application teams to optimize database schemas and queries.
o Define and implement database backup and recovery strategies.
o Implement disaster recovery and business continuity plans.
Performance Tuning and Optimization:
o Monitor and analyze database performance metrics.
o Identify and resolve performance bottlenecks.
o Tune database queries and indexes for optimal performance.
o Implement caching strategies to improve query response times.
Security and Compliance:
o Implement robust security measures to protect sensitive data.
o Stay uptodate with the latest security best practices.
o Conduct regular security audits and vulnerability assessments.
o Ensure compliance with industry standards and regulations.
Troubleshooting and Support:
o Diagnose and resolve complex database issues.
o Provide expertlevel technical support to application teams.
o Troubleshoot database replication clustering and failover issues.
o Perform root cause analysis and implement preventive measures.
Database Administration:
o Manage database upgrades and migrations.
o Perform routine database maintenance tasks such as backups restores and patching.
o Monitor database health and resource utilization.
o Implement automated scripts for routine tasks.
Key Responsibilities:
Database Architecture and Design:
o Design and implement robust scalable and highly available PostgreSQL database
solutions.
o Collaborate with application teams to optimize database schemas and queries.
o Define and implement database backup and recovery strategies.
o Implement disaster recovery and business continuity plans.
Performance Tuning and Optimization:
o Monitor and analyze database performance metrics.
o Identify and resolve performance bottlenecks.
o Tune database queries and indexes for optimal performance.
o Implement caching strategies to improve query response times.
Security and Compliance:
o Implement robust security measures to protect sensitive data.
o Stay uptodate with the latest security best practices.
o Conduct regular security audits and vulnerability assessments.
o Ensure compliance with industry standards and regulations.
Troubleshooting and Support:
o Diagnose and resolve complex database issues.
o Provide expertlevel technical support to application teams.
o Troubleshoot database replication clustering and failover issues.
o Perform root cause analysis and implement preventive measures.
Database Administration:
o Manage database upgrades and migrations.
o Perform routine database maintenance tasks such as backups restores and patching.
o Monitor database health and resource utilization.
o Implement automated scripts for routine tasks.
Required Skills and Experience:
Technical Skills:
o Strong proficiency in PostgreSQL including advanced features like partitioning foreign
data wrappers and logical replication.
o Indepth knowledge of SQL and PL/pgSQL.
o Experience with Linux/Unix operating systems.
o Familiarity with scripting languages (e.g. Bash Python).
o Knowledge of database performance tuning techniques.
o Understanding of database security best practices.
o Experience with database monitoring and alerting tools.
o Strong understanding of cloud computing concepts and GCP services.
o Proficiency in one or more programming languages (Python Java Go).
o Experience with infrastructure as code tools (Terraform Cloud Deployment Manager).
o Knowledge of containerization and orchestration (Docker Kubernetes).
o Experience with CI/CD pipelines and automation tools.
o Understanding of network security and best practices.
o Strong problemsolving and analytical skills.
o Ability to work independently and as part of a team.
o Certifications in Google Cloud Platform
o Experience with serverless computing (Cloud Functions App Engine)
o Knowledge of data engineering and big data tools (Dataflow Dataproc)
Soft Skills:
o Strong problemsolving and analytical skills.
o Excellent communication and interpersonal skills.
o Ability to work independently and as part of a team.
o A passion for learning and staying uptodate with the latest technologies.
Technical Skills:
o Strong proficiency in PostgreSQL including advanced features like partitioning foreign
data wrappers and logical replication.
o Indepth knowledge of SQL and PL/pgSQL.
o Experience with Linux/Unix operating systems.
o Familiarity with scripting languages (e.g. Bash Python).
o Knowledge of database performance tuning techniques.
o Understanding of database security best practices.
o Experience with database monitoring and alerting tools.
o Strong understanding of cloud computing concepts and GCP services.
o Proficiency in one or more programming languages (Python Java Go).
o Experience with infrastructure as code tools (Terraform Cloud Deployment Manager).
o Knowledge of containerization and orchestration (Docker Kubernetes).
o Experience with CI/CD pipelines and automation tools.
o Understanding of network security and best practices.
o Strong problemsolving and analytical skills.
o Ability to work independently and as part of a team.
o Certifications in Google Cloud Platform
o Experience with serverless computing (Cloud Functions App Engine)
o Knowledge of data engineering and big data tools (Dataflow Dataproc)
Soft Skills:
o Strong problemsolving and analytical skills.
o Excellent communication and interpersonal skills.
o Ability to work independently and as part of a team.
o A passion for learning and staying uptodate with the latest technologies.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
