Devops Data Base Administrator

Job Family:

Database Administration (Digital)

Travel Required:

Up to 10%

Clearance Required:

Ability to Obtain Public Trust

What You Will Do:

As a DevOps Database Administrator, you will be responsible for deploying and managing PostgreSQL databases within containerized and cloud environments. While the primary work is on PostgreSQL, work will also include managing MongoDB for document storage. This application platform includes many technologies, from OpenShift to Splunk, and is used by a wide range of development, QA, and system integration teams.

Responsibilities:

• Working with DevOps, Development, and Security teams to define and document requirements for deployment, configuration, hardening, and optimization of databases and database tasks.

• Deploy and manage databases per requirements.

• Monitor, analyze, and troubleshoot problems within PostgreSQL- specific and general DevOps tools and processes.

• Management of backup files and recovery processes.

• Manage accounts and roles on the databases per documented processes.

• Document database architecture and processes.

• Reviewing vulnerability scans and remediating vulnerabilities in addition to participating in periodic security audits.

• Coordinate with other teams to continually improve the delivery of products to customers.

• Maintaining and driving the modernization of legacy applications, tools, and systems.

• Design, implement, and ensure quality and security controls are met.

• Prioritize work and close out tickets on time.

What You Will Need:

• US Citizenship and the ability to obtain and maintain a federal Public Trust

• 6+ Years of experience within the DBA area

• PostgreSQL (versions 9.6 - 13) on Linux, including system configurations

• Experience with database replication (streaming, file-based, or logical)

• Experience managing both file-based and logical backups (pg_basebackup, pg_dump, pg_restore)

• Highly Available database configurations using replication, connection poolers (pgbouncer, pgPool), load balancing (HAProxy), and failover

• Database recovery from backups (single table, entire database, point in time, missing transaction logs)

• Query optimization (analyzing explain plans, index management)

• Scripting/development skills. (Python or Bash scripting is preferred)

• Log Aggregation/Analysis (pgBadger, Splunk, or similar)

• Application/Database monitoring (pgMonitor, Datadog, NewRelic, DynaTrace, AppDynamics, Zabbix, or similar)

• Experience with Linux (RHEL preferred)

• Debugging (proxies, networking, java/tomcat, database)

• Team player that fully embraces DevOps culture, eliminate barriers, and bridge moats

What Would Be Nice To Have:

• Multiple PostgreSQL distributions (EDB, Crunchy Data, 2nd Quadrant)

• Multiple Databases (PostgreSQL, MySQL, MS SQL Server, Oracle)

• Test data generation and database benchmarking

• NoSQL Databases (Mongo DB)

• Containerization (Docker)

• Openshift/Kubernetes and PostgreSQL Operators (Crunchy Data, 2nd Quadrant, EDB)

• Nexus - Artifact Repository

• Twistlock

• VMware or VirtualBox

• Bitbucket (Git)

• Ansible

• Cloud-based services (AWS, Google Cloud, ...)

• Networking/DNS/Certificates

• Security scanning/vulnerability remediation (Nessus, Retina, …)

• Good verbal and written communication skills

• Government or large organization experience

The annual salary range for this position is $115,200.00-$172,800.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer:

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical, Rx, Dental & Vision Insurance

• Personal and Family Sick Time & Company Paid Holidays

• Parental Leave

• 401(k) Retirement Plan

• Group Term Life and Travel Assistance

• Voluntary Life and AD&D Insurance

• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts

• Transit and Parking Commuter Benefits

• Short-Term & Long-Term Disability

• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities

• Employee Referral Program

• Corporate Sponsored Events & Community Outreach

• Care.com annual membership

• Employee Assistance Program

• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)

• Position may be eligible for a discretionary variable incentive bonus

About Guidehouse

Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.