Ford Global Business Services Looking for IT Analyst (PostgreSQL Database Administrator) at Chennai, Tamil Nadu Full Time

Job Description & Qualifications

A DBA with 3+ years of experience in administering/managing Postgresql databases across various platforms preferably Open Shift environment.

The DBA works within an environment of rapid growth and must anticipate and respond effectively to needs as they emerge. This position is expected

to design, develop, enhance and monitor all production and test databases that exist within the technical architecture

Auto req ID

58400BR

Entity/Organization

FGBS- Ford Global Business Services

Area of professional exposure (technical skills)

• Responsible for the monitoring and uptime of all production databases.
• Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
• Develop Stored Procedures and Database Triggers in support of application development.
• Participate in application development projects and be responsible for the database architecture and design.
• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
• Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Responsible for regular backups and recovery of databases.
• Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
• Responsible for pro-active remediation of database operational problems.
• Responsible for Query tuning and preventative maintenance.
• Participate in a 24×7 support rotation.
• Worked with OpenShift platform in managing Docker containers and Kubernetes Clusters.
• Experience with container-based deployments using Docker, working with Docker images, Docker Hub and Docker-registries and Kubernetes.
• Involved in development of test environment on Docker containers and configuring the Docker containers using Kubernetes.
• Building/Maintaining Docker container clusters managed by Kubernetes Linux, Bash, GIT, Docker, on GCP
• Worked with OpenShift platform in managing Docker containers and Kubernetes Clusters.
• Worked on infrastructure with Docker containerization and maintained Docker Images and containers.
• Administer database resources hosted on Google GCP and other public/private and Hybrid Cloud Environments

Education Qualifications

B.Sc., B.Tech., Diploma in Engineering, M.Sc, MBA, MCA

No. of years of experience

1 to 3 years