Postgresql DBA

Greenzone Solutions, Inc. Washington , DC 20001

Posted Yesterday

GreenZone Solutions, Inc. is seeking a PostgreSQL DBA who will support our federal clients data programs through engineering and administration of the clients databases. This is a proposal opportunity. The customer is looking for a Sr DBA to help define and implement improvements around their DBA processes, data migrations and assist in future deployments into AWS.



Responsibilities:

  • Maintain and optimize performance of the PostgreSQL Database as well as scale performance
  • Administration of PostgreSQL databases throughout the development and production lifecycles in an AWS environment.
  • Develop, manage, and test database backup & recovery strategies, verifying data integrity.
  • Perform database installations, configurations, upgrades, and migrations.
  • Proactively monitor and tune for performance.

Requirements

  • Bachelors degree with concentration in Business, IT, Engineering, or other related field
  • 7 or more years of experience working in a DBA capacity
  • High-level of proficiency with PostgreSQL
  • Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL
  • Knowledge of master/slave architecture for replication, backups, and scale-out capabilities, spreading the load to increase performance and failover alleviation
  • Experience in database migration and AWS cloud architecture and migrations
  • Ability to develop and generate data models and DDL
  • Experience with Ansible
  • Experience working with at least one other database such as Maria DB, SQL Server, Oracle, and Sybase
  • Knowledge of NIST, FISMA, and other federal security directives
  • Ability to provide off-hours support
  • Must be a US citizen or green card holder

Benefits

At GreenZone, we are dedicated to obtaining and maintaining the highest level of employee satisfaction by offering a competitive benefits package that includes medical, dental and vision, short and long term disability, retirement plan and company match, a generous annual leave plan, and a commitment to providing a work/life balance for all employees.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
SecretCleared Oracle DBA

Deloitte & Touche L.L.P.

Posted 4 days ago

VIEW JOBS 10/18/2019 12:00:00 AM 2020-01-16T00:00 Oracle DBA with Secret Clearance Opportunity immediately available in Washington, D.C! Work you'll do At our Client site, our Technical team is continuing to be responsible for developing new systems as well as enhancing existing ones, hence we are currently seeking a an Oracle Database Administrator join our team. Our ideal candidate will take over existing processes and responsibilities of the DBA while supporting on-going development teams by managing, monitoring, and maintaining production and non-production Oracle 12c databases. Other responsibilities of the DBA include: * Alert and performance troubleshooting * Security Management (new users, user audits etc.) and password resets * Space Management (monitoring tablespace and datafile space needs etc.) * Database upgrade and software patch management * Audit support and mitigations * Database assessment, optimization, and documentation of outcomes and recommendations from assessment * Development support (code reviews, code refactoring, tuning, data fixes, data refreshes, materialized view etc.) * Data migrations * Partitioning (as needed) * General tasks related to advanced database concepts (e.g. RMAN, queue processing, database parameters, Oracle and SQL server job management, data guard, etc.) U.S. Citizenship is required, as is an active Secret clearance The team Systems Engineering Our Systems Engineering team delivers large-scale software applications and integrated systems, and assists clients with architecture design, assessment and optimization, and definition. We develop service-oriented architecture (SOA) and other integration solutions to enable information sharing and management between business partners and disparate processes and systems, and we deliver technology enablement to support CIO services transformation. Systems Engineering professionals focus on key client issues that impact the core business by maximizing operational value, driving down the cost of quality, and enhancing technology innovation. Our teams deliver a wide range of services, including application architecture design and optimization, application modernization, business process management and solution integration, custom application design and development, and large-scale technology delivery program efforts. Qualifications Required skills: 10+ years' experience as an Oracle DBA performing responsibilities to include database installation and configuration, RMAN backup and recovery, performance tuning, Disaster Recovery solution design and implementation, and database modeling. Additional skills should encompass: * 5+ years' experience installing and configuring Oracle 12c in a Windows environment, as well as working with complex relational databases and data models * 10+ years' experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager) * 10+ years' experience in taking backup and performing recovery, performing point in time recovery at times of necessity * 10+ years' experience designing and implementing backup and recovery including disaster recovery structures * Strong experience providing performance tuning of queries when performance issues are reported * Proficiency in Oracle development tools like SQL Developer * Ability to participate in off-hours (night and weekend) tasks and projects * Excellent verbal and written communication skills, detail oriented coupled with a curious mindset Desired skills: * Experience developing reports based on user requirements * Experience with Windows scripting and Powershell script * Strong troubleshooting experience to resolve design or usability issues that arise * Experience participating in code reviews * Strong command of Microsoft Word and PowerPoint * Ability to provide support and guidance to the development teams during the design, development, and testing processes Location: Downtown DC. Metro accessible: McPherson Square or Metro Center How you'll grow At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Center. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you. Deloitte's culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte's impact on the world. Recruiter tips We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you're applying to. Check out recruiting tips from Deloitte professionals. As used in this posting, "Deloitte" means Deloitte Consulting LLP, a subsidiary of Deloitte LLP. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. Certain services may not be available to attest clients under the rules and regulations of public accounting. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. Requisition code: E20WASCMGRJK074-CBO * * * * * * Deloitte & Touche L.L.P. Washington DC

Postgresql DBA

Greenzone Solutions, Inc.