Contact Review prides itself on finding high-quality, high-accountability, barred attorneys specifically tailored to the needs of our project. Assists with document review, privilege review, expert testimony, legal research, and foreign language translation Fosters a culture where every team member sees themselves as an extension of the project's team Looks for ways to improve efficiency and streamline workflows
PostgreSQL Database Developer
Location
United States
Posted
81 days ago
Salary
0
Job Description
PostgreSQL Database Developer
Contact Government Services
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description CGS is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and Business Intelligence platform focused on providing data solutions that empower our federal customers. You will support a migration from the current Oracle database to a Postgres database and manage the database environments proactively. As we continue our growth, you will play a key role in ensuring scalability of our data systems. - Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database - Create and maintain technical documentation, using defined technical documentation templates, as well as gain an in-depth knowledge of the business data to propose and implement effective solutions - Collaborate with internal and external parties to transform high-level technical objectives into comprehensive technical requirements - Ensure the availability and performance of the databases that support our systems, ensuring that they have sufficient resources allocated to support high resilience and speed - Perform and assist developers in performance tuning - Proactively monitor the database systems to ensure secure services with minimum downtime and improve maintenance of the databases to include rollouts, patching, and upgrades - Create and maintain technical documentation using defined technical documentation templates, as well as gaining an in-depth knowledge of the business data to propose and implement effective solutions - Work within a structured and Agile development approach Qualifications - Bachelor's degree - Must be US Citizenship - 7 years of experience with administrating PostgreSQL Databases in Linux environments - Experience with setting up, monitoring, and maintaining PostgreSQL instances - Experience with implementing and maintaining PostgreSQL backup and disaster recovery processes - Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool Requirements - Experience implementing and maintaining data warehouses - Experience with AWS RDS for PostgreSQL - Experience with Oracle databases - Experience leveraging the Ora2Pg tool - Experience with working in cloud environments such as Azure and/or AWS - Prior federal consulting experience Benefits - Health, Dental, and Vision - Life Insurance - 401k - Flexible Spending Account (Health, Dependent Care, and Commuter) - Paid Time Off and Observance of State/Federal Holidays
Job Requirements
- Bachelor's degree
- Must be US Citizenship
- 7 years of experience with administrating PostgreSQL Databases in Linux environments
- Experience with setting up, monitoring, and maintaining PostgreSQL instances
- Experience with implementing and maintaining PostgreSQL backup and disaster recovery processes
- Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool
- Experience implementing and maintaining data warehouses
- Experience with AWS RDS for PostgreSQL
- Experience with Oracle databases
- Experience leveraging the Ora2Pg tool
- Experience with working in cloud environments such as Azure and/or AWS
- Prior federal consulting experience
Benefits
- Health, Dental, and Vision
- Life Insurance
- 401k
- Flexible Spending Account (Health, Dependent Care, and Commuter)
- Paid Time Off and Observance of State/Federal Holidays
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Administrator DB2 (zOS) - Virtual
Alight SolutionsAlight Inc. (NYSE: ALIT) is a leading cloud-based human capital technology and services provider
Database Administrator DB2 (zOS) - Virtual Amazing Opportunity and Great Place to Work! Are you a keen problem solver? Our Story At Alight, we believe a company’s success starts with its people. At our core, we Champion People, help our colleagues Grow with Purpose and true to our name we encourage colleagues to “Be Alight.” Our Values Champion People – be empathetic and help create a place where everyone belongs. Grow with purpose – be inspired by our higher calling of improving lives. Be Alight – act with integrity, be real and empower others. It’s why we’re so driven to connect passion with purpose. Alight helps clients gain a benefits advantage while building a healthy and financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, absence management and navigation. With a comprehensive total rewards package, continuing education and training, and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work. Join our team if you Champion People, want to Grow with Purpose through acting with integrity and if you embody the meaning of Be Alight. Learn more at careers.alight.com About the Role In this role, you will be responsible for z/OS DB2 system, application object and program product installation and management. Disaster recovery for the DB2 system and application objects is also required. Maintain and create the processes and procedures by which tasks / duties are performed. **US Citizenship requirements- as this role supports services provided to the federal government and/or a federal government contractor, proof will be required to verify US citizenship status at time of hire.** Responsibilities - Provide DB2 Database design and Implementation, configuration and planning - Perform SQL coding & tuning - Identifying problem determination & diagnosis - Provide Level 2 /3 support for all DB2 for zOS issues - Provide off-hour support, 7x24 coverage Requirements - 5+ years minimum of z/OS DB2 DBA. - Demonstrate a deep understanding of DB2 for zOS functions and features. - Maintain application life cycle management & participation in application DB2 object design. - Administer DB2 Version 13 or 12 for DB2 - Demonstrate experience with REXX programming skills - Extensive experience in BMC tools like BMC Change Manager, BMC Mainview, etc. Flexible Working So that you can be your best at work and home, we consider flexible working arrangements wherever possible. Alight has been a leader in the flexible workspace and “Top 100 Company for Remote Jobs” 5 years in a row. Benefits We offer programs and plans for a healthy mind, body, wallet and life because it’s important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well as a number of voluntary benefit options. By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alight’s employment policies. Background checks may include some or all the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position. Our commitment to Inclusion We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful. At Alight, we welcome and embrace all individuals, regardless of their background, and are dedicated to creating a culture that enables every employee to thrive. Join us in building a brighter, more inclusive future. As part of this commitment, Alight will ensure that people with disabilities are provided with reasonable accommodations for the hiring process. If reasonable accommodation is needed, please contact alightcareers@alight.com. Equal Opportunity Policy Statement Alight is an Equal Employment Opportunity employer and does not discriminate against anyone based on sex, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state or local law. In addition, we take affirmative action to employ disabled persons, disabled veterans and other covered veterans. Alight provides reasonable accommodation to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices and observances, unless doing so would result in undue hardship. Applicants for employment may request reasonable accommodation/modification by contacting their recruiter. Authorization to work in the Employing Country Applicants for employment in the country in which they are applying (Employing Country) must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the Employing Country and with Alight. Note, this job description does not restrict management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units. #LI-Remote p&tjobs We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization. Salary Pay Range Minimum : 98,000.00 USDMaximum : 125,000.00 USD Pay Transparency Statement: Alight considers a variety of factors in determining whether to extend an offer of employment and in setting the appropriate compensation level, including, but not limited to, a candidate’s experience, education, certification/credentials, market data, internal equity, and geography. Alight makes these decisions on an individualized, non-discriminatory basis. Bonus and/or incentive eligibility are determined by role and level. Alight also offers a comprehensive benefits package; for specific details on our benefits package, please visit: Wellbeing and Benefits Selector Page - Alight DISCLAIMER: Nothing in this job description restricts management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units. Alight Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, pregnancy, childbirth or related medical condition, veteran, marital, parental, citizenship, or domestic partner status, or any other status protected by applicable national, federal, state or local law. Alight Solutions is committed to a diverse workforce and is an affirmative action employer.
SQL Server Database Administrator
RESPECAchieving the impossible. Transforming our clients' visions into reality.
• Maintain, develop, refactor, and optimize a T-SQL codebase (queries, views, stored procedures, functions) across all OBMS modules. • Perform query tuning, indexing, and performance diagnostics as needed and as appropriate for a large and complex database. • Design, develop, maintain and deploy SSRS reports, ensuring high standards for data accuracy and presentation to non-technical clients. • Partner with the client and other RESPEC consultants on the OBMS team to elicit business requirements and transform them into database design. • Work tickets triaged by a help desk; manage priorities and communicate status/risks clearly. • Contribute to database design patterns for new/enhanced modules, looking for opportunities to evolve or leverage the system's existing architecture where appropriate. • Document changes, follow proper change management processes, and uphold best practices for multi-environment migrations.
Senior Database Administrator (Top Secret cleared)
ICFFounded in 1969, ICF is a global advisory and technology services company headquartered in Reston, Virginia. It delivers data-driven solutions across energy, environment, infrastru
Description Please note: This role is contingent upon a contract award. While it is not an immediate opening, we are actively conducting interviews and extending offers in anticipation of the award. The Work: ICF is seeking an experienced and driven Software Engineer to lead and oversee mission-critical initiatives in support of the Defense Counterintelligence and Security Agency (DCSA). In this role, you will design, develop, and maintain applications leveraging technologies such as Java, Kotlin, and TypeScript, working across Oracle and SQL Server databases in cloud-hosted environments including AWS GovCloud. Job Location: This position will be remote and requires that the job be performed in the United States. If you accept this position, you should note that ICF does monitor employee work locations and blocks access from foreign locations/foreign IP addresses, and also prohibits personal VPN connections. You may be asked to travel once a quarter to an office or client site. Our core work hours are 8am - 5pm Eastern Time with the option to start earlier or work later depending on your time zone. What You Will Do: - Participate in all phases of the Software Development Lifecycle (SDLC), including requirements analysis, design, development, testing, deployment, and sustainment of secure, mission-critical applications. - Design, develop, and maintain applications using technologies such as Java, Kotlin, and TypeScript, ensuring scalability, performance, and maintainability. - Develop and optimize database solutions leveraging Oracle and Microsoft SQL Server, ensuring data integrity, performance, and security. - Build and support cloud-based solutions within AWS GovCloud environments, troubleshooting and resolving issues related to cloud services and system integrations. - Collaborate within an Agile development environment, working closely with product owners, architects, cybersecurity, and DevSecOps teams to translate requirements into high-quality software solutions. - Conduct code reviews, unit and integration testing, and debugging activities to ensure applications meet quality, security, and compliance standards. - Create and maintain technical documentation to accurately reflect system architecture, software design, and implementation details. - Ensure compliance with federal regulations, DoW policies, and security requirements.. - Prepare and deliver executive-level briefings, status reports, and performance updates to government stakeholders and corporate leadership. - Maintain a positive, results-oriented work environment by building partnerships with internal and external partners. What You Will Bring With You: - Active Top Secret Clearance - Proven experience (8+ years or adjust as needed) supporting the full Software Development Lifecycle (SDLC), including design, development, testing, and deployment of secure, enterprise-level applications. What We Would Like You To Bring With You: - Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related technical field. - Experience working with DCSA - 5 years’ supporting applications in AWS GovCloud or other secure cloud environments, with understanding of cloud architecture, performance optimization, and troubleshooting. - Hands-on experience developing applications using Java or Kotlin, and TypeScript, with strong understanding of object-oriented design principles and modern development frameworks. - Experience working with Oracle and/or Microsoft SQL Server databases, including writing and optimizing queries and ensuring data integrity. - Familiarity with Agile methodologies and collaborative development practices, including code reviews, version control, and CI/CD pipelines. - Ability to self-organize, priorities and conduct research on multiple projects under tight deadlines in a fast-paced environment. Professional Skills: - Highly effective analytical, problem-solving, and decision-making capabilities. - Excellent communication and interpersonal skills to interface effectively at all levels of the business. #DMX-HES #Li-cc1 #Indeed Working at ICF ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy. We will consider for employment qualified applicants with arrest and conviction records. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email Candidateaccommodation@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process. However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed. Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position based on full-time employment is: $130,687.00 - $222,169.00 DC Remote Office (DC99)
Business Wire, a Berkshire Hathaway company, is the global market leader in press release distribution and regulatory disclosure. We are on a mission to redefine how organizations connect with their audiences - and that’s just the beginning! Organizations, large and small, depend on us to accurately publicize market-moving news and multimedia, and generate social engagements that develop interactions with their target audiences. About the Role The Senior Applications Database Administrator will work closely with the Engineering, Architecture, and Operations teams building and supporting our mission-critical database systems as Business Wire undertakes a digital transformation journey. As a member of the DBA team, you will be responsible for defining and supporting new and existing database systems across public cloud and traditional data centers. You will help guide best practices in database administration, data high availability, database management, database design, process improvement, requirements analysis, and the introduction of innovation with a focus on automation. What You'll Do - Manage the full database lifecycle: initial installation and configuration of database technologies, deployment of engineered system design solutions, daily operations, administration, upgrades, and management of database technologies - Provide high-end technical DBA support within a variety of Operating Environments (OE) while also supporting/assisting software development and operational teams with database definition, structure, long-range requirements, operational guidelines, and security/integrity controls according to industry best practices - Propose and implement enhancements to improve performance and reliability within the supported IT environments - Install, configure, upgrade, and patch Oracle EBS environments including both database and application tiers - Manage EBS concurrent managers, workflows, and patch application - Troubleshoot and resolve issues across database and application tiers - Provide subject matter expertise in performance tuning and administration. Analyze and tune SQL and Oracle EBS - Perform DDL code reviews and application code reviews for functionality related to a database - Independently analyze, solve, and correct issues in real time, providing problem resolution - Work closely with L1/L2/L3 support teams to proactively identify and resolve issues - Participate in 24x7 on-call rotation What You'll Need - 7+ years of hands-on Oracle and MySQL database experience in a mission critical 24x7 environment - Proven experience managing Oracle EBS environments including installation, patching, cloning, and performance tuning - Experience working in an Agile/Scrum environment with an understanding of ITIL - Experience with full database lifecycle management: upgrades, patching, cloning, backups, and recovery - Experience with automated database deployment using Jenkins, Ansible, or similar tools - Understanding of Unix operating systems Nice to Have - 4+ years of AWS experience designing and supporting hyper-scale mission critical database architecture - 2+ years proficiency in writing, profiling, and optimizing SQL queries for performance - 2+ years experience creating and maintaining Entity Relationship Diagrams - Understanding of data warehouses, data marts, data lakes, modeling, and profiling - Strong understanding of Java and other development frameworks Business Wire will not sponsor a new applicant for employment authorization for this position. What We Offer The base salary range for this position is $150K to $165K/year. Offered salary will be determined by several factors, including but not limited to: applicant’s education, experience, knowledge, skills and abilities, as well as internal equity and alignment with geographic market data. Business Wire reserves the right to modify this salary range at any time. Business Wire’s total rewards include: - Ability to work remotely - Excellent health benefits that begin on your first day of employment - $100 monthly fitness allotment, a tuition reimbursement program, and enhanced mental health resources - 401(k) plan with generous company match, and annual profit sharing contribution (subject to company performance) - PTO, Floating Holidays, Wellness Day Off, Birthday Day Off, and more! A pre-employment background check will be required after the acceptance of an offer. Business Wire is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. Pursuant to the San Francisco Fair Chance Ordinance and other similar state laws and local ordinances, and its internal policy, Business Wire will also consider for employment qualified applicants with arrest and conviction records.



