Job Information
Ford Motor Company IT Ops Analyst in Chennai, India
7+years of IT experience.
4+ years of experience in PostgreSQL database technologies, performance optimization for large OLTP applications.
1+ years of experience with Cloud SQL for PostgreSQL services in GCP which includes POC, feature testing and provide database service offering to product development team.
Administer database resources hosted on Microsoft Azure, Google GCP and other public/private and Hybrid Cloud Environments
Administer and manage databases on Containers (Kubernetes & OpenShift)
Configuration management, monitoring, reporting on databases hosted in On-Prem & Off-Prem environments
Configure and optimize On-prem applications to use resources Off-Prem and vice versa, as well as Hybrid cloud deployments
Optimize database workloads, both Off-Prem and On-Prem.
Define and implement database backup and recovery strategies.
Assist in planning and implementing database and application changes.
Evaluate new database products and features.
Perform database space management, database reorganizations, backups and recovery.
Monitor and tune database performance.
Assist in problem identification and solving, sometimes-requiring off-shift and coordination with cloud providers.
Provide the DBA liaison function to the Application Developers, Business Customers and be the point of contact for loads on On-Prem and Off-Prem cloud environments.
Provide guidance and migrate workloads between Off-Prem and On-Prem environments.
Assist in planning and implementing database and application changes.
Performance Tuning and Capacity Management
Adherence to Database Security
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
Knowledge on Business Continuity and Disaster Recovery
Process adherence, process improvements and knowledge management
Involve in problem management.
Mentoring/Knowledge transfer to junior team members.
Attending the global meetings, cascade inputs to the team.
Incidents/Tickets queue management and adhering SLA
Play a vital role in daily operations standup meeting
BE
Desired Experience
Experience in database administration with relational/Open-source/distributed databases/Extended and Non-Relational Databases
Experience working on DBs on cloud – Microsoft Azure and Google GCP
Experience working on Containerization, Kubernetes, OpenShift
Experience in Supporting PostgreSQL on Google Cloud and On-OpenShift environment
Experience in migrating Oracle/SQL server to GCP Cloud SQL PostgreSQL / PostgreSQL
Unix shell scripting, Terraform development experience for provisioning GCP Cloud SQL PostgreSQL
Experience in SSL and IAM authentication for GCP Cloud SQL PostgreSQL
Experience in ora2pg and GCP DMS (Database Migration Service)
Experience doing development in a Tekton pipeline
Ability to work in a large, sophisticated business and technical environment
Must be detail oriented and have the ability to multi-task
Fast starter, optimally delivers with limited supervision
Excellent communication skills written as well as verbal
Ability to communicate optimally with both the business and technical teams
Strong written/oral English communication skills with ability to communicate effectively.
Working experience in one or more database products in Relational, Extended Relational, DB technologies. Examples include: SQL Server & PostgreSQL
Training and/or any certification in Microsoft Azure/Google GCP.
Must be self-starter with strong desire to learn new technologies coupled with a record
Must have strong knowledge of Linux.
Should have experience of using Terraform in Cloud maintenance.
Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming,
catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
Must be self-starter with strong desire to learn new technologies coupled with a record
Knowledge of shell scripting (e.g., Bash, Perl).
Exposure to Open shift environment with experience managing docker containers and Kubernetes clusters preferred.
Experience with Infrastructure-as-code concepts and implementation (i.e. Cloud Formation/Terraform templating and ARM templates) and configuration management systems (i.e. Ansible, Puppet or Chef).
Requisition ID : 29768
Ford Motor Company
- Ford Motor Company Jobs