Sr. Database Engineer (PostgreSQL/AWS)
We have an immediate need for a Sr. Database Engineer to join a leading real estate technology organization for a permanent, direct hire position. The Engineer will join a small team supporting a large PostgreSQL footprint, focusing on production and development operations.
Location: Reno, Nevada (Remote working Pacific hours)
This job expects to pay about $130,000 – 160,000 annually plus benefits.
What You Will Do:
- Support a large number of PostgreSQL instances running in the organization’s hybrid cloud. Everything from RDS, Aurora, RedShift, and EnterpriseDB to community edition
- Engineer solutions that are always available and support a 24/7 operations through measured SLAs
- Manage HA architectures, disaster recovery, and backup/restore processes
- Understand and apply advanced database administration, management and performance-tuning techniques
- Repeatable builds, automation, documentation, and alerting are part of your technology wheelhouse and path to productionizing a stack
- Provide advanced technical troubleshooting for applications and database systems
- Configure and tune hardware and software to ensure optimum performance and resource utilization
- Participate in design and application review sessions
- Develop Python and shell scripts, procedures and processes for data migration and application development
What Gets You The Job:
- Minimum of seven (7) years experience with administering and maintaining Postgres-based applications to achieve reliability and availability SLAs
- Minimum of seven (7) years experience with PostgreSQL version upgrades, migrations, and patching running in a hybrid cloud
- Bachelor’s degree in computer information systems, computer science or related discipline preferred
- Proven experience as a Linux System Administrator, preferably in a production environment
- Experience with tuning of SQL statements and PL/pgSQL code
- Experience with release management and SDLC
- Experience working in a 24x7 development environment
- Experience with database analysis and design expertise
- Experience with data extraction, transformation, and loading
- Experience with AWS RDS, Aurora and Redshift
- Experience with Jira, BitBucket (Git) and Confluence
- Ability to write, debug and tune SQL and PL/pgSQL, packages, procedures, functions, triggers, etc.
- Experience working directly with application developers in terms of database design, performance tuning, and troubleshooting
Please send your resume to Hannah Xu, Senior Technical Recruiter for immediate consideration.
Irvine Technology Corporation (ITC) is a leading provider of technology and staffing solutions for IT, Security, Engineering, and Interactive Design disciplines servicing startups to enterprise clients, nationally. We pride ourselves in the ability to introduce you to our intimate network of business and technology leaders – bringing you opportunity coupled with personal growth, and professional development! Join us. Let us catapult your career!
Irvine Technology Corporation provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Irvine Technology Corporation complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.