JOB DESCRIPTION
As a Tech Lead Database Administrator In PostgreSQL and Oracle, you will be responsible for database administration, design, development, and support applications available systems. You will be responsible for continuously enhancing the automation process of the database and should have an interest in DevOps to help us improve our software engineering practices. You will require to work closely with multiple stakeholders in order to understand their database needs. After understanding their needs, you will make recommendations and provide self-service offerings that will allow stakeholders to deploy, monitor, backup and maintain their databases for business need.
You will work with a fast-paced, skilled team of engineers, DBA’s, and developers across multiple high-profile projects. You will also participate in IT projects from inception of the project and daily maintenance phase of those projects. You should have a good understanding of cloud concepts. If you are a top-notch DBA and looking for the next challenge, apply now!
Core Requirements and Responsibilities:
Essential job functions included but are not limited to the following:
· Required: 5 years’ experience running a large fleet of PostgreSQL and Oracle databases at scale, focus on installation, configuration, upgrade, performance, security, scalability, reliability, high-availability, and disaster recovery setup.
· Scripting and automation mindset: Strong experience with Python(preferred), shell(secondary)
· Experience with AWS database administration, on-premises Postgres and Oracle database administration, deployments, ideally RDS Postgres and Aurora Postgres, EC2 Oracle
· Familiarity with Postgres ecosystem - pgbouncer, replication manager, Failover Manager, Patroni, BART, pgBackRest
· Setup Monitoring, Backup & Recovery, High Available and alerting notification systems on AWS and on-premises.
· Perform analysis, design, implementation, and migration of data and application database code from Oracle to AWS- RDS/Aurora PostgreSQL and EDB PostgreSQL databases.
· Develop automation frameworks (Infrastructure as code, CI/CD pipelines) and tooling that will be consumed by the entire engineering organization.
· Container and container orchestration technologies (e.g. Docker, Kubernetes)
· Cloud-native infrastructure (AWS)
· Linux internals and network configuration and protocols
· Experience in creating shell scripts (Linux, Python is a plus).
· Infrastructure-as-Code and configuration management (Chef, Terraform, Jenkins)
· Experience in Ansible is huge plus
· Resolve complex problems by investigating and devising solutions for database operations. May include installations, configuration, tuning and maintenance of database management.
· Provides after-hours, weekend support during maintenances and participate in on-call rotation (24X7)