• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 19th Sep 2022

Writes Terraform that creates and implements functionality of PostgreSQL databases.  Ensures overall health and performance of multiple PostgreSQL databases.   Monitors performance, reliability, availability, scalability, and recoverability.  Confers with appropriate managers regarding problems with and capabilities of Client/Server databases.  Operates under general supervision.
Qualifications:
The candidate must have at least 2 years of experience coding in Terraform and managing PostgreSQL relational database.  The ideal candidate will have experience supporting other database technologies like Oracle and have Google Cloud experience.  Strong conceptual and analytic skills. Skilled in SQL programming, knowledge of operating systems and UNIX scripting languages.  Knowledge of database security management and data integrity concepts, knowledge of ETL and query tools, and experience in code migration, database change management and data management through the various stages of the development life cycle.  A Bachelor's degree in business or computer science or equivalent experience is required. 

Skills

Responsibilities (Job Duties) include:

Writing Terraform in the Google Cloud

Develop Cloud Functions in Python for managing system resources and administrative tasks

Implements database software installs, upgrades, and patches

Conducts regular database performance testing and tuning

Conducts regular SQL tracing and tuning.

Capacity planning for database storage and memory.

Recommends and implements dimensional models, including aggregation and indexing strategies

Implements and maintains operational and disaster recovery procedures

Manages database security, user accounts and access privileges

Writing and maintaining UNIX shell scripts for database monitoring and job automation

Performs complex bug verification, release testing for assigned products

Works with fellow DBAs and other internal teams to establish, implement and document database standards

Confers with internal department managers regarding problems with and the capabilities of various internally-used databases

Flexibility to adapt to and willingness to learn new technologies.

Advise on database concepts and functional capabilities

Share responsibility with fellow DBAs for 24/7 on-call support

Recommends systems changes to programming management

Demonstrated effective oral and written communication skills with the ability to communicate technical information to non-technical personnel.

Working positively and having fun within a team environment

Maintain hot and cold backups and maintains backup and recovery documentation

Ability to work within change control processes

Maintain detailed project plans for and occasionally lead DBA projects

Working on multiple PostgreSQL database projects in a fast paced and dynamic environment.