Architect I - Cloud Infrastructure Services

Architect I - Cloud Infrastructure Services

UST Global Singapore Pte Limited
Thiruvananthapuram / Trivandrum
5-8 years
Not Specified

Job Description


Job Description :
Role Proficiency:
Design and implement Infrastructure/Cloud Architecture for a small/mid projects
Outcomes: NA
Measures of Outcomes: NA
Outputs Expected: NA
Domain relevance: NA
Manage Project: NA
Estimate: NA
Manage knowledge:
Create Standard Operations Procedures for the daily Operations
Mentor junior team members on technical capabilities.
Release: NA
Design: NA
Interface with Customer: NA
Organisational skills:
  • Good analytical and problem-solving skills
  • High level communication and collaboration skills
  • Risk Analysis and Management
  • Ability to react to a changing environment
  • Capable to take heavy workload
  • Communicate with Team members effectively and efficiently.

Certifications:
  • PostgreSQL Associate/Professional Certification
  • ITIL Certification
  • AWS Cloud Certification
  • Certification on any RDBMS platforms

Technical Skills:
  • The role carries responsibility of experienced database administrator who will be responsible for ensuring the performance, availability, and security of PostgreSQL instances, will be responsible for orchestrating migrations, upgrades, backups, and provisioning of database instances.
  • 5-8 years of relevant experience in PostgreSQL
  • Strong proficiency in PostgreSQL database administration and should have worked on 9.5 to latest versions (10.x, 11.x,12.x) for both EDB and Open source flavors.
  • Must have experience in PostgreSQL database architecture, logical and physical design.
  • Should be expert at User security and database security.
  • Creating and managing table spaces, tables, and other database objects.
  • Should have experience in PostgreSQL upgrade between major versions and minor version upgrades.
  • Should have experience in PostgreSQL backup tools like pgBackrest, BART, BARMAN
  • Should be expert at configuring and maintaining replication.
  • Monitor and tune the Database performance on-going basis.
  • Must have expertise in system tuning, resource contention analysis
  • Should have experience in backup, recovery, standby and replication (Physical/logical).
  • Should have experience in PostgreSQL HA setup and multi-node replication with standby fail-overing.
  • Ability to pro-actively identify, troubleshoot, and resolve live database systems issues.
  • Strong understanding of command line and server administration.
  • Must have good knowledge of Linux.
  • Should have experience in SQL scripting.
  • Should have experience in shell scripting/python/PowerShell.
  • Experience in database level and session level Performance analysis.
  • Experience in AWS RDS/Aurora instance is a plus.
  • Expertise in Oracle/SQL server to PostgreSQL migration is a plus.

Main responsibilities
  • Perform Database Server environment implementation and steady state maintenance.
  • To standardize and stabilize the process.
  • Ensure to follow ITIL framework for management processes
  • Design, develop, implement, and maintain our core Oracle applications.
  • Maintain our SQL / PL-PGSQL processes.
  • Ensure DB availability.
  • Proactively manage and maintain security standards and controls.
  • Actively seek to optimize and simplify our architecture.
  • Take ownership of performance and capacity monitoring aspects of the DB.
  • Execution of data migration jobs and scripts as required.
  • Assist the infrastructure team in sizing hardware used for the DB.
  • Support and collaborate with product developers.
  • Contribute to the creation and maintenance of disaster recovery plans.
  • Create a reliable backup strategy. Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
  • Determine and document DB policies, procedures, and standards.
  • Performance testing and evaluation to ensure data security, privacy, and integrity. Identification of bottle necks and deadlock issues.
  • Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
  • Set user privileges within the database environment
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
  • Increase reliability and enhance efficiencies by implementing 3rd party tools and scripts
  • Ensures compliance to security standards, policies and guidelines
  • Provides business continuity through thorough back-up and restore procedures, and periodic testing of outage scenarios
  • Administers and maintains a Linux based server network, with a combination of physical and virtual servers
  • Plans, deploys, and documents new servers and services
  • Ensures that external and internal regulations and policies governing data management are met, including regulations concerning security, audit, and privacy
  • Handle Incident and request tickets via service now

Good to have:
  • Knowledge on other database platforms like Oracle and MSSQL
  • Knowledge and hands on in Cloud platforms preferably AWS, Google, or Azure
  • Thorough knowledge on ITIL framework

Personal skills:
  • Proactive
  • Detail-oriented
  • Ability to influence and persuade
  • Multi-tasking
  • Integrity and trust
  • Self-starter and Willing to learn etc.

Job Details

Similar Jobs

Career Advice to Find Better