sql dba.

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 up-to-date 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 expert-level 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 In-depth 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 problem-solving 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 problem-solving 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 up-to-date with the latest technologies.