Share Email Opening
Title

Sr. Database Administrator (PostgreSQL) 

EOE StatementWe are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, gender identity, national origin, disability status, protected veteran status or any other characteristic protected by law. Constellation West will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)
 
About the Organization Constellation West is an award winning company that delivers Information Technology (IT) engineering services and solutions along with non-IT subject matter expertise world-wide. Established in 1997, Constellation West continues as an industry leader, partnering with key organizations. As a prime contractor or preferred subcontractor, we have a continual list of opportunities to fill across the nation with multiple agencies such as the Department of Veteran Affairs, Department of Defense, civilian agencies, and national intelligence community. Many of the positions supporting U.S. federal government require our employees be granted security clearances.

Constellation West provides fully integrated solutions spanning all aspects of system/network engineering, system/network administration, data management, information assurance, quality assurance, full lifecycle support, software development, and geospatial information services. Constellation West looks for the right people ready to step up and be part of a dynamic team.

If you are looking for a new challenge and a rewarding opportunity to apply your expertise, knowledge, and problem solving skills, come join our team! Constellation West offers competitive salary and benefits including:

• Tuition reimbursement
• Competitive 401(k) plan
• Competitive Health Benefits
• 10 Paid Holidays!!
• 15 PTO Days!
• Veteran Hiring Preference

Constellation West is proud to be an EEO/AA employer M/F/D/V
 
Category Information Technology  
Description

- Perform database maintenance (administering, monitoring and maintaining all PostgreSQL database tasks such as configuration, maintenance, creation of databases and database objects, maintenance plans, monitor server jobs, executing scripts, performing backups and restores, etc.).

- Provide technical and operational support for PostgreSQL development, test, and production environments.

- Perform PostgreSQL Upgrades as required to maintain N/N-1. The contractor shall perform non-standard (named instances, multiple instances, add ’l components, etc.) PostgreSQL installations. In addition, the contractor shall do patching for PostgreSQL installations on development, test, and production environments

-Assist in developing and documenting PostgreSQL server related procedures, as well as implement remediation plans for PostgreSQL server security related findings.

-Perform Incident Management and Root cause analysis of all PostgreSQL database related issues and report within the established ITOCC Incident handling methods.

-Design, develop, and maintain code modifications and data integrity on both development, test, and production servers.

 
Position Requirements

-Understanding of IRS IT. An understanding of the IRS IT organization – its structure, processes, and leadership approach – is also desired.

-Understand Interdependencies. Contractors must understand the interdependencies and how to work within each ACIO area, across each ACIO area, and with the IRS business units.

-Consulting & Engagement. Contractors must have expert consulting resources with 10+ years of experience in communications and stakeholder engagement providing both strategy and execution support.

-Collaboration. Consultants must have the ability to work seamlessly with in-house resources and other vendors. They should also possess an exceptionally strong work ethic, self-motivation, curiosity, and drive.

-Filing Season. Contractors should have extensive experience providing the services described above for Filing Season delivery and other large-scale IT initiatives and service wide technology deployments, preferably at the IRS and within EOPS.

-CIO and EOPS Executives. Contractors should have previous experiences with EOPS and engagement with the CIO and EOPS executive teams and be extremely well versed in the vehicles, processes and practices for delivering stakeholder communications.

-ACIO Filing Season Interdependencies. Contractors must understand Filing Season interdependencies and how to work within each ACIO area, across each ACIO area, and with the IRS business units.

-Business Unit (BU) Internal Communications. Contractors must have extensive experience coordinating internal communications and tasks with Business Units across the IRS organization. They must have experience coordinating complex technology rollouts and organizational changes.

-Technical Writing. Contractors must have experience working with and adhering to the IRS ELC, Associated Press (AP) Style Guide, Federal Plain Language Guidelines, Section 508 Compliance, Internal Revenue Brand Guidelines, Service-wide Internal Communications Writing Checklist, Planning Guides and Publications

- PostgreSQL Skillset Profile. The work history of each Contractor employee shall contain experience directly related to the tasks and functions to be assigned. Personnel utilized by the contractor in the performance of this contract shall, as a minimum, meet the experience requirements set forth below and shall be fully capable of performing in an efficient, reliable, and professional manner:

• Knowledge of PostgreSQL best practices

• 5-7 years of progressive PostgreSQL support in an Enterprise environment

• 5-7 years of experience with Linux in a Highly Available infrastructure

• Knowledge of and experience in Amazon Web Services (AWS), Relational Database Services (RDS), and Key Management Services (KMS)

• Proficient in PostgreSQL server database management such as (Creating, administering, managing and tuning PostgreSQL database Instances, etc.)

• Experience with Disaster Recovery Plan implementation and High-Availability methods (including HA Clustering, Availability Zones, Replication, sharding, and Mirroring)

• Creating Service Accounts, PostgreSQL binary installation, establishing the backup methodology, and Application integration testing

• Experience with performance issue troubleshooting/tuning

• Experience/knowledge of backup/restore of large databases, including snapshot backup and incremental transaction logs backup

• Proficiency with all aspects of the PostgreSQL ecosystem.

• Experience with PostgreSQL database migration techniques and beyond

• Experience with PostgreSQL database administration 13.x. Experienced Senior PostgreSQL DBA with 5-10 years of experience

 
Full-Time/Part-Time -unspecified-  
Shift -not applicable-  
Location Lanham, MD  
Number of Openings 1  
Exempt/Non-Exempt Exempt  
Req Number INF-22-00044  
COL  

This position is currently not accepting applications.

To search for an open position, please go to http://CSSS.appone.com



WE ALSO RECOMMEND

Other Jobs Within Same Category
Software Development Specialist in Ogden, UT
Posted on: 12/1/2022
[Apply Now]

Computer Systems Engineer in Ogden, UT
Posted on: 12/1/2022
[Apply Now]

Program Management Specialist in Ogden, UT
Posted on: 12/1/2022
[Apply Now]

Cyber Penetration Tester (Master) in Camp Pendleton, CA
Posted on: 10/4/2022
[Apply Now]

Special Program SME in Offutt AFB, NE
Posted on: 9/28/2022
[Apply Now]


Other Jobs Within 60 Miles
-- None found --




 


 
Click here for technical assistance.