Database Administrator II (Hybrid)
Database Administrator II (Hybrid)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
The Database Administrator II is responsible for supporting the installation configuration and maintenance of database systems in alignment with established standards and best practices. This role helps ensure database environments are secure highperforming and reliable by performing routine maintenance monitoring system health optimizing SQL queries and resolving performance issues. The engineer will also collaborate with crossfunctional teams on a variety of projects contributing to the design implementation and improvement of database operations to support consistent and efficient data access across the organization.
This role reports to the Director of IT Operations.
What Youll Do
- Manage and optimize Amazon Aurora PostgreSQL Aurora MySQL and RDS PostgreSQL environments including Global Database clusters across multiple AWS regions
- Configure and maintain RDS/Aurora PostgreSQL parameter groups replication settings and failover configurations
- Implement and monitor data encryption strategies using AWS KMSmanaged keys.
- Design and manage PostgreSQL replication strategies including logical and physical replication in AWS
- Optimize SQL queries and analyze query performance using native PostgreSQL tools AWS Performance Insights and other observability platforms
- Design implement and maintain ETL processes for data ingestion and transformation across multiple platforms
- Manage datasets and perform administrative tasks in GCP BigQuery including data import/export partitioning and access control
- Develop maintain and improve backup and restore procedures for RDS and Aurora clusters using automated snapshots PITR and manual strategies
- Automate database provisioning schema migrations and configuration using Infrastructure as Code (IaC) tools like Terraform
- Support development and DevOps teams with databaserelated needs throughout the software lifecycle
- Respond to production incidents and actively resolve databaserelated issues across registry and registrar environments
- Participate in On Call rotation to provide 24/7 database support.
- Consistently model Identity Digital Values in all interactions and decisions
- Other duties as assigned
Who You Are / What You Bring
- 3 years of experience managing PostgreSQL and/or MySQL databases in largescale production environments with at least 3 years on AWS RDS and Aurora
- Bachelors Degree in Computer Science or related field preferred
- Proven handson experience with:
- Amazon RDS & Aurora PostgreSQL and MySQL
- Aurora Global Database configuration and crossregion replication
- PostgreSQL replication (streaming logical)
- AWS KMSbased data encryption
- SQL performance tuning and query analysis
- Backup and recovery strategies on AWS (PITR snapshots etc.)
- Proficiency with scripting and automation tools (e.g. Bash Python Terraform Ansible)
- Strong understanding of PostgreSQL internals SQL and PL/pgSQL development
- Familiarity with Linux/Unix environments and systemlevel performance metrics
- Ability to diagnose and resolve complex distributed database issues
- Ability to travel as needed
- Ability to work across time zones as part of a global organization as needed
- Reliable transportation to the workplace
Physical Requirements
- Prolonged periods of sitting at a desk and working on a computer
- Must be able to lift up to 15 pounds at times
Salary Range
The U.S. base salary range for this fulltime position is $87000 $111000 (flexibility based on experience) plus benefits as described below. In addition the successful candidate will be eligible to receive other compensation from time to time in the form of discretionary and/or nondiscretionary bonuses and longterm incentive plan. Actual compensation will be influenced by a candidates qualifications internal employee equity considerations and location. We will not ask for information about a candidates current or past compensation for purposes of developing an offer of employment.
US team members (and their spouses domestic partners and/or dependent children) are covered by generously subsidized medical dental and vision insurance which includes company contributions to a Health Savings Accounts. Team members are also covered by companypaid life and disability insurance and have the option of participating in employeepaid supplemental life accidental death and dismemberment critical illness and accident insurance. In addition team members can enroll in the companys 401(k) plan with up to a 5% match. You receive 15 days of paid vacation yearly increasing to 20 days after one year. Additionally you get 5 days of paid sick leave 13 paid holidays and 20 weeks of paid parental leave for birthing parents 12 weeks for others. Also theres an opportunity for tuition reimbursement for qualifying expenses.
Note: Benefits programs are subject to eligibility requirements and may vary in certain locations.
A few things to know about us
Identity Digital is an Equal Opportunity Employer and does not discriminate based on race color religion sex age national origin veteran status marital status sexual orientation gender identity disability or any other category prohibited by local state or federal law. This policy applies to all aspects of employment including recruitment placement promotion transfer demotion compensation benefits social and recreational activities and termination.
Background Check Statement
At the time of an offer you will be required to complete a background check. Any offer is contingent upon a satisfactory background check.
Sponsorship Statement
Please note that work sponsorship for this position may not be available now or in the future. While we strive to support our candidates not all roles will qualify. Eligibility will be reviewed on a casebycase basis.
Accommodation Statement
We are committed to the full inclusion of all qualified individuals. As part of this commitment Identity Digital will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process please contact our Recruiting Team at
Required Experience:
Unclear Seniority
Employment Type
Full Time
